Senior Oracle Database Developer. Penwortham LilyLifestyle

Overview

We are seeking an experienced Oracle Database 19c Developer / Application Maintenance Engineer to support and enhance bespoke applications built on Oracle technologies. This role focuses on maintaining and improving existing systems, resolving production issues, implementing enhancements, and ensuring the stability and performance of Oracle-based business applications.

The ideal candidate will have strong hands‑on expertise in Oracle Database 19c, PL/SQL, and application maintenance, along with experience supporting and developing solutions using Oracle Forms & Reports, Oracle Web Logic, Oracle APEX, and reporting tools such as Crystal Reports.

• Develop, maintain, and enhance PL/SQL packages, procedures, functions, triggers, and database scripts in Oracle 19c.
• Write and optimize complex SQL queries to support application functionality and reporting requirements.
• Perform database object maintenance including tables, views, indexes, sequences, and constraints.
• Support data fixes, data migration, and data validation activities in production and non-production environments.
• Ensure database code aligns with best practices, performance standards, and security guidelines.

• Provide day‑to‑day support and maintenance for Oracle‑based applications across multiple environments.
• Troubleshoot and resolve application incidents related to database logic, Oracle Forms, Reports, and Web Logic deployments.
• Conduct root cause analysis for recurring issues and implement permanent fixes.
• Support batch processes, scheduled jobs, and integration feeds to ensure business continuity.
• Work closely with business users to analyse defects and translate requirements into system enhancements.

• Maintain and enhance legacy Oracle Forms and Oracle Reports applications.
• Debug and modify Forms triggers, procedures, and Reports logic.
• Support migration efforts, patching, and modernization initiatives involving Oracle Forms/Reports systems.

• Develop, enhance, and maintain Oracle APEX applications.
• Create interactive reports, dashboards, and forms using APEX components.
• Integrate APEX applications with existing Oracle database objects and PL/SQL APIs.
• Support user access, authentication, and role‑based security in APEX.

• Support deployment and maintenance of Oracle applications hosted on Oracle Web Logic Server
  .
• Assist in troubleshooting Web Logic‑related issues such as application availability, performance, configuration, and connectivity.
• Coordinate deployments and configuration changes across development, test, and production environments.

• Develop and maintain reports using Crystal Reports to support business reporting needs.
• Analyse reporting requirements and ensure accurate data extraction from Oracle databases.
• Maintain existing reporting solutions and implement enhancements for improved performance and usability.

• Identify and resolve database performance issues using tools such as AWR, ADDM, SQL Trace, and Explain Plan
  .
• Improve performance through indexing strategies, query optimisation, and code refactoring.
• Assist with database monitoring, performance baselines, and capacity planning.

• Document technical designs, support procedures, fixes, and enhancements.
• Support release management activities including deployment planning, scripting, and production validation.
• Ensure compliance with change control processes and audit requirements.

• Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).

• Strong hands‑on expertise in PL/SQL and SQL development.
• Working knowledge of Oracle Forms and Oracle Reports development and maintenance.

• Familiar with other development platforms
• Exposure to Azure management/administration

• Experience in Oracle development and application maintenance/support.
• Experience supporting enterprise applications in production…