Oracle Forms & Reports Developer - Enterprise ERP & Back-Office Systems

The role sits in a team responsible for core back-office platforms supporting procurement, finance, asset management, and operational reporting. The stack includes classic Oracle Forms, Oracle Reports, and deep PL/SQL, with ongoing investment in stability, performance, and controlled modernisation (service enablement, improved testing, and better release discipline).

If you're an Oracle developer who enjoys ownership, problem-solving, and improving mature systems without disrupting the business, this is a strong long-term opportunity.

What you'll be doing

You'll work closely with business analysts, Oracle DBAs, and delivery teams to enhance and support production-critical applications., * Develop, enhance and maintain Oracle Forms modules (triggers, program units, canvases, LOVs, validation rules).

• Build and support Oracle Reports (layout, data models, parameters, bursting/scheduling considerations).
• Design and optimise PL/SQL packages, procedures, functions and triggers with a focus on performance and maintainability.
• Troubleshoot and resolve production issues across Forms/Reports and database layers, driving root cause fixes.
• Support formal testing cycles including integration testing, UAT, regression testing, and performance testing.
• Work with DBAs on query tuning: execution plans, indexing strategy, statistics, locking/contention analysis.
• Contribute to release and change management: code reviews, deployment notes, impact assessments, and rollback planning.
• Maintain technical documentation: interface specs, data mappings, support runbooks, and change records for audit/compliance.
• Support incidents and work requests in line with agreed SLAs, including occasional out-of-hours support when needed., * Oracle E-Business Suite (EBS) exposure (customisations, extensions, integrations, concurrent programs)
• Oracle BI Publisher / report modernisation experience
• Integration experience: REST APIs, SOAP, XML, flat-file interfaces, SFTP
• CI/CD or automation for Oracle estates (build/release scripting, deployment repeatability)
• Experience with Unix/Linux environments and scheduling (e.g. cron, job control, log inspection)
• Understanding of security concepts (roles, privileges, audit requirements)

What the systems support (business domain)

You'll be working on platforms that underpin regulated operations and require strong data governance, including:

• Finance (AP/AR, invoicing, journals, reconciliations)
• Procurement (purchase orders, approvals, supplier management)
• Asset management (asset records, maintenance work tracking, cost allocation)
• Operational reporting (audit trails, compliance reporting, management dashboards feeds)
• Interfaces to upstream/downstream systems for data exchange and regulatory evidence

What success looks like in the first 3-6 months

• You'll take ownership of key Forms/Reports areas and become a trusted escalation point for issues and enhancements.
• You'll deliver changes with low defect rates, supported by stronger regression discipline and clearer documentation.
• You'll improve performance and reliability in at least one high-usage workflow through PL/SQL and SQL tuning.
• You'll contribute to a pragmatic modernisation roadmap-stabilise today, enable integration tomorrow.

• Oracle Forms (enterprise Forms development, triggers, validation, navigation, UI patterns)
• Oracle Reports (report design, parameters, layouts, scheduling outputs)
• PL/SQL (packages, procedures, functions, exception handling, performance-focused coding)
• Oracle Database experience (SQL tuning fundamentals, constraints, sequences, indexing)
• Strong SQL knowledge (joins, aggregation, analytical thinking, query optimisation)
• Experience working within controlled environments (change control, evidence-based testing, operational stability), * Proven commercial experience as an Oracle Forms & Reports Developer (or strong Forms/PLSQL background with reporting exposure)
• Strong troubleshooting ability across application and Oracle Database layers
• Comfortable working with business stakeholders and translating requirements into stable, supportable delivery
• A quality-led mindset: clean PL/SQL, documentation, and disciplined testing/release processes