Senior Technical Analyst- Oracle DBA

About the OpportunityJob Type: Permanent

Application Deadline: 24 November 2024

Title: Senior Technical Analyst- Oracle DBA

Department: TIS - Data Services

Location: India - Bangalore

Level : 3

We’re proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this? By working together - and supporting each other - all over the world. So, join our team and feel like you’re part of something bigger.

Department Description

Data Services Group is part of the Technology Infrastructure Services (TIS) function and is responsible for providing a secure, real-time and agile Enterprise Data Platform. As part of our Relational Data Services, we provide data storage and retrieval, security, replication and migration and HA/DR services through multi-vendor relational database solutions including Oracle, SQL Server and Sybase. Support for big data, data acquisition, data pipelines, data transformation (ETL/ELT), data visualisation and enterprise data lake capability are part of our Emerging Data Services. We maintain our monitoring solutions and integrations with various other enterprise platforms via multiple channels. Most of our services are available via our automation and self-service platform, ICTECH. We achieve industry connect by leading and participating in various user groups, meet-ups and other engagement platforms.

Purpose of the Role

The Senior Technical Analyst- Oracle DBA 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 pre-production issues, working on change, incidents, problems, service improvement and engineering initiatives. In addition to this the Technical Specialist 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. DB2 database exposure is preferred, but not required

The role will involve regular BAU (Business As Usual) support during UK business hours and will involve 24 x 7 oncall support and weekend working. The candidate will maintain focus on following engineering principles, delivering robust, automated and innovative, hybrid multi-cloud data platform capability.

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.
• 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

• Above 5 Years of progressive working knowledge of database technologies
• 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 performant environments.
• Support of database installation and configuration, monitoring and housekeeping, upgrade and patching, troubleshooting, root cause analysis and performance tuning.

Personal Skills

• A good team worker.
• Ability to prioritise 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.
• Provide consultancy and guidance to business on database technologies.

Technical expertise

• Oracle Certified Professional (OCP)
• Oracle RDBMS 12c & 19c
• Oracle Data Guard
• Exposure to Oracle Golden Gate
• Oracle Automatic Storage Management (ASM)
• Oracle Grid Infrastructure
• Oracle Real Application Clusters

• Good understanding of UNIX and Linux operating systems
• Scripting skills (SQL, PL/SQL, UNIX shell scripting)
• Oracle Golden Gate
• Database backup, restore and recovery - User and server managed (RMAN and Netbackup or equivalent)
• Database instance and query performance tuning
• Oracle Enterprise Manager (OEM)
• Control-M

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.