Senior PostgreSQL DBA

KellyMitchell Group; Oakland (CA); On-site; USD 68,000 - 96,000; Full time

Benefits offered by this job

Medical, Dental, & Vision Insurance

Employee-Owned ESOP

401(k) offered

Job summary

KellyMitchell is seeking a Cloud Platform Engineer / Senior PostgreSQL DBA in Oakland, CA. You will lead migrations of Oracle, SQL Server, and on-prem PostgreSQL to Amazon RDS and Aurora PostgreSQL, while ensuring admin, automation, monitoring, and performance support.

The role requires 10+ years of enterprise PostgreSQL experience and AWS certification, with onsite work in Oakland and occasional travel to San Ramon. Join a hands-on team driving secure, scalable database platforms.

Qualifications

• 10+ years of database administration experience with deep enterprise PostgreSQL expertise.
• Hands-on experience migrating Oracle and SQL Server databases to PostgreSQL.
• Strong experience administering PostgreSQL across production, development, QA, test, and disaster-recovery environments.
• Hands-on experience with Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and AWS database services.
• Experience with AWS DMS, AWS SCT, CloudWatch, AWS CLI, and Terraform.
• Expertise in PostgreSQL performance tuning, security, backup and recovery, replication, high availability, and migration validation.
• Current AWS certification is mandatory.

Responsibilities

• Lead end-to-end migrations of Oracle, SQL Server, and on-premises PostgreSQL to Amazon RDS and Aurora PostgreSQL.
• Perform migration assessments, schema conversions, compatibility analyses, testing, cutover, validation, and handoff.
• Administer, configure, upgrade, patch, secure, monitor, and maintain enterprise PostgreSQL environments.
• Optimize database performance through query tuning, indexing, and workload analysis.
• Implement PostgreSQL backup, recovery, replication, high-availability, and disaster-recovery solutions.
• Automate database administration and provisioning with Terraform and AWS CLI.
• Troubleshoot incidents and coordinate with application and operations teams.

Skills

PostgreSQL

Migration to PostgreSQL

Oracle/SQL migration

AWS RDS/Aurora

Terraform

AWS CLI

Monitoring

Performance tuning

Backup & DR

AWS Certification

Tools

Amazon RDS

Aurora PostgreSQL

AWS DMS

Terraform

Job description

Job Summary

Our client, a leading energy and utility provider, is seeking a Cloud Platform Engineer / Senior PostgreSQL Database Administrator to join their team. This individual contributor will lead complex migrations of Oracle, SQL Server, and on-premises PostgreSQL databases to Amazon RDS and Aurora PostgreSQL while supporting database administration, automation, monitoring, performance, and operational handoff.

Contract Details

Contract position from August 17, 2026 through February 26, 2027

Potential extension based on project progress

Oakland, CA

Onsite work in Oakland is mandatory, with occasional travel to San Ramon

Candidates must already be located in California; relocation will not be considered

Core Responsibilities

• Lead end-to-end Oracle, SQL Server, and on-premises PostgreSQL migrations to Amazon RDS and Aurora PostgreSQL
• Perform migration assessments, schema conversions, compatibility analyses, testing, cutover, validation, optimization, and operational handoff
• Administer, configure, upgrade, patch, secure, monitor, and maintain enterprise PostgreSQL environments
• Optimize database performance through query tuning, indexing, execution-plan analysis, capacity planning, and workload analysis
• Implement PostgreSQL backup, recovery, replication, high-availability, and disaster-recovery solutions
• Automate database administration, infrastructure provisioning, health checks, monitoring, and alerting using Terraform, AWS CLI, and AWS-native services
• Troubleshoot production incidents, conduct root-cause analysis, and partner with application, infrastructure, cloud architecture, and operations teams

Required Skills/Experience (Must-Haves)

• 10+ years of database administration experience with deep enterprise PostgreSQL expertise
• Hands-on experience migrating Oracle and SQL Server databases to PostgreSQL
• Strong experience administering PostgreSQL across production, development, QA, test, and disaster-recovery environments
• Hands-on experience with Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and AWS database services
• Experience with AWS DMS, AWS SCT, CloudWatch, AWS CLI, and Terraform
• Expertise in PostgreSQL performance tuning, security, backup and recovery, replication, high availability, and migration validation
• Current AWS certification is mandatory

Preferred Skills/Experience (Nice-to-Haves)

• AWS Certified Database – Specialty or AWS Certified Solutions Architect – Associate/Professional
• PostgreSQL Professional certification
• Azure cloud database experience
• Experience with Broadcom, ServiceNow, or other enterprise monitoring platforms
• Experience supporting utility, financial-services, or other regulated environments
• DevOps, CI/CD, Kubernetes, or containerized PostgreSQL experience
• Experience with pgBouncer, Pgpool-II, Patroni, or similar PostgreSQL high-availability tools

Key Competencies & Behaviors

• Self-directed and able to manage migrations from source assessment through operational handoff
• Strong troubleshooting, root-cause analysis, and technical problem-solving skills
• Detail-oriented with a focus on security, reliability, performance, and minimal business disruption
• Collaborative and able to partner effectively with application, infrastructure, architecture, and operations teams
• Strong written and verbal communication skills, including technical documentation and knowledge transfer

Work Environment

Location: Oakland, CA

Work Arrangement: Onsite; occasional travel to San Ramon may be required

Compensation & Benefits

Pay Range: The approximate pay range for this position is between $49.00 and $70.00 per hour. 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)
• 401(k) 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 and project-solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.