Oracle Fusion Cloud APEX Developer; Prin Applications Analyst

Overview

Mission Support and Test Services, LLC (MSTS) manages and operates the Nevada National Security Site (NNSS) for the U.S. National Nuclear Security Administration (NNSA). Our mission is to help ensure the security of the United States and its allies by providing high-hazard experimentation and incident response capabilities through operations, engineering, education, field, and integration services, and by acting as environmental stewards to the Site's Cold War legacy.

Our vision is to be the user site of choice for large-scale, high-hazard, national security experimentation, with premier facilities and capabilities below ground, on the ground, and in the air. Our 2,750+ professionals are called upon to innovate, collaborate, and deliver on difficult nuclear security challenges facing the world today.

• Utilize Oracle Integration Cloud (OIC) or other middleware platforms to orchestrate complex data flows, leverage Fusion APIs, and manage connections securely.
• Expose APEX application data securely as REST services for consumption by other enterprise systems.
• Lead the full software development lifecycle (SDLC) for custom Oracle APEX applications, from requirements gathering and design to deployment and ongoing support.
• Design, develop, and consume RESTful web services for real-time data exchange between custom APEX applications and Oracle Fusion Cloud ERP/HCM.
• Utilize REST APIs and SOAP web services provided by Oracle Fusion for real-time data exchange.
• Expose APEX application data securely as REST services for consumption by other enterprise systems.
• Design, build, and manage integrations between custom APEX solutions and Oracle Fusion Cloud ERP/HCM using various methods, including interfacing with BI Publisher reports or services.
• Implement and manage secure authentication and authorization mechanisms for APEX applications using OCI Identity and Access Management (IAM).
• Configure SSO between APEX applications, OCI services, and Fusion Cloud Applications (ERP/HCM) using protocols such as SAML 2.0 or OIDC.
• Ensure robust security measures within APEX applications, including user authentication, authorization schemes, and compliance with OCI security best practices.
• Implement robust security measures within APEX applications, manage user authentication/authorization, and ensure data security in line with corporate standards and Fusion security models.
• Collaborate with functional consultants, business analysts (Finance, HR, Supply Chain), and IT stakeholders to understand requirements and deliver technical solutions.
• Create comprehensive technical documentation, including design specifications, integration maps, and test scripts (unit, system, UAT support).
• Ensure high performance and responsiveness of APEX applications and integrated services.

• Due to the nature of our work, US Citizenship is required for all positions.
• Bachelor's degree in a computer-related field or equivalent experience with at least 8 years of relevant, progressively responsible experience.
• Minimum of 10-12 years of dedicated experience as an Oracle APEX Developer, with at least 3-4 years specifically with Cloud ADBs preferred.
• Proven experience integrating APEX applications with Oracle Fusion Cloud ERP/HCM using standard APIs and web services.
• Proven experience designing, implementing, and managing integrations using REST web services (both consuming external services and providing services from APEX).
• Experience working in a hybrid environment connecting custom applications to enterprise SaaS platforms.
• Hands-on experience implementing and managing Single Sign-On (SSO) and security configurations within OCI IAM and Oracle Fusion environments.
• REST Web Services & Integration:
  Expertise using Oracle Integration Cloud (OIC) or other middleware platforms to orchestrate complex data flows, leverage Fusion APIs, and manage connections securely.
• Oracle APEX mastery:
  Expert knowledge of APEX features, including Interactive Grids/Reports, Forms, Pages, authentication, authorization, and themes.
• Integration expertise:
  Strong understanding of integration protocols (REST, SOAP, XML, JSON). Experience with OIC is a…