- Entry level
- No Education
- Salary to negotiate
Senior SQL DBA - 90229539
Posting Range:4 Apr 2019 - 18 Apr 2019
Job Title: Senior SQL DBA
This position will be responsible for providing L3 DBA SQL Server Infrastructure, covering all aspects of the MS SQL DBA technical role and providing the final internal technical authority on SQL DBA problems.
Designing, developing and delivering engineering solutions for the bank in the MS SQL space, using a combination of technologies and product to assist in delivering a more resilient, robust, automated SQL platform for the banks current, and future, MS SQL platform.
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)
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 SQL Server.
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 distributed platforms
Experience with setup/configuration/support of SQL Server 2008,2008R2, 2012, 2014, 2016, 2017
Expert knowledge of T-SQL, Powershell scripting.
JSon, C# a nice-to-have.
Experience configuring and all components of the MS SQL L3 set (Core DB engine and SSRS, SSAS, SSIS, Replication topologies, Service Broker, Log Shipping, Database Snapshots, Database Mirroring, and experience with AlwaysOn etc.)
Must have extensive experience as Production support SQL Server Database Administrator - strong experience in large, high volume and high criticality environments
Strong skills in designing and delivering platforms to hosts SQL server, covering HA and DR, at Enterprise scale.
Skills that will help you in the role:
Experience of working in a highly regulated environment and the associated processes and tools
Demonstrate extensive expertise in performance tuning including both query and server optimization
Must exhibit in-depth expertise in solving database contention problems (dead locks, blocking etc)
Ability to understand and influence high level technical design of Database components
Knowledge of the ITIL framework, vocabulary and best practices
Where will you be working?
*Barclays recently announced the creation of a new world-class campus at Gera Commerzone located in Kharadi. All Pune based roles will eventually start to move to this new campus starting September 2019. In the run up to that, during the course of 2018, there may be transitory movements of some roles to other temporary sites. Please speak with your recruiter about the specific location plans for your role.
Be More at Barclays
At Barclays, each day is about being more – as a professional, and as a person. ‘Be More @ Barclays’ represents our core promise to all current and future employees. It’s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be
About the company
Barclays moves, lends, invests and protects money for 48 million customers and clients worldwide.
We have over 325 years of history and expertise in banking. From our beginnings in Lombard Street, London through to the launch of the world’s first ATM and innovative mobile phone payments services, find out more about our achievements to date.
Barclays is a trading name of Barclays Bank PLC and its subsidiaries. Barclays Bank PLC is registered in England and is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Registered in England. Registered No. 1026167. Registered office: 1 Churchill Place, London E14 5HP.