The Oracle Technical Consultant APEX designs and develops Oracle EBS and APEX applications, ensuring compliance with standards and supporting integrations and troubleshooting efforts.
Job Title: Oracle Technical Consultant APEX
Location: USA
Full Time
Position Summary
The Oracle Technical Consultant – EBS & APEX is responsible for the design, development, support, and enhancement of Oracle E-Business Suite (EBS) technical solutions and Oracle APEX applications. This role supports ongoing business operations, system improvements, integrations, reporting, and technical development within an Oracle EBS and Oracle Fusion
The ideal candidate will have strong Oracle technical development experience, including SQL, PL/SQL, EBS technical components, and APEX application development, with the ability to deliver scalable, secure, and supportable solutions.
Essential Duties and Responsibilities
- Design, develop, test, implement, and support Oracle E-Business Suite technical solutions
- Develop and maintain SQL, PL/SQL packages, procedures, functions, triggers, and related database objects
- Build and support interfaces, conversions, integrations, and custom technical solutions within Oracle EBS
- Develop and maintain BI Publisher / XML Publisher reports and concurrent programs
- Develop and support Oracle APEX applications, including workflow solutions, self-service tools, dashboards, and reporting applications
- Integrate APEX applications with Oracle EBS data, security, and related technical components
- Ensure all customizations and technical solutions comply with Oracle EBS standards and online patching requirements
- Troubleshoot and resolve technical issues in EBS and APEX environments
- Collaborate with functional teams, business users, and technical teams to define and deliver solutions
- Support patching, deployments, migrations, and release activities
- Prepare and maintain technical documentation
Required Qualifications
- 5+ years of Oracle applications technical experience
- Strong hands-on experience with Oracle E-Business Suite (EBS)
- Strong hands-on experience with Oracle APEX development
- Strong proficiency in SQL and PL/SQL
- Experience with BI Publisher / XML Publisher
- Experience with interfaces, conversions, integrations, and technical troubleshooting
- Experience working in an Oracle EBS and Oracle Fusion environment
- Experience supporting or developing within Oracle EBS online patching requirements
Preferred Qualifications
- Experience with Oracle REST Data Services (ORDS)
- Experience with REST APIs, JSON, web services, or related integrations
- Experience with OA Framework (OAF)
- Experience with Oracle Forms and legacy Oracle reporting tools
- Experience with Oracle Database 19c or higher
- Experience supporting enterprise application modernization efforts using Oracle APEX
Education and Experience
- Bachelor’s degree in computer science, Information Systems, or related field preferred
- Equivalent combination of education and relevant work experience may be considered
Technical Skills
- Oracle E-Business Suite (EBS) technical development
- Oracle APEX
- SQL / PL/SQL
- BI Publisher / XML Publisher
- Interfaces, conversions, and integrations
- Oracle Cloud (Fusion)
- Online patching / adop
- ORDS, REST APIs, JSON, web services
About UsDatavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. About the Team
The Enterprise Applications Cloud ERP practice specializes on Oracle technology and supports our client’s full-life cycle needs for both on-prem and cloud products. The practice itself is 100+ FTEs strong located in the US, Colombia, and India and is the fastest growing practice in Datavail.
The right person will exemplify Datavail’s core values (Desire to service, Low Ego, Hard Work). So if you are looking for a company that loves it clients just as much we love our team then this is the right place for you.
Top Skills
Bi Publisher
JSON
Oracle Apex
Oracle Database 19C
Oracle E-Business Suite
Oracle Rest Data Services
Pl/Sql
Rest Apis
SQL
Web Services
Xml Publisher
Datavail Broomfield, Colorado, USA Office
11800 Ridge Parkway, Suite 125, Broomfield, CO, United States, 80021
Similar Jobs
4 Hours Ago
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Lead technology strategy and delivery for Clinical platforms, promote AI adoption, deliver engineering excellence, foster team development, and engage stakeholders.
Top Skills:
AgileAIAzure CloudDevsecopsGenaiPega
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
The role involves expertise in asset discovery using ARMIS, applying networking knowledge to enhance data visibility and accuracy, and collaborating across teams to ensure effective asset management. Responsibilities include managing asset intelligence data quality, documenting findings, and supporting risk management initiatives.
Top Skills:
Armis
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
The HSS Manager leads a team of care managers, manages clinical operations, ensures compliance, and drives process improvements for Home and Community Based Services.
Top Skills:
Microsoft Word
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
