Job Description

Key Responsibilities

Database Administration

• Install, configure, and maintain MySQL Community Edition databases across production, staging, and development environments.
• Perform upgrades, patches, and version migrations for community edition setups.
• Manage schemas, tables, indexes, partitions, and storage engines (InnoDB, MyISAM, etc.).
• Implement and maintain backup & recovery strategies using open-source tools (mysqldump, Percona XtraBackup).

Performance & Optimization

• Monitor and tune query performance, indexes, buffer pools, and database configuration parameters.
• Conduct slow query analysis, execution plan reviews, and schema optimization.
• Use open-source tools like Percona Toolkit, PMM, or custom scripts to improve performance.

High Availability & Replication

• Set up and maintain replication topologies such as:
• Asynchronous / Semi-synchronous replication
• Masterslave / multi-source replication
• Manage failover, disaster recovery, and infrastructure redundancy.
• Implement backup testing and end-to-end DR drills.

Security & Compliance

• Configure and manage user roles, privileges, audit logs, encryption (TLS/SSL).
• Ensure compliance with internal security policies for open-source DB environments.
• Conduct periodic security hardening for MySQL Community Edition.

Automation & Scripting

• Automate routine DBA tasks using Bash, Shell, Python, or Ansible.
• Maintain automated monitoring, alerts, and reporting dashboards for database health and capacity.

Troubleshooting & Support

• Provide L2/L3 support for database issues, outages, deadlocks, and replication failures.
• Perform root cause analysis (RCA) and implement permanent fixes.
• Work closely with development teams for schema design, SQL reviews, and migration planning.

Documentation & Best Practices

• Maintain updated documentation for architecture, configuration, SOPs, and DR plans.
• Introduce industry best practices for open-source MySQL operations.

Required Skills & Experience

• 9-15 + years of experience as a MySQL DBA (Community Edition or Open Source ecosystem).
• Strong expertise in MySQL internals, storage engines, query optimizer, and replication.
• Hands-on experience with Linux environments (Ubuntu, RHEL, CentOS).
• Proficiency in performance tuning, optimizing schema and SQL queries.
• Experience with backup/recovery, monitoring tools, and HA configurations.
• Scripting skills: Shell, Bash, Python.
• Understanding of cloud platforms (AWS, GCP, Azure) is an added advantage.

Preferred Qualifications

• Experience with Percona Server, MariaDB, or Galera Cluster.
• Knowledge of DevOps, CI/CD pipelines, and infrastructure-as-code.
• Exposure to microservices-based architectures and high-throughput systems.
• Experience with Docker/Kubernetes database deployments is a bonus.

Soft Skills

• Strong analytical and problem-solving abilities.
• Good communication skills to collaborate with developers, architects, and product teams.
• Ability to work in high-pressure, production-critical environments.

More Info

Education