Oracle DBA, Developer

Imagineeer

. Support consolidation of CIDB files, including obtaining the CIDB Full file from OPM and generating the CIDB Abbreviated file internally .

Posted 9/29/2026full-timeRemote • Virginia • United StatesMid-LevelSenior💰 $130,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced proficiency in SQL and PL/SQL for database management and ETL processes, with a strong focus on data analysis and file format specification development. Capable of producing comprehensive technical documentation and maintaining Oracle database performance and security.

Highest-signal resume keywords

Oracle Database AdministrationSQL and PL/SQL ProficiencyETL Process DevelopmentData Analysis and ReportingOracle Certified Professional (OCP)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPL/SQLETL ProcessesOracle Database AdministrationPerformance TuningData AnalysisFile Format Specification DevelopmentData ConsolidationTechnical DocumentationScripting (Python or Shell)

Soft Skills

Strong Written CommunicationStrong Verbal Communication

Tools & Technologies

SQL*LoaderExternal TablesOracle HCM/EHCM

Certifications & Qualifications

Oracle Certified Professional (OCP)

Industry Keywords

Federal HR DataPayroll DataOPM File ExchangesHHS Operating DivisionsPublic Trust Clearance

Tech Stack

Tools & technologies

ETLOraclePythonSQL

About the role

Key responsibilities & impact

Support consolidation of CIDB files, including obtaining the CIDB Full file from OPM and generating the CIDB Abbreviated file internally
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
Develop a Paytran file format specification for OPM and establish receipt of the file from OPM
Analyze the technical usage of the EHCM data dump, including reviewing 100+ data tables
Determine the purpose and usage of EHCM tables, identify derived files, associated reports, and downstream data exchanges with HHS Operating Divisions
Design, develop, and maintain PL/SQL packages, procedures, and ETL processes to ingest, validate, and transform incoming data files
Perform Oracle database administration, 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

Requirements

What you’ll need

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
Employment contingent upon being a United States citizen
Ability to successfully obtain and maintain a Public Trust clearance
Desired: Familiarity with Oracle HCM/EHCM data structures
Desired: Experience with federal HR and payroll data, such as EHRI, personnel and payroll transaction data, or the OPM Guide to Data Standards
Desired: Prior experience supporting HHS or other federal civilian agencies
Desired: Oracle Certified Professional (OCP) certification
Desired: Scripting experience with Python or Shell