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

  • 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

The Dorne Region

Entry-Level Client Services Coordinator - No Degree Required (Oakbrook Terrace) | $70,000-$100,000 Job at The Dorne Region

 ...often comes down to a clear answer and a follow-up that happens when promised. As an Entry-Level Client Services Coordinator, you will help make both happen. This full-time, in-office opportunity gives you a clear team environment while you learn the client-service... 

S.A. Comunale Co., Inc.

Fire Alarm Technician Job at S.A. Comunale Co., Inc.

 ..., maintain, and program various types of alarm systems. The Company goal is to continuously...  .... Occasionally must train Alarm Technician Trainees. Ability to work on low voltage...  ..., repair, maintain, and program Fire Alarm, Access Control, Nurse Call Intrusion... 

ALLIANCE IN HEALTH LLC

Non-Emergency Medical Transportation (NEMT) Driver Job at ALLIANCE IN HEALTH LLC

Job Description Job Description Alliance in Health Transportation is seeking reliable and compassionate drivers to provide non-emergency medical transportation for patients throughout the Philadelphia and surrounding counties

Baptist Memorial Health

Manager-Radiology Job at Baptist Memorial Health

 ...Manager-Radiology- Located at the Oxford Diagnostic Center 504 Azalea Drive Oxford MS Job Summary This position manages a high volume Imaging Center with several Radiology modalities as well as a lab and patient access departments. Demonstrates accountability... 

Socrates Academy

Upper School Computer Science Teacher Job at Socrates Academy

 ...Computer Science TeacherFull time with Middle School teaching responsibilitiesLocation: Matthews, North CarolinaStart date: January 19, 20...  ...OverviewSocrates Academy seeks a full-time computer science teacher to provide engaging, hands-on instruction across Upper and Middle...