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- ankita@stellentit.com | Ext: 138 Contact No : 201-581-4822
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
A flatbed truck driver is primarily responsible for the transport and delivery of goods, ensuring efficiency and timeliness. * Following strict safety regulations, such as maintaining insurance coverage on the vehicle and keeping up with required maintenance checks* ...
...The Division of Gastroenterology and Hepatology at Mayo Clinic in Rochester is seeking Board Certified or Board Eligible Gastroenterologists interested in pursuing exemplary clinical care, research, and/or education in a leading academic multi-specialty practice. The...
...Department Details NO REMOTE/WORK FROM HOME OPTION Job Summary Answers patient inquiries... ...provided to patients during triage in health record systems; records patients health... .... Currently holds an unencumbered RN license with the State Board of Nursing where...
...Job Title: Senior React Developer Location : Irving,TX; Tampa,FL; RutherFord,NJ(Candidates should be ready for F2F Interview) Exp: 12+yrs On w2 only This is pretty Urgent and Critical Requirement Responsibilities: Design, develop, and maintain high-quality...
...Summary **MUST BE CURRENTLY WORKING IN COUNTRY ON AN ACTIVE H2B VISA TO APPLY / BE CONSIDERED** Job Summary: Are you seeking... ...Safe and Have Fun! Responsible for supporting the Executive Chef and Sous Chef to execute, prepare and ensure quality service in...