Database Administrator at Seven Up Bottling Company

Description
Database Administrator:

• The Database Administrator’s role is to design, install, monitor, maintain, and performance-tune production databases while ensuring high levels of data availability.
• This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities
Strategy & Planning:

• 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.

Position Requirements
Formal Education & Certification:

• A minimum of 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 laws.

Personal Attributes:

• Leadership ability.
• Business Savvy.
• Political Sensitivity.
• Strong technical documentation skills.
• Good interpersonal skills.
• Ability to conduct research into database issues, standards, and products as required.
• Ability to present ideas in user-friendly language.
• Highly self-motivated and directed.
• Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment.