Senior Database Migration Engineer – Oracle to PostgreSQL & ODI to ADF – 6 Months in Copenhagen/Hybrid

You’ll play an important role in:

• Migrate Oracle to PostgreSQL databases by refactoring and transforming core database structures, procedural logic, and data connections into scalable, high-performing PostgreSQL implementations.
• Translate & convert core database logic by refactoring complex Oracle database components (packages, stored procedures, functions, triggers) into clean and efficient PostgreSQL structures.
• Migrate Oracle Data Integration (ODI) workflows to Azure Data Factory (ADF), ensuring seamless and efficient data transformation and pipeline orchestration. Added value if the candidate has experience with Apache Airflow for workflow automation and scheduling.
• Migration Tooling Proficiency: Hands-on experience with specialized schema and data movement utilities such as ora2pg, or other modern data pipeline frameworks designed for large-scale migrations (Terabyte)
• Develop automated migration workflows using script automation (Python, C# and etc) to streamline schema conversions, data validations, and other repetitive tasks within database transformation.
• Optimize Postgres database performance by analysing execution plans, applying advanced indexing techniques, and tuning configuration parameters for post-migration performance.
• Collaborate across teams to minimize downtime during migrations and provide hands-on support for testing, cutover, scaling, and troubleshooting.

Must have experience with the following:

• PostgreSQL
• Azure Data Factory
• Oracle Data Integrator (ODI)
• Oracle Database migration

To succeed in the role, you:

• Proven experience in Oracle-to-PostgreSQL migrations, including expertise in refactoring database structures, packages, stored procedures, triggers, and data connection logi
• Proficiency in ODI and ADF: Experience migrating ODI workflows to ADF pipelines, incl. parameterisation, scheduling, integration runtime, monitoring, and error handling. Added value: Apache Airflow.
• Advanced skills in Oracle PL/SQL and PostgreSQL PL/pgSQL, featuring proficiency in handling advanced procedural logic, cursors, triggers, and exception-handling patterns.
• Post migration data testing and validation: Ability to verify that migrated data is complete and consistent.
• Cloud: Familiarity with Azure cloud-based PostgreSQL deployments and security best practices.
• Expertise in Power BI reporting tool, with proven ability to build interactive reports and dashboards using advanced Power BI functionalities.

Additionally, it would be great if you have:

Experience designing and implementing zero-downtime migration strategies and replication mechanisms.

Advanced Performance Tuning: Deep knowledge of PostgreSQL internals, including vacuuming configurations, partition management for large datasets, and memory tuning.

Terabyte-Scale Migration Experience: Proven experience handling large-scale database migrations involving Terabytes (TB) of volume data, ensuring minimal application downtime and zero data loss.

Practical Information

• Duration: 12-10-2026 - 31-03-2027
• Working hours: 37 hours per week
• Work setup: Hybrid setup with minimum 3 days onsite per week.
• The consultant must be based in Denmark.