Job Description
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
Rate:
Not specified
Location:
Remote or Arkansas
IR35 Status:
Outside
Remote Status:
Remote
Industry:
IT
Seniority Level:
Senior