MY SQL DBA Expert - 100% Remote

SDH Systems LLC; Alaska; Remote; USD 120,000 - 170,000; Full time

Job summary

SDH Systems LLC is seeking an experienced MySQL DBA for a 100% remote role. You will manage large-scale MySQL environments, handle performance tuning, replication, and HA/DR, and provide production support.

The ideal candidate has 8+ years of hands-on experience with MySQL, strong SQL skills, and expertise in backup/recovery, monitoring, and automation. You will collaborate with development teams to optimize queries and database design, while ensuring minimal downtime during upgrades.

Qualifications

• 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.
• High Availability / Disaster Recovery.
• Linux/Unix administration.
• Shell scripting.
• Security and access management.
• Monitoring and troubleshooting tools.

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.

Skills

MySQL DBA 8+yrs

MySQL 5.7/8.x

SQL optimization

Replication & HA

Backup & Recovery

Performance tuning

InnoDB & storage

Linux/Unix admin

Shell scripting

Security & access

Monitoring tools

Indexing & plan analysis

Partitioning

Tools

MySQL Enterprise Backup

XtraBackup

ProxySQL

MySQL Router

Terraform

AWS RDS/Aurora

Job description

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