Senior Oracle Database Developer. Job in Penwortham LilyLifestyle Jobs

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 WebLogic, Oracle APEX, and reporting tools such as Crystal Reports.

Responsibilities

• Oracle Database Development & Maintenance
  • 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.
• Application Maintenance & Production Support
  • 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 WebLogic 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.
• Oracle Forms & Reports Development
  • 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.
• Oracle APEX Development
  • 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.
• WebLogic Server Administration & Support
  • Support deployment and maintenance of Oracle applications hosted on Oracle WebLogic Server.
  • Assist in troubleshooting WebLogic-related issues such as application availability, performance, configuration, and connectivity.
  • Coordinate deployments and configuration changes across development, test, and production environments.
• Reporting & Business Intelligence Support
  • 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.
• Performance Tuning & Optimization
  • 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.
• Documentation & Change Management
  • 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.

Qualifications

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

Essential skills

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

Desired skills

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

Experience

• Experience in Oracle development and application maintenance/support.
• Experience supporting enterprise applications in production environments.
• Strong experience with Oracle Database 19c.
• Experience with Oracle WebLogic Server in application deployment and support.
• Experience developing and supporting Oracle APEX applications.
• Experience creating and maintaining reports using Crystal Reports.

Benefits

• Collaborative working environment - we stand shoulder to shoulder with our clients and our peers through good times and challenges.
• We empower all passionate technology loving professionals by allowing them to expand their skills and take part in inspiring projects.
• Expleo Academy - enables you to acquire and develop the right skills by delivering a suite of accredited training courses.
• Competitive company benefits.
• Always working as one team, our people are not afraid to think big and challenge the status quo.

As a Disability Confident Committed Employer we have committed to:

• Ensure our recruitment process is inclusive and accessible.
• Communicating and promoting vacancies.
• Offering an interview to disabled people who meet the minimum criteria for the job.
• Anticipating and providing reasonable adjustments as required.
• Supporting any existing employee who acquires a disability or long term health condition, enabling them to stay in work at least one activity that will make a difference for disabled people.

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation or age. We treat everyone fairly and equitably across the organisation, including providing any additional support and adjustments needed for everyone to thrive.