PostgreSQL Developer DBA

Job Title: PostgreSQL Developer DBA

Location: Irvine, CA

Job Type: Long Term Contract

Experienced PostgreSQL Developer DBA with expertise in Oracle/SQL Server to PostgreSQL migrations, AWS cloud databases, and Infrastructure as Code. Strong hands-on experience in AWS Aurora PostgreSQL, RDS PostgreSQL, AWS SCT, AWS DMS (Full Load & CDC), PL/pgSQL development, schema conversion, stored procedure remediation, performance tuning, database security (RBAC), and production cutovers. Experienced in Terraform-based provisioning and automation of database infrastructure, CI/CD integration, backup/recovery, disaster recovery testing, and database validation. Proven ability to lead end-to-end migration projects, collaborate with application teams, and deliver scalable, secure, and high-performing database solutions on AWS.   

Key Skills: 

• PostgreSQL Administration & Development 

• Oracle/SQL Server → PostgreSQL Migrations 

• AWS Aurora PostgreSQL & RDS PostgreSQL 

• AWS SCT & AWS DMS (CDC) 

• PL/pgSQL, Functions, Procedures & Triggers 

• Query Performance Tuning & Optimization 

• Terraform (Infrastructure as Code) 

• Flyway & CI/CD Automation 

• PostgreSQL Security, Roles & RBAC 

• Backup, Recovery & Disaster Recovery 

• Migration Validation, Cutover & Hypercare Support 

• AWS Cloud & DevOps Integration