Technical Consultant - Oracle Dba

  • Dublin
  • Fidelity International

About the opportunity : Department Description

The Data Services Group sits within TIS (Technical Infrastructure 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 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.

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 mínimal direction.

Technical expertise

Above 10 Years of progressive working knowledge of database technologies

  • Oracle Certified Professional
  • Oracle RDBMS (11g, 12c, 18c)
  • 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 Netbackup or equivalent)
  • Database Instance and Query performance tuning

Desirable Skills

  • Big Data, No/SQL & Related Technologies
  • Data Visualization - Tableau, OBIEE, MS Power BI

About you : About Fidelity International : We’ve been helping our clients plan and save for the futures they want for over 50 years. From more than 25 locations around the world, we provide investment services and retirement expertise to 2.5 million clients - everyone from central banks and financial institutions to wealth managers and private individuals. We think generationally and look to the long term. And today, building on the security of private ownership and our strong sense of purpose, we’re growing our business like never before.

What it’s like to work here.

In our welcoming, caring culture, you’ll feel valued, trusted and free to express yourself. We recognise the value of inclusion and diversity in culture, in thought and in experience. With this in mind, please let us know if you feel you might benefit from any reasonable adjustments to perform to the best of your ability during the recruitment proces