Database Engineer (MySQL)

Overview

Job Description For Database Engineer

Job Title: Database Engineer(MySQL)

Company: Mydbops

About Us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest security and operational excellence standards.

Role Overview:

You will work in a fast-paced environment where we are responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL database running and we are vital to the success of their business. 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: Guide and mentor 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:

• Strong SQL Optimization Skills – Proficient in optimizing queries, indexing strategies, and MySQL performance tuning.
• MySQL Administration – Deep understanding of MySQL architecture, replication, and troubleshooting.
• 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 – Ability to effectively communicate 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.)

Why Join Us:

• Opportunity to work in a dynamic and growing industry.
• Learning and development opportunities to enhance your career.
• A collaborative work environment with a supportive team.

Job Details:

• Job Type: Full-time opportunity
• Work Days - 5 days
• Work time: Rotational shift
• Mode of Employment - Work From Home
• Experience - 1 to 1.5 years

Job Types: Full-time, Permanent

Pay: ₹500,000.00 - ₹700,000.00 per year

Benefits:

• Provident Fund

Schedule:

• Rotational shift

Supplemental Pay:

• Performance bonus

Education:

• Bachelor's (Required)

Experience:

• Database administration: 1 year (Required)

Shift availability:

• Day Shift (Required)
• Night Shift (Required)
• Overnight Shift (Required)

Work Location: Remote