Senior Oracle DBA: 19c Migration Specialist (Remote)

System One; Herndon (VA); Hybride; USD 120 000 - 160 000; Plein temps

Résumé du poste

System One is seeking a Senior Oracle Database Administrator to lead the Oracle 19c migration and data extraction for an Army data migration initiative. The role focuses on migration engineering, data validation, and performance optimization, with the Palantir Foundry loading in mind.

The position is primarily remote with periodic onsite support at Fort Belvoir, VA, and requires an active Secret clearance. You will collaborate with data engineers, application developers, testers, security

Qualifications

• Hands-on experience with Oracle 19c database extraction, migration, backup, recovery, and performance tuning.

Responsabilités

• Lead extraction and migration of legacy Oracle 19c database, ensuring data integrity and staging for Palantir loading.
• Analyze and document normalized, time-variant database schema and dependencies.
• Design source-to-target mapping for business processes and database objects.
• Evaluate legacy PL/SQL, ETL processes and database objects for migration, refactor, or retirement.
• Perform data profiling, cleansing, validation, and reconciliation for source-to-target integrity.
• Collaborate with replication/synchronization topology to enable repeatable extraction without disruption.
• Support incremental synchronization from source to Palantir.
• Support partitioning, bulk loading, and performance tuning for migration throughput.
• Coordinate with data engineers, developers, testers, security, and stakeholders throughout the migration lifecycle.

Connaissances

Oracle 19c

RMAN

Data Pump

ASM

PL/SQL

Partitioning

Data Guard

DoD environment

Formation

Bachelor's degree in a technical field

Outils

Oracle 19c

Description du poste

System One is seeking a Senior Oracle Database Administrator to lead the Oracle 19c migration and data extraction for an Army data migration initiative. The role focuses on migration engineering, data validation, and performance optimization, with the Palantir Foundry loading in mind.

The position is primarily remote with periodic onsite support at Fort Belvoir, VA, and requires an active Secret clearance. You will collaborate with data engineers, application developers, testers, security