Oracle Dba

Job Title :Oracle DBA

Location: Pune

About Barclays

Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group.

Risk and Control Objective

Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.

Working Flexibly

We’re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers’ and clients’ needs. Whether you have family commitments or you’re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life.

Hybrid Working
BUK & BX - All locations

Please discuss the detail of the working pattern options for the role with the hiring manager.

Introduction:
The AVP reports into the Database Manager and will be a key technical leader in the delivery of the database services, utilizing excellent technical knowledge and experience to proactively define and develop the environment and procedures, and be an expert trouble-shooter for major or critical service incidents.
As a member of the Operations Infrastructure teams, the primary function of the role is to ensure the Oracle database services and associated support infrastructure and services are secure, robust, resilient and compliant to PCI standards

What we’re looking for:
Leadership. Proven as a technical leader in a high-performing environment, with evidence of ideas generated and implemented, service situations owned and proactive planning of successful migrations/new environments and services/tools

Technical. Demonstrable expert knowledge of the Oracle database components and the environments that surrounds them, including industry trends, services and delivery models. Strong understanding of other infrastructure areas and their interaction with the database environment - for example: servers, storage, operating systems, virtualisation, active directory, networks.

Environmental. Track record of delivering and operating complex services within a high-pressure environment, with excellent communications with all levels of technician and senior leaders.
- Ownership and leadership of technical resolution for high severity production incidents (Major-4/3/2/1)
- Technical engagement in Incident, Problem and Change as part of BAU Operations activities.
- Involve and drive estate wide Oracle patching, Scheduled Disaster Recovery/Production Crossover exercises and state-wide remediation and rollouts
- Adherence to Barclays standards for change control, database security and database patterns, adhering to bank’s governance and control procedures.
- Define and Lead database delivery requirements for Service Improvement Unit initiatives
- Act as technical point of contact internally and externally for technical queries across Investment Bank regarding Oracle databases.
- Analysis of re-occurring incidents and identify service improvements where possible.
- Be an effective, proactive team member, influencing the behaviour of colleagues internally and across Infrastructure Services
- Deliver process and documentation around automated patching, estate patch-fit remediation processes.

Skills that will help you in the role:

- Expert knowledge of database administration on Oracle.
- Expert in multiple versions of Oracle - 9i, 10g, 11g, 12c, 19c
- Expert knowledge of RMAN, Dataguard, Database Performance Tuning, OEM, plus third-party products such as Imperva.
- Expert knowledge of Real Application Cluster with Maximum Availability setup.
- Must exhibit SME expertise in solving database contention, Performance Tuning problems (Slow SQL response, slow database response etc).
- Database, RAC, OEM, OID installation, configuration and integration.
- Database Upgrade, Migration with ZDLR and Patching.
- Expertise in Goldengate configuration, troubleshooting.
- Database Security policies, fine grained auditing.
- Must have extensive experience as Production support Oracle Database Administrator - strong experience in handling large, high volume and high criticality environments.
- Demonstrate extensive expertise in performance tuning including both query and database optimization
- Knowledge of the ITIL framework, vocabulary and best