MY SQL DBA Expert

Position: Senior MySQL Database Administrator
Experience: 10+ Years
Location: Remote
Employment Type: Contract

Job Summary

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.

Key Responsibilities

• 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.

Required Skills

• 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

Key Resume Keywords

MySQL DBA | MySQL 8 | InnoDB | Replication | Performance Tuning | SQL Optimization | Query Optimization | Backup & Recovery | HA/DR | AWS RDS | Aurora MySQL | Linux | Shell Scripting | Partitioning | Indexing | Monitoring | Disaster Recovery | Database Migration