Source description
About the role
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 Strong 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).
More at Freecharge