Role Overview
Oracle 19c Database Administrator leads extraction and migration of the legacy system database, producing a clean, integrity-validated NIPR snapshot for load into Palantir. Working from the existing Dataguard replication topology, the DBA supports source-to-target data mapping, incremental sync design, and analysis of legacy Oracle ETL/PL-SQL objects. The role emphasizes migration and transition engineering – data profiling, reconciliation, and system data-quality validation – rather than steady-state database maintenance.
Key Responsibilities
- Snapshot and extract the legacy Oracle 19c database (NIPR) for load into G-1 Palantir – consistent point-in-time capture, integrity validation, and staging.
- Design and support source-to-target data mapping of key processes and data objects; application-dependency mapping across source systems.
- Analyze legacy Oracle ETL/PL-SQL jobs and objects to determine what must be refactored vs. retired in the move to the Palantir pipeline.
- Data profiling, cleansing, and reconciliation to enforce system data-quality/validation rules on migrated data.
- Work the existing replication/sync topology to establish repeatable extract/sync without disrupting the legacy system.
- Support incremental sync design from the Oracle source into Palantir.
- Partition, bulk-load, and performance-tune specifically for one-time and incremental migration throughput.
- Maintain Oracle 19c internals sufficient to migrate confidently – RMAN, Data Pump, ASM, PL/SQL, partitioning, and Data Guard familiarity.
- Adhere to DoD/Army migration context: STIG-hardened Oracle baselines, RMF, NIPR constraints, and handling of controlled data.
Requirements & Eligibility
- Must have Secret clearance.
- Must be a U.S. Citizen.
Bonus Skills
- Oracle Certified Professional (OCP) 19c.
- Security+ (DoD 8570/8140 baseline for privileged access).