Job Opportunities

MySQL Database Administrator – L2

Job Designation: MySQL Database Administrator – Level 2.

Employment Type: Full-time | Onsite.

Experience: 3–5 years in MySQL/MariaDB administration.

About the Role:
The MySQL DBA will manage MySQL databases used by enterprise applications, ensuring reliability, performance, and security. The role includes replication setup, performance tuning, capacity planning, and backup/recovery management.

Key Responsibilities:
• Install, configure, upgrade, and administer MySQL databases
• Manage MySQL replication setups (Master–Slave, GTID, Multi-source)
• Conduct performance tuning, slow query analysis, and index optimization
• Perform backup and restore using mysqldump, MySQL Enterprise Backup, or Percona Tools
• Monitor error logs, slow logs, connections, buffer pools, and memory utilization
• Handle schema changes, storage engine management (InnoDB preferred)
• Implement partitioning, sharding, and optimization strategies
• Ensure DB security, user privileges, SSL/TLS configuration
• Support high-availability solutions (Galera Cluster, Percona XtraDB)
• Conduct regular DR testing & ensure data consistency
• Prepare reports for DB performance, capacity, and health

Required Skills & Experience:
• Strong knowledge of MySQL 5.7 / 8.0
• Hands-on experience in replication, clustering, performance tuning
• Experience with Linux (RHEL/AIX) as MySQL runs primarily on Linux
• Knowledge of backup utilities like Percona XtraBackup
• Understanding of DB security, encryption, and hardening
• Exposure to monitoring tools (Nagios, Prometheus, Grafana)
• Experience supporting banking or mission-critical applications (preferred)