Senior Data Migration Engineer

On behalf of a private sector client, we are looking for a Senior Data Migration Engineer for a database modernisation project.

The project involves migrating core databases from Oracle to PostgreSQL as part of a broader effort to modernise the client’s engineering application ecosystem. The consultant will take technical ownership of the migration, including refactoring database structures, stored procedures, triggers, and procedural logic, while also adapting .NET-based application layers for PostgreSQL compatibility.

Alongside the database work, the role includes migrating legacy reporting solutions from Crystal Reports and SAP BusinessObjects to Power BI, as well as building automation tooling to streamline schema conversions and data validation.

The right consultant brings solid hands-on experience with Oracle-to-PostgreSQL migrations and strong knowledge of both PL/SQL and PL/pgSQL. Scripting skills in Python or C# are important for building migration pipelines. The team works across software engineering, DevOps, and business stakeholders, so the ability to collaborate effectively and keep downtime to a minimum during cutovers is important. A background check will be required for this role.

Your qualifications:
Proven experience with Oracle-to-PostgreSQL migrations, including refactoring of database structures, packages, stored procedures, and triggers.

Strong Oracle PL/SQL and PostgreSQL PL/pgSQL skills, including advanced procedural logic, cursors, and exception handling.

Application migration experience with .NET (C#), including restructuring SQL queries and data connections for PostgreSQL compatibility.

Experience migrating Crystal Reports and SAP BusinessObjects solutions to Power BI, including building interactive dashboards.

Scripting experience for automation and ETL pipelines, using Python, C#, or similar tools.

Experience with post-migration data testing and validation to ensure completeness and consistency.

Familiarity with AWS-hosted PostgreSQL deployments and zero-downtime migration strategies is an advantage.