Oracle Database Administrator - SME :: Remote
Stellent IT LLC
- Job
- 33182
- Posted
- Location
- Remote
- Work type
- Full Time
- Tax terms
- C2C
- Experience
- Experience open
- Openings
- 1 opening
Opens your email app with a message to the employer, its subject naming this job. Attach your resume and send it from your own email.
Skills
- Oracle
- Database Administration
- Database
- Reverse Engineering
- Extraction
- Data Mapping
- Mapping
- Data Profiling
- Data Quality
- Legacy Systems
- POC
- Oracle RMAN
- Oracle ASM
- Application Service Management
- PL/SQL
- Oracle Data Guard
- Replication
- Stig
- Risk Management Framework
- RMF
About the job
TITLE Oracle Database Administrator - SME
Location - REMOTE
Type: Contract
Must have SECRET clearance
Overview: The Oracle 19c Database Administrator leads the extraction and migration of the legacy system database, producing a clean, integrity-validated NIPR snapshot for load into Palantir and reverse-engineering the highly normalized, time-variant schema that drives the migration. 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 to determine what carries forward into the Vantage pipeline. The role emphasizes migration and transition engineering data profiling, reconciliation, and system data-quality validation rather than steady-state database maintenance. Responsibilities include:
Migration & extraction
Snapshot and extract the legacy Oracle 19c database (NIPR) for load into G-1 Palantir consistent point-in-time capture, integrity validation, and staging (Task 1)
Design and support source-to-target data mapping of key processes and data objects; application-dependency mapping across source systems to sequence the migration safely
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 (source-to-target row/field integrity)
Transition engineering
Work the existing replication/sync topology) to establish repeatable extract/sync without disrupting the legacy system during the PoC
Support incremental sync design from the Oracle source into Palantir
Partition, bulk-load, and performance-tune specifically for one-time and incremental migration throughput
Foundational Oracle 19c depth (enabler, not the focus)
Oracle 19c internals sufficient to migrate confidently - RMAN, Data Pump, ASM, PL/SQL, partitioning; enough Data Guard familiarity to work the replication seam
Environment/compliance
DoD/Army migration context: STIG-hardened Oracle baselines, RMF, NIPR constraints, and handling of controlled data during transition
Must have SECRET clearance
Bonus if you have:
Oracle Certified Professional (OCP) 19c
Security+ (DoD 8570/8140 baseline for privileged access)
Requirements :
Database Administration - Advanced
Database Migrations - Intermediate
Transition Management - Intermediate
Ankita Singh -Recruitment Manager
Email- | Ext: 138 Contact No :
STELLENT IT A Nationally Recognized Minority Certified Enterprise
"Happiness can be found, even in the darkest of times, if one only remembers to turn on the light."
- JK Rowling