Summary
Position Summary
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)
Our purpose
Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities.
Our people and culture
Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work.
Professional development
At Deloitte, professionals have the opportunity to work with some of the best and discover what works best for them. Here, we prioritize professional growth, offering diverse learning and networking opportunities to help accelerate careers and enhance leadership skills. Our state-of-the-art DU: The Leadership Center in India, located in Hyderabad, represents a tangible symbol of our commitment to the holistic growth and development of our people. Explore DU: The Leadership Center in India .
Benefits To Help You Thrive
At Deloitte, we know that great people make a great organization. Our comprehensive rewards program helps us deliver a distinctly Deloitte experience that helps that empowers our professionals to thrive mentally, physically, and financially—and live their purpose. To support our professionals and their loved ones, we offer a broad range of benefits. Eligibility requirements may be based on role, tenure, type of employment and/ or other criteria. Learn more about what working at Deloitte can mean for you.
Recruiting tips
From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.Requisition code: 307462
