Oracle-PostgreSQL Migration Engineer

TESTQ Technologies Limited; Belfast City District; On-site; GBP 55,000 - 90,000; Full time

Job summary

TESTQ Technologies Limited is seeking a DB Engineer with Oracle and PostgreSQL skills to drive data migrations between Oracle and PostgreSQL databases. The role involves automating data integrity checks and migration validation at the database level.

Candidates should understand Oracle schemas, PL/SQL, and PostgreSQL PLpgSQL, with familiarity of migration tools such as pgloader and ora2pg, and be able to diagnose and resolve migration errors to ensure data quality.

Qualifications

• Experience migrating data between Oracle and PostgreSQL databases.
• Knowledge of Oracle schemas, data types, PL/SQL, triggers and stored procedures.
• Familiarity with PostgreSQL schemas, data types, functions, extensions and PLpgSQL.
• Experience with migration tools such as pgloader and ora2pg.
• Ability to diagnose, troubleshoot, and resolve migration errors and data quality issues.

Responsibilities

• Drive data migration between Oracle and PostgreSQL databases.
• Automate data integrity and migration validation scripts at DB level.
• Identify and resolve migration errors and incompatibilities.
• Remove duplicates and ensure data quality.

Skills

Oracle

PostgreSQL

Data migration

PLpgSQL

Tools

pgloader

ora2pg

Python

Perl

Job description

TESTQ Technologies Limited is seeking a DB Engineer with Oracle and PostgreSQL skills to drive data migrations between Oracle and PostgreSQL databases. The role involves automating data integrity checks and migration validation at the database level.

Candidates should understand Oracle schemas, PL/SQL, and PostgreSQL PLpgSQL, with familiarity of migration tools such as pgloader and ora2pg, and be able to diagnose and resolve migration errors to ensure data quality.