Senior Oracle Database Administrator

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

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.

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

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.

People Soft Administration Support

• Support Oracle databases underlying People Soft Financials application.
• Support People Soft infrastructure including Application Server, Process Scheduler, Web Logic, Tuxedo, and Integration Broker components.
• Lead People Tools 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 People Soft application deployments.
• Administer and support People Soft Search Framework and Open Search 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 Web Logic, Tuxedo and JDK environments.
• Support single sign‑on (SSO), SSL certificates, and security integrations.
• Assist with vulnerability management and infrastructure planning.
• Optimize People Soft batch processing, Application Engine programs, Process Scheduler performance, and reporting workloads.
• Troubleshoot database performance issues impacting People Soft online and batch operations.

Performance Tuning & Optimization

• Analyze AWR, ASH, Statspack, and execution plans to identify performance bottlenecks.
• Implement proactive monitoring and performance improvement initiatives.

Backup, Recovery & Disaster Recovery

• Support backup and recovery strategies using RMAN via third party tool (Rubrick).
• Support disaster recovery planning and testing for Oracle and People Soft environments.
• Support a Day‑1 copy of a production database using Oracle Data Guard Snapshot Standby.

Security & Compliance

• Implement database security controls and access management.
• Support compliance initiatives and security audits.
• Apply Oracle Critical Patch Updates (CPUs) and security patches.

Automation & Documentation

• Support automation scripts using bash…