06 Sep
|
Panzer Technologies
|
Hyderabad
06 Sep
Panzer Technologies
Hyderabad
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
Solid troubleshooting, diagnostic, and problem-solving capabilities
Additional Skills (Good to Have)
Storage systems
Shell scripting
Perl scripting
MySQL Workbench
📌 DBA – Database Administrator (Hyderabad)
🏢 Panzer Technologies
📍 Hyderabad