Oracle Database Administrator - SME :: Remote Job at Stellent IT LLC, Remote

dCtoUXlCcjBrZWpBaEhHYk5CakY4blJMRmc9PQ==
  • Stellent IT LLC
  • Remote

Job Description

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

Job Tags

Contract work, Remote work

Similar Jobs

Ford

CRM and Digital Marketing Specialist, Ford Racing Job at Ford

 ...belong. Help us write the next chapter.In this positionWe're looking for a Digital Specialist to help bring the Ford Racing brand to life across our digital channels. You'll support the marketing team in producing and managing content across web, CRM, and owned... 

HDR

Land Surveyor Job at HDR

 ...we constantly ask ourselves: What is our impact on the world?Watch Our Story:' We are seeking a detail-oriented and motivated Land Surveyor to support land surveying operations. The ideal candidate will assist in collecting, processing, and analyzing field data for boundary... 

C.R. England

Local CDL-A Truck Driver - Home Daily Job at C.R. England

 ...Description C.R. England is Urgently Hiring Now Dedicated Local Drivers! Dedicated Local Fleet - Competitive Pay - Full Benefits...  ...trainees \n \n Our Fleets Offer: \n \n Local routes, home daily \n Competitive pay \n Reliable miles \n Top-of-the-line... 

Insurance Recruiting Solutions

Internal Auditor Job at Insurance Recruiting Solutions

 ...ABOUT THE ROLE Are you an auditor who wants more than just checking boxes? Were partnering with a fast-growing Property & Casualty insurance organization that is investing in its internal audit function and looking for an Internal Auditor to help strengthen controls... 

Kaleidoscope Education Solutions

Special Education Teacher Job at Kaleidoscope Education Solutions

 ...Job Description Location: Huntley, IL 60142 Date Posted: 10/01/2026 Category: Education K12 Education: Bachelor's Degree Our school client is seeking K-12 Certified Special Education Teacher - Huntley, IL. Imagine doing your best work in the profession you...