AWS RDS DBA / Cloud Database Engineer

• We are looking for an experienced AWS RDS DBA / Cloud Database Engineer.. • The candidate should have strong hands-on experience in managing production database workloads on AWS.. • This role requires knowledge of AWS RDS, AWS DMS, database optimization, RDS Proxy, monitoring, backup, migration, and upgrade planning.. • The candidate should not be limited to traditional DBA activities like basic backup, restore, and SQL query writing.. • The person should understand cloud database operations, performance tuning, migration planning, and production troubleshooting..

Key Responsibilities • Manage and maintain AWS RDS database instances for MySQL, PostgreSQL, MariaDB, or SQL Server.. • Handle RDS instance creation, configuration, sizing, storage planning, and maintenance.. • Configure and manage RDS backups, snapshots, point-in-time recovery, and restore testing.. • Work with RDS parameter groups, option groups, subnet groups, security groups, and maintenance windows.. • Monitor database health using AWS CloudWatch, Performance Insights, Enhanced Monitoring, and database logs.. • Troubleshoot production issues such as high CPU, high memory usage, high connections, slow queries, deadlocks, replication lag, and IOPS bottlenecks.. • Perform database performance optimization, including query tuning, index optimization, schema review, and workload analysis.. • Work on AWS DMS-based database migration projects.. • Configure AWS DMS source endpoints, target endpoints, replication tasks, full load, CDC, validation, and cutover planning.. • Plan and execute database migration with minimum downtime.. • Prepare rollback plans for database migration and upgrade activities.. • Implement and manage RDS Proxy for connection pooling and high-traffic applications.. • Configure and maintain RDS Multi-AZ, read replicas, storage autoscaling, and failover readiness.. • Plan low-downtime database upgrades using RDS Blue/Green Deployment or replica-based upgrade approach.. • Evaluate and recommend RDS performance features such as Optimized Writes, Optimized Reads, gp3/io2 storage, provisioned IOPS, and instance class upgrades.. • Work with developers and DevOps teams to improve database performance and application stability.. • Implement database security best practices including encryption, SSL/TLS, least privilege access, Secrets Manager, KMS, and audit logging.. • Prepare database health reports, optimization reports, migration plans, upgrade runbooks, and RCA documents..

Required Skills • Strong hands-on experience with AWS RDS administration.. • Good understanding of MySQL, PostgreSQL, MariaDB, or SQL Server.. • Experience in database performance tuning and production troubleshooting.. • Hands-on experience with AWS DMS for database migration or replication.. • Knowledge of full load, CDC, replication tasks, migration validation, and cutover planning.. • Experience with RDS snapshots, automated backups, point-in-time recovery, read replicas, and Multi-AZ.. • Good understanding of RDS Proxy and database connection pooling.. • Experience with CloudWatch, Performance Insights, Enhanced Monitoring, alarms, and database logs.. • Knowledge of parameter groups, option groups, subnet groups, VPC, and security groups.. • Ability to troubleshoot slow queries, indexing issues, locks, deadlocks, replication lag, and high connection issues.. • Understanding of RDS Blue/Green upgrade approach and rollback planning.. • Ability to recommend the right solution between query optimization, indexing, storage tuning, instance upgrade, read replica, or RDS Proxy.. • Good written and verbal communication skills..

Good to Have Skills • AWS Certified Database – Specialty certification.. • AWS Solutions Architect certification.. • Experience with Amazon Aurora MySQL or Aurora PostgreSQL.. • Experience with Terraform or CloudFormation for RDS infrastructure automation.. • Knowledge of AWS Secrets Manager, IAM authentication, KMS, and database audit logging.. • Experience with high-traffic SaaS, eCommerce, fintech, healthcare, or enterprise application databases.. • Knowledge of Linux, shell scripting, PowerShell, or Python for DBA automation.. • Experience with SQL Server on AWS RDS..

Candidate Should Know • How to migrate an on-premise database to AWS RDS using AWS DMS.. • Difference between AWS DMS full load and CDC.. • Difference between Multi-AZ, read replica, snapshot, PITR, and DMS replication.. • When to use RDS Proxy and how it helps in connection-heavy applications.. • How to troubleshoot high CPU, high database connections, slow queries, locks, and IOPS issues in RDS.. • How to plan a low-downtime RDS version upgrade.. • How RDS Blue/Green Deployment works.. • How to create a rollback plan before database migration or upgrade.. • How to use Performance Insights and CloudWatch to identify database bottlenecks..

Minimum Qualification • 3+ years of experience in database administration or database engineering.. • At least 1–2 years of hands-on production experience with AWS RDS.. • Experience with MySQL, PostgreSQL, MariaDB.. • Experience in database backup, restore, monitoring, troubleshooting, migration, and optimization..

Who Should Not Apply • Candidates with only local MySQL or SQL Server experience and no AWS RDS exposure.. • Candidates who only know basic backup, restore, and SQL queries.. • Candidates who have not worked on production database troubleshooting.. • Candidates without practical knowledge of AWS RDS, AWS DMS, monitoring, migration, or optimization..

About Client • Our client is India's leading Food Tech Product Company, Job Location is Bangalore - Whitefield .

Apply Now • Apply if you have hands-on experience with AWS RDS, AWS DMS, database optimization, and cloud database operations..

• • We are looking for candidates who can manage real production workloads, not only basic DBA tasks..