Deloitte | India Offices of the US

Assistant Manager – Infrastructure SQL Services – Deloitte Support Services India Pvt. Ltd.

The ITS Operations function is accountable for delivering all internal technology infrastructure – including Email, Skype, File Services and platforms underpinning SQL, SAP, Enterprise (IT) Security Services. It also provides technology that supports the service lines in delivering clients facing or client engagements as part of its client IT services

Team Summary

The Infrastructure SQL Services team are responsible for managing SQL infrastructure including databases, servers and clusters throughout their lifecycle. This role plays an important part in the SQL related aspects of designing, testing, operating and improving IT services.

This is a large, enterprise SQL environment, underpinning many missions' critical applications. Interfacing business application owners, providing SQL support and guidance is a key element.

As the IT function is spread over multiple geographic locations, you will be expected to communicate and collaborate effectively with remote colleagues.

Responsibilities

•       Administer, maintain, and implement SQL Server databases (on-premises and cloud-based)

•       Oversee database performance tuning, query optimization, and troubleshooting for mission-critical systems

•       Implement and manage high availability and disaster recovery solutions (e.g., Always On Availability Groups, clustering, replication).

•       Develop, enforce, and monitor database security policies, including user access, encryption, and compliance with regulatory requirements.

•       Automate database maintenance tasks and develop scripts for monitoring and reporting.

•       Conduct root cause analysis for critical incidents and implement preventive solutions.

•       Collaborate with architects, developers, and infrastructure teams to align database solutions with business needs.

•       Maintain comprehensive documentation for database configurations, procedures, and standards.

•       Respond to service outages which affect Deloitte’s business operation and reputation, including out of hours escalations as part of a 24 x 7 on-call rota

•       Maintain the performance, availability and security of SQL services, with a focus on continuous service improvement

•       Installing and managing SSIS packages and writing and deploying SSRS reports

•       Proactive system \ platform availability checks

•       Server performance management and capacity planning

•       Troubleshooting and Break-fix (Incidents & Service requests)

•       Documentation and cross-training of other team members

•       Performs systematic and periodic application \ infrastructure availability check \ tasks

•       Share knowledge of new solutions with UK and Swiss Security Operations teams

•       Assist with client audits / MF Standards / ISO compliance and evidence gathering

Essential

·       In-depth knowledge and understanding of SQL working in a large-scale enterprise estate, including both on-premises and cloud hosted infrastructure

·       In depth knowledge of SQL high availability techniques, specifically AlwaysOn Availability Groups and Failover Cluster Instances

·       Experience with cloud database platforms (Azure SQL, AWS RDS, etc.).

·       Experience with installing and managing SSIS (integration services) packages and writing and deploying SSRS (reporting services) reports

·       Strong SQL performance tuning and troubleshooting skills

·       Strong experience in SQL backup and recovery processes

·       Fluent in T-SQL scripting

·       Experience in server performance management and capacity planning

·       Good knowledge of client/server architectures - this should primarily be centred upon, but not exclusively, the Microsoft suite of back-office products

·       PowerShell basic scripting

·       SolarWinds and SCOM monitoring

·       A solid understanding of the ITIL framework

·       Exceptional communications skills, both written and verbal

·       Diplomatic and persuasive with an ability to handle difficult conversations and confidently manage stakeholders

·       A strong track record of delivering continual service improvement

·       Be able to communicate effectively, technical issues with technical and non-technical audience

·       Able to work as part of a geographically separated team

Desirable

·       Database and server migration from on-premises architecture to cloud (Azure and AWS)

·       ITIL Service Operations knowledge preferred (Event Management, Incident Management, Change Management, and Problem Management).

·       Powershell advanced scripting

Tools & Technology

·       SQL Server 2017, 2019 and 2022

·       Azure/AWS (IaaS and PaaS)

·       SSRS, SSIS 

·       T-SQL and PowerShell Scripting 

·       SolarWinds, SCOM monitoring

·       RedGate SQL Monitor

·       ServiceNow

·       CyberArk- Password Management tool

Technical Certifications (Must have)

·       ITIL v3 or v4 Foundation

·       Certification in SQL Server & Azure cloud Technology  

Technical Certifications (Good to have)

·       DP-300 & AI-900 Certification

·       Azure fundamentals certification (AZ-900)