Database Administrator Vacancy at Seven Up Bottling Company

Overview

Responsibilities

• Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Acquisition & Deployment:
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Operational Management:
• Create models and relational entity diagrams for new database development and/or changes to existing ones.
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize, and allocate physical data storage for database systems.
• Plan and coordinate data migrations between systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Create, or support the creation of, required reports in response to business user needs.
• Perform database transaction and security audits.
• Establish appropriate end-user database access control levels.
• Develop routines for end users to facilitate best practices in database use.
• Manage and/or guide junior members of the team.
• Understand the needs and requirements of the applications using the databases and provide support for these applications.
• Coordinate multiple applications accessing the same database.
• Write and debug lines of SQL code for application development.

Requirements

• Formal Education & Certification:
• Candidates should possess a Higher National Diploma (HND) or University Degree in the field of Computer Science or Engineering with a minimum of 6 years of relevant work experience as a DBA.
• Certifications in Database Management and/or Administration from Microsoft or Oracle are required.
• Knowledge & Experience:
• Strong understanding of database structures, theories, principles, and practices.
• Working technical experience with designing, building, installing, configuring, and supporting database servers, including Microsoft SQL Servers 2008 to 2022, MySQL, Postgres, and SAP HANA Database.
• Hands-on database tuning and troubleshooting experience.
• Experience with data processing flowcharting techniques.
• Project management experience.
• SQL Scripting experience.
• Programming skills are nice to have.
• Good understanding of the organization’s goals and objectives.
• Knowledge of applicable data privacy practices and la