OCI / Database Architect - Integrations

40 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Summary

As a Principal OCI Solution Architect, you will lead the architecture, design, and implementation of enterprise-grade integration and database solutions, with a primary focus on Oracle Cloud Infrastructure (OCI), Oracle Database (PL/SQL). You will design scalable, secure, and high-performing architectures that seamlessly connect cloud and on-premises systems, leveraging API-led, SOA, and event-driven integrations.This role requires deep technical expertise in PL/SQL development, database performance optimization, and Oracle Supply Chain Management (SCM) processes. You will act as a technical leader, driving best practices in integration and database architecture within a hybrid cloud environment.Key ResponsibilitiesLead Architecture & Design: Define and implement end-to-end integration and database architectures using OCI, and Oracle Database for both cloud and on-premises applications.Database Excellence: Design, develop, and optimize PL/SQL packages, procedures, and workflows to support high-performance data processing and complex business logic.Performance & Tuning: Conduct proactive database performance tuning, query optimization, and capacity planning to ensure system scalability and reliability.SCM Enablement: Collaborate with functional teams to design and implement integration solutions for Oracle SCM modules, ensuring data consistency and business alignment.Security & Compliance: Apply best practices for database and integration security, authentication, and encryption in compliance with enterprise standards.Problem Solving: Troubleshoot and resolve complex integration and database issues across OCI, OIC, and on-prem environments.Technical Leadership: Provide mentoring and technical direction to developers and integration teams, fostering a culture of architectural excellence.Continuous Improvement: Identify and implement opportunities for automation, efficiency, and innovation in integration and database processes.Documentation: Maintain clear and detailed architectural diagrams, technical documentation, and design standards.

Responsibilities

Qualifications & Skills Mandatory:Strong hands-on expertise with Oracle Database (DBA), Oracle Cloud Infrastructure (OCI), and PL/SQL, including developing optimized queries, stored procedures, triggers, and performance-tuned database code.Deep understanding of RESTful and SOAP-based web services, including design, implementation, and governance.Familiarity with SaaS and on-premises enterprise applications and their integration architectures.Strong grasp of integration design patterns, error handling, and security best practices (authentication, authorization, and encryption).Advanced analytical, troubleshooting, and debugging skills across integration and database layers.Excellent collaboration and communication skills with the ability to work effectively in cross-functional, fast-paced environments.Good-to-Have:Knowledge of Oracle Supply Chain Management (SCM) processes, data flows, and related integrations.Knowledge of OIC or other integrationsExperience with Oracle ERP Cloud or other large-scale enterprise applications.Exposure to VBCS for custom extensions and API management tools (e.g., Oracle API Gateway, Apigee).Certification(s) in OCI, OIC, or Oracle Database Administration will be an advantage.Self-Assessment QuestionsDo I have hands-on experience with Oracle Database Administration , OCI, and PL/SQL?Can I efficiently develop, optimize, and troubleshoot complex PL/SQL and database workflows?Do I have a solid understanding of integration patterns, error handling, and security best practices?Can I clearly communicate technical concepts and collaborate effectively within a fast-paced, dynamic environment?

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Oracle logo
Oracle

Information Technology

Redwood City

RecommendedJobs for You