DHA-EOSS Database Administrator; EDW Database Administrator

Quantum Sky is searching for an experienced Senior Database Administrator to maintain, optimize, secure, and modernize critical Oracle database instances supporting the Defense Health Agency (DHA) E-Commerce System (ECS) in Aurora, Colorado.

The DHA ECS delivers integrated financial management, acquisition operations, and contract lifecycle support for TRICARE private-sector healthcare delivery across the Military Health System (MHS). Operating within a virtualized Amazon Web Services (AWS) Gov Cloud East infrastructure via the DHA MedCOI Application Virtualization Hosting Environment (AVHE), this role is available in two specialized tracks:

• Track 1:
  Enterprise Data Warehouse (EDW) Track — Specializes in multi-terabyte analytical and reporting databases, complex data warehousing structures (Stage, Archive Stage, and multidimensional reporting marts), and bulk data ingestion pipelines.

• Track 2:
  Contract Management (CM) Track — Specializes in transactional database administration supporting DHA procurement and contract administration systems, including COTS Global Unison PRISM, custom Cold Fusion applications (MTR, PAT, Extranet), and software change control suites (ECCP/SBM/QC).

Responsibilities:

• Analytical Database Architecture: Maintain and optimize Oracle database instances across 4 environments (Development, System Test, QA/Pre-Prod, and Production) supporting the 3 distinct EDW layers:

  • Landing & Staging (Stage): High-throughput data ingestion area receiving batch feeds from Oracle Federal Financials (OFF), TRICARE Encounter Data System (TEDS), and pharmacy rebate processors.

  • Archive Stage (Arc Stage): Non-volatile historical archive maintaining longitudinal private sector healthcare data.

  • Reporting Data Marts: Dedicated schemas powering business intelligence platforms (OAS, BI Publisher, SplashBI) across the Financial Reporting Data Mart (FRDM), Operations Reporting Data Mart (ORDM), Pharmacy Reporting Data Mart (PRDM), and Contract Reporting Data Mart (CRDM).

• Batch Ingestion & ETL Alignment: Partner with Informatica ETL and BMC Control-M administrators to support nightly batch windows (1800–0600 MT), monitoring data loading locks, index health, tablespace growth, and partition management.

• Contract Modernization Projects:

  • Warehouse Archival Project: Design and execute data archival pipelines to offload cold data while maintaining reporting query performance.

  • All OFF Sets of Books Ingestion: Implement database changes required to integrate multi-set of books financial records into EDW reporting marts.

  • CARS CTDE File Reconciliation: Support database ingestion structures for Central Accounting Reporting System files to enable automated daily cash transaction matching.

• Procurement & Operations Database Administration: Administer Oracle database schemas supporting the DHA ECS Contract Management suite:
  • PRISM Database Tier: Maintain the Oracle backend for Global Unison PRISM COTS software, managing procurement solicitation data, contract award records, and clause logic integrations.
  • MTR / Extranet / PAT Database Tier: Maintain shared and dedicated schemas for custom Adobe Cold Fusion applications tracking TRICARE Concept Requirements (Con Req), contractor deliverables, and contractor performance assessments.
  • E-Commerce Change Control Process (ECCP): Administer database instances supporting Solutions Business Manager (SBM) and Quality Center (QC) workflow configurations.
• Procurement Cycle Integration Support: Support schema adjustments and interface tables enabling the automated "handshake" between PRISM and Oracle Federal Financials (OFF) to validate funds availability and obligations prior to contract modifications.
• Shared…