MySQL Database Administrator (DBA) - AWS RDS

Job Summary

We are looking for an experienced MySQL Database Administrator (DBA) with strong hands-on experience in AWS RDS for MySQL to manage, optimize, secure, and maintain production database environments.

Responsibilities

• Manage and administer MySQL databases across development, staging, and production environments.
• Manage AWS RDS for MySQL instances, configurations, parameter groups, storage, backups, snapshots, and maintenance.
• Monitor database health, availability, CPU, memory, storage, connections, IOPS, and query performance.
• Perform SQL query optimization and performance tuning.
• Identify and troubleshoot slow queries using: Slow Query Log, EXPLAIN / EXPLAIN ANALYZE, Performance Schema, AWS Performance Insights / Database Insights, CloudWatch metrics and logs.
• Optimize indexes, database schemas, queries, and table structures.
• Configure and manage RDS Multi-AZ deployments for high availability.
• Manage Read Replicas and replication-related issues.
• Plan and execute database scaling, including instance upgrades and storage optimization.
• Implement and maintain automated backups, manual snapshots, point-in-time recovery, and disaster recovery procedures.
• Perform database restoration and periodically test backup recovery procedures.
• Handle MySQL version upgrades and AWS RDS maintenance activities.
• Manage database users, roles, privileges, and access controls.
• Implement database security best practices, including encryption, SSL/TLS, IAM integration where applicable, and least-privilege access.
• Work with AWS VPC, Security Groups, IAM, KMS, CloudWatch, Secrets Manager, and other services related to RDS security and monitoring.
• Troubleshoot database connectivity, locking, deadlocks, connection exhaustion, replication lag, and application performance issues.
• Monitor and optimize database storage and infrastructure costs.
• Support database migration from on-premise/VM MySQL to AWS RDS and between RDS environments.
• Assist developers with database design, indexing strategies, stored procedures, queries, and performance improvements.
• Establish database monitoring, alerting, maintenance, and capacity-planning processes.
• Maintain database documentation, SOPs, backup policies, and disaster recovery procedures.
• Participate in production incident troubleshooting and root-cause analysis.

Requirements

• Strong hands-on experience with MySQL Database Administration.
• Strong experience managing AWS RDS for MySQL in production environments.

Excellent knowledge of:

• MySQL architecture
• InnoDB
• Indexing
• Query optimization
• Transactions
• Locking and deadlocks
• Performance tuning
• Backup and recovery
• Replication
• Experience troubleshooting high CPU, memory, IOPS, storage, and slow-query issues.
• Strong SQL skills and ability to analyze and optimize complex queries.
• Experience with AWS CloudWatch and database performance monitoring.
• Understanding of AWS networking concepts such as VPC, subnets, security groups, and private database connectivity.
• Experience with database security, user permissions, encryption, and auditing.
• Experience handling production database incidents and performance bottlenecks.
• Good understanding of High Availability and Disaster Recovery (HA/DR) concepts.
• Ability to work with developers and DevOps teams to troubleshoot application/database performance issues.

Good to Have

• Experience with Amazon Aurora MySQL.
• Experience with AWS Database Migration Service (DMS).
• Experience migrating large MySQL databases to AWS.
• Knowledge of PostgreSQL or Microsoft SQL Server.
• Experience with Terraform, CloudFormation, or other Infrastructure-as-Code tools.
• Knowledge of Linux administration and shell scripting.
• Experience with database monitoring tools such as Grafana, Prometheus, Datadog, or similar.
• Experience supporting databases for high-traffic web applications, SaaS platforms, ERP/CRM systems, or enterprise applications.
• AWS certification or relevant database certification is an advantage.

Experience

2 to 6 years of relevant experience in MySQL Database Administration, with hands-on experience managing AWS RDS MySQL production environments.

What We Are Looking For

We are specifically looking for a hands-on DBA, not someone with only theoretical or basic SQL knowledge. The candidate should be comfortable independently investigating issues such as:

• Why a MySQL RDS instance suddenly reaches 90 100% CPU
• Why an application query that previously took 200 ms now takes several seconds
• How to identify missing or inefficient indexes
• How to troubleshoot deadlocks and locking issues
• How to handle too many database connections
• How to safely restore a production database
• How to minimize downtime during database migration or upgrades
• How to design backup and disaster recovery strategies
• How and when to use Multi-AZ and Read Replicas
• How to improve RDS performance without unnecessarily increasing AWS infrastructure costs

Job Type

Full-Time

Location

Bangalore

Education

Any

Department

Cloud Infrastructure / Database Administration / DevOps

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.