AWS RDS DBA with PostgreSQL

JD: AWS RDS DBA(PostgreSQL)/Cloud Database Operations Engineer Role AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer Mode of work: Remote Long Term Job Summary We are seeking an experienced AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer to own the reliability, performance, security, and operational integrity of enterprise database platforms hosted on Amazon Web Services (AWS). The role will support mission-critical applications running on Amazon RDS for PostgreSQL and will work closely with Cloud Engineering, DevOps, Data Engineering, Security, and Application Development teams. The ideal candidate will possess deep expertise in PostgreSQL administration, AWS cloud services, database performance tuning, backup and recovery strategies, high availability architectures, and operational support in regulated enterprise environments. This role is critical to ensuring database availability, performance, recoverability, and security across multiple production and non-production environments. Key Responsibilities AWS RDS Ownership & Operations Own day-to-day administration of Amazon RDS PostgreSQL environments. Manage database availability, health, and performance across development, test, staging, DR, and production environments. Configure and maintain: o RDS instances o Parameter groups o Option groups o Security groups o Networking connectivity Implement and maintain Multi-AZ deployments and read replicas. Work with infrastructure teams to support VPC, Direct Connect, PrivateLink, and cloud networking requirements. Database Performance & Optimization Analyze and optimize database performance using: o Performance Insights o CloudWatch o Query analysis tools o PostgreSQL performance views Tune: AWS RDS DBA(PostgreSQL)/Cloud Database Operations Engineer o SQL queries o Indexes o Memory settings o Connection management o Storage configurations Identify and resolve: o Slow-running queries o Deadlocks o Lock contention o Replication latency o Resource bottlenecks Backup, Recovery & Disaster Recovery Design and manage backup and recovery strategies. Validate backup integrity and recovery readiness. Perform: o Point-in-time recovery testing o Database refresh activities o Restore exercises o DR validation testing Support organizational RTO and RPO requirements. Develop and maintain recovery documentation and operational runbooks. AWS documentation identifies backup planning, monitoring, recovery strategy, security, parameter management, and database optimization as core responsibilities remaining with DBAs even in managed RDS environments. [aws.amazon.com], [aws.amazon.com], [docs.aws.amazon.com] Security & Compliance Enforce database security best practices. Manage: o Roles and permissions o Database authentication o Encryption at rest and in transit o Audit logging Partner with Security teams to ensure compliance with organizational and regulatory requirements. Support vulnerability remediation and security assessments. Monitoring, Automation & Operational Excellence Establish proactive monitoring and alerting. Create automated operational processes using: o AWS Lambda o Terraform AWS RDS DBA(PostgreSQL)/Cloud Database Operations Engineer o Python o AWS Systems Manager Develop operational dashboards and health reporting. Drive continuous improvement of cloud database operations. Production Support & Incident Management Provide L2/L3 database support. Participate in production on-call rotations. Respond to P1/P2 incidents within SLA commitments. Perform root cause analysis and implement preventive actions. Collaborate with application and cloud platform teams during incident response activities. Application & Cloud Platform Collaboration Partner with: o AWS Engineers o DevOps Teams o Application Development Teams o Data Engineering Teams Support application modernization and migration initiatives. Participate in architecture reviews and operational readiness reviews. Assist development teams with database design, schema optimization, and deployment planning.