Leads design, development, testing, deployment, monitoring, and support of Oracle Cloud integrations using OIC across ERP, SCM, HCM, and third-party systems. Develops REST and SOAP APIs, real-time and batch integrations, SQL and PL/SQL solutions, and Oracle reports using OTBI and BI Publisher. Provides technical design, requirements analysis, application support, lifecycle maintenance, troubleshooting, and stakeholder collaboration.
The Department of Information Services at SUNY Downstate Health Sciences University is seeking a full-time Lead Programmer Analyst / Lead Oracle Developer.
The successful candidate will serve as a Lead Programmer Analyst for Oracle Cloud applications (ERP, SCM, HCM) in supporting and developing integrations between Oracle Cloud applications (ERP, SCM, HCM) and on-premise, third-party systems using Oracle Integration Cloud (OIC) and supports Oracle data and reports.
- Design and development of Oracle integrations on OIC using file based/REST/SOAP adapters.
- Develop and deliver Oracle Integration Cloud based integrations with Oracle SaaS and 3rd Party applications.
- Design and develop Webservices/APIs for cloud, on premises, and hybrid solutions using Oracle Integration Cloud (OIC).
- Design, develop, unit testing, performance tuning and implementation of real time and batch integration.
- Expertise in building, error handling, auditing, scheduling, deployment, monitoring/alert integrations in OIC/ICS, and support end to end testing of integrations.
- Thorough knowledge of Mapping, Lookups, Connections, XSLT, Agents, Packages, and other features of OIC.
- Conceptualize technical design options, identify the best option, and complete the technical design specifications.
- Design and build reports leveraging Oracle OTBI, BI Publisher, Tableau and Fusion Analytic Warehouse.
- In depth knowledge about Oracle Cloud ERP schema and writing SQL queries, Data Modeling and Data Engineering.
- Expertise in creating BI Publisher & OTBI reports and using the RTF templates
- Support day-to-day Oracle application operations, including help desk issues and end user support.
- Meets with stakeholders, documents requirements, user stories, and related artifacts to determine technical specifications
- Adheres to all security, change management and application management lifecycle policies
- Supports systems maintenance, upgrades, enhancements, and integrations with other major systems.
- Understands multiple application platforms and collaborates with other teams to maintain operations.
- Maintains a current knowledge of relevant technologies as assigned.
Required Qualifications
- Bachelor’s degree in computer science, or related field combined with at least five years’ experience in the Software field with experience designing, developing, and testing of software applications
- 3+ years of experience working with Oracle SaaS modules and hands-on development and administration experience with Oracle Integration Cloud (OIC)
- 3+ years of experience with REST API, SOAP, FBDI, PL/SQL, and the use of Oracle Cloud-delivered Web Services.
- 2+ years of experience with developing integration using Oracle OIC
- End-to-end Oracle Integration Cloud (OIC) implementation experience with at least 1 end-to-end Oracle SaaS/PaaS/IaaS implementation project
- Experienced with interfacing between Oracle Cloud or ERP and 3rd party systems
- Experienced working with Oracle Cloud Infrastructure (OCI)
- Experience with Python and C# programming languages and or mobile app development.
- Ability to leverage pre-built integrations, cloud adapters, connections, SaaS applications, etc. in the solution
- Hands-on development experience with Oracle Database Cloud services (DBCS) and Managed File Transfer (MFT)
- Experience with all phases of the software development lifecycle (requirement, design, development, testing, deployment, support).
- Strong analytical and communication skills.
- Or, an acceptable equivalent combination of education, experience and training to the above.
Preferred Qualifications
- Experienced with Oracle Cloud ERP, SCM and HCM.
- REST API and SOAP. Oracle OIC, OTBI Tableau and BI Publisher.
- Oracle PL/SQL and SQL Server Stored Procedures,
- SQL Server Integration Services (SSIS).
- Programming language Python and C#
- Experience with implementation of Artificial Intelligence (AI).
- Experienced in Hospital or healthcare environment.
Are you looking to take your career to new heights with a leader in healthcare? SUNY Downstate Health Sciences University is one of the nation's leading metropolitan medical centers. As the only academic medical center in Brooklyn, we serve a large population that is among the most diverse in the world. We are also highly-ranked by Castle Connolly Medical, a healthcare rating company for consumers, among the top 5 leading U.S. medical schools for training doctors.
About the Team Equal Employment Opportunity
SUNY Downstate Health Sciences University is an affirmative action, equal opportunity employer and does not discriminate on the basis of race, color, national origin, religion, creed, age, disability, sex, gender identity or expression, sexual orientation, familial status, pregnancy, predisposing genetic characteristics, military status, domestic violence victim status, criminal conviction, and all other protected classes under federal or state laws.
Women, minorities, veterans, individuals with disabilities and members of underrepresented groups are encouraged to apply.
If you are an individual with a disability and need a reasonable accommodation for any part of the application process, or in order to perform the essential functions of a position, please contact Human Resources at [email protected].
Similar Jobs
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Manage classified, air-gapped Windows and Linux systems in closed-area lab environments. Responsibilities include Active Directory, GPO, domain controller, VMware, Veeam, Trellix ePO, Nessus, Splunk, vulnerability remediation, data spill response, secure sanitization, STIG and RMF compliance, documentation, and audit readiness. The role is fully onsite, supports classified mission environments, and requires occasional after-hours or weekend maintenance and incident response.
Top Skills:
Active DirectoryDhcpDnsGroup Policy Objects (Gpos)Lab-In-A-Box (Lib)LinuxNessusNispomPowershellPythonRmfSplunkStigsTrellix EpoVeeamVmware VsphereWindows
Cloud • Information Technology • Security • Software • Cybersecurity
Own mid-market territory sales by acquiring new customers, expanding and renewing existing accounts, building partner relationships, developing pipeline, communicating Cloudflare’s value, forecasting revenue, negotiating contracts, and driving adoption. The role requires engaging technical and executive stakeholders across security, networking, development, and infrastructure teams while coordinating with internal cross-functional groups.
Top Skills:
Cloud InfrastructureCloud SecurityCloudflare OneConnectivity CloudGoogle SuiteMS OfficeSFDCTableau
Cloud • Information Technology • Security • Software • Cybersecurity
Leads technical go-to-market programs supporting Solutions Architects, Forward Deployed Engineers, Professional Services, and Developer GTM leadership. Designs repeatable playbooks, coordinates strategic customer initiatives and onsite visits, improves engagement prioritization and reporting, supports Professional Services packaging, and incubates new technical programs. The role requires strong program management, technical fluency, cross-functional influence, analytical skills, and experience with technical customer-facing teams.
Top Skills:
BigQueryBoostupProduct-Led GrowthSaaSSalesforce CRMTableau
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
