Responsibilities
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 the .NET team to move it into the C# service layer, with special care for date/time, time-zone and temporal behavior and for numeric precision in calculation algorithms.
Collaborate with .NET
developers on the data-access layer so that the application runs on PostgreSQL in CI, while existing integration contracts, reports and exports stay unchanged
Design and run data validation and equivalence checks between SQL Server and PostgreSQL (row counts, checksums, query-result and business-rule reconciliation) and document the results as validation evidence.
Benchmark and tune PostgreSQL performance (indexes, query plans, configuration) against the SQL Server baseline
Design and build ETL pipelines for data migration from SQL Server to PostgreSQL
Run representative migration tests on anonymized data sets, support client user acceptance testing, fix defects and retest.
Write the migration runbook and support knowledge transfer and handover to the client team.
Use the AI-assisted engineering tools approved for the project, and review and test all AI-generated output before it is committed.
Participate in Agile/Scrum activities: daily stand-up, demo, retrospective, planning, etc.
Guide and review the work of the Data Engineers in the squad.
Perform other tasks assigned by the Leader/Manager.