Description
Job Description
The Premium SQL DBA reports into the Head of SQL Change Delivery. This role holds accountability for database support in the Barclays Investment Bank.
- 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.
- Provide on-call rota support where required
- Lead and define database delivery requirements for Service Improvement Unit initiatives
- Incident Management - provide 24 x 7 (rota) support for all SQL Server technologies.
- Change Management - Assess, plan, test and implement BAU change into Production environment, adhering to bank's governance and control procedures
- Able to clearly communicate complex technical issues to a wide audience, including Business owners, Directors and Managing Directors and those from a non-technical background.
- 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.
- Provide pro-active capacity planning of Investment Bank SQL Server estate
- Be an effective, proactive team member, influencing the behaviour of colleagues internally and across Infrastructure Services
- Demonstrable experience of database performance tuning and capacity management on critical customer-facing systems and high-volume payments services
- Experience of working in a highly regulated environment and the associated processes and tools
- Have a strong working knowledge of Barclays infrastructure components and the processes required to maintain the infrastructure
- Have a good understanding of the business areas and application/service components used and an appreciation of applications from both a technical and business perspective.
Technical experience
- Expert knowledge of database administration on distributed platforms
- Knowledge of the ITIL framework, vocabulary and best practices
- Experience with setup/configuration/support of SQL Server 2008,2008R2,SQL2012, SQL2014
- Experience configuring and Deploying Reporting Services and Service Broker
- Must have extensive experience as Production support SQL Server Database Administrator - strong experience in large, high volume and high criticality environments
- Windows Clustering
- SQL Server Replication
- Experience of working in a highly regulated environment and the associated processes and tools
- Project build, test and implementation of Database components
- Preferable an Investment Banking background
- Must have extensive experience with Log Shipping, Database Snapshots, Database Mirroring, San Replication and experience with AlwaysOn
- Demonstrate extensive expertise in performance tuning including both query and server optimization
- Must have hands-on experience with Transactional Replication (multiple subscribers)
- 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 -bottom.0001pt;line-height: normal'>
- Be an effective, proactive team member, influencing the behaviour of colleagues internally and across Infrastructure Services
- Precise, Imperva, Autosys.
- Demonstrable experience of database performance tuning and capacity management on critical customer-facing systems and high-volume payments services
- Experience of working in a highly regulated environment and the associated processes and tools
- Have a strong working knowledge of Barclays infrastructure components and the processes required to maintain the infrastructure
- Have a good understanding of the business areas and application/service components used and an appreciation of applications from both a technical and business perspective.