MySQL Database Administrator (DBA)

Database Administration

• Install, configure, upgrade, and patch MySQL database servers.
• Manage schemas, tables, indexes, partitions, and storage engines.
• Create and maintain stored procedures, triggers, and functions.

Performance Optimization

• Monitor database performance using

  Performance Schema, MySQL Enterprise Monitor, Percona PMM, or similar tools

  .
• Optimize queries, execution plans, and indexing strategies.
• Troubleshoot slow queries, locks, and performance bottlenecks.

Backup, Recovery & Security

• Develop and maintain

  backup/recovery procedures

  using mysqldump,

  Percona XtraBackup

  , or other tools.
• Implement and test

  disaster recovery (DR) and high availability (HA)

  solutions.
• Manage user accounts, roles, and privileges.
• Ensure compliance with

  data security and privacy standards

  .

High Availability & Replication

• Configure and maintain

  MySQL Replication, MySQL Cluster, and/or Percona XtraDB Cluster

  .
• Implement failover, load balancing, and sharding strategies.
• Monitor replication lag and consistency across environments.

Collaboration & Support

• Work closely with application developers on schema design and SQL query optimization.
• Support ETL processes, data migrations, and integration with third-party applications.
• Provide production support and on-call availability for critical incidents.
• Document database processes, SOPs, and troubleshooting guides.

Qualifications

• Bachelors degree in Computer Science, IT, or related field.

• 6+ years of hands-on experience as a MySQL DBA

  .
• Strong skills in

  SQL, query optimization, indexing, and stored procedures

  .
• Experience with

  replication, clustering, and HA/DR solutions

  .
• Knowledge of

  Linux/Unix system administration

  as it relates to MySQL.
• Proficiency with

  backup/recovery strategies and tools

  (mysqldump, XtraBackup, etc.).
• Familiarity with

  cloud databases

  (AWS RDS/Aurora, GCP Cloud SQL, Azure Database for MySQL).

Preferred Skills & Certifications

• MySQL Database Administrator Certification (Oracle MySQL).
• Experience with

  automation/scripting

  (Python, Bash, Ansible).
• Exposure to

  NoSQL databases

  (MongoDB, Redis) is a plus.
• Familiarity with

  DevOps and CI/CD pipelines

  for database deployment.