HR Data Engineer/DBA - PostgreSQL & Oracle Migrations

CAI

Trenton (NJ)

Hybrid

USD 96,000 - 102,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical insurance
Dental insurance
Vision insurance
401k retirement

Job summary

CAI in Trenton, NJ is seeking a Data Engineer-DBA to design the HR data model, lead legacy data conversion, and reconcile records for HR modernization initiatives. The role is a full-time contract with a hybrid work arrangement (3 days onsite) in Trenton, NJ, requiring PostgreSQL, Oracle data extraction, and data masking skills along with SQL and Python scripting.

The ideal candidate will collaborate with developers and architects to ensure scalable data access and reliable migration tooling,

Qualifications

  • Bachelor's degree in CS/IS or related field.
  • 7+ years in data engineering or DBA roles.
  • PostgreSQL schema design and migration tooling.
  • Experience extracting data from Oracle sources.
  • Experience with reconciliation and drift detection between systems.
  • Experience with data masking for non-prod use.
  • Advanced SQL skills and Python scripting.

Responsibilities

  • Design and maintain the PostgreSQL schema for the HR data model.
  • Manage schema changes through migration tooling such as Flyway or Liquibase with version control.
  • Partner with developers and architects on data access patterns and performance.
  • Extract data from Oracle sources and design repeatable conversion and load processes.
  • Run conversion cycles, validate results, and resolve data quality issues with business owners.
  • Reconcile person and employee records between the existing system and the new platform.
  • Build drift detection between two systems that hold the same records with exception reporting and resolution workflows.
  • Implement data masking for non-production environments to protect sensitive information.
  • Support database performance tuning, backup and recovery, and access management.

Skills

PostgreSQL design
SQL/Python scripting
Data integration
Drift detection
Data masking
Oracle data extraction

Education

Bachelor's degree in CS/IS

Tools

Flyway
Liquibase
Oracle
Amazon Aurora

Job description

CAI in Trenton, NJ is seeking a Data Engineer-DBA to design the HR data model, lead legacy data conversion, and reconcile records for HR modernization initiatives. The role is a full-time contract with a hybrid work arrangement (3 days onsite) in Trenton, NJ, requiring PostgreSQL, Oracle data extraction, and data masking skills along with SQL and Python scripting.

The ideal candidate will collaborate with developers and architects to ensure scalable data access and reliable migration tooling,

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

HR Data Engineer-DBA: PostgreSQL & Data Migration (Hybrid)
HR Data Engineer-DBA: PostgreSQL & Data Migration (Hybrid)

CAI • New Jersey

Hybrid
USD 96,000 - 102,000
Medical insurance
Dental insurance
Vision insurance
+1
Data Engineer-DBA
Data Engineer-DBA

CAI • New Jersey

Hybrid
USD 96,000 - 102,000
Medical insurance
Dental insurance
Vision insurance
+1
Data Engineer-DBA
Data Engineer-DBA

CAI • Trenton (NJ)

Hybrid
USD 96,000 - 102,000
Medical insurance
Dental insurance
Vision insurance
+1
Senior Database Architect & Engineer (Oracle→PostgreSQL)
Senior Database Architect & Engineer (Oracle→PostgreSQL)

Age Solutions • Philadelphia

Hybrid
USD 122,000 - 149,000
26 Days Paid Leave
Performance Bonuses
401(k) with Match
+5
Senior Database Administrator — Oracle & PostgreSQL @ Parsippany, New Jersey
Senior Database Administrator — Oracle & PostgreSQL @ Parsippany, New Jersey

Servsys Corporation • Parsippany-Troy Hills (NJ)

Hybrid
USD 120,000 - 140,000
Senior Database Architect & Engineer (Oracle→PostgreSQL)
Senior Database Architect & Engineer (Oracle→PostgreSQL)

Age Solutions • Philadelphia

Hybrid
USD 122,000 - 149,000
26 Days Paid Leave
401(k) with Match
Health Benefits
Remote: Legacy HR Data Migration Engineer (PeopleSoft/EBS)
Remote: Legacy HR Data Migration Engineer (PeopleSoft/EBS)

CACI International Inc • United States

Remote
USD 120,000 - 180,000
PostgreSQL Developer
PostgreSQL Developer

DEW Softech Inc • Trenton (NJ)

Hybrid
USD 90,000 - 120,000
PostgreSQL Database Engineer - Oracle-to-Postgres Migration
PostgreSQL Database Engineer - Oracle-to-Postgres Migration

CGS Federal • Chicago (IL)

On-site
USD 110,000 - 160,000
Health, Dental, and Vision
Life Insurance
401k
+2
Senior Oracle & PostgreSQL DBA — Hybrid NJ
Senior Oracle & PostgreSQL DBA — Hybrid NJ

Servsys Corporation • Parsippany-Troy Hills (NJ)

Hybrid
USD 120,000 - 140,000