Oracle Cloud Technical Consultant, Principal

<h3>Company Description</h3><p>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. </p><p> We’re an award-winning employer reflecting how our employees are at the very heart of  what we do: </p><ul><li>UK &amp; Ireland's premier AWS, Microsoft &amp; Oracle partner </li><li>3300+ strong, €350/£300m revenue business </li><li>10+ years as a Great Place to Work in Ireland &amp; UK </li><li>Best Workplace for Women in the UK &amp; Ireland by GPTW </li><li>Best Workplace for Wellbeing in the UK by GPTW </li></ul><p>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!. </p><h3>Job Description</h3><p><strong>Role Overview</strong></p><p>We are seeking an experienced Technical Lead to lead the design, development, and delivery of a strategic Oracle APEX-based solution supporting Procurement, Finance, and FP&amp;A business functions. The solution leverages Oracle APEX, Oracle Autonomous Data Warehouse (ADW), and Oracle Fusion REST APIs to automate PO review, accrual management, audit compliance, and workflow automation. The Technical Lead will own architecture, technical governance, integration strategy, security design, and delivery oversight.</p><p><strong>Key Responsibilities</strong></p><p><strong>Technical Leadership</strong></p><ul><li>Lead end-to-end architecture and solution design.</li><li>Define application, integration, database, and security architecture.</li><li>Provide technical guidance to APEX developers and integration consultants.</li><li>Establish development standards, code review processes, and deployment practices.</li><li>Conduct architecture and design workshops with business stakeholders.</li></ul><p><strong>Oracle APEX Solution Design</strong></p><ul><li>Design enterprise-grade Oracle APEX applications.</li><li>Define role-based dashboards, reporting, workflow, and approval frameworks.</li><li>Design reusable components and development standards.</li><li>Drive performance optimization and scalability initiatives.</li></ul><p><strong>Oracle Fusion Integration</strong></p><ul><li>Lead Oracle Fusion REST API integration strategy.</li><li>Design secure integration patterns between Oracle Fusion and APEX.</li><li>Oversee API authentication, error handling, monitoring, and exception management.</li><li>Ensure seamless integration with Procurement, AP, Finance, and related modules.</li></ul><p><strong>Database &amp; Data Architecture</strong></p><ul><li>Design ADW data models and reporting structures.</li><li>Define audit trail framework and historical data retention strategy.</li><li>Implement performance tuning and data optimization measures.</li><li>Ensure data security and regulatory compliance.</li></ul><p><strong>Governance &amp; Compliance</strong></p><ul><li>Ensure SOX-compliant design and auditability.</li><li>Implement Segregation of Duties (SoD) controls.</li><li>Design immutable audit trails and controlled access models.</li><li>Support internal audit reviews and compliance assessments.</li></ul><p><strong>Delivery &amp; Stakeholder Management</strong></p><ul><li>Collaborate with Project Managers, Functional Consultants, and Business SMEs.</li><li>Participate in requirement workshops, design reviews, SIT, UAT, and go-live activities.</li><li>Manage technical risks, issues, and dependencies.</li><li>Provide executive-level technical updates and recommendation papers.</li></ul><h3>Qualifications</h3><p><strong>Required Skills</strong></p><p><strong>Technical Skills</strong></p><ul><li>Oracle APEX (Version 21.x and above preferred)</li><li>Oracle Database / PL/SQL</li><li>Oracle Autonomous Data Warehouse (ADW)</li><li>Oracle Fusion Cloud ERP</li><li>Oracle Fusion REST APIs</li><li>SQL Performance Tuning</li><li>Oracle Cloud Infrastructure (OCI)</li><li>Web Services (REST/JSON)</li><li>Git / Source Control</li><li>Application Security &amp; RBAC</li></ul><p><strong>Functional Knowledge</strong></p><ul><li>Procurement</li><li>Purchase Orders</li><li>Accrual Processes</li><li>AP &amp; Financial Close</li><li>Approval Workflows</li><li>Audit &amp; Compliance Controls</li></ul><p><strong>Preferred Qualifications</strong></p><ul><li>Oracle APEX Developer Professional Certification</li><li>Oracle Cloud Certifications</li><li>TOGAF or equivalent Architecture Certification</li><li>Experience in regulated industries (Life Sciences, Healthcare, Financial Services)</li></ul><p><strong>Nice to Have</strong></p><ul><li>Oracle Integration