Freecharge
Website:
freecharge.in
Job details:
Role description
Principal Engineer- Mysql Database Administrator
Location: Gurugram (Hybrid)
Experience: 8-12 Yrs
Education: Bachelors / Masters in Software Engineering
Design, implement, and manage MySQL, Amazon Aurora, and Amazon RDS for MySQL environments in production.
Manage large-scale replication setups (Master–Replica, 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.
Required Skills & Experience
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).
Click on Apply to know more.