RDS PostgreSQL Lead

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

Cloud Architecture

Design scalable and reliable database architectures on AWS
Implement InfrastructureasCode 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

Required Skills Qualifications

Core Database Skills

Strong expertise in PostgreSQL 8 years
Handson 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 pgdumprestore
ETLELT pipelines
Understanding of data warehousing concepts

Soft Skills

Strong problemsolving skills
Excellent communication and stakeholder management
Ability to work in highpressure environments

Preferred Qualifications

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

Key Competencies

Ownership and accountability
Performance optimization mindset
Leadership and mentoring
Continuous improvement and automation

KPIs Success Metrics

Database uptime and performance
Reduction of incidents and MTTR
Successful DR testing and recovery readiness
Efficiency improvements in query performance
Team productivity and delivery

Nice to Have

Experience with Redshift Snowflake
Knowledge of eventdriven architectures
Exposure to multicloud environments"