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

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

Pension / 25-30 days holidays (buy and sell) / Bonus

Additional Benefits

Private Medical

Region

Remote

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

Bonus: up to 10% (performance-related)

Working pattern: Remote

Holiday: 25-30 days + bank holidays (option to buy/sell)

Pension: employer contribution matched to 4%

Private medical (or health cash plan)

The Opportunity

We are recruiting an Oracle Forms & Reports Developer for a UK organisation in the utilities sector. This business operates large scale, regulated services where accuracy, audit trails, and system availability are non-negotiable.

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.

Key responsibilities

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.

Tech stack (what you’ll be working with)

This is a core Oracle development role with a strong emphasis on engineering fundamentals.

Essential skills

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)

Highly desirable

Oracle E-Business Suite (EBS) exposure (customisations, extensions, integrations, concurrent programs)

Oracle BI Publisher / report modernisation experience

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:

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.

What we’re looking for

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

#J-18808-Ljbffr