MySQL Database Administrator

Job Title-Senior Systems Engineer II-MySQL Database Administrator

Job Description

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 optimization 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.

What Youll Do:

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 optimization, 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, execution, monitoring 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 & 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.What Youll Bring:

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 optimization, 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.

Bachelors degree in Computer Science, Information Technology, or a related field (or equivalent practical experience).