2.0 - 3.0 years

4 - 8 Lacs

bengaluru, thiruvananthapuram

Work from Office

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

Posted 2 weeks ago

Apply

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.