Legacy Modernisation & Enterprise Application SupportRole Overview
We are looking for an Oracle Application Support Engineer to support and evolve mission-critical enterprise systems built on Oracle Forms, Reports, and ADF.
This role sits at the intersection of production stability, structured enhancements, and legacy modernisation — ensuring systems remain reliable today while progressively improving performance, maintainability, and integration with modern platforms.
You will operate within a governed SDLC environment, taking ownership of incident resolution, change requests (CRs), and release activities, while working closely with cross-functional teams across business, QA, and infrastructure.
Key Responsibilities1. Production Support & System StabilityProvide L2/L3 application support for Oracle-based systems (Forms, Reports, ADF), ensuring high availability and reliabilityTroubleshoot production issues and perform root cause analysis (RCA) across application, database, and integration layersMonitor and stabilise batch jobs, scheduled workflows, and reporting processesEnsure adherence to incident management SLAs and operational procedures
2. Change Requests (CRs) & EnhancementsAnalyse, design, and implement CRs, bug fixes, and enhancements across Oracle applicationsPerform impact analysis on database objects, PL/SQL packages, triggers, and schema dependenciesEnsure all changes comply with coding standards, security controls, and governance requirementsContribute to continuous improvement of legacy systems through refactoring and optimisation
3. Development & Technical DeliveryEnhance and maintain applications built on:Oracle Forms & Reports (triggers, built-ins, libraries)Oracle ADF (Application Development Framework)PL/SQL (procedures, packages, functions)Optimise SQL queries and database performance for scalability and efficiencySupport integration with downstream/upstream systems and APIs
4. Testing & Release ManagementDevelop and execute functional, regression, and integration test casesSupport User Acceptance Testing (UAT) by resolving defects and clarifying expected system behaviourManage deployment activities across environments (DEV / SIT / UAT / PROD)Perform post-deployment validation to ensure stability and prevent regressions
5. Environment & Platform SupportSupport applications deployed on Oracle WebLogic or equivalent middlewareTroubleshoot environment-related issues across application servers and database layersEnsure compliance with environment configuration and release governance standards
6. Documentation & GovernanceMaintain clear documentation for:Technical designs and CR implementationsTest cases and outcomesSystem configurations and operational proceduresSupport audits and ensure alignment with public sector IT governance and security policies
7. Stakeholder CollaborationWork closely with Business Analysts, QA Engineers, DBAs, and Operations teamsParticipate in Agile or hybrid delivery environments to ensure timely and quality deliveryTranslate business requirements into practical, maintainable technical solutions
Key RequirementsCore Technical SkillsStrong hands-on experience in:Oracle Forms & Reports developmentOracle ADF (Application Development Framework)PL/SQL programming and Oracle Database designExperience with:Stored procedures, triggers, packages, and performance tuningLegacy system support and modernisation initiativesMiddleware platforms such as Oracle WebLogic
Engineering & DeliverySolid understanding of:SDLC and structured change management processesAgile or hybrid delivery modelsTesting methodologies (functional, regression, integration)Ability to perform impact analysis and structured troubleshooting
ExperienceMinimum 3+ years of hands-on experience in Oracle Forms, Reports, ADF, and PL/SQLProven experience in production support and CR delivery for enterprise systems
Good to HaveExperience working in government or regulated environmentsFamiliarity with secure coding practices and compliance frameworksExposure to modernisation initiatives (e.g. migration from Forms to web-based platforms)Relevant certifications (e.g. NUS-ISS ICT Certification or equivalent)
What Success Looks LikeHigh system uptime with minimal production incidentsTimely and high-quality delivery of CRs and enhancementsImproved system performance and reduced technical debtClear documentation enabling long-term maintainability and handover