Note: The job is a remote job and is open to candidates in USA. First Tek, Inc. is seeking a System Administrator 3 to maintain the technical health and reliability of the agency's Oracle Enterprise Performance Management (EPM) Cloud platform. The role involves monitoring system operations, troubleshooting automation failures, and enhancing system reliability through advanced scripting.
Responsibilities
- Contribute to the organization, planning, and management of the agency's Oracle EPM Cloud environment to ensure operational health, stability, and reliability
- Maintain, troubleshoot, and strengthen existing automation scripts written in PowerShell and Windows Batch to help ensure the reliability of nightly data processing and maintenance cycles
- Develop new automation using EPM Automate and REST API to streamline administrative tasks and improve system stability
- Perform root cause analysis for production issues by investigating server logs and EPM Automate exit codes to resolve failures in a timely manner
- Collaborate with technical team members, the third-party implementation partner, and business users to translate requirements into functional capabilities
- Manage the migration of EPM artifacts (Calculation Scripts, Web Forms, Business Rules, Security) between environments using Life Cycle Management (LCM)
- Define data staging requirements and collaborate with data warehouse and source system teams to ensure that data is properly structured, transformed, and validated prior to being loaded into the EPM application
- Assist with core application duties, including metadata management, user security provisioning, application maintenance, and performance tuning
- Mark documents and maintain filing system(s), files, emails, and records in accordance with compliance requirements. Share and disperse documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Mark and maintain all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validate official records are accurately maintained for auditing purposes
Skills
- A bachelor's degree in information technology, computer science, or a related field is preferred
- 8 years of experience is required with an applicable bachelor's degree
- 10 years of experience is required without a degree or an applicable degree
- Experience must include direct work experience in information technology performing system administration
- 3 years of direct, hands-on work experience in the administration and development of an Oracle EPM/Hyperion platform
- Demonstrated proficiency with EPM Automate for executing administrative tasks and moving data/artifacts
- Advanced scripting experience in PowerShell, Python, and/or Windows Batch Scripting, including creating robust error-handling and logging routines
- Experience administering an Oracle EPM Cloud application (e.g., PBCS/EPBCS, FCCS) or a similar on-premises Hyperion Planning environment
- Experience troubleshooting EPM data load processes using Data Management / Data Integration
- Knowledge of EPM architectural components, including business rules, calculation scripts, and security models
- Experience with Life Cycle Management (LCM) for migrating application artifacts
- Experience defining data transformation and validation rules for integrating data from relational sources (e.g., data warehouses) into a multidimensional EPM/Essbase application
- Oracle Cloud EPM Planning Certified Implementation Professional certification is strongly preferred
- Experience using REST APIs for EPM Cloud within PowerShell or another scripting language
- Knowledge of SQL for data validation and troubleshooting
- Experience maintaining Essbase Business Rules (Calculation Scripts). Foundational knowledge of Groovy scripting for EPM is highly desirable
- Familiarity with federal information security (INFOSEC) and data handling standards
- Prior experience acting as a liaison with software vendors or implementation partners
- General understanding of federal budgeting and financial planning processes
Benefits
- Remote Work Eligible - Must live in BPA's service territory of WA, OR, ID, MT. Official Duty Station is the home address.
- Periods of up to 3 days onsite may be required up to 6 times per year.
- 5% anticipated Overtime
- Up to 5% local travel for meetings
- Attendance at all conferences, workshops, training, etc. must be pre-approved by SLMO. Requests will be reviewed on a case-by-case basis. Approval is subject to the most current guidance provided to SLMO by BPA or DOE and is subject to change at any time.
- SLMO reserves the right to negotiate attendance on billable/non-billable hours and reimbursement of travel costs with the supplier. Reimbursable travel costs must adhere to the Federal Travel Regulations and be submitted via an expense sheet in Fieldglass.
- CFTE must sign NDA (Non-Disclosure Agreements) at beginning of assignments. (Does not apply to Craft assignments)
- CFTE must complete annual Information Security and Privacy Awareness training.
- CFTE must complete and pass background investigations of an appropriate level.
- BPA provided safety training will be the same training provided to Federal Workers.
Company Overview