MySQL DBA

We are looking for an experienced MySQL DBA with 8+ years of hands-on experience in database administration, performance tuning, high availability, backup/recovery, and production support. The candidate should have strong experience managing large-scale MySQL environments and troubleshooting critical database issues., * Administer and support MySQL databases in production and non-production environments.

• Perform database installation, configuration, upgrades, patching, and migrations.
• Monitor database health, performance, capacity, and availability.
• Perform SQL query and database performance tuning.
• Analyze slow queries, execution plans, locks, deadlocks, and resource utilization.
• Configure and troubleshoot MySQL Replication and high-availability environments.
• Manage backup and recovery using tools such as MySQL Enterprise Backup, XtraBackup, or equivalent.
• Perform database recovery and disaster-recovery activities.
• Troubleshoot database incidents and provide root-cause analysis.
• Manage users, roles, privileges, security, and access controls.
• Work with development teams to optimize SQL queries, indexes, stored procedures, and database design.
• Perform database upgrades, migrations, and version upgrades with minimal downtime.
• Develop monitoring, automation, and maintenance scripts.

• 8+ years of MySQL DBA experience
• Strong knowledge of MySQL 5.7/8.x
• Advanced SQL and query optimization
• Indexing and execution-plan analysis
• MySQL Replication
• Backup & Recovery
• Performance tuning
• High Availability / Disaster Recovery
• InnoDB architecture and storage engines
• Transactions, locking, and deadlocks
• Partitioning
• Linux/Unix administration
• Shell scripting
• Database security and access management
• Monitoring and troubleshooting tools

Good to Have

• AWS RDS / Aurora MySQL
• MySQL Group Replication / InnoDB Cluster
• ProxySQL / MySQL Router
• Percona Toolkit / XtraBackup
• AWS cloud migration experience
• Terraform or automation experience
• Experience with large-scale enterprise databases

Production Scenario Experience

Candidates should be able to troubleshoot scenarios such as:

• Sudden high CPU or memory utilization
• Slow-running SQL queries
• Replication lag
• Deadlocks and blocking transactions
• Database outages
• Backup failures
• Database corruption/recovery
• Storage capacity issues
• Performance degradation after a database upgrade