Technical Consultant - Oracle DBA

About the OpportunityJob Type: Permanent

Application Deadline: 28 February 2025

Title Technical Consultant

Department ETS (Enterprise Technical Services)

Location Ireland or UK

Reports To

Level 5

About Fidelity International

Fidelity International offers world class investment solutions and retirement expertise. As a privately owned, independent company, investment is our only business. We are driven by the needs of our clients, not by shareholders. Our vision is to deliver innovative client solutions for a better future.

Our people are passionate, engaged, smart and curious, and we give them the independence and the confidence to make a difference. While we take pride in the excellence of our investment solutions and client service, we know we can always do better. We are honest, respectful and make tough calls, challenging the status quo to achieve better outcomes through innovation. Above all else, we always put our clients first.

Find out more about what we do, our history, and how you could be a part of our future at our website.

Our Values

All of our people must be able to demonstrate affinity with the Fidelity core values:

Innovation – Being willing to experiment and try new and better ways to serve our clients.

Integrity – Taking personal responsibility for always acting in the best interests of our clients.

Excellence – Striving to be the best while knowing we can always be better next time.

Our Behaviours

All our people must be able to operate in accordance with our behaviours:

Commitment – We are committed to our clients and proud to work for Fidelity. We push through obstacles to make things happen; we make decisions quickly and thoughtfully. We are individually committed to building a culture of excellence.

Collaboration – We collaborate with colleagues, seek alternative views, invite different ideas and always challenge traditional thinking. This approach allows us to create a whole that is much greater than the sum of its parts.

Client Focus – We are expected to, and measured on, our ability to put our client first. We go the extra mile to understand their needs and strive to exceed their expectations. We listen carefully, we communicate clearly, and we’re quick to respond. We’re respectful of the trust placed in us to manage their money.

Department Description

The Data PlatformGroup sits within ETS (Enterprise Technology Services) providing a real-time, agile Enterprise Data Platform. We provide traditional Relational Database support and consultation alongside Data Analytics, In-memory, Virtualisation, Big Data built on a Self-service and automation platform. We also provide services around Data Security, Data Quality and the full Lifecycle management.

Purpose of your role

The Technical Consultant – Databases is responsible for working on database project delivery and / or production support activities from a technical perspective. Typically, this will be day to day activities supporting database infrastructure including solving production and non-production issues, working on change, incidents, problems, service improvement and engineering initiatives. In addition to this the Technical Consultant also acts as a trusted technology advisor to the business providing guidance and consultancy as required.

This role demands strong technical skills with a focus to ensure maximum uptime of the production database infrastructure. Working as a member of a global database support team the successful candidate will play a pro-active role in the support of Fidelity’s database estate. The role requires strong Oracle database technical skills across various UNIX and Linux platforms.

The role will involve regular BAU (Business As Usual) support and will involve 24 x 7 support and weekend working.

Key Responsibilities

The key responsibilities of this role are:

• 24x7 support for Fidelity’s Production database estate. This includes all Production, Disaster Recovery, Emergency Break Fix, User Acceptance Testing and Development environments.
• Rapid response to address high severity (severity 1, 2 and 3H) incidents.
• Support and delivery of assigned project work.
• Pro-active issue detection and resolution as well as service monitoring.
• Service restoration subsequent to unanticipated outages or disruptions.
• Driving root cause analysis and resolution to closure.
• Identification and driving of database related service quality improvements and engineering deliverables.
• Provision of technical support on a shift, on-call and rotational basis.
• Resolution of production support issues.
• Escalation as necessary to secure assistance and technical guidance from other Technology teams to resolve support issues.
• Management and progression of Action items.
• Automation and process improvement of database activities.

Experience and Qualifications Required

• Excellent Oracle database administration skills in a production support capacity; with the responsibility for the delivery, support and maintenance of reliable, highly available and high-performance environments.
• Support of database installation and configuration, monitoring and housekeeping, upgrade and patching, troubleshooting, root cause analysis and performance tuning.
• Good experience in another RDBMS platform, preferably Microsoft SQL Server, database administration and skills as above.

Personal Skills

• A good team worker.
• Ability to priorities and co-ordinate activities.
• Experience of working to tight deadlines on a regular basis.
• Good analytical, problem solving and documentation skills.
• Ability to adapt to changing business needs (flexible) and learning new skills quickly.
• Good written and verbal communication skills, together with the ability to communicate with management and other business and technical groups.
• Calm approach when under pressure.
• Customer focused – strong service ethic.
• Ability to work on own initiative with minimal direction.

Technical expertise

Above 10 Years of progressive working knowledge of database technologies

• Oracle Certified Professional
• Oracle RDBMS (11g, 12c, 18c,19c)
• Oracle Data Guard
• Oracle Automatic Storage Management (ASM)
• Oracle Grid Infrastructure and Real Application Clusters
• Oracle Exadata
• Oracle Golden Gate
• Good understanding of UNIX and Linux operating systems (Red Hat Enterprise Linux)

• Strong scripting skills (SQL, PL/SQL, UNIX shell scripting)
• Database backup, restore and recovery - User and server managed (RMAN and EMC DataDomain or equivalent)
• Database Instance and Query performance tuning

Desirable Skills

• Big Data, No/SQL & Related Technologies
• Data Visualization - Tableau, OBIEE, MS Power BI
• Cloud Fundamental - AWS, Azure, Oracle

Feel rewarded

For starters, we’ll offer you a comprehensive benefits package. We’ll value your wellbeing and support your development. And we’ll be as flexible as we can about where and when you work – finding a balance that works for all of us. It’s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.

For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.