Data Engineer - DBA - DE 26-16832

Compu-Vision Consulting Inc.
Newark, NJ, United States
3 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours

Tech stack

Amazon Web Services Configuration Management Information Systems Databases Data Conversion Information Engineering Data Masking Data Retrieval Data Security Database Design Identity and Access Management Python (Programming Language)
+11 more
PostgreSQL Liquibase Oracle (Applications) Oracle SQL Developer Scripting Sql Optimization Database Optimization Change Data Capture Information Technology Drift Detection Software Version Control

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 for key initiatives, including the agency’s HR Modernization initiative.

What You’ll Do

Database Design and Change Management

  • 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.

Data Conversion and Reconciliation

  • 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.

Data Security and Database Operations

  • Implement data masking for non-production environments to protect sensitive information.
  • Support database performance tuning, backup and recovery, and access management.

Requirements

Database Administration, Database Administration, Data Modeling, Reconciliation, Database Design, Change Management, PostgreSQL, Source Code/Configuration Management (SCM), Machine Tool, Oracle, * 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 Qualifications

  • 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.

Physical Demands

  • Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards.
  • Sedentary work that involves sitting or remaining stationary most of the time, with occasional need to move around the office to attend meetings.
  • Ability to conduct repetitive tasks on a computer, using a mouse, keyboard, and monitor.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…