Oracle DBA, Developer

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Assist in the consolidation of CIDB files, which includes acquiring the CIDB Full file from OPM and internally creating the CIDB Abbreviated file.

• Standardize the intake, formatting, and processing of the Admin (SAC Codes) file received from OPM.

• Standardize the intake, formatting, and processing of the Paytran file.

• Create a specification for the Paytran file format for OPM and establish a protocol for receiving the file from OPM.

• Analyze the technical utilization of the EHCM data dump, which includes reviewing over 100 data tables.

• Identify the purpose and usage of EHCM tables, recognize derived files, related 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.

• Conduct Oracle database administration tasks, such as performance tuning, schema management, backup and recovery, and security configuration.

• Create technical documentation, including data dictionaries, data lineage, file format specifications, and standard operating procedures.

⛳️ Requirements

• Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or a related discipline.

• Over 6 years of experience as an Oracle DBA and/or Oracle Developer.

• High-level proficiency in SQL and PL/SQL, including stored procedures, complex queries, and performance optimization.

• Experience in building ETL processes for flat-file ingestion (both fixed-width and delimited) using SQL*Loader, external tables, or similar tools.

• Experience in developing file format specifications or interface control documents for external data exchanges.

• Experience in standardizing and consolidating data file processes.

• Experience working with OPM file exchanges.

• Ability to analyze large and complex data sets to ascertain their purpose, usage, and downstream dependencies.

• Excellent written and verbal communication skills.

• Employment is 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: Previous experience supporting HHS or other federal civilian agencies.

• Desired: Oracle Certified Professional (OCP) certification.

• Desired: Scripting experience with Python or Shell.

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional development and career advancement.

• Collaborative and supportive work environment.

• Access to cutting-edge technology and tools.

• Flexible work arrangements.