Jr/Database Administrator

My Healthcare; Gurugram District; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

My Healthcare in Gurugram is seeking an experienced DBA to design, manage, and optimize MariaDB databases with Galera Cluster for high availability. You will handle replication, clustering, monitoring, and performance tuning in production environments.

Ideal candidates will have 4-7 years of MariaDB/MySQL experience, strong skills in stored procedures and triggers, and familiarity with backup and disaster recovery strategies. Excellent communication and teamwork are essential.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 4-7 years of experience in MariaDB/MySQL database administration.
• Hands-on experience managing MariaDB with Galera Cluster in production environments.
• Strong understanding of database clustering, replication, and high availability architectures.
• Experience with query optimization, performance tuning, and database troubleshooting.
• Strong experience in writing DB triggers and Stored Procedures.
• Experience managing large-scale databases and mission-critical systems.
• Familiarity with backup, monitoring, and disaster recovery strategies.
• Strong problem-solving and analytical skills.
• Ability to work collaboratively in a team environment.
• Excellent written and verbal communication skills.

Responsibilities

• Design, develop, and maintain databases and database applications using MariaDB.
• Deploy, manage, and maintain MariaDB with Galera Cluster for high availability and fault tolerance.
• Monitor and optimize MariaDB, ProxySQL, Galera Cluster performance, node synchronization, and cluster health.
• Configure and manage database replication, clustering, and failover mechanisms.
• Write efficient DB triggers and Stored Procedures.
• Create database schemas that represent and support business processes.
• Troubleshoot and resolve database performance issues, cluster inconsistencies, and replication failures.
• Ensure data integrity, security, and high availability of production databases.
• Implement backup based on GFS Strategy, disaster recovery, and database recovery strategies.
• Optimize database performance through query tuning, indexing strategies, and server configuration.
• Participate in code reviews and provide technical guidance to team members.
• Collaborate with cross-functional teams to design and implement scalable database solutions.

Skills

MariaDB Administration

Database clustering

Replication

High availability

Query optimization

Performance tuning

Stored Procedures

Triggers

Disaster recovery

Monitoring

Troubleshooting

Team collaboration

Education

Bachelors/Masters in CS/Engineering

Tools

MariaDB Galera Cluster

ProxySQL

Percona XtraDB Cluster

AWS RDS

Azure

Prometheus

Grafana

Job description

We are seeking an experienced DBA to join our team. The successful candidate will be responsible for designing, managing, and maintaining high-availability database systems with a strong focus on MariaDB environments – particularly MariaDB with Galera Cluster.

The ideal candidate will have strong expertise in database architecture, replication, clustering, performance tuning, and high availability setups, along with experience in developing complex database applications and stored procedures.

Key Responsibilities:

• Design, develop, and maintain databases and database applications using MariaDB.
• Deploy, manage, and maintain MariaDB with Galera Cluster for high availability and fault tolerance.
• Monitor and optimize MariaDB, ProxySQL, Galera Cluster performance, node synchronization, and cluster health.
• Configure and manage database replication, clustering, and failover mechanisms.
• Write efficient DB triggers and Stored Procedures.
• Create database schemas that represent and support business processes.
• Troubleshoot and resolve database performance issues, cluster inconsistencies, and replication failures.
• Ensure data integrity, security, and high availability of production databases.
• Implement backup based on GFS Strategy, disaster recovery, and database recovery strategies.
• Optimize database performance through query tuning, indexing strategies, and server configuration.
• Participate in code reviews and provide technical guidance to team members.
• Collaborate with cross-functional teams to design and implement scalable database solutions.

Requirements:

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 4 -7 years of experience in MariaDB/MySQL database administration.
• Hands-on experience managing MariaDB with Galera Cluster in production environments.
• Strong understanding of database clustering, replication, and high availability architectures.
• Experience with query optimization, performance tuning, and database troubleshooting.
• Strong experience in writing DB triggers and Stored Procedures.
• Experience managing large-scale databases and mission-critical systems.
• Familiarity with backup, monitoring, and disaster recovery strategies.
• Strong problem-solving and analytical skills.
• Ability to work collaboratively in a team environment.
• Excellent written and verbal communication skills.

Preferred Qualifications:

• Experience with Percona XtraDB Cluster or similar clustering technologies.
• Experience with cloud database infrastructure (AWS RDS, Aurora, Azure, etc.).
• Familiarity with NoSQL databases such as MongoDB.
• Experience with database monitoring tools (Percona Monitoring, Prometheus, Grafana, etc.).
• Experience in Database environment where more than 500 MariaDB installations.
• Experience with ETL pipelines and data warehousing solutions.

Work location: Gurugram(work from office)