MYSQL DBA Developer

2 - 3 years

4 - 8 Lacs

Posted:2 weeks ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are looking for an adept MySQL Database Administrator (DBA) + Developer with 23 years of

experience, including hands-on work with clustering technologies. The role demands proficiency in both database administration and development, with a strong focus on high availability, replication,

and system reliability. The engineer will provide essential business support, including off-hours and

247 on-call coverage as required.

Key Responsibilities

  • Install, configure, and upgrade MySQL databases across development, testing, and

production environments.

  • Set up and maintain clustering configurations (including master-slave and multi-node

master-master set-ups) to deliver high availability and redundancy.

  • Configure and manage read/write replicas supporting scalable, reliable application

workloads.

  • Monitor and manage MySQL cluster nodes, ensuring healthy state, prompt failover, and

consistent data replication across all participating nodes.

  • Plan and execute database migrations, upgrades, and patching in clustered environments,

with minimal impact to business operations.

  • Analyze and optimize database performance, including tuning node communication,

replication lag, query speed, and overall cluster reliability.

  • Develop and maintain MySQL database objects: tables, views, stored procedures, triggers,

and functions.

  • Implement and manage backup/recovery strategies, routinely test recovery using all cluster

nodes.

  • Automate administration tasks through scripts and available tooling, especially for routine

checks across cluster nodes.

  • Support application developers in writing complex queries, optimizing SQL code, and

troubleshooting database issues within clustered and non-clustered environments.

  • Enforce security best practices including management of user accounts, roles, and privileges

within distributed setups.

  • Maintain comprehensive documentation on all configurations, cluster setups, node roles,

and operating procedures.

  • Participate in 247 business-support rotations as required, providing timely incident

response and resolution for critical and routine database issues.

  • Perform planned and scheduled maintenance activities during weekends or night hours to

minimize business disruption.

Required Skills & Qualifications

  • Education: Bachelor’s degree in Computer Science, IT, or equivalent experience.
  • Experience: 2–3 years as MySQL DBA/Developer, including support for clustering and

replication.

  • Technical Skills:
  • Deep knowledge of MySQL cluster architectures, master-slave, master-master, and

multi-node configurations.

  • Experience administering and troubleshooting read and write replicas.
  • Proficient in SQL development: stored procedures, triggers, functions.
  • Expertise with performance monitoring, query optimization, and tuning in clustered

setups.

  • Skills in Linux/Unix administration and scripting for cluster automation.
  • Familiar with backup/recovery methods for distributed environments (mysqldump,

Percona XtraBackup, etc.).

  • Understanding of database security and user management in clusters.
  • Experience with cloud platform MySQL services (AWS RDS, Azure Database for

MySQL, etc.) is a plus.

  • Basic familiarity with version control and CI/CD tooling.

Desired Attributes

  • Analytical and troubleshooting ability in distributed and replicated environments.
  • Strong communication and documentation skills for collaboration across technical teams.
  • Flexibility to work out-of-hours and respond quickly to database incidents.
  • Proactive approach to learning new clustering, automation, and cloud technologies.
  • Commitment to best practices and continuous improvement in high-availability database

infrastructures.

Additional Information

  • Role requires participation in an on-call rotation with 247 coverage as dictated by business

need.

  • Planned maintenance activities may occur during nights or weekends to ensure system

uptime and reliability.

  • Chance to influence high-availability architecture and automation strategies within a fast

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Centilytics logo
Centilytics

Cloud Management

Bangalore

RecommendedJobs for You

bengaluru, thiruvananthapuram

chandigarh, panchkula, zirakpur