03 Aug
|
freecharge
|
Gurugram
03 Aug
freecharge
Gurugram
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 settings.
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