SME Oracle Database Administrator

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

SME Oracle Database Administrator

Remote

At IPT Associates (IPTA), we enjoy solving real-world problems with technology. We work closely with our customers, teammates, experts, and partners to come up with practical solutions that make a difference. Whether it's a government or business organization, we focus on understanding the need and building something that works.

Our Team

At IPTA, everything starts with our people. We're big believers that when you invest in your team, great things happen. That's why we encourage learning, growth, and trying new things-even if you don't have all the answers yet.

Our culture is rooted in fierce determination, fearless integrity, and passionate service-but we also like to keep things collaborative, supportive, and down-to-earth.

We're looking for people who:

• Are curious and excited about technology
• Like solving problems and figuring things out
• Can take initiative but also enjoy working with a team
• Want to keep learning, growing, and challenging themselves

If you're someone who's eager to jump in, learn something new, and make an impact-you'll fit right in here.

Responsibilities:

• Serves as the Oracle 19c database authority for the migration of a legacy U.S. Army enterprise system into Palantir Foundry (Army Vantage), with a focus on migration and transition engineering rather than steady-state database maintenance
• Extracts the legacy Oracle 19c database on NIPRNet, producing a consistent point-in-time, integrity-validated snapshot and staging it for load into Palantir Foundry
• Reverse-engineers the highly normalized, time‑variant legacy schema and leads source‑to‑target data mapping of key processes and data objects, including application‑dependency mapping across source systems to sequence the migration safely
• Analyzes legacy Oracle ETL jobs and PL/SQL objects to determine what must be refactored versus retired in the move to the Palantir Foundry pipeline
• Performs data profiling, cleansing, and source‑to‑target reconciliation (row‑ and field‑level integrity) to enforce system data‑quality and validation rules on migrated data
• Works within the existing Oracle Data Guard replication/sync topology to establish a repeatable extract and incremental sync into Palantir Foundry without disrupting the legacy system during the proof of concept
• Partitions, bulk‑loads, and performance‑tunes specifically for one‑time and incremental migration throughput
• Applies DoD and Army requirements throughout the transition, including STIG‑hardened Oracle baselines, RMF, NIPRNet constraints, and proper handling of controlled data

Requirements:

• 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 database migration and data transition projects
• Advanced Oracle 19c expertise, including RMAN, Data Pump, ASM, PL/SQL, and partitioning, with working knowledge of Oracle 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. Coordinate changes to computer databases
• Plan, coordinate, and implement security measures to safeguard computer databases
• Provides technical/management leadership on major tasks or technology assignments
• Establishes goals and plans that meet project objectives. Has domain and expert technical knowledge
• Directs and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are met
• Interactions involve client negotiations and interfacing with senior management
• Decision making and domain knowledge may have a critical impact on overall project implementation
• May supervise others
• An active Secret security clearance is required

Preferred Qualifications:

• Oracle Certified Professional (OCP), Oracle Database 19c
• CompTIA Security+ or equivalent DoD 8570/8140 baseline certification
• Experience designing incremental sync or change data capture (CDC) from Oracle sources
• Exposure to Palantir Foundry or Army Vantage data integration

IPTA is an Equal Opportunity Employer. All employment decisions are based on individual merit, including qualifications, experience, performance, and business needs, consistent with applicable federal laws and federal contracting requirements. IPTA provides equal opportunity and utilizes merit‑based principles to make employment‑related decisions.

#clearance