Oracle Analytics Cloud (OAC) Migration Consultant

JOB DESCRIPTION:

This position will be responsible for the migration of the agency''s existing Oracle Business Intelligence Enterprise Edition (OBIEE) environment to Oracle Analytics Cloud (OAC). The intent is to ensure a complete, secure, and supportable migration while enabling knowledge transfer to DOIT staff. Candidates must have experience aligning with the responsibilities detailed in the job description below, as well as providing the types of relevant deliverables listed as well. Do not submit a candidate unless they have served as a specialist in an OBIEE to OAC migration, meeting the skills/requirements listed. 

Overview:

Responsibilities/Expectations Include: 

Discovery & Assessment

• Evaluate the current OBIEE environment, including:
• Architecture, version, and topology
• RPDs, subject areas, and metadata
• Catalog content (dashboards, analyses, agents)
• Customizations (JavaScript, skins, ActionFramework)
• BI Publisher reports (if applicable)
• Assess usage, performance metrics, and user activity
• Identify external dependencies and integrations(data sources, schedulers, APIs)
• Identify unsupported, deprecated, or low-usage content

Deliverables

• OBIEE Assessment Report
• Content Inventory and Usage Analysis
• Migration Readiness and Risk Assessment

Security & Identity Management

• Document current OBIEE security model:
• Users, groups, application roles, and policies
• Data-level(row-level) security rules
• Design and implement OAC security model
• Integrate OAC with Azure Entra ID for authentication
• Map OBIEE application roles to OAC roles
• Validate data access and role-based security post-migration

Deliverables

• Security Mapping Document (OBIEE → OAC)
• Entra ID Integration Configuration
• Security Validation Results

Functional Gap Analysis

• Compare OBIEE functionality with OAC capabilities
• Identify gaps, limitations, or redesign requirements, including:
• OBIEE Answers vs OAC Data Visualization
• Agents vs OAC scheduling
• Write-back functionality
• BI Publisher and pixel-perfect reporting
• Custom JavaScript compatibility
• Recommend mitigation or redesign strategies using OAC-native features

Deliverables

• Functional Gap Analysis Report
• Recommended Remediation or Redesign Plan

Migration Strategy & Planning

• Define migration approach (phased vs big-bang)
• Develop a detailed migration plan including:
• Timelines and milestones
• Resource assignments
• Cutover and rollback strategy
• Parallel run (if required)
• Validate user access to dashboards, analyses, and data

Deliverables

• Migration Plan and Schedule
• Cutover and Rollback Plan

OAC & OCI Environment Setup

• Provision OAC environments (Dev/Test/Prod)
• Configure OCI components and networking
• Configure security, roles, and access controls
• Validate connectivity to on-premises and cloud data sources

Deliverables

• OAC Environment Configuration Documentation
• Connectivity and Access Validation Report

Backup & Risk Management

• Perform full backups of OBIEE RPDs and Catalogs
• Validate backup completeness
• Establish version control for migrated artifacts

Deliverables

• Backup Validation Report
• Version Control Strategy

Data & Metadata Migration

• Clean and prepare metadata for migration
• Migrate RPDs to OAC and convert metadata as required
• Validate:
• Subject areas
• Logical table sources
• Aggregations and hierarchies
• Session variables and initialization blocks
• Migrate OBIEE Catalog to OAC

Deliverables

• Migrated and Validated RPD
• Migrated OAC Catalog
• Metadata Validation Results

Connectivity & Integrations

• Configure and validate OAC data connections
• Implement on-premises data gateway if required
• Configure caching and refresh strategies
• Validate credential management

Deliverables

• Data Source Connectivity Configuration
• Refresh and Caching Strategy Document

Customizations & Extensions

• Identify custom scripts and extensions
• Migrate supported customizations
• Redesign or replace unsupported functionality using OAC-native features

Deliverables

• Customization Compatibility Assessment
• Redesigned Solutions Documentation

Testing & Validation

• Perform functional testing of reports and dashboards
• Validate data accuracy against OBIEE
• Support User Acceptance Testing (UAT)
• Conduct performance testing and benchmarking

Deliverables

• Test Plans and Test Results
• UAT Sign-Off Documentation

Go-Live & Post-Go-Live Support

• Promote OAC environment to production
• Support go-live activities
• Provide hypercare support
• Monitor performance, usage, and errors

Deliverables

• Production Go-Live Checklist
• Hypercare Support Plan

Knowledge Transfer & Documentation

• Deliver comprehensive technical documentation, including:
• As-is and To-be architectures
• Security and role management
• OAC administration and operations
• Conduct knowledge transfer sessions for DOIT staff

Deliverables

• Complete Technical Documentation Set
• Knowledge Transfer Sessions and Recordings
  
  

  Skill	Required / Desired	Amount	of Experience

  OBIEE to OAC migration experience, specifically

  Required

  Experience providing the types of deliverables noted in the job description as related to an OBIEE to OAC migration

  Required

  OBIEE administration and development experience (RPD, Catalog, Security)

  Required

  6

  Years

  Oracle Analytics Cloud (OAC) architecture and administration experience

  Required

  6

  Years

  Oracle Cloud Infrastructure (OCI) experience

  Required

  6

  Years

  Identity and Access Management (IAM), including Azure Entra ID integration experience

  Required

  6

  Years

  SQL and data modeling experience

  Required

  6

  Years

  BI migration tools and automation experience

  Required

  6

  Years

  Performance tuning and troubleshooting experience

  Required

  6

  Years

  Documentation and knowledge transfer experience

  Required

  6

  Years