Delivery Manager | MS SQL | Bengaluru | Engineering

Delivery Manager | MS SQL | Bengaluru | Engineering Job requisition ID : 98569 Location : Bengaluru Entity : Deloitte Touche Tohmatsu India LLP Delivery Manager | EA&D-Engineering | SQL DBA Location: Bengaluru The team Engineering helps Reimagine and re-engineer mission-critical operations and processes; Leverage engineering-led design, deep industry knowledge, and AI and data-driven insights to transform the technology platforms at the heart of business. Working alongside team, we 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 Your work profile Were looking for aSenior Microsoft SQL Server DBAto operate, secure, and optimize enterprise SQL platforms running on aSoftwareDefined Data Center (SDDC). You will ownHA/DR,backup & recovery,performance tuning,capacity planning, andpatching/upgradesfor SQL Server instances and clusters running onVMware vSphere/vSAN/NSXT(and hybrid, as applicable). The role partners closely with app, infra, and security teams to deliverhigh availability, compliance, and costefficientdatabase services. Key Responsibilities Database Operations & Reliability AdministerSQL Server 2012/2016/2017/2019/2022across standalone, clustered, and AG topologies. OwnHA/DRdesign and operations:Always On Availability Groups,Failover Cluster Instances (FCI),Log Shipping,Replication(Transactional/Snapshot), andgeoDRpatterns. Implement and validatebackup & recovery(full/diff/log),pointintime restore, and recovery runbooks using enterprise tools (e.g.,Veeam, Commvault, Rubrik, Cohesity) and native SQL backups. Leadpatching, CU/Service Packrollouts, version/edition upgrades, migration planning (sidebyside, rolling upgrades), and decommissioning with data retention controls. Performance Engineering Proactively monitor and tuneworkloads, queries, indexes, and statistics; leverageQuery Store,Extended Events,DMVs, execution plans, baseline metrics. Implement smartindexing strategies(covering, filtered, columnstore), statistics management, and parameter sniffing mitigations. Rightsize server/VM resources (vCPU, memory, storage IOPS/latency) and coordinate with SDDC teams for contention mitigation (NUMA, reservations, storage policy). SDDC/Virtualization Alignment Operate SQL workloads onVMware vSphere/ESXi/vCenter, align withvSAN/SAN/NASstorage policies (latency, throughput, RW patterns), andNSXTnetworking (segments, microsegmentation). Participate incapacity planning(compute, memory, IOPS), placement policies (antiaffinity for AG replicas), andchange managementwith infra teams. SupportDRwithSRM/HCXwhere applicable, and documentRPO/RTObacked runbooks. Security, Compliance & Governance ImplementTDE,backup encryption,row/columnlevel security,Always Encrypted, TLS certs; manageLogins/Users/Roles,least privilege, andseparation of duties. Enforceauditing(SQL Audit, serverlevel and DBlevel), data classification/retention policies, andcompliancealignment (e.g., CIS, organizational baselines). Remediate vulnerabilities (CVE tracking), secure endpoints, and maintainprivileged accessprocesses. Data Services & Platform Integration SupportSSIS/SSRS/SSAS(as applicable), Linked Servers, Agent Jobs, Database Mail, and alerts. Partner with app teams onschema design, deployment pipelines (CI/CD), andchange reviews. Contribute toautomationusingPowerShell(dbatools),TSQL,Ansible, or pipelines (Git, Azure DevOps/Jenkins/GitLab). Observability & Operations Excellence Implement and tune monitoring/alerting with tools likeSQL Sentry/SentryOne, Redgate, Idera (SQL DM), SolarWinds DPA, SCOM, orPrometheus exporters + Grafana. MaintainSOPs, runbooks, KBs, CMDB entries, andarchitecture/DR diagrams. Provide L2/L3 support, lead incident/problem/change (ITIL) processes, drive RCAs and preventive actions, and participate in oncall rotation. 710 years handson MS SQL Server administration in enterprise environments. Key skills required: HA/DR:Always On AGs, FCI, Log Shipping, Replication; DR drills and failover runbooks. Performance tuning:Query tuning, indexing, statistics, wait analysis, baselining, Extended Events/Query Store. Backup/Recovery:Strategy design, PITR, validation, restore testing; enterprise backup suites and native SQL. Security:TDE, encryption in transit, auditing, RBAC, credential management, data masking/classification. SDDC operations:Running SQL onVMware vSphere; storage/network considerations (vSAN/SAN/NAS, VLANs/segments, microsegmentation). Automation & Scripting:PowerShell,TSQL; version control withGit. Patching/Upgrades/Migrationswith minimal downtime approaches. Strong troubleshooting, documentation, and stakeholder communication skills; ITIL exposure. Experience with Azure SQL (IaaS SQL on Azure, Azure SQL MI/DB) or hybrid connectivity. Familiarity with Kubernetes/Containers (running SQL on Windows/Linux containers where appropriate). Exposure to DevOps for DB (schema drift detection, Redgate toolchain, automated deployments). Knowledge of storage performance engineering (queue depth, IOPS/throughput, writelog latency). Certifications: Microsoft DP300 (Administering Relational Databases on Microsoft Azure), legacy MCSE: Data Management & Analytics, VMware VCPDCV, ITIL v3/4.