Responsibilities:
Install, configure, and maintain MySQL database servers across development, test, and production environments.
Monitor database performance proactively and tune configurations for optimal efficiency.
Implement, manage, and test backup and recovery procedures to ensure data integrity and availability.
Ensure database security, access controls, and compliance with data protection regulations.
Optimize SQL queries, indexes, and database structures for application performance improvements.
Manage user roles, privileges, and access permissions.
Configure and maintain MySQL replication, monitor replicas, and ensure replication health.
Troubleshoot, diagnose, and resolve complex database issues in a timely manner.
Design, implement, and support high-availability and disaster recovery solutions (replication, clustering, failover).
Collaborate closely with development and operations teams to support database needs and deployments.
Maintain detailed documentation of database configurations, standards, and procedures.
Manage MySQL deployments in cloud environments such as AWS RDS/Aurora, GCP Cloud SQL, and Azure Database for MySQL.
Requirements:
Proven experience as a MySQL Database Administrator (DBA) in production environments.
Strong understanding of MySQL architecture, internals, and storage engines.
Hands-on experience with database performance tuning, query optimization, and profiling tools.
Proficiency in configuring and managing MySQL replication (asynchronous, semi-synchronous, GTID-based) and managing replicas.
Strong knowledge of MySQL backup and recovery tools such as Percona XtraBackup, MariaBackup, and native MySQL tools.
Familiarity with Percona Toolkit and other MySQL utilities for monitoring, maintenance, and troubleshooting.
Experience with MySQL version upgrades and database migrations (in-place and cross-platform).
Proven experience with high-availability solutions including: Percona XtraDB Cluster (Galera-based), MySQL InnoDB Cluster and good to have if having knowledge on MMM (Master-Master Replication Manager) controller and agent management.
Experience with replication topologies (master-slave, multi-source replication, clustering, etc.) and disaster recovery planning.
Experience managing MySQL in cloud environments (AWS RDS/Aurora, GCP Cloud SQL, Azure Database for MySQL).
Strong SQL skills and proficiency in scripting (Shell, Python, or Perl).
Solid knowledge of Linux/Unix/Windows operating systems and system-level troubleshooting.
Excellent analytical, problem-solving, and troubleshooting skills.
Strong communication skills and ability to work collaboratively in cross-functional teams.
Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
Education:
High school diploma or equivalent required. Bachelor’s degree in related field of software development, database programming, or computer engineering required.
Experience:
Six+ years of experience as a MySQL DBA. Experience in software development, database programming, computer engineering or a related technological field. Proven experience implementing and supporting enterprise database systems.
Experience in other DB Technologies such as Postgres or Oracle databases is additional advantage.
