DBA - MySQL Professional

We are seeking a highly skilled and experienced MySQL Database Administrator (DBA) with 6 to 8 years of hands-on experience in managing, securing, and optimizing MySQL database environments. The ideal candidate will be responsible for ensuring database reliability, performance, scalability, and availability across production, development, and test systems.

• Database Administration & Operations:
• Install, configure, and upgrade MySQL databases (Community and/or Enterprise editions).
• Manage multiple database environments including production, development, QA, and staging.
• Perform regular health checks, capacity planning, and proactive monitoring of MySQL instances.
• Manage replication (Master-Slave, GTID-based, Group Replication) and clustering (InnoDB Cluster, Galera).
• Troubleshoot database-related issues (performance, locking, replication lag, crashes, corruption).
• Maintain and enforce database security, user access control, and auditing policies.
• Performance & Tuning:
• Optimize database performance by monitoring slow queries, indexing, partitioning, and caching.
• Analyze execution plans and tune SQL queries and schemas.
• Manage high availability and scalability using replication, clustering, load balancing, and connection pooling.
• Backup & Recovery:
• Implement and maintain robust backup/recovery strategies using mysqldump, mysqlpump, Percona XtraBackup, or equivalent.
• Test disaster recovery procedures regularly to ensure minimal downtime.
• Handle point-in-time recovery and restore operations during incidents.
• Handle DB refresh activity as per the requirement on AWS RDS and on prime environment.
• Automation & Scripting:
• Develop and maintain scripts in Shell/Python/Perl/Ansible to automate routine DBA tasks.

Required Skills 6-8 years of proven experience as a MySQL DBA in large-scale environments. Strong expertise in MySQL 8.0 administration, performance tuning, replication, and clustering. Solid understanding of RDBMS concepts, ACID properties, transactions, and isolation levels. Proficiency in Linux/Unix environments with strong shell scripting skills. Experience in backup/recovery strategies. Hands-on experience with high availability solutions Familiarity with cloud platforms (AWS RDS/Aurora, GCP CloudSQL, Azure MySQL). Strong problem-solving, analytical, and troubleshooting skills. Good communication skills and ability to collaborate with cross-functional teams. Preferred Skills (Good to Have) Exposure to Oracle / MSSQL database administration Experience with Kubernetes / Docker for containerized MySQL deployments. Knowledge of Git Repo for DB pathing, backup, and instance creation.