Jr/Database Administrator

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)