Job Description

You will join the database migration track of a modernization program for a US-based software client. The product is a business-critical enterprise application. While the application is re-built on .NET and React, this track moves its Microsoft SQL Server database, including the business logic held in T-SQL, to PostgreSQL and proves, with evidence, that the migrated system behaves the same. All work is done on anonymized data

Responsibilities:

Assess the existing Microsoft SQL Server database (schema, T-SQL stored procedures, functions, triggers, jobs) and contribute to the SQL Server to PostgreSQL conversion design.
Convert schema, data types and data to PostgreSQL, and build repeatable, automated migration tooling and scripts (schema conversion, data load, migration rehearsal)
Monitor data quality in pipelines and provide data support to clients.
Convert T-SQL procedural logic to PL/pgSQL, or work with