Database Administrator

XtraNet Technologies Limited

3 years

0 Lacs

bhopal madhya pradesh india

Posted:3 months ago| Platform:

Apply

Skills Required

database mysql clustering replication backup tuning monitoring design failover indexes configuration strategy test metrics query security encryption audit troubleshooting linux management zabbix automation ansible terraform chef communication documentation

Work Mode

On-site

Job Type

Full Time

Job Description

Location:

Experience:

Job summary

We are looking for a hands-on MySQL DBA with 2–3 years of experience to manage, tune and maintain MySQL databases (including clustering & replication) for production systems. The ideal candidate will own availability, backup & recovery, performance tuning, and monitoring for OLTP workloads.

Key responsibilities

Install, configure and maintain MySQL instances (5.7/8.0 or higher) in production and staging.
Design, implement and manage MySQL clustering and high-availability solutions (Galera / Percona XtraDB Cluster / MySQL InnoDB Cluster or equivalent).
Implement and maintain replication topologies (asynchronous, semi-sync, group replication); perform failover and recovery.
Performance tuning: diagnose slow queries, optimize schema/indexes, tune MySQL configuration and OS-level settings.
Backup & recovery strategy: implement automated backups, test restores, point-in-time recovery.
Monitor DB health (alerts, metrics) and troubleshoot DB incidents (connectivity, locking, replication lag).
Work with developers to review schema changes, query plans and migrations.
Maintain security best practices: users, roles, encryption, audit as per policy.
Document processes, runbooks and change records; participate in on-call rota when required.

Required skills & qualifications

2–3 years hands-on experience as MySQL DBA or Database Engineer.
Strong practical knowledge of MySQL internals (InnoDB, buffer pool, transaction handling).
Experience with MySQL clustering & HA solutions (Galera, Percona XtraDB Cluster, MySQL Group Replication, or InnoDB Cluster).
Experience implementing and troubleshooting replication (master-slave, master-master, multi-source).
Experience with backup tools (mysqldump, xtrabackup, mysqlpump) and recovery operations.
Solid Linux administration skills (system tuning, I/O, kernel params).
Familiarity with monitoring tools (Prometheus/Grafana, Percona Monitoring & Management, Zabbix, Nagios).
Knowledge of automation/config management (Ansible, Terraform, Chef) is a plus.
Good troubleshooting, communication and documentation skills.

More Jobs at XtraNet Technologies Limited

AI/MLOps Professional

Gujarat, India

7.0 - 7.0 yrs

Salary: Not disclosed

Solution Architect - .NET

Gandhinagar, Gujarat, India

7.0 - 7.0 yrs

Salary: Not disclosed

Database Administration

Bhopal, Madhya Pradesh, India

20.0 - 20.0 yrs

Salary: Not disclosed

Pre-Sales Executive (LinkedIn Specialist)

Bhopal, Madhya Pradesh, India

1.0 - 1.0 yrs

Salary: Not disclosed

Senior Mobile App Developer

Bhopal, Madhya Pradesh, India

20.0 - 20.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

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.