Oracle SaaS & Oracle Integration Cloud (OIC) Administrator

Stony Brook Eastern Long Island Hospital; Stony Brook (NY); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Hybrid telecommuting: up to 5 remote/5

Job summary

Stony Brook University seeks an Oracle SaaS & Oracle Integration Cloud (OIC) Administrator to manage SaaS Fusion environments across HCM, ERP, EDM, EPM, and OIC. This role ensures boundary system integrations, certificates, and keys are maintained throughout the lifecycle.

The position involves implementing security, file transfer automation, and collaboration with Database Administrators and Security teams to support enterprise platforms.

Qualifications

• Bachelor’s degree (or foreign equivalent) with 7 years of relevant experience.
• Experience with ERP systems and Oracle Fusion Administration.
• Experience with Oracle Integration Cloud (OIC) and Oracle cloud architecture.

Responsibilities

• Support SaaS Fusion environments for multiple Oracle products and manage lifecycle of environments, keys, and certificates.
• Provide Secure File Transfer Protocol guidance and automate file transfers using scripts and tooling.
• Manage SSH keys, access permissions, and vault integration for boundary systems.
• Coordinate environment provisioning, EDM/EPM governance, and data integration across platforms.
• Engage with vendor support and user communities to resolve issues.

Skills

ERP systems

Oracle Fusion

Oracle Integration Cloud

Scripting

Linux/Windows admin

Vendor support engagement

Security principles

Education

Bachelor’s degree

Tools

Oracle Fusion Admin

Oracle Integration Cloud (OIC)

Oracle Visual Builder Cloud Service

Job description

Job Description - Oracle SaaS & Oracle Integration Cloud (OIC) Administrator (2603429)

Required Qualifications: (as evidenced by an attached resume) Bachelor’s degree (or foreign equivalent). In lieu of a degree, a combination of education and full-time relevant experience totaling seven [7] years may be considered. Three (3) years of full-time experience working with an application requiring technical knowledge of Enterprise Resource Planning (ERP) systems. Experience with Oracle Fusion Administration, Oracle Integration Cloud Maintenance or an Oracle Certification. Experience with Oracle cloud architecture, cloud integration, or an Oracle Integration Cloud certificate. Experience managing ERP systems in Linux/Windows environments. Experience with software development or scripting.

Preferred Qualifications: Advanced degree. Additional years of experience working with an application requiring technical knowledge of Enterprise Resource Planning (ERP) systems. Certification in cloud platforms. ERP Administration experience (upgrading, installing, configuring, securing, monitoring, performance tuning, and troubleshooting ERP systems). Experience configuring web applications (including HTTP and log analysis). Experience optimizing Oracle SQL queries. Experience with networking and security principles. Experience engaging with vendor support and user communities. Brief Description of Duties: The Oracle SaaS & Oracle Integration Cloud (OIC) Administrator supports Enterprise Platforms by managing SaaS Fusion Application environments for HCM, ERP, Fusion Data Intelligence (FDI), Oracle Enterprise Data Management (EDM), Enterprise Performance Management (EPM), and Oracle Integration Cloud (OIC). This role is critical in implementing and maintaining various boundary system integrations and managing the lifecycle of environments, keys, and certificates.

Developer Support & File Transfer Automation:

• Secure File Transfer Protocols: Provide technical guidance to developers on Secure File Transfer Protocols (SFTP) and PGP encryption/decryption. Implement file transfer/management platform.
• Tooling & Scripting: Write custom shell scripts to automate file transmission, retrieval, encryption, and decryption. Assist developers with WinSCP configuration and troubleshooting.
• SSH & Folder Permissions: Manage SSH key uploads to OIC SFTP servers for shared boundary system accounts and configure folder-level access permissions.

Support departmental goals, applications and team collaboration:

• Support Departmental Goals: Tackle ad-hoc projects and diverse technical tasks that align with team objectives and your role's scope.
• Maintain Secondary Applications: Assist with upgrading, installing, configuring, and administering additional software applications as needed.
• Collaborate Across Teams: Partner closely with Database Administrators, Application Security, Information Security, Systems, Network, and Development teams to ensure seamless system implementation.
• Fusion Environment Management: Coordinate and execute environment provisioning activities, including creation, deletion, and refresh operations.
• Fusion Data Intelligence (FDI) Administration: Provision and configure FDI instances, including JSON Web Tokens (JWT) key generation, upload, and lifecycle management.
• Enterprise Data Management (EDM) & Enterprise Performance Management (EPM) Governance: Administer master data, financial planning systems, and analytical applications. Maintain structural consistency across disparate systems, manage reporting logic and data integrations, and control end-user access to support budgeting, forecasting, and consolidations.

Security, Keys & Certificate Management:

• Identity & Access Management: Create and configure confidential applications for boundary systems. Set up Open Authorization authentication, assign users/roles, and partner with functional teams and vendors to troubleshoot access issues.
• Certificate & Key Lifecycle Management: Generate, distribute, and upload Pretty Good Privacy (PGP) keys. Manage certificate signing requests (CSRs) for boundary systems. Securely store and upload certificates and JWT keys across Oracle Visual Builder Cloud Service, API gateways, and external developer portals.
• Vault Management: Implement Vault to securely store keys and certificates. Integrate Vault with OIC to automate the creation, rotation, and distribution of certificates, keys, and secrets across all integration endpoints.
• API Gateway Deployment: Deploy and configure API gateways for various boundary systems, including certificate generation and CA bundle uploads.

Integration & Connectivity Support:

• Integration Account Management (AIM): Manage service accounts, roles, IAM policies, and passwords for OIC. Ensure all integration connectors use service accounts rather than individual credentials.
• Object Storage Management: Request Oracle Object Storage bucket and service user creations, establish application-specific directory structures, and troubleshoot connectivity issues.
• External Integration: Partner with JPMorgan Chase (JPMC) to streamline the certificate upload and renewal process for JPMC Concourse using their developer portal.

Other duties or projects as assigned as appropriate to rank and departmental mission.

Special Notes: This is a full-time appointment. FLSA Exempt position, not eligible for the overtime provisions of the FLSA. Minimum salary threshold must be met to maintain FLSA exemption.

SUNY implemented a hybrid telecommuting pilot program. This position has been approved to participate in the pilot, which allows for up to 5 remote days per pay period.

Stony Brook University is committed to excellence in diversity and the creation of an inclusive learning, and working environment. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, pregnancy, familial status, sexual orientation, gender identity or expression, age, disability, genetic information, veteran status and all other protected classes under federal or state laws.

If you need a disability-related accommodation, please call the university Office of Equity and Access (OEA) at [phone] or visit OEA .

In accordance with the Title II Crime Awareness and Security Act a copy of our crime statistics can be viewed here. Visit our WHY WORK HERE page to learn about the total rewards we offer.

Job Number:

2603429

Official Job Title: Lead Programmer/Analyst

Job Field

Information Technology

Primary Location

Department/Hiring Area: Division of Information Technology - Enterprise Applications and Integrations