Senior PostgreSQL Developer / DBA – AWS Cloud & Database Migration

IPolarity

San Antonio (TX)

On-site

USD 110,000 - 140,000

Full time

4 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

IPolarity in Texas is seeking a Database Migration & AWS PostgreSQL expert to lead Oracle/SQL Server to PostgreSQL migrations on AWS. You will design, optimize, and secure PostgreSQL instances, performing schema conversions and performance tuning while coordinating with apps teams for production cutovers on Aurora/RDS.

Responsibilities include AWS DMS Full Load & CDC migrations, RBAC implementation, and delivering scalable AWS database solutions with high reliability.

Qualifications

Experience migrating Oracle/SQL Server to PostgreSQL.
Strong PostgreSQL administration on AWS (Aurora, RDS).
Proficient with AWS DMS migrations (Full Load & CDC).
Implement RBAC and security best practices in database environments.

Responsibilities

Lead end-to-end Oracle/SQL Server to PostgreSQL migration projects.
Design, develop, administer, and optimize PostgreSQL databases on AWS.
Work with AWS Aurora PostgreSQL and RDS PostgreSQL.
Perform schema conversion, stored procedure remediation, and performance tuning.
Implement secure database solutions using RBAC and security best practices.
Execute AWS DMS migrations including Full Load and CDC.
Collaborate with application teams for smooth production cutovers.
Deliver scalable, secure, and high-performing AWS database solutions.

Skills

PostgreSQL

AWS

DMS

RBAC

Oracle

SQL Server

Aurora PostgreSQL

RDS PostgreSQL

Tools

Oracle

SQL Server

PostgreSQL

AWS

AWS DMS

Job description

Database Security & RBAC
Lead end-to-end Oracle/SQL Server to PostgreSQL migration projects.
Design, develop, administer, and optimize PostgreSQL databases on AWS.
Work extensively with AWS Aurora PostgreSQL and RDS PostgreSQL.
Perform schema conversion, stored procedure remediation, and performance tuning.
Implement secure database solutions using RBAC and security best practices.
Execute AWS DMS migrations including Full Load and CDC.
Collaborate with application teams to ensure smooth migration and production cutovers.
Deliver scalable, secure, and high-performing AWS database solutions.