OIPA Administrator

Job Description

Primary Job Duties:

- Monitor, Analyze and Configure the OIPA Application and Database Servers to ensure optimal performance.
- Database Tuning includes query, index recommendations for performance and I/O consumption.
- Application Server Tuning includes Clustering, CPU, Memory and Thread Pool recommendations.
- Design OIPA production and lower infrastructure environments.
- Produce system design specification documents.
- Design and review Security requirements based on business user requirements.
- Support complex deployments and migrations.
- Proactively assess short/long term design implications that would impact effective and efficient operations of the overall OIPA and the PAS ecosystem.
- Identify, recommend and implement standardization and consolidation opportunities as the system is implemented across the organization.
- Work closely with internal OIPA Configuration teams as well as Oracle Development team to manage OIPA SRs.
- Manage multiple development designs and projects to meet project and customer required time lines.
- Participate and lead, when needed, the project meetings with technical and business teams.
- Train and mentor other team members.

Required Experience:

- 4+ years of Oracle DB Support/Administration.
- 5+ years of Oracle WebLogic, IBM WebSphere, Redhat JBoss, Tomcat and Coherence.
- OIPA Components Deployment with WebLogic will be an asset.
- 5+ years of Oracle Linux.
- Oracle System Administration Tools - OEM, Admin Server, Data Guard.
- CRON jobs - creating and scheduling.
- System Alerts - Creating and modifying system alerts utilizing scripting tools - Python.
- Oracle Exalogic and Exadata will be an asset.
- OIPA Database and Application upgrade will be an asset.
- Data migration, management, partitioning experience.
- Data simulation/replication (i.e., Policy Copy or equivalent tool) will be an asset.
- OIPA Release Management will be an asset.
- OIPA Components User Management with security group entitlements and SSO enablement will be an asset.
- DI - Queue configuration and setup - troubleshooting of issues with JMS messaging with WebLogic or WebSphere.
- Database back up tools - Rubrik.
- Deployment experience with Docker images / Kubernetes for WebLogic and TomEE profiles.
- Experience with Cycle and DI monitoring / troubleshooting to identify RCA.
- OIPA v10 or v11 experience will be an asset.
- OIPA System Design and Configuration using OIPA v10 or v11 will be an asset.
- OIPA implementation experience for multiple clients will be an asset.
- Knowledge of Oracle SOA, MuleSoft and BPM will be an asset.
- Knowledge of AWS and Oracle OCI cloud computing will be an asset.
- Working knowledge of insurance life and health products for individual, group and worksite markets will be an asset.

Education

Bachelor's degree in Actuarial Science, Math, Statistics, Finance, Computer Science, or other equivalent working experience

---