SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL

HCL Technologies Limited; Uttar Pradesh; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

HCL Technologies Limited is seeking an experienced L3 Database Engineer with deep Microsoft SQL Server expertise to own stability, performance, security, and recoverability of the production database estate.

You will serve as the final technical escalation point, mentor junior DBAs, and collaborate with application, infrastructure, security, and cloud teams to keep databases reliable, scalable, and compliant.

Qualifications

• Experience owning production SQL Server estates and incident management.
• Design, implement, and validate high availability and disaster recovery solutions.
• Proficient in query tuning, indexing, and performance baselining.
• Strong RCA skills using logs, Extended Events, DMVs, and Query Store.
• Experience with on-call rotation and timely incident response.

Responsibilities

• Act as final escalation point for complex SQL Server issues escalated by L1/L2 teams.
• Lead P1/P2 incident resolution including outages, corruption, failovers, and performance degradation.
• Perform RCA and document permanent fixes; track problem records to closure.
• Raise Premier/Unified Support cases and coordinate across teams (application, infra, security, cloud).
• Plan and execute backups, patching, and migrations with minimal downtime.
• Maintain BAU monitoring, alerting, and performance baselines.

Skills

Microsoft SQL Server

Performance tuning

HA/DR design

Root cause analysis

Extended Events

Query Store

DMVs

PowerShell/dbatools

On-call escalation

Tools

Ola Hallengren scripts

SSMS

Azure SQL Database/SQL MI

SQL Server patching/upgrades

Job description

Job Summary

We are looking for an experienced L3 Database Engineer with deep expertise in Microsoft SQL Server to own the stability, performance, security, and recoverability of our production database estate. As the final technical escalation point above the L1 and L2 teams, you will resolve complex and business-critical SQL Server issues, lead root cause analysis, design high availability and disaster recovery solutions, and drive automation and continuous improvement. You will also mentor junior DBAs and work closely with application, infrastructure, security, and cloud teams to keep databases reliable, scalable, and compliant.

L3 Incident, Problem, and Escalation Management

• Act as the final technical escalation point for complex SQL Server issues escalated by L1 and L2 teams.
• Lead the resolution of P1/P2 incidents such as database outages, corruption (DBCC CHECKDB errors), failover failures, TempDB contention, and severe performance degradation.
• Perform in-depth root cause analysis (RCA) using error logs, Extended Events, DMVs, and Query Store, and document permanent fixes.
• Own problem records for recurring database issues and drive them to closure.
• Raise and manage Microsoft Premier/Unified Support cases for product defects.
• Participate in the rotational on-call schedule for after-hours critical support.

Performance Tuning and Query Optimization

• Analyze and tune slow-running queries, stored procedures, and workloads using execution plans, wait statistics, DMVs, Query Store, and Extended Events.
• Resolve blocking, deadlocks, parameter sniffing, plan regressions, and TempDB and memory pressure.
• Design and maintain indexing strategies, including index and statistics maintenance (for example, Ola Hallengren scripts).
• Tune instance-level settings such as MAXDOP, cost threshold for parallelism, max server memory, and TempDB configuration.
• Review T-SQL code from development teams and recommend optimizations before release.
• Establish performance baselines and proactive alerting.

High Availability and Disaster Recovery

• Design, implement, and support Always On Availability Groups, Failover Cluster Instances (WSFC), log shipping, and transactional, merge, and snapshot replication.
• Troubleshoot AG synchronization issues, listener problems, quorum and cluster failures, and replication latency.
• Define and maintain backup and restore strategies (full, differential, transaction log) that meet agreed RPO and RTO targets.
• Plan and run periodic DR drills, failover tests, and restore validations, and document the results.
• Maintain up-to-date DR runbooks and recovery procedures.

Installation, Upgrades, Patching, and Migrations

• Build and configure SQL Server instances (2016, 2017, 2019, 2022) to approved standards and hardening baselines.
• Plan and execute version upgrades, Cumulative Update (CU) and security patching with minimal downtime.
• Lead database migrations, including on-premises to Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, or AWS RDS for SQL Server.
• Review and approve database changes and deployment scripts through the change management (CAB) process, with implementation and rollback plans.

Security, Compliance, and Audit

• Manage logins, users, server and database roles following least-privilege principles, with AD and Microsoft Entra ID integration.
• Implement encryption and data protection features such as TDE, Always Encrypted, TLS, Dynamic Data Masking, and Row-Level Security.
• Configure SQL Server Audit and support internal and external audits (for example, SOX, ISO 27001, GDPR, HIPAA, GxP, as applicable).
• Remediate vulnerabilities and security findings within defined timelines and conduct periodic access reviews.

Automation, Monitoring, and Continuous Improvement

• Automate health checks, backups, patching, provisioning, and reporting using PowerShell (dbatools),…