Oracle Technical Consultant (EBS - HRMS & ApeX)

The Oracle Technical Consultant develops complex integrations and automations, including REST APIs and application security measures. Looking for the candidate having Bachelor's or Master's Degree in Computer Science, Software Engineering, Information Technology, or a related field, preferably with exposure to ERP systems, enterprise software, and application development, along with 4-6 years of relevant experience in Oracle EBS Technical Development and/or Oracle APEX Application Development, with strong hands-on expertise in SQL, PL/SQL, reporting technologies, integrations, and enterprise applications. Candidate will support application deployment, testing, and operational activities while coordinating with database administrators, infrastructure, and support teams. The role requires a deep understanding of Oracle EBS modules, especially Core HR, Payroll, and General Ledger, coupled with expertise in Oracle development tools and reporting technologies. This position demands a proactive approach in troubleshooting and optimizing solutions while adopting innovative AI-enabled features to improve business process automation. Candidates should have significant experience in Oracle technical architecture and demonstrate competence in advanced database and front-end web technologies.

Responsibilities

Design, develop, and maintain custom reports using BI Publisher, XML Publisher, RDF, and Oracle reporting tools.
Develop complex PL/SQL packages, procedures, functions, triggers, and other database objects.
Build and enhance enterprise applications leveraging Oracle APEX, PL/SQL, JavaScript, HTML5, and CSS3 technologies.
Create interactive dashboards, reports, forms, interactive grids, charts, and customized user interfaces.
Collaborate with functional teams to accurately convert business requirements into detailed technical specifications and develop corresponding application solutions.
Develop and consume RESTful APIs, JSON integrations, and Oracle REST Data Services (ORDS) for seamless application communication.
Implement and support Oracle Workflow solutions and integrate various enterprise applications and services.
Provide ongoing Oracle EBS technical support including customization and report development to meet business needs.
Ensure adherence to Oracle development standards, code quality practices, security protocols, and performance optimization techniques.
Optimize SQL queries, PL/SQL code, reports, and application performance to meet SLAs and business expectations.
Coordinate and cooperate with Database Administrators, Infrastructure, and Support teams for deployment, testing, and production support activities.
Proactively troubleshoot and resolve application, integration, and production environment issues efficiently.
Implement advanced AI-enabled features within Oracle APEX applications, including AI agents and AI tools.
Leverage modern AI technologies such as Generative AI, RAG, Vector Search, and AI-assisted development methods to drive innovation.
Support data migration, release management, and post-production operational activities to ensure smooth business function continuity.
Document technical designs, development processes, and change management procedures comprehensively.
Stay abreast of emerging technologies and apply knowledge to enhance enterprise solutions and development frameworks.

Skills

Enterprise Integrations PL/SQL XML Publisher BI Publisher SQL Release Deployment Business Process Automation AI-enabled Application Development ABP Framework .NET ASP.NET Core EBS Data Migration And Conversion Cloud-based Application Development Change Management Technical Documentation AI-Assisted Application Development Vector Search RAG Ai Tools AI Agents Generative AI AJAX Callback Processes ords Enterprise Application Development Financial Integrations General Ledger Payroll Core Hr Oracle EBS R12.x Technical Architecture API-based Architectures Database Performance Tuning and Optimization Authentication Application Security Oracle Apex Development JSON integration Rest APIs APEX Dynamic Actions CSS3 HTML5 JavaScript Oracle Workflow Oracle Developer Suite 10g Oracle E-Business Suite HRMS RDF Reports

Job Details

Total Positions:

1 Post

Job Type:

Full Time/Permanent

Job Location:

Faisalabad, Pakistan

Gender:

No Preference

Minimum Experience:

4 Years

Apply Before:

Oct 24, 2026

Posting Date:

Oct 16, 2026

Octans Digital

· 101-200 employees - Faisalabad

Interloop Holdings (Pvt.) Limited is an investment holding company having diversified businesses including Dairies, Dairy Products, Packaging, Logistics and Health Services. The principle business activity of the Company is to invest, acquire, sell and hold stocks, shares, securities and any other form of investment of its subsidiaries.