Oracle DBA/Developer

imagineeer LLC; Arlington (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Imagineeer is seeking an experienced Oracle DBA/Developer to join our team supporting the Department of Health and Human Services (HHS) HRIT contract. You will modernize HR and payroll data by consolidating data file exchanges and building Oracle-based intake/processing workflows.

You will analyze a large enterprise HR data environment, document table usage, and develop PL/SQL packages and ETL processes while performing DBA tasks including tuning, backups, and security.

Qualifications

• Bachelor's degree in CS, CIS, IT, or related field.
• 6+ years as Oracle DBA and/or Oracle Developer.
• Advanced proficiency in SQL/PL/SQL with performance tuning.
• Experience building ETL for flat-file ingestion (fixed-width and delimited).
• Experience creating file format specifications for external exchanges.
• Experience standardizing and consolidating data file processes.
• Experience working with OPM file exchanges.
• Ability to analyze large data sets to determine purpose and downstream usage.
• Strong written and verbal communication.

Responsibilities

• Consolidate CIDB files and liaise with OPM to provide CIDB Full/Abbreviated.
• Standardize intake/format/processing of Admin SAC Codes file from OPM.
• Standardize Paytran file intake and develop a format spec for OPM.
• Analyze EHCM data dump across 100+ tables to map usage and data exchanges.
• Design, develop, and maintain PL/SQL packages, procedures, and ETL processes.
• Perform Oracle DBA tasks including performance tuning, backups, security.
• Produce data dictionaries, data lineage, and SOPs.

Skills

SQL & PL/SQL

ETL development

Data analysis

Documentation

Communication

OCP certification

Education

Bachelor's degree in CS/ CIS/ IT

Tools

SQL*Loader

External Tables

Job description

Imagineeer is seeking an experienced Oracle DBA/Developer to join our team supporting the Department of Health and Human Services (HHS) Human Resources Information Technology (HRIT) contract. In this role, you will help modernize how HHS receives, processes, and uses critical HR and payroll data by consolidating and standardizing key federal data file exchanges, building reliable Oracle-based intake and processing workflows, and analyzing a large enterprise HR data environment to document how its tables, reports, and downstream data exchanges are used across the Department. This is a hands-on technical role for someone who enjoys bringing structure and clarity to complex data systems and who can work effectively with both technical teams and government stakeholders.

Key Responsibilities:

• Support consolidation of CIDB files, including obtaining the CIDB Full file from Office of Personnel Management (OPM) and generating the CIDB Abbreviated file internally to eliminate reliance on externally supplied abbreviated extracts.
• Standardize the intake, format, and processing of the Admin (SAC Codes) file received from OPM.
• Standardize the intake, format, and processing of the Paytran file, including developing a file format specification to share with OPM and establishing receipt of the file from OPM
• Analyze the technical usage of the Enterprise Human Capital Management (EHCM) data dump, including reviewing 100+ data tables to determine purpose and usage, identifying derived files, associated reports, and data exchanges with HHS Operating Divisions (OPDIVs) that rely on the data dump.
• Design, develop, and maintain PL/SQL packages, procedures, and ETL processes to ingest, validate, and transform incoming data files.
• Perform Oracle database administration tasks, including performance tuning, schema management, backup and recovery, and security configuration.
• Produce technical documentation, including data dictionaries, data lineage, file format specifications, and standard operating procedures.

Qualifications and Skills:

• Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or a related field.
• 6 + years of experience as an Oracle DBA and/or Oracle Developer
• Advanced proficiency in SQL and PL/SQL, including stored procedures, complex queries, and performance tuning
• Experience building ETL processes for flat-file ingestion (fixed-width and delimited) using SQL*Loader, external tables, or equivalent tools
• Experience developing file format specifications or interface control documents for external data exchanges
• Experience standardizing and consolidating data file processes
• Experience working with OPM file exchanges
• Ability to analyze large, complex data sets to determine purpose, usage, and downstream dependencies
• Strong written and verbal communication skills

Desired Skills and Competencies:

• Familiarity with Oracle HCM / EHCM data structures
• Experience with federal HR and payroll data, such as EHRI, personnel and payroll transaction data, or the OPM Guide to Data Standards
• Prior experience supporting HHS or other federal civilian agencies
• Oracle Certified Professional (OCP) certification
• Scripting experience (Python, Shell) to automate file processing

Additional Information:

Employment for this position is contingent upon the candidate being a United States citizen and having the ability to successfully obtain and maintain a Public Trust clearance, in accordance with applicable federal regulations. We use AI to review resumes. All hiring decisions will be made in compliance with applicable federal, state, and local laws and regulations

Equal Opportunity Employer:

We are an Equal Opportunity Employer and do not discriminate in employment decisions on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other status protected by applicable federal, state, or local laws. All employment decisions are based on business needs, job requirements, and individual qualifications.

Imagineeeris a fast-growing SBA 8(a) Small Disadvantaged Business headquartered in Arlington, VA, delivering federal AI modernization across health, defense, homeland security, and transportation. We design, test, and deploy secure, AI-ready systems that move agencies from pilots to production without breaking governance, compliance, or mission continuity. Our Mission Studio model creates shared environments where policy, data, security, and operations come together. We are capability-driven and competitive by design, not program-dependent. Our leadership hasoperatedinside the federal systems we now transform, bringing institutional knowledge that accelerates delivery and reduces risk. If real delivery motivates you more than slides, and you want your work to compound across programs and agencies,Imagineeeris growing and we are building the team to match.