MSSQL Database Administrator

Job DescriptionPurpose of the roleTo effectively monitor and maintain the bank's critical technology infrastructure and resolve more complex technical issues, whilst minimising disruption to operations. AccountabilitiesProvision of technical support for the service management function to resolve more complex issues for a specific client of group of clients. Develop the support model and service offering to improve the service to customers and stakeholders.Execution of preventative maintenance tasks on hardware and software and utilisation of monitoring tools/metrics to identify, prevent and address potential issues and ensure optimal performance.Maintenance of a knowledge base containing detailed documentation of resolved cases for future reference, self-service opportunities and knowledge sharing.Analysis of system logs, error messages and user reports to identify the root causes of hardware, software and network issues, and providing a resolution to these issues by fixing or replacing faulty hardware components, reinstalling software, or applying configuration changes.Automation, monitoring enhancements, capacity management, resiliency, business continuity management, front office specific support and stakeholder management.Identification and remediation or raising, through appropriate process, of potential service impacting risks and issues.Proactively assess support activities implementing automations where appropriate to maintain stability and drive efficiency. Actively tune monitoring tools, thresholds, and alerting to ensure issues are known when they occur.Analyst ExpectationsTo perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement.Requires in-depth technical knowledge and experience in their assigned area of expertiseThorough understanding of the underlying principles and concepts within the area of expertiseThey lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources.If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.OR for an individual contributor, they develop technical expertise in work area, acting as an advisor where appropriate.Will have an impact on the work of related teams within the area.Partner with other functions and business areas.Takes responsibility for end results of a team's operational processing and activities.Escalate breaches of policies / procedure appropriately.Take responsibility for embedding new policies/ procedures adopted due to risk mitigation.Advise and influence decision making within own area of expertise.Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct.Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function.Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.Make evaluative judgements based on the analysis of factual information, paying attention to detail.Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents.Guide and persuade team members and communicate complex / sensitive information.Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.Join us as a MSSQL Database Administrator at Barclays, responsible for supporting the successful delivery of Location Strategy projects to plan, budget, agreed quality and governance standards. You'll spearhead the evolution of our digital landscape, driving innovation and excellence. You will harness cutting-edge technology to revolutionise our digital offerings, ensuring unparalleled customer experiences.To be successful as a MSSQL Database Administrator you should have experience with:Experience in support/setup/configuration of SQL Server 2012, 2014, 2016, 2017, 2019, 2022. Hands-on SQL Server Administration experience in High Availability and Disaster Recovery using AlwaysOn & Log-Shipping, Replication topologies, Backup and Recovery, Service Broker, Database Snapshots, Windows Clustering etc.Expert knowledge of T-SQL. Must have extensive experience as Production support SQL Server DBA - strong experience in large, high volume and high criticality environments.Database maintenance and troubleshooting. Must exhibit in-depth expertise in solving database contention problems (dead locks, blocking etc). Demonstrate extensive expertise in performance tuning including both query and server optimization.Ability to understand and influence high level technical design of Database components.Knowledge of the ITIL framework, vocabulary and best practices.Some other highly valued skills may include:Strong skills in designing and delivering platforms to hosts SQL server, covering HA and DR, at Enterprise scale.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.You may be assessed on the key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen strategic thinking and digital and technology, as well as job-specific technical skills. This role is based in Chennai.