OBIEE to OAC Migration Specialist - Remote - Contract (Client in Concord, NH) - B4104B

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Technovision, Inc., is seeking the following. Apply via Dice today! Our direct client is looking for a OBIEE to OAC Migration Specialist for a 100% Remote Contract in Concord, NH IMPORTANT NOTES: • Client will consider fully remote candidates, however, candidates local and able to work on a hybrid schedule (2 days/week onsite, ideally) will be given preference. Remote resources must be located within the contingent United States and must remain within the contingent United States for all work while in this role. Candidates must be able to work on the client's Eastern Time Zone business hours. • Position will have a 37.5-hour work week, NOT a 40-hour workweek. • Any education, degrees, and certifications listed on the resume MUST contain a valid degree/certification details, INCLUDING the date the certification/degree was acquired or candidates will not be considered. • - Please send a Word document that includes contact info for THREE professional references. These references must be supervisory references from past employment, and at least one of the three must be a supervisor from employment where the candidate worked in a role similar to what is being requested for this position. References must include the full name, phone number, and email address for the reference • EXCEPTIONAL COMMUNICATION SKILLS REQUIRED- Exceptional communication skills, both written and verbal, are required to be considered for this position. J0B DESCRIPTION: • This position will be responsible for the Migration of our OnPrem OBIEE application to the cloud based OAC product. • 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: 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 ID integration • SQL and data modeling • BI migration tools and automation • Performance tuning and troubleshooting • Documentation and knowledge transfer 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, 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 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 MATRIX: • 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 • Oracle Analytics Cloud (OAC) architecture and administration experience - Required • Oracle Cloud Infrastructure (OCI) experience - Required • Identity and Access Management (IAM), including Azure Entra ID integration experience - Required • SQL and data modeling experience - Required • BI migration tools and automation experience - Required • Performance tuning and troubleshooting experience - Required • Documentation and knowledge transfer experience - Required Question 1: Respond to this question with a link to your candidate's LinkedIn Profile. Question 2: READ AND ANSWER APPROPRIATELY: Will your candidate be working fully remotely or are they local and willing and able to go into the office on a hybrid schedule? Question 3: Please specify your candidate's FULL ADDRESS of their current residence. (If not specified or if location specified is determined to be untrue at any point during the screening/interview/onboarding process - including during background check where address will be verified - your candidate will not be considered/will be removed from consideration for the position). Question 4: For remote work - client will provide selected resource with a laptop to use for the contract work. Candidate must have the ability to successfully work remotely - this includes the appropriate internet connectivity. Internet cost and any additional equipment beyond the state-provided laptop that is desired by candidate is at candidate's own expense and will not be reimbursed by CAI or the Client. Please confirm you have discussed these requirements with the candidate and they accept the requirements. Question 5: Remote candidates must be located within the US and must be able to work on the State of NH's Eastern Time Zone business hours. The candidate must be able to participate in web/video meetings as needed while remote. Please confirm you have discussed these requirements with the candidate and they accept the requirements. Question 6: This position is expected to work 37.5 hours per week (NOT a 40-hour work week). Please confirm you have discussed this with your candidate and you accept these requirements. Question 7: This position requires an additional CJIS level background check with fingerprinting which will be coordinated by the agency with the selected candidate. If contractually required background checks run by the vendor for the selected candidate come back clear, candidate can start with limited access while awaiting CJIS results. Continued employment will be contingent upon CJIS check coming back clear. Confirm you discussed this with your candidate and they accept this requirement. Location: 100% Remote, Concord, NH Type: Contract Work Location: 7 Hazen Dr, Concord, NH 03302 Please send resume to "jobs at etechnovision dot com" with B4104B in Subject for immediate consideration.