Senior Oracle APEX Consultant

Version 1 has celebrated 30 years in business and continues to be trusted by global brands to deliver technology and transformation solutions that drive customer success. Our deep expertise enables our customers to navigate the rapidly evolving technology landscape. We foster strong partnerships with global technology leaders including Microsoft, AWS, Oracle, Red Hat, OutSystems, Snowflake, ensuring that our customers are provided with the highest quality solutions and services. 

 We’re an award-winning employer reflecting how our employees are at the very heart of  what we do: 

• UK & Ireland's premier AWS, Microsoft & Oracle partner 
• 3300+ strong, €350/£300m revenue business 
• 10+ years as a Great Place to Work in Ireland & UK 
• Best Workplace for Women in the UK & Ireland by GPTW 
• Best Workplace for Wellbeing in the UK by GPTW 

We’re a core values driven company, we hire people who share our values, and we reward those who display and foster them, it’s deeply embedded within our DNA. Invest in us and we’ll invest in you!. 

Role Overview

We are looking for a highly skilled Senior Oracle APEX Consultant to design, develop, and support Oracle APEX applications integrated with Oracle Fusion Cloud. The consultant will build dashboards, review workflows, audit functionality, and API integrations while ensuring high performance, usability, and compliance requirements are met.

Key Responsibilities

Application Development

• Develop Oracle APEX applications using best practices.
• Build role-based dashboards and interactive reports.
• Develop drill-down reporting and analytical views.
• Create forms, workflows, and approval-driven functionalities.
• Configure export features and dashboard visualizations.

Oracle Fusion Integration

• Develop integrations with Oracle Fusion REST APIs.
• Consume and process Oracle Procurement and PO data.
• Implement error handling and reconciliation mechanisms.
• Support automated transaction and workflow execution.

Database Development

• Develop PL/SQL packages, procedures, functions, and triggers.
• Create efficient SQL queries and database objects.
• Implement audit trail tables and historical tracking.
• Optimize performance for large-volume transactional data.

Security & Compliance

• Implement role-based security models.
• Support audit logging and traceability requirements.
• Ensure compliance with SOX and internal controls.
• Maintain data integrity and segregation of duties requirements.

Testing & Deployment

• Prepare unit test cases and support SIT/UAT.
• Resolve defects and performance issues.
• Support deployments across environments.
• Participate in production support and hypercare activities.

Required Technical Skills

Oracle Technologies

• Oracle APEX
• Oracle Database
• PL/SQL
• SQL Tuning
• Oracle REST Data Services (ORDS)
• Oracle Fusion REST APIs
• Oracle Autonomous Database / ADW

Development Skills

• REST API Integration
• JSON Processing
• JavaScript
• HTML/CSS
• Interactive Reports & Dashboards
• Dynamic Actions
• Application Security

Functional Skills

• Oracle Procurement
• Purchase Orders
• Accounts Payables
• Financial Accrual Processes
• Month-End Reporting
• Audit Controls

Preferred Qualifications

• Oracle APEX Certification
• Oracle Cloud ERP Exposure
• Experience integrating APEX with Oracle Fusion
• Experience working in agile delivery teams

Key Competencies

• Strong problem-solving skills
• Stakeholder communication
• Solution-oriented mindset
• Attention to detail
• Ownership and accountability
• Ability to work independently and within distributed teams

Ideal Experience Profile

• Delivered enterprise Oracle APEX applications.
• Integrated APEX with Oracle Fusion Cloud using REST APIs.
• Worked on finance, procurement, audit, or compliance-related applications.
• Experience implementing audit trails, approval workflows, and role-based security models.

Why Version 1? 

 At Version 1, we believe in providing our employees with a comprehensive benefits package that prioritises their wellbeing, professional growth, and financial stability. 

• Share in our success with our Quarterly Performance-Related Profit Share Scheme, where employees collectively benefit from a share of our company's profits 
• Strong Career Progression & mentorship coaching through our Strength in Balance & Leadership schemes with a dedicated quarterly Pathways Career Development programme 
• Flexible/remote working, Version 1 is tremendously understanding of life events and people’s individual circumstances and offer flexibility to help achieve a healthy work life balance 
• Financial Wellbeing initiatives including; Pension, Private Healthcare Cover, Life Assurance, Financial advice and an Employee Discount scheme 
• Employee Wellbeing schemes including Gym Discounts, Bike to Work, Fitness classes, Mindfulness Workshops, Employee Assistance Programme and much more. Generous holiday allowance, enhanced maternity/paternity leave, marriage/civil partnership leave and special leave policies 
• Educational assistance, incentivised certifications, and accreditations, including AWS, Microsoft, Oracle, and Red Hat 
• Reward schemes including Version 1’s Annual Excellence Awards & ‘Call-Out’ platform. 
• Environment, Social and Community First initiatives allow you to get involved in local fundraising and development opportunities as part of fostering our diversity, inclusion and belonging schemes. 

And many more exciting benefits… drop us a note to find out more.    

Version 1 is an equal opportunities employer. 

We are committed to building a diverse, inclusive and respectful workplace where everyone feels valued and able to thrive. We welcome applications from people of all backgrounds, identities and lived experiences, and we value the different perspectives people bring including those shaped by disability and neurodiversity. 

We want every candidate to have a positive and accessible recruitment experience. If you need reasonable adjustments at any stage of the process, please contact your recruiter at Version 1. We will consider all requests carefully, respectfully and confidentially. 

Video links: https://www.youtube.com/watch?v=F_d3ELTH5zo