DB 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

• DB Engineer Oracle and PostgreSQL skills required to drive the data migration between Oracle and PostgreSQL DB automate the data integrity and migration validation scripts at DB level
• Oracle Database Knowledge Understanding of Oracle schemas data types PLSQL triggers stored procedures and constraints
• PostgreSQL Knowledge Familiarity with PostgreSQL schemas data types functions extensions and procedural language PLpgSQL
• Migration Tools Utilities such as pgloader ora2pg ETL scripts with Python Perl etc
• Error Handling Troubleshooting Ability to identify diagnose and resolve migration errorsincompatibilities remove duplicates ensure data quality