MySQL Database Administrator (AWS RDS)

MySQL Database Administrator (AWS RDS)

Company: Nextwebi Location: Bengaluru, Karnataka (On-site) Job Type: Full-time Experience: 3 – 6 years Notice Period: Immediate to 30 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.