More jobs:
MySQL Database Administrator; DBA AWS RDS
Job Description & How to Apply Below
Location: Bengaluru
About the Role
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.
The ideal candidate should have practical experience managing high-availability MySQL databases, troubleshooting performance issues, optimizing complex queries, implementing backup and disaster recovery strategies, and administering databases hosted on AWS.
You will work closely with application developers, Dev Ops engineers, and infrastructure teams to ensure our databases remain secure, highly available, scalable, and performant.
Key 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
Cloud Watch 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, Cloud Watch, 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.
Required Skills
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, connection, IOPS, storage, and slow-query issues.
Strong SQL skills and ability to analyze and optimize complex queries.
Experience with AWS Cloud Watch 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 Dev Ops 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, Cloud Formation, 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…
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×