Manage and administer Amazon Aurora (MySQL & PostgreSQL) and Amazon RDS (MySQL & PostgreSQL) databases in production environments.

Configure and support Aurora Clusters, Writer/Reader Endpoints, Read Replicas, and Multi-AZ deployments.

Perform database provisioning, upgrades, patching, maintenance, and capacity planning.

Monitor database performance using AWS CloudWatch, Performance Insights, Enhanced Monitoring, and native database tools.

Troubleshoot performance bottlenecks, replication lag, slow queries, locking, blocking, deadlocks, and connectivity issues.

Perform backup, restore, snapshot management, and Point-in-Time Recovery (PITR).

Implement database security, encryption, user management, and access control.

Collaborate with application teams for database deployments, releases, and production support.

Participate in incident management,



root cause analysis (RCA), and problem management activities.

Technical Skills

AWS Services ,Amazon Aurora ,Amazon RDS ,CloudWatch ,Performance Insights ,IAM ,VPC ,KMS,AWS Backup

Aurora PostgreSQL

VACUUM / Autovacuum pg_stat_activity

Query Optimization

Index Management

Replication Monitoring

Parameter Groups

Performance Tuning

Aurora MySQL / RDS MySQL

Explain Plans

Slow Query Logs

Query Optimization

Replication

Performance Tuning

Index Optimization

RDS PostgreSQL

Backup & Recovery

PITR

PostgreSQL Replication

Lock Analysis

Capacity Planning

High Availability

Scripting

Shell Scripting

📌 PostgreSQL DBA, AWS RDS, Shell Scripting, MYSQL DBA (Pune)
🏢 Tata Consultancy Services
📍 Pune