Data Engineer - DBA - DE 26-16832
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+11 more
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦