MSSQL Database-Site Reliability Engineer

Job Description

Purpose of the role

To apply software engineering techniques, automation, and best practices in incident response, to ensure the reliability, availability, and scalability of the systems, platforms, and technology through them. 

Accountabilities

• Availability, performance, and scalability of systems and services through proactive monitoring, maintenance, and capacity planning.
• Resolution, analysis and response to system outages and disruptions, and implement measures to prevent similar incidents from recurring.
• Development of tools and scripts to automate operational processes, reducing manual workload, increasing efficiency, and improving system resilience.
• Monitoring and optimisation of system performance and resource usage, identify and address bottlenecks, and implement best practices for performance tuning.
• Collaboration with development teams to integrate best practices for reliability, scalability, and performance into the software development lifecycle, and work closely with other teams to ensure smooth and efficient operations.
• Stay informed of industry technology trends and innovations, and actively contribute to the organization's technology communities to foster a culture of technical excellence and growth.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• 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 will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders to achieve outcomes.

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-Site Reliability Engineer 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-Site Reliability Engineer you should have experience with:

• Experience with setup/configuration/support of SQL Server 2014,2016, 2017, 2019, 2022.
• Proven track record of implementing and leading SRE practices across large organizations or complex teams.
• Expert-level knowledge of telemetry, monitoring, and platform observability tooling (e.g. ESAAS etc) with experience in customizing and scaling these solutions.
• Experience in implementing modern DevOps and SRE practices in enterprise environments.
• Proven expertise in SQL query optimization and database performance tuning at scale.
• Experience with DevOps automation tools such as Code versioning (git), JIRA, Ansible, Containers and Kubernetes , database CI/CD tools and their implementation.
• Hands-on as DevOps on Ansible, Powershell, T SQL coding.
• Experience configuring and all components of the MS SQL set Core DB engine and SSRS, SSAS, SSIS, Replication topologies, AlwaysOn, Service Broker, Log Shipping, Database Snapshots etc and Windows Clustering.
• 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.
• Expert knowledge of backup and recovery.
• Good knowledge on PowerShell scripting.
• The resource would be handling major escalated incidents, complex problem record.
• This includes periodic review of systems, capacity management, on boarding new services, patching coordination & maintain good health of these.
• Take responsibility for completing tasks, focusing on requirements and planning to meet client needs, which the job holder helps to identify, advise and recommend technical solutions based on experience and Industry knowledge.
• Driving Automations agenda - Identifying the possibility of automation in database area and work to deliver it.

Some other highly valued skills may include:

• Desirable experience on database automation will be preferred.
• Strong skills in designing and delivering platforms to hosts SQL server, covering HA and DR, at Enterprise scale.
• Experience with tape backup tools like TSM/TDP/DDBoost/BoostFs/Rubrik etc.
• Knowledge of the ITIL framework, vocabulary and best practices.
• Understanding of Cloud Based Computing particularly RDS\Azure.
• Expert in system configuration management tools such as Chef, Ansible for database server configurations.
• Expert expertise with scripting languages (e.g. PowerShell) for automation/migration tasks.

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 Pune.