Database Administrator

We are seeking a highly skilled MySQL and PostgreSQL Database Administrator having 5 to 6 years of experience to manage, optimize, secure, and support mission-critical on-premise and/or cloud database environments. The DBA will be responsible for installation, configuration, performance tuning, high availability (HA), replication, backup & recovery, writing/optimizing advanced SQL queries and troubleshooting.

The ideal candidate must have strong expertise in MySQL & PostgreSQL internals , replication technologies, and experience supporting production workloads.

Key Responsibilities:

1. Installation, Configuration & Upgrades
2. Performance Monitoring & Tuning
3. Database Migration and upgradation
4. High Availability (HA) & Replication
5. Backup, Recovery & Disaster Recovery
6. Maintenance & Housekeeping
7. Write, analyze, and optimize complex SQL queries for OLTP and reporting workloads
8. Security & Compliance
9. Monitoring & Alerting
10. Troubleshooting & Root Cause Analysis

Core Technical Skills:

1. PostgreSQL:

• Streaming replication, logical replication, WAL internals
• Autovacuum, bloat management, MVCC internals
• pg_partman, pg_repack, TimescaleDB extensions
• HA solutions: Patroni, repmgr, HAProxy, etcd
• Performance tuning using pg_stat_statements

1. MySQL:

• InnoDB engine internals
• Replication (async/semi-sync), GTIDs
• Performance tuning (buffer pool, redo logs, tmp usage)
• MySQL 5.7/8.0 optimizer & indexing strategies
• Troubleshooting deadlocks, long transactions

1. Preferred / Nice-to-Have

• Experience with Docker or Kubernetes (StatefulSets)
• Knowledge of Citus, TimescaleDB, pgpool-II
• Familiarity with Cloud DB offerings (AWS RDS, Aurora, Azure PG/MySQL)
• Understanding of CI/CD pipelines
• EDB certification
• ETL development