Job Title: Oracle L2 DBA Location: Chennai 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. If you would like some flexibility, then please discuss this with the hiring manager. Introduction: The Infrastructure Lead reports into the Database Lead 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 & Sybase database services and associated support infrastructure and services are secure, robust, resilient and compliant to PCI standards. What will you be doing? 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 SQL Server 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 (Sev 3 high, Sev 2 and Sev1) - Define and drive the product strategy. - Adherence to Barclays standards for change control, database security and database patterns, adhering to bank’s governance and control procedures. - Provide on-call rota support where required - Lead and define 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. What we’re looking for: - Expert knowledge of database administration on Oracle. - Ready to work in 24 x7 Operations. Expert in multiple versions of Oracle - +i, 10g, 11g, 12c,1+c - Expert knowledge of RMAN, Dataguard, PT, OEM, Audit Vault, plus third-party products such as Foglight, Precise, Imperva - Knowledge of the ITIL framework, vocabulary and best practices - Must have extensive experience as Production support Oracle Database Administrator - strong experience in large, high volume and high criticality environments - Must exhibit in-depth expertise in solving database contention, PT problems (dead locks, blocking etc) - Demonstrate extensive expertise in performance tuning including both query and server optimization - Knowledge of the ITIL framework, vocabulary and best practices Skills that will help you in the role: - Oracle Certified Performance Tuning Expert - Oracle 12c or 11g - Oracle Certified Maximum Availability Expert - Oracle 12c or 11g - Experience of working in a highly regulated environment and the associated processes and tools Where will you be working? Chennai Be More at Barclays Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details. Purpo