At a Glance
- Tasks: Manage and optimise Oracle databases, focusing on PeopleSoft applications.
- Company: Join a leading Specialty Insurer with a commitment to innovation and growth.
- Benefits: Competitive salary, dynamic work environment, and opportunities for professional development.
- Other info: Be part of a diverse team that values creativity and transformative thinking.
- Why this job: Make a real impact in a rapidly evolving industry while working with cutting-edge technology.
- Qualifications: Experience in Oracle Database Administration and supporting PeopleSoft environments.
The predicted salary is between 54000 - 66000 £ per year.
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 People Soft applications.
The role holder will be responsible for the administration, performance, security, and availability of Oracle databases supporting People Soft 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.
- 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 shell.
- Create and maintain operational procedures and support documentation.
- Document People Soft-specific database standards and maintenance processes.
Skills and Experience Specification
Essential
- Oracle Database Administration experience.
- Experience supporting Oracle databases in a People Soft environment.
- Strong experience with Oracle ASM, Data Guard, RMAN, and Enterprise Manager.
- Experience supporting People Soft applications, including People Tools architecture.
- Experience administering Oracle databases on Linux/Unix platforms.
- Strong SQL skills.
Desirable
- Oracle Certified Professional (OCP) certification.
- Advanced knowledge of Oracle database performance tuning and troubleshooting.
- Experience with People Soft Financials.
- Experience with People Soft PUM upgrades and People Tools upgrades.
- Familiarity with middleware technologies including Web Logic and Tuxedo.
- Experience with third party enterprise monitoring tools, such as Foglight, and ITIL-based support processes using Service NOW.
- Experience with Peoplesoft change management tools, such as Phire.
What We Offer
The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package.
We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals.
The Tokio Marine HCC Group of companies is an equal opportunity employer.
Your success is our priority.
In a world that is rapidly changing, TMHCC enables you to take on opportunities with confidence.
At Tokio Marine HCC, we pride ourselves on hiring the smartest, most conscientious people, who want to make a difference no matter their background.
And then we give them the support and trust they need.
We’re always looking for curious, creative transformative thinkers who want to change the status quo and have a passion for doing the right thing.
#J-18808-Ljbffr
Senior Oracle Database Administrator employer: HCC Service Company, Inc.
HCC Service Company, Inc. is an attractive employer due to its commitment to employee empowerment and professional development. The company fosters a collaborative work culture that encourages innovation and creativity. With a hybrid work model, employees enjoy flexibility while contributing to meaningful projects.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Oracle Database Administrator
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at HCC Service Company, Inc. or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to HCC Service Company, Inc..
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like HCC Service Company, Inc..
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like HCC Service Company, Inc. that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Senior Oracle Database Administrator
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at HCC Service Company, Inc..
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at HCC Service Company, Inc. and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at HCC Service Company, Inc.
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If HCC Service Company, Inc. uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.
