RDS (PostgreSQL) Lead

Hello Professional,

Our client is looking  RDS (PostgreSQL) Lead project in Los Angeles, CA below is the detailed requirements.

Role: RDS (PostgreSQL) Lead

Locations: Los Angeles, CA

Contract role

Exp: 12 Yrs

Job Description:

• Strong expertise in PostgreSQL 8 years, hands on experience with AWS RDS Aurora PostgreSQL 3 years
• Deep understanding of Query optimization execution plans, WAL replication vacuum indexing, High availability and failover
• AWS Cloud Skills: Strong knowledge of AWS services, RDS EC2 S3 IAM VPC
• Experience with monitoring tools CloudWatch Performance Insights
• Familiarity with cost optimization FinOps
• Automation Scripting: Proficiency in Python Shell scripting
• Experience with Infrastructure as Code tools
• Data Integration: Experience with Data migration tools AWS DMS pgdum prestore
• ETL/ELT pipelines, Understanding of data warehousing concepts

Preferred Qualifications:

• AWS Certification Database Solutions Architect
• Experience with Aurora Global Database Serverless
• Exposure to Docker Kubernetes, Knowledge of Kafka or streaming platforms

Responsibilities:

• 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 and failover testing

Cloud Architecture:

• Design scalable and reliable database architectures on AWS
• Implement Infrastructure as Code Terraform CloudFormation
• Work with VPC IAM S3 EC2 and networking components
• Collaborate with DevOps for CICD integration

Security Compliance:

• Implement database security best practices IAM roles encryption
• Manage encryption at rest and in transit
• Ensure compliance with enterprise security standards
• Conduct audits and vulnerability assessments

Troubleshooting Production Support:

• Provide L2L3 support for critical production systems
• Perform root cause analysis RCA for incidents
• Ensure system uptime and SLA adherence

Leadership Mentorship:

• Lead a team of DBAs and engineers
• Mentor team members and drive knowledge sharing
• Establish standard processes and automation practices