Senior Engineer - Database Migration

Overview

Migration of a client's legacy system from Sybase ASE to Microsoft SQL Server, on premises, with no change to business functionality.

The system consists of a Sybase database with many stored procedures, a PowerBuilder desktop application, and a set of Java applications and batch jobs on top of it.

Responsibilities

• Convert stored procedures, triggers and views from Sybase T-SQL to SQL Server T-SQL, keeping the same behavior.
• Fix the code that does not convert automatically, and the differences in behavior between the two databases.
• Update the PowerBuilder application and the Java applications to work with SQL Server.
• Test and compare the old and new systems to confirm that the results are the same.
• Work with the client's technical team on site, and with the offshore team on daily delivery.

Requirements

• 4+ years of experience with databases and back-end development.
• Hands-on experience with Sybase and MSSQL, for schema, query & server.
• Strong T-SQL - able to read and rewrite long, complex stored procedures.
• Experience with Java or PowerBuilder application development.

Nice to have

• Experience in a previous database migration project.
• PowerBuilder, especially Data Windows.
• Java / Spring Boot, or WebLogic.
• Python or shell scripting.
• Linux.