Join the database migration track of a modernization program for a US-based software client, moving a Microsoft SQL Server database to PostgreSQL.
Locations (4)
United States
Vietnam
Poland
Mexico
Compensation
Attractive Salary and Benefits
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
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
Requirements
Bachelor's degree in Computer Science, Information Technology, or a related field
Nice to have: AWS (Aurora/RDS PostgreSQL)
Nice to have: Azure SQL
Nice to have: Azure Data Factory (ADF)
Nice to have: C#/.NET data access (EF Core, Dapper)