Responsibilities

• Install, configure, and maintain MySQL database instances (on-premises and cloud-based).
• Monitor database performance and optimize queries, indexing, and schema design.
• Implement and manage backup, recovery, and disaster recovery strategies.
• Configure and maintain replication setups (Master-Slave, Group Replication, MySQL Cluster).
• Troubleshoot and resolve database-related issues, including outages and performance bottlenecks.
• Enforce security best practices including access control, encryption, and compliance with standards such as GDPR and PCI-DSS.
• Automate routine database administration tasks using Shell, Python, and SQL scripts.
• Perform database upgrades, migrations, and patching with minimal service disruption.
• Monitor system health, storage utilization, and capacity planning using MySQL and third-party monitoring tools.
• Collaborate with development teams to design efficient schemas, optimize queries, and support application scalability.

Requirements

• Proven experience as a MySQL DBA in both on-prem and cloud environments.
• Strong knowledge of replication, backup/recovery, and performance tuning.
• Experience with automation tools and scripting (Shell, Python, SQL).
• Familiarity with MySQL monitoring tools and infrastructure planning.
• Solid understanding of database security and compliance standards.
• Strong analytical, troubleshooting, and communication skills.

Posted By