DHA-EOSS Database Administrator (EDW Database Administrator)

Quantum Sky•Aurora, CO

1d•$135,000 - $145,000•Onsite

About The Position

Quantum Sky is hiring an experienced Senior Database Administrator to maintain, optimize, secure, and modernize Oracle databases supporting the Defense Health Agency (DHA) E-Commerce System (ECS) in Aurora, Colorado. DHA ECS provides financial management, acquisition operations, and contract lifecycle support for TRICARE private-sector healthcare delivery. The environment runs in virtualized AWS GovCloud East through the DHA MedCOI Application Virtualization Hosting Environment (AVHE). The position has two specialized tracks. The Enterprise Data Warehouse (EDW) track supports multi-terabyte analytical and reporting databases, data warehouse layers, and bulk ingestion pipelines. The Contract Management (CM) track supports transactional databases for procurement and contract administration systems, including Global Unison PRISM, custom ColdFusion applications, and software change-control tools. Across both tracks, the DBA performs database operations, maintenance, tuning, backup and recovery, disaster preparedness, cybersecurity hardening, audit support, and outage response. The role operates under strict production access controls and service-level agreements, and participates in disaster recovery exercises and compliance activities.

Requirements

Must be a United States citizen.
Must qualify for and maintain an IT Level II Privileged Access designation under DoD 5200.2-R.
Must possess a valid DoD Manual 8140.03 IAT Level II baseline certification upon hire or within three months of contract employment (examples include CompTIA Security+ ce, CCNA Security, CySA+, or GSEC), and complete relevant OS/DBMS Operating Environment training.
Bachelor’s degree from an accredited university in Computer Science, Information Technology, Engineering, or a related discipline; 15 years of documented database administration experience may substitute for the degree.
EDW track: at least five years of hands-on Oracle database administration on Linux/Unix supporting an enterprise data warehouse application of comparable size and complexity.
CM track: at least five years of hands-on Oracle database administration on Linux/Unix supporting contract management, procurement, or web tracking applications of comparable size and complexity.
Advanced administration of Oracle Enterprise Database 12c/19c on Red Hat Enterprise Linux (RHEL).
Expertise in RMAN scripting, catalog administration, and automated backup/restore verification.
In-depth knowledge of database security hardening, DISA STIGs, SCAP tools, and vulnerability mitigation.
Advanced performance tuning using Oracle Enterprise Manager (OEM)/Cloud Control, AWR, ASH, ADDM, and SQL execution plan profiling.
Strong Bash and Korn shell scripting skills for database maintenance automation, log rotations, and monitoring.
Must hold an active or favorably adjudicated Tier 3 (T3)/NACLC investigation (SF-86) granting Secret eligibility.

Nice To Haves

EDW track: experience with large partition schemas, star/snowflake dimensional models, Informatica ETL database targets, and BI Publisher/OAS database repository schemas.
CM track: experience supporting Global Unison PRISM database backends, Adobe ColdFusion database connection pooling, and Micro Focus SBM/QC database instances.
Familiarity with Oracle Access Manager (OAM 11i), Oracle Internet Directory (OID 11i), Oracle Cloud Control 13c, and AWS GovCloud virtualized EBS volume management.

Responsibilities

For the EDW track, maintain and optimize Oracle database instances across Development, System Test, QA/Pre-Prod, and Production environments, supporting staging, archive, and reporting data marts.
Support high-throughput batch data ingestion from Oracle Federal Financials (OFF), TRICARE Encounter Data System (TEDS), and pharmacy rebate processors; monitor loading locks, index health, tablespace growth, and partition management in coordination with Informatica ETL and BMC Control-M administrators.
Design and execute data archival pipelines, support integration of all OFF sets of books into EDW reporting marts, and support database ingestion structures for Central Accounting Reporting System (CARS) CTDE file reconciliation.
For the CM track, administer Oracle schemas and database tiers supporting Global Unison PRISM, MTR, Extranet, PAT, Solutions Business Manager (SBM), and Quality Center (QC).
Support schema adjustments and interface tables for the automated PRISM and Oracle Federal Financials handshake to validate funds availability and obligations before contract modifications.
Maintain shared PRISM, MTR, and PAT database server configurations on Linux RHEL, including application isolation and performance tuning.
Perform database administration, memory allocation, automated maintenance scheduling, and SQL workload tuning; analyze AWR, ADDM, and ASH reports to diagnose bottlenecks, lock contention, and performance degradation.
Maintain database design documentation, data dictionaries, schema diagrams, and Standard Operating Procedures compliant with CDRL 0010; enforce environment segregation and execute and validate production schema migrations.
Configure, automate, and monitor backups using Oracle Recovery Manager (RMAN) and AWS virtual machine snapshots; conduct monthly restore tests and maintain database reconstitution procedures under the DHA ECS Continuity of Operations Plan (COOP).
Participate in annual COOP and disaster recovery exercises, supporting cutover to alternate AWS environments within 12 hours of declaration.
Apply and validate DISA Database STIGs and CCIs; remediate ACAS scan and IAVA vulnerabilities; coordinate POA&M findings with the Security DBA and ISSO; enforce DoD PKI authentication and encryption at rest and in transit.
Provide technical responses and evidence for DHA CRM financial audits, contract management audits, and RMF re-authorizations.
Meet production and non-production restoration service-level agreements, including heightened end-of-month and October requirements; notify Government representatives of disruptions within required timeframes.