Job Responsibilities

- Design, implement, and manage MySQL, Amazon Aurora, and Amazon RDS for MySQL environments in production.

- Manage large-scale replication setups (MasterReplica, Multi-AZ, cross-region replication) and ensure high availability and disaster recovery.

- Optimize database performance through query tuning, indexing strategies, and workload optimization.

- Architect and maintain highly available, scalable database solutions using Aurora clusters and RDS features.

- Monitor database health using tools (Performance Insights, CloudWatch, etc.) and proactively resolve bottlenecks.

- Plan and execute backup, restore, snapshot, and disaster recovery strategies across environments.

- Lead database capacity planning, scaling strategies (vertical horizontal), and cost optimization in AWS.

- Automate database operations using scripting (Shell/Python).

- Collaborate with application, DevOps, and data engineering teams for schema design and performance improvements.





- Define and enforce database governance, security, and compliance standards.

Location

Gurugram

Experience

Experience Required: 7 - 13 Years

Key Qualifications / Skills

- Robust hands-on experience with MySQL internals, including storage engines, replication, and indexing.

- Extensive experience with AWS database services:

- Amazon RDS for MySQL

- Amazon Aurora (MySQL-compatible)

- Expertise in performance tuning, query optimization, and troubleshooting production issues.

- Deep understanding of replication (binlog, GTID), failover mechanisms, and HA architectures.

- Experience with backup recovery strategies, snapshots, and point-in-time recovery (PITR).

- Familiarity with monitoring tools (Grafana, Percona Toolkit, etc.).

- Knowledge of database security best practices (encryption, IAM, access control).

📌 Principal Database Administrator - DBA (Gurugram)
🏢 freecharge
📍 Gurugram