PostgreSQL-to-Oracle Migration Engineer

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

Job summary

Booz Allen Hamilton is seeking a Database Solutions Engineer to lead PostgreSQL-to-Oracle migrations and modernize complex database environments in Reston, VA. You will design IA-ready Oracle AI Database 26ai environments, implement multi-model databases, and migrate on-prem or cloud databases to OCI, coordinating with cross-functional teams to ensure reliable, secure transitions.

The role requires 8+ years of database experience, strong SQL/PL-SQL skills, and a TS/SCI clearance.

Qualifications

• 8+ years of experience in database development, engineering, or data migration.
• Experience planning and executing PostgreSQL-to-Oracle migrations across discovery, schema and code conversion, data movement, testing, cutover, reconciliation, and stabilization.
• Experience designing and implementing Oracle AI Database 26ai environments.
• Experience designing multi-model databases using relational, spatial, JSON, and graph data types.
• Experience migrating Oracle Databases from on-premises or cloud environments into OCI.
• Experience with database migration tools.
• Experience with SQL and PL/SQL, including database schemas, interfaces, performance optimization, and operational automation.
• Active TS/SCI clearance; willingness to take a polygraph exam.
• Bachelor’s degree.

Responsibilities

• Plan and execute PostgreSQL-to-Oracle Database migrations from discovery through post-migration stabilization.
• Design and implement Oracle AI Database 26ai environments that meet application, analytics, availability, security, and operational requirements.
• Design multi-model databases integrating relational, spatial, JSON, including JSON Relational Duality, and graph data types.
• Migrate Oracle Databases from on-premises or other cloud environments into OCI while managing network, service, sequencing, and operational dependencies.
• Use Zero Downtime Migration, Data Pump, GoldenGate, or comparable tools to execute reliable migrations with rollback and recovery planning.
• Develop and optimize SQL, PL/SQL, schemas, interfaces, and operational automation for migrated and newly developed applications.
• Define migration test plans, reconcile source and target data, assess migration readiness, and troubleshoot functional, performance, and integration issues.
• Create migration plans, design documentation, runbooks, cutover checklists, and stakeholder-ready status reports.

Skills

SQL

PL/SQL

Data migration

PostgreSQL

Oracle databases

Oracle OCI

Migration tools

Education

Bachelor’s degree

Tools

Data Pump

GoldenGate

Zero Downtime Migration

OCI

Oracle AI Database 26ai

Oracle API Gateway

Job description

Booz Allen Hamilton is seeking a Database Solutions Engineer to lead PostgreSQL-to-Oracle migrations and modernize complex database environments in Reston, VA. You will design IA-ready Oracle AI Database 26ai environments, implement multi-model databases, and migrate on-prem or cloud databases to OCI, coordinating with cross-functional teams to ensure reliable, secure transitions.

The role requires 8+ years of database experience, strong SQL/PL-SQL skills, and a TS/SCI clearance.