OCI Architect - Integrations OIC SOA

Job Summary

JOB DESCRIPTION

As a Principal Integrations Solution Architect, you will lead the design and implementation of complex integration solutions with a strong focus on Oracle Database (DBA) and Oracle Cloud Infrastructure (OCI). Leveraging OCI, Oracle Integration Cloud (OIC), SOA, and API-based technologies, you will translate complex business requirements into scalable, secure, and high-performing architectures. Strong expertise in PL/SQL, database design, performance tuning, and Supply Chain Management (SCM) is required. This role is ideal for technical leaders passionate about cloud, database, and integration architecture excellence.

Key Responsibilities

Lead the architecture, design, and delivery of integration solutions with a strong focus on OCI and Oracle Database for cloud and on-premises systems.

Design, implement, and optimize PL/SQL and database workflows to ensure efficient, secure, and high-performing data processing.

Provide guidance on database architecture, performance tuning, and best practices for integration solutions.

Collaborate with business and technical stakeholders to define scalable integration strategies and architectures.

Implement and govern RESTful and SOAP-based services to connect applications.

Apply integration and database design patterns, error handling, and security best practices.

Troubleshoot, analyze, and resolve complex database and integration issues.

Provide technical leadership, mentoring, and guidance to development teams.

Identify opportunities for automation, efficiency, and continuous improvement in database and integration processes.

Responsibilities

Qualifications & Skills

Mandatory:

Strong hands-on experience with Oracle Database (DBA), OCI, and PL/SQL, including writing efficient queries, stored procedures, and performance-tuned database code.

Experience with Oracle Integration Cloud (OIC), SOA, VBCS, and API-based integration solutions.

Expertise in RESTful and SOAP-based web services.

Familiarity with SaaS and on-premises application software.

Solid understanding of integration design patterns, error handling, and security best practices.

Strong analytical, troubleshooting, and debugging skills.

Comfortable working in a collaborative, fast-paced environment.

Good-to-Have:

Knowledge of Supply Chain (SCM) processes or systems.

Experience With Oracle ERP Cloud Or Other Enterprise Applications.

Exposure to VBCS and advanced API management tools.

Self-Assessment Questions

Do I have hands-on experience with Oracle Database, OCI, and PL/SQL, as well as OIC, SOA, and API-based solutions?

Can I efficiently develop, optimize, and troubleshoot complex PL/SQL and database workflows?

Am I comfortable working with SaaS and on-premises environments, including RESTful and SOAP integrations?

Do I understand integration design patterns, error handling, and security best practices?

Can I effectively communicate technical concepts and collaborate in a fast-paced, dynamic team?

Qualifications

Career Level - IC4

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.