PostgreSQL-to-Oracle Migration Engineer

bah; Springfield (VA); On-site; USD 87,000 - 198,000; Full time

Job summary

Booz Allen is seeking a Database Solutions Engineer in Reston, VA to lead PostgreSQL-to-Oracle migrations and modernize data platforms. The role focuses on schema/code conversion, data movement, testing, and post-migration stabilization, with collaboration across security, cloud, and application teams.

A TS/SCI clearance and a Bachelor's degree are required. Additionally, responsibilities include designing Oracle AI Database 26ai environments, ensuring performance, availability, and security,

Qualifications

• 8+ years of experience in database development, engineering, or data migration.
• Expertise migrating PostgreSQL to Oracle databases.
• Experience designing Oracle AI Database 26ai environments.
• Proficiency with SQL/PL-SQL, schemas, and performance optimization.
• Active TS/SCI clearance; willingness to take a polygraph.

Responsibilities

• Plan and execute PostgreSQL-to-Oracle migrations from discovery to stabilization.
• Design and implement Oracle AI Database 26ai environments meeting requirements.
• Design multi-model databases including relational, spatial, JSON, and graph types.
• Migrate Oracle databases into OCI, managing network, services, sequencing, and dependencies.
• Use migration tools such as Data Pump, GoldenGate with rollback planning.
• Develop and optimize SQL/PL-SQL and automation for migrated apps.
• Create migration test plans, validate data, reconcile source/target, document decisions.
• Prepare runbooks, cutover checklists and stakeholder reports.

Skills

SQL

PL/SQL

Database development

Data migration

PostgreSQL

Oracle

Security clearance TS/SCI

Education

Bachelor’s degree

Tools

Oracle AI Database 26ai

Data Pump

GoldenGate

OCI

Job description

Booz Allen is seeking a Database Solutions Engineer in Reston, VA to lead PostgreSQL-to-Oracle migrations and modernize data platforms. The role focuses on schema/code conversion, data movement, testing, and post-migration stabilization, with collaboration across security, cloud, and application teams.

A TS/SCI clearance and a Bachelor's degree are required. Additionally, responsibilities include designing Oracle AI Database 26ai environments, ensuring performance, availability, and security,