Oracle Cloud Data Architect

About this role

Role Overview:

• Seeking a highly skilled and experienced Oracle Cloud Data Architect / Engineer with deep expertise in SQL‑based data architecture and enterprise reporting platforms.

• The role will be part of a team supporting a major insurance client, responsible for designing, developing, and maintaining scalable Oracle Cloud (OCI) data architecture and database solutions for analytics and reporting environments.

• Play a critical role in architecting cloud‑based data platforms, optimizing database performance, and ensuring reliability, security, and scalability of reporting systems.

• Collaborate within an agile, cross‑functional team comprising diverse technical backgrounds to solve complex data and cloud architecture challenges across Oracle Cloud and integrated platforms.

• Actively participate in architecture discussions, design reviews, and brainstorming sessions, driving continuous improvement initiatives from concept through implementation.

• Required to navigate ambiguous requirements and translate business needs into robust technical data models and cloud solutions.

• Ideal candidate will have 8+ years of overall IT experience, including 5+ years in a Data Architect or Senior Data Engineering role with strong SQL expertise; experience in the life insurance domain is preferred but not mandatory.

Key Responsibilities & Skillsets:

•
Common Skillsets:

• Superior analytical and problem-solving skills.

• Should be able to work on a problem independently and prepare client ready deliverable with minimal or no supervision.

• Excellent communication skill for client interaction

•
Application development Skillsets:

• Proven experience designing cloud‑native and hybrid data architectures.

• Understanding of security, access controls, encryption, and compliance in cloud environments.

• Ability to handle ambiguous requirements and drive architectural clarity.

• Strong computer science fundamentals such as algorithms, data structures, multithreading, object-oriented development, distributed applications, client-server architecture

• Strong expertise in SQL (advanced joins, window functions, performance tuning).

• Hands on experience with Oracle Databases (Autonomous DB, Oracle 19c/21c preferred).

• Solid knowledge of Oracle Cloud Infrastructure (OCI) components including:

• OCI Object Storage

• Networking and IAM

• Compute and Database services

• Experience designing enterprise data models (dimensional, relational, reporting focused).

• Familiarity with ETL / data integration tools and batch data pipelines.

• Strong understanding of data migration, reconciliation, and validation strategies.

• Experience supporting reporting and analytics platforms (BI tools, data marts).

• Experience in web services, streaming and messaging technologies is a plus.

• Proven ability to optimize database performance through query tuning, indexing and stored procedure optimization.

• Strong leadership and mentoring skills, with the ability to guide and inspire a team.

• Experience with collaborating with cross-functional teams and managing client and stakeholder expectations.

• Demonstrated experience with data governance, data security and privacy regulations.

Candidate Profile:

• Bachelor's/master's degree in computer science/engineering, operations research, or related analytics areas welcome to apply.

• 10+ years' of IT experience with expertise in Oracle and Oracle Cloud based architectures, preferably in Life Insurance but not mandatory

• Capability of designing complex data architecture solutions

• Team Management

• Superior analytical and problem-solving skills.

• Outstanding written and verbal communication skills

• Able to work in a fast paced and continuously evolving environment with the ability to take-up challenging tasks.

• Can understand cross cultural differences and can collaborate with clients across the globe.

Originally posted on Himalayas