Migration Architect: PostgreSQL to Oracle on OCI AI DB

Booz Allen Hamilton; Reston (VA); On-site; USD 87,000 - 198,000; Full time

Job summary

Booz Allen Hamilton is seeking a Database Developer to lead PostgreSQL-to-Oracle migrations and deliver secure, mission-ready database solutions in the United States.

You will work across schema conversion, data movement, OCI migration, and Oracle AI Database 26ai environments, collaborating with database engineers, cloud specialists, security professionals, and stakeholders to ensure reliable testing, cutover, and post-migration stabilization.

Qualifications

• 8+ years of experience in database development, database 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 database solutions 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.

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

PostgreSQL

Oracle

SQL

PL/SQL

data migration

database development

data movement

Education

Bachelor’s degree

Tools

Data Pump

GoldenGate

Oracle API Gateway

Grafana

Oracle Analytics Cloud

Oracle Analytics Server

RESTful APIs

Job description

Booz Allen Hamilton is seeking a Database Developer to lead PostgreSQL-to-Oracle migrations and deliver secure, mission-ready database solutions in the United States.

You will work across schema conversion, data movement, OCI migration, and Oracle AI Database 26ai environments, collaborating with database engineers, cloud specialists, security professionals, and stakeholders to ensure reliable testing, cutover, and post-migration stabilization.