Senior Engineer

fpt asia pacific; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

FPT Asia Pacific is seeking a skilled database engineer to migrate a legacy system from Sybase ASE to Microsoft SQL Server on premises, preserving business functionality. The project includes transforming stored procedures, triggers, and views, and updating PowerBuilder and Java components to operate with SQL Server.

Current responsibilities involve testing and validating results to ensure identical outcomes, coordinating with the client's technical team on site, and collaborating daily with an

Qualifications

• 4+ years of experience with databases and back-end development.
• Hands-on with Sybase and MSSQL for schema, query, and server.
• Strong T-SQL, able to read and rewrite 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 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

SQL

T-SQL

Tools

Sybase

MSSQL

PowerBuilder

Java

Job description

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.