Oracle Hyperion Administrator

Location: Remote – Singaporean Time Zone

Experience: 05+ Years

What We Are Looking For

We are seeking an experienced Oracle Hyperion Administrator with 5+ years of hands-on experience in managing, maintaining, and optimizing enterprise Oracle Hyperion / Enterprise Performance Management (EPM) environments.

The ideal candidate will be responsible for the end-to-end administration, security, patching, upgrades, performance tuning, and high availability of Hyperion components across Development, Test, UAT, Production, and Disaster Recovery environments. You will work closely with cross-functional teams including Database Administrators, Middleware teams, OS Administrators, and Finance teams to support business-critical financial close, budgeting, and forecasting cycles.

Job Responsibilities

1. Hyperion / EPM Infrastructure Administration

• Install, configure, administer, and maintain Oracle Hyperion / EPM environments.
• Manage application servers, web servers, middleware, and Hyperion services.
• Conduct routine system health checks and ensure overall system availability and stability.
• Execute start, stop, and restart procedures for Hyperion services during maintenance windows.
• Maintain Development, Test, UAT, Production, and Disaster Recovery (DR) environments.

2. Core Application Administration

• Oracle Essbase: Configure and maintain applications, outlines, dimensions, hierarchies, attributes, calculation scripts, business rules, and rules files. Perform database restructuring, outline optimization, cache tuning, and data refreshes.
• Hyperion Planning: Administer Planning applications, dimensions, Smart Lists, forms, task lists, menus, and Calculation Manager business rules. Support annual planning-cycle roll-forwards.
• Hyperion Financial Management (HFM): Maintain HFM metadata, rules, application settings, and security. Support financial consolidation, intercompany eliminations, currency translation, and financial close cycles.
• FDMEE / Data Integration: Administer FDMEE / Data Management, maintain source/target mappings, import formats, categories, and scheduled data-load rules.

3. User Access and Security Management

• Create and manage users, groups, roles, and provisioning via Oracle Hyperion Shared Services.
• Configure Essbase security filters, application access, and maintain segregation of duties.
• Perform periodic security access reviews and support compliance audits.

4. Environment Migration, Patching, and Upgrades

• Patching: Plan and execute Oracle Patch Set Updates (PSUs), Critical Patch Updates (CPUs), and security fixes across all environments. Prepare pre-patch backups and rollback plans.
• Upgrades: Execute version upgrades and platform migrations for Hyperion tools, WebLogic Server, Java/JDK, OHS, and DB clients.
• Lifecycle Management: Use Lifecycle Management (LCM) for migrating artifacts between environments, cloning applications, and performing Prod-to-Test refreshes.

5. Performance Monitoring and Operational Support

• Monitor CPU, Memory, JVM utilization, WebLogic health, Essbase cube performance, and calculation runtimes.
• Provide L2/L3 production support, perform root-cause analysis (RCA) for critical issues, and resolve incidents within SLAs.
• Develop and maintain automated automation scripts using MaxL, Shell, PowerShell, SQL, or batch scripts for scheduled jobs.
• Support Smart View connectivity, Financial Reporting, and end-user troubleshooting.
• Participate in DR switchover exercises, backup/recovery testing, and maintain operational runbooks.

Skills and Qualifications

Technical Skills

• Hyperion Suite: Hands-on experience with Hyperion Planning, Oracle Essbase, HFM, FDMEE, Shared Services, Workspace, Calculation Manager, and Financial Reporting.
• Middleware & Infrastructure: Proficiency in Oracle WebLogic Server, Oracle HTTP Server (OHS), JVM tuning, and SSL/TLS configuration.
• Operating Systems & Scripting: Strong knowledge of Linux (RHEL/Oracle Linux), AIX, or Windows Server, along with scripting skills in MaxL, Shell, PowerShell, or SQL.
• Data Integration: Experience integrating Hyperion with ERPs (Oracle EBS, Fusion), Data Warehouses, and external databases.

Professional Experience & Requirements

• Work Experience: Minimum 5+ years of dedicated experience as an Oracle Hyperion / EPM Administrator.
• Financial Process Knowledge: Understanding of FP&A, budgeting, forecasting, financial consolidations, and month-end/year-end close processes.
• Shift & Location Flexibility: Ability to work remotely and align operational hours with the Singaporean Time Zone (SGT).
• Certifications (Preferred): Oracle Hyperion / EPM or Oracle WebLogic System Administrator certifications.
• Soft Skills: Excellent problem-solving abilities, strong communication skills for multi-team coordination, and capability to handle high-pressure financial-close windows.

[email protected]

Pay: Rs300,000.00 - Rs400,000.00 per month

Work Location: Remote