MY SQL DBA Expert - 100% Remote
Job Title: MY SQL DBA Expert Location: 100% Remote Visa: Any Interview Process: Video (2 Rounds) 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