Senior Team Lead | MS SQL | Bengaluru | Engineering | Hybrid Cloud Engineering

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Bengaluru; On-site; INR 1,000,000 - 1,800,000; Full time

Job summary

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft is seeking a MS-SQL DBA L2 to provide 24x7 database support across production systems. The role involves on-call duties during weekends and after-hours, managing incidents, changes, and requests, and ensuring BAU operations run smoothly.

The candidate should have strong knowledge of production database operations, ITIL processes, and experience in query optimization and routine maintenance tasks.

Qualifications

• Experience in 24x7 database support including incidents, requests and changes.
• Strong knowledge on Production Database Operations and BAU.
• Experience with ITIL framework and incident management.

Responsibilities

• Provide 24x7 database support including incidents, requests and changes.
• Provide on-call database support during week-ends and out of business hours.
• Provide 24x7 support for critical production systems.
• Manage production database operations and BAU activities.
• Troubleshoot data corruption and perform maintenance tasks.
• Prepare/Update SOPs documents (Technical & Operational).

Skills

MS-SQL

Always-ON

Clustering

Performance Tuning

PostgreSQL

MongoDB

ITIL

Incident Management

Problem Solving

SQL Profiler

Performance Monitor

Index Maintenance

Education

Any Bachelor’s or Master’s degree

Tools

SQL Profiler

Performance Monitor

Autosys

DB Mirroring

Job description

Select how often (in days) to receive an alert:

Shift (If Applicable) – 24*7 (Morning, Second & Night, with on-call support during weekends)

The team

Engineering helps empower and drive mission-critical solutions whether we need to modernize existing systems or implement new technology products and platforms. Through innovation, we improve financial performance, accelerate new digital businesses and fuel growth. Learn more about Engineering, AI and Data

MS-SQL DBA L2 with good knowledge on Always-ON, Clustering, Performance Tuning, PostgreSQL or MongoDB technology support is an added advantage.

• Providing 24* 7 database support including incidents, requests & changes.
• Providing on-call database support during week-ends & out of business hours.
• Provide 24x7 support for critical production systems.
• Strong knowledge on Production Database Operations & understanding the importance of BAU
• Good Knowledge onITIL Framework
• Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients
• Strong analysis skills, Problem Solving and Decision making
• Willing to accept/take responsibility and problem ownership
• Skill-up on new concepts, features and Open source technology and being Mentors
• Ability to work in a rapidly changing environment
• Planning and execution of PSU Patching & Upgradation of SQL Server (Legacy Mgt)
• Good Experience on automating PSU Patching, installations and other BAU tasks
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries, blockings and deadlocks.
• Knowledge on index de-fragmentation, re-indexing and update the index statistics
• Configuration & Monitoring High Availability, Log-Shipping, DB Mirroring, Replication, Clustering and Always-ON
• Periodical Backups of the database and timely recovery when required. Scheduling the automated backup jobs
• Scheduling, Monitoring and Trouble shooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans
• Education : Any Bachelor’s or Master’s degree
• Must have good team working skills balanced with ability to work in shifts (24x7 on rotation basis) / ability to work alone and a positive attitude.
• Provide 24x7 support for critical production systems.
• Strong knowledge on Production Database Operations & understanding the importance of BAU
• Good Knowledge onITIL Framework
• Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients
• Good knowledge on Presentation skills with PPT and expert in Excel with functions & Macros
• Good Experience on Client projects/domain, End-to-End Project management, setting-up technology Roadmap
• Strong analysis skills, Problem Solving and Decision making
• Planning and execution of PSU Patching & Upgradation of SQL Server (Legacy Mgt)
• Good Experience on automating PSU Patching, installations and other BAU tasks
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries, blockings and deadlocks.
• Knowledge on index de-fragmentation, re-indexing and update the index statistics
• Configuration & Monitoring High Availability, Log-Shipping, DB Mirroring, Replication, Clustering and Always-ON
• Periodical Backups of the database and timely recovery when required. Scheduling the automated backup jobs
• Scheduling, Monitoring and Trouble shooting SQL Agent Jobs/Autosys Maintenance Jobs & Maintenance Plans
• Trouble Shooting and fixing Data corruption (Page, table level)
• Preparing/Updating SOPs documents (Technical & Operational)

Good to have:

• Experience of handling very large environment, min 500+ SQL Instances and TB's of database size