Oracle DB Migration Lead to PostgreSQL

Dynamo Technologies LLC; Vienna (VA); On-site; USD 120,000 - 155,000; Full time

Job summary

Dynamo Technologies LLC in Vienna, VA seeks an Oracle Database Migration Specialist to support assessment, planning, and execution of Oracle database modernization and migration initiatives. You will work with technical stakeholders to evaluate environments, develop migration strategies, perform data migration, and assist testing and post-migration optimization.

The ideal candidate has hands-on experience migrating Oracle workloads to PostgreSQL or similar platforms, using Ora2Pg or equivalent

Qualifications

• Bachelor's degree or equivalent in CS/IS/Engineering.
• 7+ years of relevant database experience (11+ years without a Bachelor's).
• Experience supporting at least one Oracle database migration project.

Responsibilities

• Assess current Oracle environments and identify migration considerations, risks, and dependencies.
• Develop migration strategies, roadmaps, and implementation plans.
• Execute migration activities including schema/conversion, data migration, validation, and cutover support.
• Collaborate with application teams to remediate issues during migration.
• Analyze and optimize database performance before, during, and after migration.
• Support testing activities (functional/integration/performance/UAT).
• Document migration procedures and designs.
• Provide recommendations for modernization and operational improvements.
• Participate in technical discussions with stakeholders.
• Troubleshoot and resolve issues throughout the migration lifecycle.

Skills

Oracle Database administration

Oracle-to-PostgreSQL migrations

Manual PL/SQL to PostgreSQL conversion

SQL performance tuning

Cloud experience (AWS RDS)

JDBC/ODBC connectivity changes

Strong written and verbal comms

Independent and collaborative work

Education

Bachelor's degree in Computer Science, Information Systems, Engineering

Tools

Ora2Pg

Job description

Dynamo Technologies LLC in Vienna, VA seeks an Oracle Database Migration Specialist to support assessment, planning, and execution of Oracle database modernization and migration initiatives. You will work with technical stakeholders to evaluate environments, develop migration strategies, perform data migration, and assist testing and post-migration optimization.

The ideal candidate has hands-on experience migrating Oracle workloads to PostgreSQL or similar platforms, using Ora2Pg or equivalent