DHA-EOSS Database Administrator

Quantum Sky•Aurora, CO

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

About The Position

Quantum Sky is hiring a Database Administrator to support the Defense Health Agency (DHA) E-Commerce Operational Systems Support (EOSS) contract in Aurora, Colorado. The role is part of the Business Intelligence and Data Warehousing engineering team and administers, enhances, and maintains reporting data marts within the DHA E-Commerce Data Warehouse, which integrates healthcare claims, financial accounting, and contract administration data for the Military Health System. The position supports the Financial Reporting Data Mart (FRDM), Operations Reporting Data Mart (ORDM), Pharmacy Reporting Data Mart (PRDM), Contract Reporting Data Mart (CRDM), and ad hoc reporting portals in a cloud-hosted MedCOI AWS GovCloud East environment. It maintains and configures Oracle Analytics Server (OAS), Oracle Business Intelligence Enterprise Edition (OBIEE), BI Publisher, and Oracle WebLogic; develops reports and dashboards; supports user access and reporting issues; and ensures reporting interfaces meet Section 508 and WCAG 2.1 accessibility requirements. The role also supports report testing and enhancement projects, usage and performance monitoring, user documentation and training, and outage resolution under contract service-level agreements. Candidates must be U.S. citizens and possess an active or favorably adjudicated Tier 2 Public Trust background investigation or higher, with an IT Level II sensitivity designation, before performance begins. A bachelor's degree in a relevant field is required, although 15 years of documented relevant experience may substitute. The position requires at least three years of relevant hands-on experience.

Requirements

Must be a U.S. citizen.
Must possess an active or favorably adjudicated Tier 2 (T2) Public Trust background investigation (SF-85P/MBI) or higher, with an IT Level II sensitivity designation, before performance begins.
If assigned privileged system access, must possess or obtain a DoD 8570.01-M / DoD Manual 8140.03 IAT Level II baseline certification, such as CompTIA Security+ CE or CCNA-Security, within six months of hire.
Bachelor's degree from an accredited institution in Computer Science, Information Systems, Software Engineering, Mathematics, or a related field; 15 years of documented experience in data warehousing, BI development, or reporting administration may substitute.
At least three years of hands-on experience in business intelligence reporting, data mart maintenance, and SQL development in an enterprise data warehouse environment.
Strong working knowledge of Oracle Analytics Server (OAS), OBIEE 11g/12c, and BI Publisher report authoring.
Advanced SQL query writing and optimization skills, including knowledge of relational schemas, star schemas, dimensional models, and aggregate tables.
Experience maintaining reporting catalogs, creating dashboard prompts, configuring user security filters, and managing scheduled report bursts.
Familiarity with Linux (RHEL) commands, basic shell navigation, and multi-tier web application architectures.

Nice To Haves

Experience supporting the Military Health System (MHS), TRICARE Encounter Data (TEDS), or Department of Defense financial or contracting reporting systems.
Direct experience developing Section 508- and WCAG 2.1-compliant reports and web dashboards.
Familiarity with Oracle WebLogic Server administration, SSL certificates, and CAC/PKI authentication.
Knowledge of Informatica PowerCenter workflows and batch job monitoring in BMC Control-M.
Experience with cloud-hosted BI environments, including AWS GovCloud or MedCOI.

Responsibilities

Administer, configure, and sustain DHA ECS reporting data marts and ad hoc reporting portals on Oracle and Linux (RHEL) platforms.
Maintain and support Oracle Analytics Server (OAS), OBIEE, and Oracle WebLogic software, including routine maintenance, configuration updates, and vendor patches.
Maintain report repositories, subject areas, physical-to-logical data mappings, and catalog objects such as dashboards, analyses, prompts, and report templates.
Administer drop-down menus, parameter filters, and presentation variables to reflect changing business rules.
Develop, test, and maintain pixel-perfect operational and management reports using BI Publisher and interactive dashboards in OAS.
Support the restricted-access Contractor Resource Center portal, maintaining data integrity and timely production of its report types.
Modify reports to incorporate Oracle Federal Financials data into FRDM and PRDM reporting.
Respond to ad hoc user inquiries by generating custom datasets and reports for DHA CRM, CO-Aurora, and DHA leadership.
Manage data mart user profiles, access permissions, and dashboard security filters using OID/SSO and CAC PKI authentication.
Troubleshoot reporting discrepancies, query timeouts, and dashboard access issues for users.
Maintain user guides, standard operating procedures, and training documentation in accordance with CDRL 0014.
Conduct functional walk-throughs and informal training for DHA analysts and contractor stakeholders.
Ensure dashboards, generated PDF and Excel reports, and web interfaces comply with Revised Section 508 Standards and WCAG 2.1 Level A and AA requirements.
Apply accessibility design standards for assistive technology users and remediate accessibility findings in existing catalog objects.
Support testing and rollout of enhancement initiatives, including the CRDM project and LOA/CCAS reporting fields.
Perform unit testing and support UAT for new reports, recording test evidence and screenshots for CMB change packages.
Track monthly website access and report execution metrics across FRDM, ORDM, PRDM, and CRDM to identify anomalies or performance degradation.
Meet outage-resolution SLAs, restoring reporting services within four hours during monthly financial closeouts and eight hours during normal operational windows.