OBIEE to OAC Migration Specialist

Job Title: OBIEE to OAC Migration Specialist
Job
-00955
Location:
Remote
Duration: 06 months of contract

This position will be responsible for the Migration of our OnPrem OBIEE application to the cloud based OAC product.

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 client 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:

• The applicant must demonstrate hands-on experience in the following areas:
• OBIEE administration and development (RPD, Catalog, Security)
• Oracle Analytics Cloud (OAC) architecture and administration
• Oracle Cloud Infrastructure (OCI)
• Identity and Access Management (IAM), including Azure Entra n
• SQL and data modeling
• BI migration tools and automation
• Performance tuning and troubleshooting
• Documentation and knowledge transfer

• Evaluate the current OBIEE environment, including:
• Architecture, version, and topology
• RPDs, subject areas, and metadata
• Catalog content (dashboards, analyses, agents)
• Customizations (JavaScript, skins, Action Framework)
• 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

• OBIEE Assessment Report
• Content Inventory and Usage Analysis
• Migration Readiness and Risk Assessment
• Security & Identity Management

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

• Security Mapping Document (OBIEE → OAC)
• Entra n Configuration
• Security Validation Results
• Functional Gap Analysis
• Compare OBIEE functionality with OAC capabilities

• 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

• Functional Gap Analysis Report
• Recommended Remediation or Redesign Plan
• Migration Strategy & Planning
• Define migration approach (phased vs big-bang)

• Timelines and milestones
• Resource assignments
• Cutover and rollback strategy
• Parallel run (if required)
• Validate user access to dashboards, analyses, and data

• Migration Plan and Schedule
• Cutover and Rollback Plan

• 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

• OAC Environment Configuration Documentation
• Connectivity and Access Validation Report

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

• Backup Validation Report
• Version Control Strategy

• 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

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

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

• Data Source Connectivity Configuration
• Refresh and Caching Strategy Document

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

• Customization Compatibility Assessment
• Redesigned Solutions Documentation

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

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

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

• Production Go-Live Checklist
• Hypercare Support Plan

• Deliver…