PostgreSQL Administration & AWS Cloud

Job Title: Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)

Location: Oakland,CA

Duration: August 17, 2026 — February 26, 2027

Job Description:

We are seeking an experienced Senior PostgreSQL Database Administrator with 12 years of database administration experience to migrate and support mission-critical database environments across on-premises and AWS cloud platforms. The ideal candidate will be responsible for the administration, performance tuning, security, backup and recovery, high availability, automation, and migration of PostgreSQL databases.

This role requires deep expertise in PostgreSQL database administration along with strong hands-on experience in AWS services, Infrastructure as Code (Terraform), AWS CLI automation, monitoring, and large-scale database migration initiatives, including Oracle to AWS RDS/Aurora PostgreSQL, SQL Server to AWS RDS/Aurora PostgreSQL, and On-Premises PostgreSQL to AWS RDS/Aurora PostgreSQL.

The successful candidate will work closely with application teams, infrastructure teams, cloud architects, and project stakeholders to ensure highly available, secure, and performant database environments.

• Extensive experience installing, configuring, upgrading, patching, and maintaining PostgreSQL databases in enterprise environments.
• Proven experience monitoring database performance, availability, capacity, and storage utilization to ensure optimal system health.
• Strong expertise in performance tuning, query optimization, indexing strategies, and execution plan analysis.
• Experience managing database security, user roles, permissions, access controls, encryption, and compliance requirements.
• Skilled in troubleshooting database issues, performing root cause analysis, and resolving production incidents.
• Experience supporting production, development, test, QA, and disaster recovery environments.
• Strong background in capacity planning, workload analysis, and database growth forecasting.
• Experience providing on-call support and managing critical database operations.
• Extensive experience implementing and managing PostgreSQL backup and recovery solutions.
• Hands‑on experience with , , WAL Archiving, and Point‑in‑Time Recovery (PITR).
• Experience performing backup validation, restoration testing, and disaster recovery exercises.
• Develop and maintain disaster recovery procedures and documentation.
• Ensure adherence to RTO/RPO requirements and business continuity standards.
• Experience configuring and administering PostgreSQL replication technologies.
• Design, implement, and support High Availability (HA) and disaster recovery architectures.
• Monitor replication health, troubleshoot synchronization issues, and optimize replication performance.
• Execute failover, switchover, and recovery activities with minimal downtime.
• Design and support highly available PostgreSQL architectures across on‑premises and AWS cloud environments.

• Hands‑on experience administering Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and EC2‑hosted PostgreSQL environments.
• Experience provisioning, configuring, and managing cloud database infrastructure within AWS.
• Monitor, analyze, and optimize database performance using AWS‑native monitoring tools.
• Implement database security controls, encryption, auditing, and compliance best practices.
• Experience managing AWS database backups, maintenance activities, upgrades, and patching.
• Strong understanding of AWS architecture, networking, IAM, KMS, and cloud operational best practices.
• Extensive experience with AWS database administration, migration, monitoring, and automation across enterprise PostgreSQL environments.
• Hands‑on experience utilizing AWS Lambda, Amazon Cloud Watch, Amazon SNS, AWS Systems Manager, and AWS CLI to implement automated database management solutions.
• Experience developing automated database health checks, proactive monitoring, and custom alerting solutions to improve database uptime and operational efficiency.
• Strong…