Senior PostgreSQL Database Administrator

Job Summary

Our Energy and Utilities Client is looking for a PostgreSQL Database Administrator (AWS Cloud & Migration Specialist) 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 ,sqlserver to AWS RDS/Aurora PostgresSQL 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.


 

This position is W-2 only. We do not work with third-party firms or C2C arrangements for this role.


Core Responsibilities

• Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)
• 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

Required Skills/Experience (Must-Haves)

• 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 (Nice-to-Haves)

• 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 & Behaviors

• 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

Work Environment

• Location: Oakland, CA
• Hybrid: Work Model: Hybrid - onsite 3 or more days/week, as needed
• Anchor days: Tue/Wed/Thu - Work Hours: 8:30am - 5:00pm CST

Compensation & Benefits

• Pay Range: The approximate pay rate for this position is between $60.00 and $70.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
• Medical, Dental, & Vision Insurance Plans
• Employee-Owned Profit Sharing (ESOP)
• 401K offered

About KellyMitchell

At KellyMitchell, our culture is world class. We’re movers and shakers! We don’t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.


Marketing Disclosure

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from KellyMitchell and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://www.careers.kellymitchell.com/privacy-policy