MySQL Database Administrator

**Job Description
- MySQL Engineer**

As an L3 MySQL Database Engineer, you will be responsible for the advanced administration, troubleshooting, and optimization of MySQL databases within our environment. You will provide expert-level support for complex database issues, lead troubleshooting efforts, and contribute to the development and implementation of database architecture best practices.

You will work closely with cross-functional teams, including developers, system administrators, and cloud engineers, to ensure the availability, performance, security, and scalability of MySQLbased solutions.

**Responsibilities**:

- Provide expert-level troubleshooting for critical database issues, including performance degradation, slow queries, deadlocks, and replication failures.
- Manage and optimize large-scale MySQL database environments, including configuration, clustering, replication, and backup strategies.
- Implement and monitor performance tuning techniques such as query optimization, indexing, and resource allocation.
- Troubleshoot and resolve complex issues related to MySQL replication, sharding, and failover configurations.
- Design and implement high-availability (HA) and disaster recovery (DR) solutions using MySQL clustering, MySQL Group Replication, and other related technologies.
- Collaborate with development teams to optimize database queries, schemas, and stored procedures for performance and scalability.
- Work with cloud teams to manage MySQL databases in cloud environments (AWS, Azure, GCP).
- Contribute to the automation of database management tasks using scripting languages (e.g., Bash, Python, Ansible).
- Ensure robust database security practices, including user roles, encryption, and audit logging.
- Provide guidance and mentorship to junior team members and participate in code and database architecture reviews.
- Maintain comprehensive documentation for database architectures, configurations, and troubleshooting procedures.
- Participate in on-call rotation to support database environments during critical incidents or system downtimes.

**Key Skills & Qualifications**:

- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
- Minimum of 5+ years of experience managing and administering MySQL databases in production environments.
- In-depth knowledge of MySQL architecture, query optimization, replication, clustering, and failover mechanisms.
- Hands-on experience with MySQL performance tuning and troubleshooting (e.g., slow query logs, EXPLAIN plans, indexing).
- Strong expertise in_**MySQL**_**high-availability solutions, including MySQL Cluster, MySQL Group Replication, and Galera Cluster.**:

- Experience with MySQL backup strategies and disaster recovery planning (e.g., logical backups, physical backups, point-in-time recovery).
- Familiarity with cloud-based database platforms and managing MySQL in cloud environments (AWS RDS, Google Cloud SQL, Azure Database for MySQL).
- Strong understanding of database security concepts, including encryption (data-at-rest, data-in-transit), user authentication, and role-based access control.
- Experience with automation and configuration management tools such as Ansible, Chef, or Puppet.
- Knowledge of containerized environments (Docker, Kubernetes) and their integration with MySQL.
- Strong scripting skills **(Bash, Python, or similar languages)** to automate tasks and database management processes.
- Familiarity with monitoring tools like Prometheus, Nagios, Percona Monitoring and Management (PMM), or Zabbix.
- Excellent problem-solving and analytical skills, with a proactive approach to identifying and resolving database issues.
- Strong communication and collaboration skills, with the ability to mentor and work effectively with other teams.

**Preferred Skills**:

- Certifications in **MySQL or database administration (e.g., MySQL DBA certification, Oracle Certified Professional).**:

- Experience with **database-as-a-service (DBaaS)**offerings and hybrid cloud environments.
- Knowledge of additional databases (**e.g., MariaDB, PostgreSQL) or NoSQL**technologies is a plus.

**Job Types**: Full-time, Permanent

Pay: ₹1,000,000.00 - ₹1,400,000.00 per year

**Benefits**:

- Paid sick time
- Provident Fund

Schedule:

- Day shift

**Experience**:

- MySQL: 5 years (required)
- MySQL architecture: 3 years (required)
- MySQL in cloud environments: 3 years (required)
- MySQL or DBA certification: 3 years (required)

License/Certification:

- MySQL DBA certification (required)

**Location**:

- Pune, Maharashtra (required)

Work Location: In person