Database Administrator

Job Summary

We are looking for an experienced MySQL DBA to manage, optimize, secure, and maintain production MySQL databases. The candidate should have strong hands-on expertise in SQL query optimization, performance tuning, indexing strategies, database architecture, backup and recovery, and high availability.

Key Responsibilities

• Design, implement, manage, and maintain MySQL databases across development, testing, and production environments.
• Optimize complex SQL queries, joins, subqueries, and stored procedures to improve application performance.
• Analyze execution plans using EXPLAIN and EXPLAIN ANALYZE to identify performance bottlenecks.
• Design and optimize indexes, including composite and covering indexes, to minimize query execution time and database resource utilization.
• Identify and resolve slow queries, full table scans, locking, blocking, deadlocks, and inefficient database access patterns.
• Monitor and optimize database performance, CPU, memory, disk I/O, connections, and storage utilization.
• Implement and maintain backup, recovery, replication, high availability (HA), and disaster recovery (DR) strategies.
• Perform database upgrades, migrations, schema changes, capacity planning, and data archiving.
• Implement database security, access controls, auditing, and data protection best practices.
• Establish database monitoring, alerting, maintenance, and performance-reporting mechanisms.
• Troubleshoot critical production incidents and perform root-cause analysis (RCA).
• Collaborate with developers, architects, and DevOps teams to improve database design and application performance.
• Automate routine DBA activities using shell scripting, Python, or other suitable tools.

Requirements

Required Skills

• Strong hands-on experience with MySQL 8.0+, database administration, and production support.
• Excellent SQL skills and expertise in query optimization and performance tuning.
• Strong understanding of indexing strategies, index selectivity, composite indexes, and query execution plans.
• Experience with MySQL InnoDB internals, transactions, locking, isolation levels, and concurrency management.
• Expertise in identifying and resolving slow queries, deadlocks, blocking sessions, and resource bottlenecks.
• Hands-on experience with database backup, point-in-time recovery, replication, and HA/DR configurations.
• Knowledge of database security, user privileges, encryption, and auditing.
• Experience with database monitoring, capacity planning, performance baselining, and troubleshooting.
• Familiarity with Linux administration and shell scripting.
• Experience managing large databases and handling production workloads.

Preferred Skills

• Experience with Azure Database for MySQL, AWS RDS for MySQL, or other managed MySQL services.
• Knowledge of cloud database migration, cost optimization, and monitoring tools.
• Experience with Percona Toolkit, MySQL Enterprise tools, or equivalent database diagnostic utilities.
• Exposure to automation, CI/CD, infrastructure as code, and database change management.
• Experience with high-volume transactional applications and 24×7 production environments.