Senior Engineer - Database Migration

FPT ASIA PACIFIC PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

FPT Asia Pacific Pte. Ltd. in Singapore is seeking a seasoned database migration specialist to lead the transformation of a legacy system from Sybase ASE to Microsoft SQL Server on-premises, preserving business function.

The role focuses on converting stored procedures, triggers, and views to SQL Server, updating applications, testing results, and collaborating with on-site client teams and the offshore delivery team to ensure a seamless cutover.

Qualifications

• 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.

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.

Skills

Back-end development

Database design

T-SQL

Tools

Sybase

MSSQL

Java

PowerBuilder

Linux

WebLogic

Spring Boot

Job description

Overview

Migration of a client's legacy system fromSybase ASEtoMicrosoft SQL Server, on premises, with no change to business functionality.

The system consists of aSybase databasewith many stored procedures, aPowerBuilder desktop application, and a set ofJava applicationsand 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 withSybaseandMSSQL, for schema, query & server.
• Strong T-SQL - able to read and rewrite long, complex stored procedures.
• Experience withJavaorPowerBuilderapplication 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.