OCI / Database Architect - Integrations
Oracle
Date: 2 days ago
City: Ahmedabad, Gujarat
Contract type: Full time
Job Summary
JOB DESCRIPTION
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 Responsibilities
Lead 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 integrations
Experience 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 Questions
Do 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 [email protected] 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.
JOB DESCRIPTION
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 Responsibilities
Lead 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 integrations
Experience 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 Questions
Do 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 [email protected] 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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Deputy Manager-EHS
Piramal Pharma Ltd,
Ahmedabad, Gujarat
2 weeks ago
Job Description Executing EHS related projects with planning, supervising & execution. Execution of short and long-term EHS objectives and goals with EHS improvement plan. Ensures, maintains all compliance of EHS. Implementing, and managing technical performance of EHS related activities. Conductingaudits, identification of corrective action, preventive action, and its closure. EHSrelatedpromotional activities like safety week, Environment Day & other campaign. PrepareEHS...
Launch Project Manager
Valeo,
Ahmedabad, Gujarat
2 weeks ago
MISSION To lead the industrialization of the new P1To improve the production efficiency (machine & Direct Labor) in its perimeterCapitalize and share the know-how of industrial processes in his domainTo participate on the design of new equipment and new linesTo lead Lean design workshopIndustrializationTo manage production equipment introduction using IPROM To follow equipment or assembly lines development with the supplierTo...
Area Manager - Equipment Finance
Bajaj Finserv,
Ahmedabad, Gujarat
2 weeks ago
Location Name: AhmedabadJob Purpose“This position is open with Bajaj Finance Ltd.”Duties And ResponsibilitiesTo achieve collection targets assigned to the territory by meeting collection target for the states or region assigned. Meeting the Target on Cost of Collections. Ensuring meeting PI Targets within cost limit specified. Ensuring legal guidelines are complied for entire collection structure in letter and sprits. Ensure that...
