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 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 optimization, 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