Oracle-to-PostgreSQL Migration Specialist

Dynamo Technologies; United States; Remote; USD 120,000 - 155,000; Full time

Job summary

Dynamo Technologies LLC in the United States seeks an Oracle Database Migration Specialist to support modernization and migration initiatives across enterprise environments. You will collaborate with technical stakeholders to assess environments, develop migration strategies, and lead data migration activities using Ora2Pg and related tooling, ensuring minimal downtime and maximal data integrity.

Ideal candidates have hands-on Oracle DB administration experience, strong SQL tuning skills, and a

Qualifications

• Bachelor's degree required; 7+ years database experience.
• 7+ years of database experience required (11+ years without degree).
• Experience supporting at least one Oracle database migration project.
• Ability to manually convert Oracle PL/SQL objects to PostgreSQL equivalents when tooling cannot fully automate.

Responsibilities

• Assess current Oracle environments and identify migration considerations, risks, and dependencies.
• Develop migration strategies, roadmaps, and implementation plans.
• Execute schema conversion, PL/SQL object conversion, and data migration tasks.
• Collaborate with application teams to remediate migration issues.
• Document migration procedures and support post-migration optimization.

Skills

Oracle Database administration

Oracle to PostgreSQL migrations

SQL performance tuning

Data migration planning

JDBC/ODBC connectivity

Documentation & stakeholder comms

Independent & cross-functional work

Change Data Capture (CDC)

PL/SQL to PostgreSQL conversion

Education

Bachelor's degree in CS/IS/Engineering or related field

Tools

Ora2Pg

AWS SCT

AWS DMS

EDB Postgres MTK

Job description

Dynamo Technologies LLC in the United States seeks an Oracle Database Migration Specialist to support modernization and migration initiatives across enterprise environments. You will collaborate with technical stakeholders to assess environments, develop migration strategies, and lead data migration activities using Ora2Pg and related tooling, ensuring minimal downtime and maximal data integrity.

Ideal candidates have hands-on Oracle DB administration experience, strong SQL tuning skills, and a