SQL Server & Azure IaaS Specialist

HCLTech; Lucknow; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

HCLTech Lucknow on-site is seeking an experienced SQL Server DBA with 6-12 years of hands-on expertise in SQL Server administration, installations, configurations, patching, migrations, and version management.

You will design and maintain HA/DR solutions (Always On, FCI, WSFC, log shipping), optimize performance, ensure security (TDE, auditing), perform health checks (DBCC CHECKDB), and collaborate with teams using PowerShell and Azure services.

Qualifications

• 6–12 years of experience in database administration, specifically SQL Server.
• Expertise in SQL Server installation, configuration, patching, upgrades, migrations, and version management.
• Strong knowledge of SQL Server backup, restore, recovery models, and DR strategies.
• Experience implementing and supporting HA/DR solutions including Always On, FCI, WSFC, and log shipping.
• Strong skills in performance monitoring, tuning, and index maintenance.
• Deep understanding of SQL Server security, authentication, authorization, encryption (TDE), auditing.
• Hands-on health checks with DBCC CHECKDB and proactive monitoring.
• Experience with Azure services and Windows environments for enterprise databases.

Skills

SQL Server DBA

HA/DR Implementation

Performance Tuning

Azure VMs

PowerShell Scripting

Security & Auditing

DBCC CHECKDB

Incident Management

Tools

SQL Server Agent

Maintenance Plans

WSFC

Azure Monitor

Job description

Location: HCLTech Lucknow, Uttar Pradesh (on-site)

Experience: 6 Years to 12 Years

Required Technical Expertise

• Strong hands-on experience in Microsoft SQL Server Database Administration.
• Expertise in SQL Server installation, configuration, patching, upgrades, migrations, and version management.
• Strong knowledge of SQL Server Backup, Restore, Recovery Models, and Disaster Recovery (DR) strategies.
• Experience implementing and supporting High Availability (HA) and Disaster Recovery (DR) solutions, including Always on Availability Groups, SQL Server Failover Cluster Instances (FCI), Windows Server Failover Clustering (WSFC), Log Shipping, and SQL Server Replication.
• Expertise in database performance monitoring, performance tuning, query execution plan analysis, index optimization, and database maintenance.
• Strong understanding of SQL Server security, including authentication, authorization, encryption (Transparent Data Encryption - TDE), user access management, and auditing.
• Hands-on experience performing database integrity checks using DBCC CHECKDB and implementing proactive database health monitoring.
• Experience troubleshooting production database issues related to performance, blocking, deadlocks, CPU, memory, storage, and connectivity.
• Hands-on experience with SQL Server Agent, Maintenance Plans, capacity planning, and proactive database monitoring.
• Experience with Azure Virtual Machines, Managed Disks, Availability Sets, Availability Zones, Azure Backup, and Azure Monitor.
• Knowledge of PowerShell scripting for SQL Server administration and automation is preferred.
• Experience working in enterprise production environments with Incident, Change, and Problem Management processes.
• Strong analytical, troubleshooting, communication, and documentation skills.
• Microsoft SQL Server and/or Microsoft Azure certifications are an added advantage.
• Experience supporting large-scale, mission-critical database environments.