DBA – Database Administrator

DBA – Database Administrator MariaDB – Cluster Admin Location Openings Work Mode Hyderabad DBA – 5 Yrs Sr. DBA – 8 Yrs Work from Office (5 days/week) Overview We are seeking an experienced DBA / Senior 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 possess deep expertise in database architecture, replication, clustering, performance tuning, and high-availability setups, along with hands-on experience in developing complex database applications, triggers, and stored procedures. Key Responsibilities Design, develop, and maintain databases and database applications using MariaDB Deploy, manage, and maintain MariaDB with Galera Cluster to ensure high availability and fault tolerance Monitor and optimize MariaDB, ProxySQL, and Galera Cluster performance, including node synchronization and overall cluster health Configure and manage database replication, clustering, and failover mechanisms Develop efficient database triggers and stored procedures Design and maintain database schemas that effectively 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 backups based on GFS strategy, along with disaster recovery and database recovery processes 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 5–8 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 in query optimization, performance tuning, and database troubleshooting Strong expertise in writing database triggers and stored procedures Experience managing large-scale databases and mission-critical systems Familiarity with backup, monitoring, and disaster recovery strategies Strong analytical and problem-solving skills Ability to work effectively in a collaborative team environment Excellent written and verbal communication skills Preferred Qualifications Experience with Percona XtraDB Cluster or similar clustering technologies Experience with cloud database platforms (AWS RDS, Aurora, Azure, etc.) Familiarity with NoSQL databases such as MongoDB Experience with database monitoring tools (Percona Monitoring, Prometheus, Grafana, etc.) Experience managing environments with 100 MariaDB database instances Experience with ETL pipelines and data warehousing solutions Expertise in OS-level and database performance tuning and optimization Expertise in MySQL replication setup, including Group Replication, GTID, and troubleshooting Strong experience in setting up high availability (HA) and disaster recovery (DR) architectures Experience conducting DR drills and validation exercises Experience in data migration activities Good-to-have knowledge across multiple database domains: MariaDB, PostgreSQL, MongoDB; Graph databases (Neptune, OrientDB, etc.); Vector databases (FAISS, Chroma, Pinecone, Weaviate, etc.); PrestoDB, Apache Pinot, RocksDB Working knowledge of Linux file systems and LVM Familiarity with cloud environments and virtualization technologies Expertise in automating routine tasks using Shell / Perl scripting Ability to work under pressure while managing multiple tasks and priorities Self-motivated and capable of working independently Strong attention to detail with a focus on delivering high-quality results Excellent communication skills, with the ability to translate technical concepts for diverse audiences Strong troubleshooting, diagnostic, and problem-solving capabilities Additional Skills (Good to Have) Storage systems Shell scripting Perl scripting MySQL Workbench