Description :

You will work in a fast-paced environment where you will be responsible for the most critical systems.

Our external teams ( Customers ) count on us to keep their MySQL databases running, and we are vital to the success of their businesses.

You will troubleshoot and resolve customer issues related to the DB system's availability and performance.

You will develop relationships with customers, comprehend and fulfil their needs, and maintain their satisfaction through regular communication and engagement with their environments.

Key Responsibilities :

- Database Performance Optimization : Optimize complex SQL queries and database structures to enhance performance.

- Query Analysis & RCA : Analyze database errors, troubleshoot issues, and provide detailed Root Cause Analysis (RCA) when required.

- Alert Management : Handle and resolve MySQL alerts efficiently, ensuring database stability.

- Client Interaction : Join client calls to discuss database performance, troubleshooting, and optimization strategies.

- Mentoring & Training : Guided and mentored Associate Database Engineers (ADBEs) to improve their database troubleshooting skills.

- Documentation & Process Improvement : Maintain and improve technical documentation, RCA reports, and operational processes for better efficiency.

- Shift Responsibilities : The role may involve night shifts and on-call support as per business needs.

- Community Contribution : Actively participate in the database community and contribute to blogs, open-source projects, and knowledge-sharing initiatives.

Required Skills & Expertise :

1. Strong SQL Optimization Skills Proficient in optimizing queries, indexing strategies, and MySQL performance tuning.

2. MySQL Administration Deep understanding of MySQL architecture, replication, and troubleshooting.

3. Backup & Recovery Expertise Hands-on experience with :

- Mysqldump

- mydumper/myloader

- Xtrabackup / mariabackup

4. Replication & High Availability Expertise in :

- Binlog-based replication

- GTID-based replication

5. InnoDB architecture and performance tuning

6. Cloud & AWS Operations Experience with :

- AWS RDS / Aurora

- S3 bucket operations

7. Linux Commands for Database Operations Proficiency in essential Linux commands

8. Log collection & analysis

9. Incident & RCA Management Ability to analyze issues and document detailed Root Cause Analysis (RCA) reports.

10. Excellent Communication Skills Effectively communicating with clients and internal teams.

11. Problem-Solving & Teamwork Strong analytical skills, team collaboration, and willingness to take ownership.

Added Advantage :

- Experience in Galera Cluster and Group Replication

- Knowledge of ProxySQL as a load balancer

- Familiarity with monitoring tools (PMM, Nagios, Prometheus, etc)