Overview
Skills
Job Details
Position Details: Oracle Administrator
Type: Long Term Contract (6 Months+)
Job Description
We are looking for an Oracle Saas Administrator, with at least 5 years of recent experience. In this role you will be responsible for managing and maintaining Oracles cloud-based applications. These applications include Oracle Fusion Cloud modules such as ERP, PPM, and EPM. The ideal candidate will have strong technical expertise in Oracle Cloud Infrastructure, BI Publisher, and SQL, along with excellent problem-solving and customer interfacing skills. The role ensures that the organization's Oracle SaaS environments are secure, stable, and optimized for business operations.
Skills
- Oracle Cloud Infrastructure
- SaaS admin for OCI
- Manage all environments (Test, Prod, Dev)
- Schedule and manage refreshes (with and without data masking for training) and tracking spreadsheets to ensure all environments (Test, Dev2, etc.) are refreshed on schedule
- Manage user access
- Quarterly Patch Analysis
- Review and advise quarterly patches
- Execute our manual "post-refresh steps" for Oracle environments
- Oracle BI Publisher
- Knowledge of the "Oracle BI Publisher" plugin for Microsoft Word and Excel.
- Create, modify, and fix reports (specifically RTF templates) that connect directly to Oracle data.
- Oracle Reports, Data Catalogs
- Knowledge of the Oracle Fusion ERP, EPM, PPM table structures.
- Understanding, modifying, troubleshooting SQL queries that power Oracle's data catalogs and reports.
- General Technical Tickets & Meetings
- Handling technical incidents that require investigation into the Oracle backend (e.g., PO tax rate discrepancies).
- Attending Oracle Customer Connect sessions on behalf of the team (e.g., "Fusion Application Identity Upgrade").
Primary Focus
Dev:
- Designing and delivering custom reports using Oracle BI Publisher
Admin:
- Managing and configuring Oracle Cloud SaaS applications
Core Responsibilities
Dev:
- Build data models and SQL queries
- Design report templates (RTF, Excel)
- Integrate reports with Oracle ERP
- Optimize report performance
Admin:
-Manage user roles and security
- Configure application settings and workflows
- Monitor system performance
- Handle patches and updates
Skills Required
Dev:
- SQL, PL/SQL
- BI Publisher tools
- XML, RTF templates
- Oracle ERP knowledge
Admin:
-Oracle Cloud SaaS platform expertise
- Security and role management
- Functional configuration
- Basic troubleshooting
Goal
Dev:
-Provide accurate, formatted reports for business insights
Admin:
-Ensure smooth operation and compliance of SaaS apps
Typical Deliverables
Dev:
- Financial statements
- Operational dashboards
- Invoices and compliance reports
Admin:
- Configured SaaS environment
- Secure user access
- Updated workflows