Data Engineer-DBA

Amtex Enterprises,Inc

Trenton (NJ)

Hybrid

USD 120,000 - 150,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Amtex Enterprises Inc. in Trenton, NJ is seeking a Data Engineer – DBA to design the HR data model, lead legacy data conversion, and reconcile person and employee records with our client for HR Modernization initiatives.

The role is fully onsite for about the first month, then hybrid (3 days per week onsite). Responsibilities include designing PostgreSQL schemas, managing migrations with Flyway or Liquibase, extracting data from Oracle, implementing data masking for non-prod, and ensuring data

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or a related field.
  • 7+ years of experience in data engineering or database administration.
  • PostgreSQL schema design and migration tooling.
  • Experience extracting data from Oracle sources.
  • Experience with reconciliation and drift detection between two systems holding the same records.
  • Experience with data masking in non-production environments.

Responsibilities

  • Design and maintain the PostgreSQL schema for HR data.
  • Manage schema changes with Flyway or Liquibase.
  • Partner with developers on data access patterns and performance.
  • Extract data from Oracle sources and design ETL processes.
  • Run conversion cycles, validate results, and fix data quality issues.
  • Reconcile records between legacy and new HR systems.
  • Build drift detection and exception workflows.
  • Implement data masking for non-production environments.

Skills

Advanced SQL
Python scripting
Data reconciliation
Drift detection

Education

Bachelor’s degree in Computer Science or related field

Tools

PostgreSQL
Flyway
Liquibase
Oracle

Job description

Job Title: Data Engineer-DBA
Location Trenton, NJ (Fully onsite for about the first month, then hybrid 3days per week)
Duration: 12 months with extension expected

Candidates must be local to Trenton, NJ as all interviews will be onsite. No requests for remote/webcam interviews will be accommodated.
Role is Fully onsite for about the first month, then hybrid (3 days per week onsite) non-negotiable

Job Description: We are looking for a Data Engineer – DBA to design the HR data model, lead legacy data conversion, and reconcile person and employee records with our client for key initiatives, including the agency’s HR Modernization initiative.

What You’ll Do
  • 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
What You’ll Need
Required:
  • Bachelor’s degree in Computer Science, Information Systems, or a related field
  • 7+ years of experience in data engineering or database administration
  • PostgreSQL schema design and migration tooling
  • Experience extracting data from Oracle sources
  • Experience with reconciliation and drift detection between two systems holding the same records
  • Experience with data masking for non-production use
  • Advanced SQL skills and experience with a scripting language such as Python
Preferred:
  • Ability to read Oracle PL/SQL
  • Experience with change data capture tooling
  • AWS database certification or experience with Amazon Aurora
  • Experience with HR or personnel data
  • Experience within Human Services or Child Welfare programs
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer-DBA
Data Engineer-DBA

CAI • New Jersey

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

Amtex Enterprises,Inc • Trenton (NJ)

Hybrid
USD 120,000 - 150,000
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 • Trenton (NJ)

Hybrid
USD 96,000 - 102,000
Medical insurance
Dental insurance
Vision insurance
+1
HR Data Engineer/DBA - PostgreSQL & Oracle Migrations
HR Data Engineer/DBA - PostgreSQL & Oracle Migrations

CAI • Trenton (NJ)

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

Valiant Technologies LLC • Trenton (NJ)

On-site
USD 86,000 - 123,000
Data Engineer
Data Engineer

Quantum Technologies. LLC • Trenton (NJ)

On-site
USD 86,000 - 123,000
Data Engineer
Data Engineer

Robotic Technologies Automation • Trenton (NJ)

On-site
USD 86,000 - 123,000
Senior Data Engineer: Oracle, PostgreSQL & AWS
Senior Data Engineer: Oracle, PostgreSQL & AWS

Robotic Technologies Automation • Trenton (NJ)

On-site
USD 86,000 - 123,000
Data Engineer
Data Engineer

Eliassen Group • St. Louis (MO)

Hybrid
USD 110,000 - 138,000
Medical benefits
401k with company matching
Life insurance