Senior Oracle PL/SQL Developer

Summary

We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernisation initiatives. The ideal candidate will review, refactor, and migrate legacy application logic, including PL/SQL code, stored procedures, and Crystal Reports, into a modern AWS-based architecture.

This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third-party vendor. They will support the redesign of core application functionality, including modules such as

records, classification and sentence computation, to ensure accurate operation within the updated system.

Key Responsibilities

• Review and document existing application architecture, data models, workflows, and stored
• procedures.
• Rewrite and optimise Oracle PL/SQL packages, functions, triggers, and views for migration to a
• cloud environment.
• Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
• Extract, map, validate, and transform data to support ETL and database conversion activities.
• Analyse, document, and refactor core logic modules such as sentence computation.
• Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
• Understand and document scheduled jobs and backend automation processes.
• Collaborate with a third-party vendor to clarify requirements and support modernisation efforts.

Required Technical Skills

• Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
• Strong SQL expertise, including query optimisation and performance tuning.
• Experience with data migration, ETL workflows, and schema transformation.
• Ability to understand logic from legacy applications and undocumented code.
• Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
• Experience with task schedulers for data automation.

Preferred Qualifications

• Experience with AWS database and reporting services.
• Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
• Scripting experience (Python, PowerShell).
• Experience with Offender Management or enterprise justice systems.
• Experience working with external vendor teams on modernisation projects.