Data Engineer-DBA
CAI•Trenton, NJ
•$70 - $74•Hybrid
About The Position
The Data Engineer-DBA will design the HR data model, lead legacy data conversion, and reconcile person and employee records for the client’s HR modernization initiatives. This is a full-time contract position with a hybrid work arrangement requiring three days onsite in Trenton, New Jersey. Local candidates are requested, and candidates must have work authorization that does not require sponsorship now or in the future.
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- At least 7 years of experience in data engineering or database administration.
- PostgreSQL schema design and experience with 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.
- Experience with a scripting language such as Python.
- Work authorization that does not require sponsorship now or in the future.
- Local candidates only.
Nice To Haves
- 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.
Responsibilities
- Design and maintain the PostgreSQL schema for the HR data model.
- Manage schema changes through migration tools such as Flyway or Liquibase and use 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 systems that hold the same records, including 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.
Benefits
- Medical insurance.
- Dental insurance.
- Vision insurance.
- Access to a 401(k) retirement account.
- Paid sick leave and/or other paid time off as provided by applicable law.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
