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"