06 Sep
|
Nextwebi IT Solutions
|
Bengaluru
06 Sep
Nextwebi IT Solutions
Bengaluru
About the Role
We are looking for an experienced MySQL Database Administrator (DBA) with robust 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, DevOps 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
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, I
📌 MySQL Database Administrator (Bengaluru)
🏢 Nextwebi IT Solutions
📍 Bengaluru