Database Administrator - MySQL/Oracle DB

Description :

Roles and Responsibilities :

- Should have good knowledge on MySQL, Oracle, PostgreSQL, Microsoft SQL Server, MongoDB, Redis, Elasticsearch, Cassandra, MariaDB, IBM Db2

- Able to Choose the right hardware and software for the database, considering factors such as the size of the database, the number of users, and the performance requirements.

- Configure the database for the company's needs, including creating user accounts, granting permissions, and setting up database parameters.

- Perform regular maintenance on the database servers, such as patching the operating system and database software, applying security updates, and backing up the database.

- Monitor the performance and health of the database servers and troubleshoot and resolve any issues that arise.

- Develop and implement backup as well as recovery plans / jobs that meets the company's data recovery requirements, considering factors such as the frequency of backups, the type of backups, and the retention period for backups.

- Develop a recovery plan to restore databases in the event of a failure, considering factors such as the type of failure, the recovery time objective (RTO), and the recovery point objective (RPO).

- Set up database monitoring tools to track key performance metrics, such as CPU usage, disk I/O, memory usage, and query execution times.

- Analyse database performance data to identify trends and patterns, and to identify any areas where performance is suboptimal.

- Investigate the root cause of performance issues, such as slow queries, inefficient indexes, and database bottlenecks.

- Implement tuning solutions to improve database performance, such as rewriting inefficient queries, creating new indexes, and adjusting database parameters.

- Perform other database maintenance tasks, such as defragmenting indexes and shrinking databases.

- Monitor database usage and audit database activity to identify suspicious activity.

- Develop and implement database security standards and procedures, covering areas such as password management, data encryption, and access control.

- Work with developers to fix database design or code issues that are causing problems.

- Create and maintain database indexes to improve the performance of database queries.

Technologies :

- Bachelors degree in computer science, Software Development, or related field.

- Database Administration Certification in any one of the following databases : Oracle, MS-SQL, MySQL, Postgres

- A minimum of 2 years hands-on experience as a DBA in one or more of the above Database technologies.

- MS-SQL DBA experience shall be preferred.

- Working knowledge of AWS DB technologies like RDS shall be an added advantage.

- Knowledge of Cloud computing/Elastic computing across virtualized environments shall be a plus.

- Excellent written and verbal communication skills and high level of personal integrity.

- Good organizational skills