Oracle-to-PostgreSQL Migration Expert

Dynamo Technologies, LLC; United States; On-site; USD 120,000 - 155,000; Full time

Job summary

Dynamo Technologies, LLC is seeking an Oracle Database Migration Specialist to lead assessment, planning, and execution of Oracle modernization and migration initiatives. You will work with technical stakeholders to evaluate environments, develop migration strategies, perform data migration activities, and support testing and post-migration optimization efforts.

The ideal candidate has demonstrated experience migrating applications and databases from Oracle to non-Oracle platforms in complex

Qualifications

• 7+ years of relevant database experience with Oracle migrations.
• Experience migrating Oracle to PostgreSQL or other targets in enterprise environments.
• Hands-on with Ora2Pg or comparable toolsets and CDC-based minimal-downtime cutover.

Responsibilities

• Assess current Oracle environments and migration considerations.
• Develop migration strategies, roadmaps, and implementation plans.
• Execute schema conversion, data migration, validation, and cutover support.
• Collaborate with application teams on JDBC/ODBC changes and issue remediation.
• Analyze and optimize performance before, during, and after migration.
• Document procedures and technical designs; participate in stakeholder discussions.
• Provide recommendations for modernization and operational improvements.
• Troubleshoot database and application integration issues throughout migration.

Skills

Oracle Database administration

Oracle-to-PostgreSQL migrations

Ora2Pg tooling

PL/SQL to PostgreSQL conversion

SQL performance tuning

AWS RDS provisioning

DevOps / CI/CD familiarity

Communication skills

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

AWS SCT

AWS DMS

EDB Postgres MTK

PostgreSQL

Job description

Dynamo Technologies, LLC is seeking an Oracle Database Migration Specialist to lead assessment, planning, and execution of Oracle modernization and migration initiatives. You will work with technical stakeholders to evaluate environments, develop migration strategies, perform data migration activities, and support testing and post-migration optimization efforts.

The ideal candidate has demonstrated experience migrating applications and databases from Oracle to non-Oracle platforms in complex