Job: Data Engineer-DBA
Onsite
Location: Trenton, NJ (Fully onsite for about the first month, then hybrid 3days per week)
Hours Per week: 40
Project Start: ASAP
Project 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 accomodated.
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. This position will be contract and hybrid (3 days onsite) in Trenton, NJ.
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