Experienced Mid-Level DBA

 Years Of Experience: 2-4 years

Level of Education: Minimum Bachelor’s Degree

 Duties and Responsibilities

- Responsible for ensuring availability and performance of the databases that support the system

- Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance

- To proactively monitor the database systems to ensure secure services with minimum downtime

- Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management

- Responsible for problem escalation to Oracle Development team and third parties as appropriate

- Responsible for improvement and maintenance of the databases to include rollout and upgrades

- Responsible for implementation and release of database changes as submitted by the development team

- Responsible for configuration, synchronization and administration of Oracle Dataguard (DR)

- Responsible for installation, and administration of Oracle Real Application Cluster (RAC)

- Provision MySQL instances, both in clustered and non-clustered configurations

- Ensure performance, security, and availability of databases

- Prepare documentations and specifications

- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

- Profile server resource usage, optimize and tweak as necessary

- Collaborate with other teams members and stakeholders

Skills / Attributes Required

- Strong Oracle Database Administration experience

- Experience of managing multiple RDBMS on large systems

- Experience of working in a team that delivers a high availability service

- Experience of working in Data Guard environment

- Experience of working in RAC environment 

- Practical experience in monitoring and tuning a database to provide a high availability service

- Experience of SQL Server is desirable

- Oracle Certification, preferably OCP

- Strong proficiency in MySQL database management

- Decent experience with recent versions of MySQL

- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM

- Experience with replication configuration in MySQL

- Knowledge of de-facto standards and best practices in MySQL