Oracle Cloud Security & Reporting Consultant

r3 Consultant; Maharashtra; Hybrid; INR 1,500,000 - 1,900,000; Full time

Job summary

r3 Consultant is seeking an experienced Oracle Cloud Security & Reporting Consultant to manage Oracle ERP and HCM Cloud security, RBAC implementation, user provisioning, and advanced reporting. The role requires hands-on security administration, data modeling, and collaboration with business users across enterprise systems.

The ideal candidate will have 5+ years of relevant experience, strong SQL skills, and a background in OTBI and BI Publisher reporting, with a hybrid/remote work model as per

Qualifications

• Hands-on experience in Oracle Cloud Security administration, RBAC and SoD.
• Experience in user provisioning, access reviews and data security policies.
• Proficiency in OTBI and BI Publisher reporting; strong SQL skills.
• Experience with Oracle Cloud data models and reporting across ERP/HCM.
• Excellent stakeholder management and communication abilities.

Responsibilities

• Configure, manage, and maintain Oracle ERP and HCM Cloud security.
• Implement RBAC, SoD and data security policies; perform provisioning and reviews.
• Create OTBI and BI Publisher reports; develop data models for reporting.
• Write complex SQL queries for reporting and data analysis.
• Collaborate with business users and technical teams; prepare security and design docs.

Skills

RBAC

User Provisioning

Access Management

Advanced SQL

Stakeholder Management

Analytical Thinking

Problem-Solving

Strong Communication

Hybrid/Remote Collaboration

Education

Bachelor's Degree in CS/IT/Engineering

Oracle Cloud Certification

Tools

OTBI

BI Publisher

Oracle ERP Cloud

Oracle HCM Cloud

OIC

REST APIs

SOAP APIs

HDL/HSDL

Oracle Security Console

IAM

Job description

Job Description - Oracle Cloud Security & Reporting Consultant

Job Title: Oracle Cloud Security & Reporting Consultant

Experience: 5+ Years

Location: Pune (Hybrid/Remote as per business requirement)

Employment Type: Contract (12 Months)

Notice Period: Immediate to 15 Days Preferred

Role Overview

We are seeking an experienced Oracle Cloud Security & Reporting Consultant to manage and support Oracle Cloud ERP and HCM security across enterprise applications. The ideal candidate should have hands-on experience in Oracle Cloud Security administration, role-based access control (RBAC), user provisioning, reporting using OTBI and BI Publisher, SQL, and Oracle Cloud data models. The consultant will be responsible for designing, implementing, and maintaining secure access controls while supporting reporting requirements across Oracle ERP and HCM Cloud.

Key Responsibilities

Oracle Cloud Security Administration

• Configure, manage, and maintain Oracle ERP and HCM Cloud security.
• Create and manage users, roles, privileges, and data security policies.
• Implement Role-Based Access Control (RBAC) and segregation of duties (SoD).
• Perform user provisioning, de-provisioning, and access reviews.
• Support security audits, compliance requirements, and governance activities.
• Troubleshoot and resolve Oracle Cloud security-related issues.

Oracle ERP & HCM Reporting

• Develop and maintain reports using Oracle Transactional Business Intelligence (OTBI).
• Create and maintain BI Publisher (BIP) reports.
• Develop reports across Oracle ERP Cloud and Oracle HCM Cloud modules.
• Build complex SQL queries for reporting and data analysis.
• Create and maintain data models for BI Publisher reporting.
• Validate report accuracy and optimize report performance.

Collaboration & Support

• Work closely with business users to understand security and reporting requirements.
• Coordinate with functional and technical teams during implementations and enhancements.
• Prepare technical documentation, security design documents, and user guides.
• Support production issues, security changes, and periodic access certifications.
• Participate in testing activities including SIT, UAT, and production deployment.

Mandatory Skills

• Oracle ERP Cloud Security Administration
• Oracle HCM Cloud Security Administration
• Role-Based Access Control (RBAC)
• User Provisioning & Access Management
• Oracle Transactional Business Intelligence (OTBI)
• BI Publisher (BIP)
• Oracle Cloud ERP Report Development
• Oracle Cloud HCM Report Development
• Advanced SQL
• Oracle Cloud Data Models
• Security Roles & PrivilegesData Security Policies
• Segregation of Duties (SoD)
• Oracle ERP Cloud
• Oracle HCM Cloud
• Stakeholder Management
• Strong Analytical & Problem-Solving Skills

Preferred Skills

• Oracle Security Console
• Oracle Identity & Access Management (IAM)
• Oracle Fast Formula
• Oracle Integration Cloud (OIC)
• REST & SOAP APIs
• HDL / HSDL
• Oracle Cloud Security Audit & Compliance
• Oracle Cloud Implementations
• Oracle Cloud Certification

Educational Qualification

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.
• Oracle Cloud Certification is an added advantage.

Experience Requirements

• Minimum 5+ years of experience as an Oracle ERP/HCM Security Administrator.
• Hands‑on experience with Oracle ERP Cloud and Oracle HCM Cloud Security.
• Experience developing reports using OTBI and BI Publisher.
• Strong SQL and Oracle Cloud Data Model knowledge.
• Experience in user access management, security configuration, and Oracle Cloud reporting.

Preferred Candidate Profile

• Immediate joiners or candidates with a notice period of up to 15 days.
• Strong communication and stakeholder management skills.
• Experience working in enterprise Oracle Cloud environments.
• Ability to work independently while collaborating with cross-functional teams.
• Willingness to work in a Hybrid/Remote model based on business requirements.