Role Name: RDS (PostgreSQL) Lead

Location: Los Angeles hybrid



JOB DESCRIPTION:

Key Responsibilities

RDS PostgreSQL Administration

Manage Amazon RDS and Aurora PostgreSQL databases in production

Perform installation configuration upgrades patching and migrations

Configure and manage MultiAZ deployments read replicas and failover strategies

Monitor database health using AWS CloudWatch Performance Insights



Performance Tuning Optimization

Analyze and optimize slow queries and execution plans

Tune PostgreSQL parameters sharedbuffers workmem autovacuum etc

Implement indexing partitioning and query optimization strategies

Handle largescale highvolume transactional systems



Backup Recovery High Availability

Implement automated backups and PointinTime Recovery PITR

Design and test disaster recovery strategies

Conduct periodic DR drills...