MySQL Database Administrator (AWS RDS)
Company: Nextwebi Location: Bengaluru, Karnataka (On-site) Job Type: Full-time Experience: 3 – 6 years Notice Period: Immediate to 15 days preferred
About the Role
Nextwebi is looking for an experienced MySQL Database Administrator to manage, optimize, and support our production database environments, both on-premises and on AWS RDS/Aurora. You will be responsible for ensuring database performance, availability, and security while collaborating closely with our development, DevOps, and infrastructure teams in a 24x7 production support environment.
Key Responsibilities
- Install, configure, and maintain MySQL (5.x / 8.x) databases across production, UAT, and development environments.
- Manage and support AWS RDS and Aurora MySQL instances, including provisioning, patching, upgrades, and migrations.
- Implement and manage replication (GTID/asynchronous), Multi-AZ high availability, Read Replicas, and disaster recovery solutions.
- Perform backup and recovery operations using mysqldump, Percona XtraBackup, RDS automated snapshots, and point-in-time recovery (PITR).
- Tune query performance using EXPLAIN, slow query logs, indexing strategies, and database parameter group optimization.
- Monitor database health and performance using CloudWatch, Prometheus, Grafana, or Percona Monitoring & Management (PMM).
- Manage database users, roles, privileges, and ensure compliance with security and audit requirements.
- Automate routine maintenance tasks using Shell/Bash scripting and cron jobs.
- Troubleshoot critical production incidents, including replication lag, locking, and connectivity issues, and provide root cause analysis (RCA).
- Participate in on-call rotation and handle Severity-1 incidents within defined SLAs.
- Collaborate with application, DevOps, and cloud infrastructure teams during releases and deployments.
Required Skills
- Strong hands-on experience with MySQL 5.x/8.x administration in production environments.
- Practical experience with AWS RDS and Aurora MySQL (provisioning, monitoring, scaling, failover).
- Solid understanding of replication, backup/recovery, and high availability concepts.
- Experience with performance tuning, indexing, and query optimization.
- Proficiency in Linux systems and Shell scripting for automation.
- Familiarity with monitoring tools such as CloudWatch, Grafana, Prometheus, or PMM.
- Strong troubleshooting and incident-resolution skills in a production support setting.
Good to Have
- Experience with PostgreSQL or other relational databases.
- AWS certification (Cloud Practitioner, Solutions Architect, or Database Specialty).
- Familiarity with Infrastructure as Code tools (Terraform, CloudFormation).
- Exposure to MongoDB or other NoSQL databases.
Qualifications
- Any graduate (Bachelor's degree in any discipline).
- 3–6 years of relevant experience as a Database Administrator, with a focus on MySQL and cloud database management.
Pay: ₹352,649.12 - ₹1,465,710.06 per year
Work Location: In person
