Senior Engineer - Database Migration
FPT Asia Pacific Pte Ltd Singapore, Singapore
IT Services and IT Consulting · 10,001+ employees
About the role
Convert legacy Sybase stored procedures, triggers, and views to Microsoft SQL Server while maintaining business functionality. Update PowerBuilder and Java applications to ensure compatibility with the new database environment.
What they look for
Requirements
Requires at least 4 years of experience in database and back-end development with strong T-SQL proficiency. Candidates must have hands-on experience with Sybase and MSSQL, along with knowledge of Java or PowerBuilder.
Full description
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.
