Senior PostgreSQL Database Administrator

Our Energy and Utilities Client is seeking a PostgreSQL Database Administrator with 12+ years of experience to migrate and support mission-critical database environments across on-premises and AWS cloud platforms.

Responsibilities

• Develop and maintain disaster recovery procedures and documentation
• Ensure adherence to RTO/RPO requirements and business continuity standards
• 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
• Monitor, analyze, and optimize database performance using AWS-native monitoring tools
• Implement database security controls, encryption, auditing, and compliance best practices
• Create and maintain operational dashboards, performance reports, and key metrics for database operations and service health
• Perform Oracle-to-PostgreSQL assessments, schema conversions, compatibility analysis, and performance optimization
• Support PostgreSQL version upgrades, platform migrations, and cloud modernization initiatives
• Execute end-to-end migration activities including assessment, planning, testing, cutover, validation, and post-migration support

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
• 12+ years of Database Administration experience
• 8+ years of PostgreSQL Database Administration experience
• 5+ years of AWS & Azure cloud database administration experience
• Strong experience managing mission-critical production databases
• Proven experience with PostgreSQL upgrades, migrations, and performance tuning
• Strong troubleshooting and problem-solving skills
• Excellent verbal and written communication skills
• AWS Certified Database Specialty
• AWS Certified Solutions Architect Associate/Professional
• PostgreSQL Professional Certification

Preferred Skills

• Experience with Enterprise Monitoring tools
• Experience supporting large-scale utility, financial or regulated environments
• Experience with DevOps and CI/CD pipelines
• Knowledge of Kubernetes and containerized PostgreSQL environments
• Experience with pgBouncer, Pgpool-II, Patroni, or similar PostgreSQL HA solutions

Key Competencies

• Maintain highly available, secure, and scalable PostgreSQL database environments
• Deliver optimized database performance, reliability, and operational excellence
• Implement automated monitoring, alerting, reporting, and operational processes
• Ensure disaster recovery readiness, backup compliance, and adherence to RTO/RPO requirements
• Drive infrastructure automation and cloud adoption using Terraform and AWS services
• Successfully execute database migration projects with minimal downtime and business impact

Schedule

• Location: Oakland, CA
• Hybrid: 3 or more days onsite per week, as needed
• Anchor days: Tuesday, Wednesday, Thursday
• Work Hours: 8:30am - 5:00pm CST

Pay

The approximate pay range for this position is between $60.00 and $70.00 per hour. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location.

Benefits

• Medical, Dental, & Vision Insurance Plans
• Employee-Owned Profit Sharing (ESOP)
• 401K offered