Senior Database Administrator - MySQL

Key Responsibilities :

- Design, install, configure, and maintain MySQL database clusters in production and non-production environments.

- Monitor database performance, identify bottlenecks, and perform query optimization, indexing, and tuning.

- Implement high availability and disaster recovery solutions (Replication, Clustering, Backup & Recovery).

- Manage database security, access controls, and compliance requirements.

- Perform proactive database capacity planning and scaling to support business growth.

- Develop and maintain automation scripts for backups, monitoring, and deployments.

- Troubleshoot complex database issues and provide root cause analysis.

- Collaborate with application developers for schema design, stored procedures, and SQL optimization.

- Maintain documentation of database architecture, policies, and procedures.

- Mentor junior DBAs and provide technical guidance to cross-functional teams.

Qualifications & Skills :

- Bachelors/Masters degree in Computer Science, Information Technology, or related field.

- 6+ years of experience as a MySQL DBA in large-scale, high-transaction environments.

- Strong knowledge of MySQL internals, replication, clustering, and partitioning.

- Expertise in query tuning, performance optimization, and indexing strategies.

- Hands-on experience with Linux/Unix environments and shell scripting.

- Experience with cloud platforms (AWS RDS/Aurora, GCP CloudSQL, Azure Database for MySQL).

- Familiarity with DevOps tools (Ansible, Terraform, CI/CD pipelines) is a plus.

- Knowledge of NoSQL databases (MongoDB, Redis, Cassandra) is an advantage.

- Strong problem-solving and analytical skills with ability to work under pressure.