Advisory Apps Hiring! Full Time Oracle Form Expert in WP Kuala Lumpur - Ricebowl

Engagement type: Fixed-term contract, 9 months. You'll work hand-in-hand with our in-house team to dissect existing Oracle Forms applications and translate them onto our target stack.

Key Responsibilities

• Work alongside our development team to dissect existing Oracle Forms applications part by part — UI logic, triggers, program units, item-level events, and backend data flow

• Analyse and translate Oracle PL/SQL — stored procedures, functions, triggers, and packages — into equivalent Microsoft SQL Server (T-SQL) queries and procedures

• Read and reverse-engineer existing Oracle logic written by others, then explain to the team what each procedure does, why it exists, and how it maps to the new MSSQL implementation

• Debug and reproduce issues in the current Oracle Forms application to confirm intended behaviour before translation

• Map Oracle-specific constructs and data types (sequences, packages, DECODE, NVL, etc.) to their MSSQL equivalents, flagging gaps and edge cases

• Consult on and help plan the conversion of Oracle Forms applications into Advisory Apps' modern technology stack, mapping legacy logic to new architecture

• Develop, configure, and customise Oracle Forms applications to client specifications

• Maintain and enhance existing Oracle Forms applications for enterprise clients

• Collaborate with project managers and analysts to translate business requirements into technical solutions

• Produce schema, procedure, logic, and Oracle-to-MSSQL mapping documentation for handover, knowledge transfer, and ongoing maintenance

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field

• Proven hands-on experience coding, configuring, and using Oracle Forms (10g, 11g, or later)

• Strong proficiency writing Oracle database scripts — PL/SQL stored procedures, triggers, functions, and packages

• Working knowledge of Microsoft SQL Server / T-SQL — able to write equivalent stored procedures and queries, and understand how Oracle constructs differ from their MSSQL equivalents

• Demonstrated ability to read and reverse-engineer complex Oracle PL/SQL and Forms logic written by others

• Ability to debug Oracle errors and tune database performance under production conditions

• Strong analytical and communication skills — able to explain legacy Oracle logic clearly to a team unfamiliar with it, in a hands-on pairing and knowledge-transfer setting

• Comfortable working collaboratively with an in-house team rather than in isolation

• Available for the full 9-month contract term

Bonus / Nice-to-Have

• Familiarity with other databases (MySQL, PostgreSQL)

• Exposure to Node.js

• Prior experience migrating or re-platforming legacy enterprise applications