Senior Oracle 19c DBA - Remote Data Migration Lead

Interactive Process Technology LLC; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

IPT Associates (IPTA) seeks a seasoned SME Oracle Database Administrator to lead a critical migration of an Army enterprise system into Palantir Foundry. You will manage 19c expertise, data profiling, and source‑to‑target mapping while upholding DoD security standards.

The role requires DoD clearances, strong PL/SQL skills, and experience with RMAN/Data Pump. Remote work is offered to support nationwide collaboration on this high‑impact project.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field (equivalent experience may be considered).
• 10+ years of Oracle database administration experience, including hands‑on migration and data transition projects.
• Advanced Oracle 19c expertise, including RMAN, Data Pump, ASM, PL/SQL, and partitioning, with working knowledge of Data Guard replication.
• Demonstrated data migration experience: point‑in‑time extraction, source‑to‑target mapping, data profiling, reconciliation, and data‑quality validation.
• Experience analyzing legacy PL/SQL and Oracle ETL code to drive refactor‑or‑retire decisions.
• DoD environment experience: STIG‑hardened Oracle baselines, RMF, and NIPRNet constraints.
• Administer, test, and implement computer databases, applying knowledge of database management systems.
• Plan, coordinate, and implement security measures to safeguard computer databases.
• Provides technical/management leadership on major tasks or technology assignments.

Responsibilities

• Serves as the Oracle 19c database authority for the migration of a legacy U.S. Army enterprise system into Palantir Foundry (Army Vantage).
• Extracts the legacy Oracle 19c database on NIPRNet, producing a consistent point‑in‑time, integrity‑validated snapshot for Palantir Foundry.
• Reverse‑engineers the highly normalized legacy schema and leads source‑to‑target data mapping across systems.
• Analyzes legacy PL/SQL and Oracle ETL code to determine refactor vs retire in the Foundry migration.
• Performs data profiling, cleansing, and reconciliation to enforce data quality in migrated data.
• Works in the DoD‑aligned, STIG‑hardened environment including RMF and NIPRNet constraints.

Skills

Oracle 19c

Database migration

RMAN

Data Pump

PL/SQL

Partitioning

Data Guard

Security clearance

DoD requirements

Education

Bachelor's degree

Tools

Oracle ASM

RMF

Job description

IPT Associates (IPTA) seeks a seasoned SME Oracle Database Administrator to lead a critical migration of an Army enterprise system into Palantir Foundry. You will manage 19c expertise, data profiling, and source‑to‑target mapping while upholding DoD security standards.

The role requires DoD clearances, strong PL/SQL skills, and experience with RMAN/Data Pump. Remote work is offered to support nationwide collaboration on this high‑impact project.