MySQL Database Administrator (AWS RDS) (Bengaluru)

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 - Robust 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). - 36 years of relevant experience as a Database Administrator, with a focus on MySQL and cloud database management. Compensation: 352,649.12 - 1,465,710.06 per year Work Location: In person 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 - Robust hands-on experience with MySQL 5.x/8.x