Job Title: Senior Oracle Database Administrator

Reporting to: Director, Infrastructure and Database Operations

Direct Reports: None

Position Type: Permanent, full-time, hybrid with minimum 3 days in the office per week

Overview

Why Tokio Marine HCC?

Standing still is not an option in the current world of Insurance. TMHCC is one of the world’s leading Specialty Insurers. With deep expertise in our chosen lines of business, our unparalleled track record and a solid balance sheet, TMHCC evaluates and manages risk like no one else in the industry. Looking beyond profit, empowering our people and delivering on our commitments are at the core of our customer values, along with a desire to grow and provide creative and innovative solutions to our clients.

Job Purpose

The Senior Oracle Database Administrator (DBA) will support and maintain mission-critical on-premises Oracle database environments, with a strong focus on Oracle PeopleSoft applications. The role holder will be responsible for the administration, performance, security, and availability of Oracle databases supporting PeopleSoft Financials.

Key Responsibilities

Oracle Database Administration

• Patch, update, and maintain Oracle Database environments.
• Administer Oracle 19c databases across development, test, QA, and production environments.
• Manage Oracle ASM, Data Guard, RMAN, and related technologies.
• Monitor database performance, capacity, and availability.

PeopleSoft Administration Support

• Support Oracle databases underlying PeopleSoft Financials application.
• Support PeopleSoft infrastructure including Application Server, Process Scheduler, WebLogic, Tuxedo, and Integration Broker components.
• Lead PeopleTools upgrades, PUM image deployments, environment refreshes, migrations, and application maintenance activities.
• Support Phire change management administration, including migration workflows, user access, release management, troubleshooting, and coordination of PeopleSoft application deployments.
• Administer and support PeopleSoft Search Framework and OpenSearch environments, including installation, configuration, indexing, performance tuning, monitoring, and troubleshooting.
• Administer and support Integration Broker, gateways, web services, and APIs.
• Collaborate with functional teams, developers, and DBAs to resolve application, batch processing, search, and integration issues.
• Support production releases, system monitoring, incident response, root cause analysis, and operational improvements.
• Develop and maintain automation solutions using shell scripting and related administration tools.
• Configure, troubleshoot, and regularly patch Oracle WebLogic, Tuxedo, and JDK environments.
• Support single sign-on (SSO), SSL certificates, and security integrations.
• Assist with vulnerability management and infrastructure planning.
• Optimize PeopleSoft batch processing, Application Engine programs, Process Scheduler performance, and reporting workloads.
• Troubleshoot database performance issues impacting PeopleSoft online and batch operations.