MSSQL Database Administrator

HCL Technologies Limited; Lucknow; On-site; INR 2,000,000 - 4,000,000; Full time

Job summary

HCL Technologies Limited in Lucknow, Uttar Pradesh, is seeking an MSSQL Database Administrator with 6–12 years of experience to manage enterprise-grade SQL Server databases in an on-site environment.

The role emphasizes Azure IaaS administration, high availability, disaster recovery, and robust security practices. You will monitor, tune, and maintain SQL Server performance while ensuring compliance with change and incident processes in a large enterprise setting.

Qualifications

• Strong hands-on experience in Microsoft SQL Server Database Administration.
• Expertise in SQL Server installation, configuration, patching, upgrades, migrations, and version management.
• Hands-on experience administering SQL Server on Azure IaaS (Azure Virtual Machines).
• Strong knowledge of SQL Server backup, restore, recovery models, and disaster recovery strategies.
• Experience implementing HA/DR solutions including Always On, FCI, WSFC, Log Shipping, and Replication.
• Performance monitoring, tuning, and index optimization for SQL Server.
• Security knowledge including authentication, authorization, encryption (TDE), user access, and auditing.
• DBCC CHECKDB and proactive health monitoring implementations.
• Troubleshooting production issues: performance, blocking, deadlocks, CPU, memory, storage, connectivity.
• SQL Server Agent, maintenance plans, capacity planning, and proactive monitoring.
• Understanding of Windows Server environments supporting SQL Server deployments.
• Experience with Azure Virtual Machines, Managed Disks, Availability Sets/Zones, Azure Backup, and Monitor.
• PowerShell scripting for SQL Server administration and automation is preferred.
• Experience in enterprise production environments with Incident, Change, and Problem Management processes.
• Strong analytical, troubleshooting, communication, and documentation skills.

Responsibilities

• Manage Microsoft SQL Server databases in production environments.
• Install, configure, patch, upgrade, and migrate SQL Server instances.
• Administer SQL Server on Azure IaaS (Azure VMs).
• Implement backups, restores, DR, and recovery strategies.
• Design HA/DR solutions including Always On, FCI, WSFC, and log shipping.
• Monitor performance, tune queries, and optimize indexes.
• Ensure security, auditing, and encryption (TDE) for data protection.
• Troubleshoot production issues: blocking, deadlocks, resource contention.
• Use SQL Server Agent, maintenance plans, and capacity planning.

Skills

SQL Server DBA

Azure IaaS

HA/DR

Performance tuning

Security & encryption

DBCC CHECKDB

Troubleshooting

PowerShell

Windows Server

Incident management

Job description

Job Title: MSSQL Database Administrator

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

Experience: 6 Years to 12 Years

We are looking for experienced professionals with strong expertise in Microsoft SQL Server Database Administration and Azure Infrastructure as a Service (Azure IaaS) to support enterprise-scale database environments.

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.
• Hands-on experience administering SQL Server on Azure IaaS (Azure Virtual Machines).
• 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.
• Good understanding of Windows Server environments supporting SQL Server deployments.
• 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.

Preferred

• Microsoft SQL Server and/or Microsoft Azure certifications are an added advantage.
• Experience supporting large-scale, mission-critical database environments.

This is a location-specific hiring only for Lucknow.