MySQL DBA Engineer

We are seeking a highly skilled and experienced MySQL Database Administrator to join our dynamic team. In this pivotal role, you will be responsible for the architecture, deployment, management, and optimisation of our critical MySQL database environments. You will play a key role in ensuring the high availability, performance, and scalability of our data infrastructure, with a particular focus on deployments within Kubernetes.

The candidate will have responsibilities across the following functions:

MySQL Expertise:

• Design, deploy, and manage highly available, scalable, and performant MySQL clusters on Kubernetes clusters/Container platforms in production and non-production environments.
• Perform database installation, configuration, patching, and upgrades for MySQL.
• Implement and manage robust backup and recovery strategies for MySQL (e. g., MySQL Enterprise Backup, mysqldump).
• Monitor MySQL health, performance, and capacity, proactively identifying and resolving issues.
• Conduct performance tuning, query optimisation, and capacity planning for MySQL.
• Manage user access, security, and data encryption for MySQL.
• Troubleshoot complex MySQL-related incidents, performing root cause analysis.
• Lead Life Cycle Management for MySQL DB product.
• Lead projects in the DB space. Plan, design, execute, monitor, and control; drive the closure, articulate project stages, resolve dependencies, etc.

Kubernetes Integration (Highly Desirable):

• Manage MySQL deployments on Kubernetes platforms.
• Automate MySQL deployment, scaling, and management tasks on Kubernetes.
• Familiarity with containerization technologies (Docker) and orchestration (Kubernetes).
• Understand and implement best practices for running stateful applications on Kubernetes.

Leadership and Mentorship:

• Act as a subject matter expert for MySQL, providing technical guidance and mentorship to junior DBAs and development teams.
• Drive the adoption of database best practices, standards, and automation initiatives.
• Lead technical discussions, design reviews, and problem-solving sessions.
• Contribute to strategic planning for database infrastructure and technology roadmaps.

Cross-functional Collaboration:

• Work closely with development, operations, and SRE teams to ensure seamless application and database integration.
• Participate in on-call rotations to provide 24/7 support for critical database systems.
• Document database architecture, procedures, and runbooks.

Additional Database Knowledge (Advantageous):

• Experience working with at least one other NoSQL database technology such as Couchbase is an added advantage.
• Experience with Elasticsearch.
• Experience with Infrastructure as Code (IaC) tools like Terraform.
• Experience with monitoring tools (e. g., Prometheus, Grafana, Splunk) for Elasticsearch and database metrics.

Requirements:

• Mandatory: 5 to 8 years of progressive experience as a Database Administrator, with at least 3+ years specifically focused on MySQL.
• Mandatory: Deep expertise in MySQL architecture, query optimisation, replication (e. g., asynchronous, semi-synchronous, Group Replication), and administration.
• Proven experience with MySQL backup and recovery strategies and tools (e. g., MEB, mysqldump, point-in-time recovery).
• Strong understanding of database security principles and best practices for MySQL.
• Proficiency in scripting languages (e. g., Python, Bash) for automation.
• Excellent troubleshooting, problem-solving, and analytical skills.
• Strong communication and interpersonal skills, with the ability to explain complex technical concepts clearly.
• Bachelor's degree in computer science, Information Technology, or a related field (or equivalent practical experience).

Skills

DBA, Database Administration, Kubernetes, MySQL