SeniorAdministrator - AzureMSSQL DBA, Microsoft Azure
India
Apply now
Job Description
SeniorAdministrator - AzureMSSQL DBA, Microsoft Azure
Chennai, Tamil Nadu

Job Summary

Database Administration Install, configure, and maintain MS SQL Server (2016/2017/2019/2022). Manage database instances, schemas, tables, indexes, and storage structures. Perform database upgrades, migrations, and patching activities. Ensure database health, integrity, and consistency. 2. Performance Tuning & Optimization Analyze and optimize slow-running queries using execution plans. Perform index optimization, partitioning, and query tuning. Identify bottlenecks in CPU, memory, I/O, and storage. Implement best practices for performance monitoring and improvement. 3. High Availability & Disaster Recovery (HADR) Configure and manage: Always On Availability Groups Failover Cluster Instances (FCI) Log Shipping Replication (Transactional, Merge, Snapshot) Ensure DR readiness and perform failover testing. Design and implement backup and recovery strategies. 4. Backup & Recovery Design and manage backup strategies (Full, Differential, Log backups). Perform point-in-time recovery and restore operations. Ensure backup validation and compliance with RPO/RTO. 5. Troubleshooting & Incident Management Act as Level 3 escalation point for critical database issues. Perform root cause analysis (RCA) and provide permanent fixes. Handle production incidents and performance degradation issues. Work closely with application and infrastructure teams. 6. Security & Compliance Implement database security (logins, roles, permissions). Manage encryption (TDE, SSL, Always Encrypted). Conduct vulnerability assessments and audits. Ensure compliance with organizational and regulatory standards. 7. Automation & Monitoring Develop scripts using T-SQL, PowerShell for automation. Implement monitoring tools (SQL Server Agent, Extended Events, Profiler, SCOM, SolarWinds, etc.). Set up alerts and proactive monitoring mechanisms.

Key Responsibilities

Database Administration Install, configure, and maintain MS SQL Server (2016/2017/2019/2022). Manage database instances, schemas, tables, indexes, and storage structures. Perform database upgrades, migrations, and patching activities. Ensure database health, integrity, and consistency. 2. Performance Tuning & Optimization Analyze and optimize slow-running queries using execution plans. Perform index optimization, partitioning, and query tuning. Identify bottlenecks in CPU, memory, I/O, and storage. Implement best practices for performance monitoring and improvement. 3. High Availability & Disaster Recovery (HADR) Configure and manage: Always On Availability Groups Failover Cluster Instances (FCI) Log Shipping Replication (Transactional, Merge, Snapshot) Ensure DR readiness and perform failover testing. Design and implement backup and recovery strategies. 4. Backup & Recovery Design and manage backup strategies (Full, Differential, Log backups). Perform point-in-time recovery and restore operations. Ensure backup validation and compliance with RPO/RTO. 5. Troubleshooting & Incident Management Act as Level 3 escalation point for critical database issues. Perform root cause analysis (RCA) and provide permanent fixes. Handle production incidents and performance degradation issues. Work closely with application and infrastructure teams. 6. Security & Compliance Implement database security (logins, roles, permissions). Manage encryption (TDE, SSL, Always Encrypted). Conduct vulnerability assessments and audits. Ensure compliance with organizational and regulatory standards. 7. Automation & Monitoring Develop scripts using T-SQL, PowerShell for automation. Implement monitoring tools (SQL Server Agent, Extended Events, Profiler, SCOM, SolarWinds, etc.). Set up alerts and proactive monitoring mechanisms.

Skill Requirements

Database Administration Install, configure, and maintain MS SQL Server (2016/2017/2019/2022). Manage database instances, schemas, tables, indexes, and storage structures. Perform database upgrades, migrations, and patching activities. Ensure database health, integrity, and consistency. 2. Performance Tuning & Optimization Analyze and optimize slow-running queries using execution plans. Perform index optimization, partitioning, and query tuning. Identify bottlenecks in CPU, memory, I/O, and storage. Implement best practices for performance monitoring and improvement. 3. High Availability & Disaster Recovery (HADR) Configure and manage: Always On Availability Groups Failover Cluster Instances (FCI) Log Shipping Replication (Transactional, Merge, Snapshot) Ensure DR readiness and perform failover testing. Design and implement backup and recovery strategies. 4. Backup & Recovery Design and manage backup strategies (Full, Differential, Log backups). Perform point-in-time recovery and restore operations. Ensure backup validation and compliance with RPO/RTO. 5. Troubleshooting & Incident Management Act as Level 3 escalation point for critical database issues. Perform root cause analysis (RCA) and provide permanent fixes. Handle production incidents and performance degradation issues. Work closely with application and infrastructure teams. 6. Security & Compliance Implement database security (logins, roles, permissions). Manage encryption (TDE, SSL, Always Encrypted). Conduct vulnerability assessments and audits. Ensure compliance with organizational and regulatory standards. 7. Automation & Monitoring Develop scripts using T-SQL, PowerShell for automation. Implement monitoring tools (SQL Server Agent, Extended Events, Profiler, SCOM, SolarWinds, etc.). Set up alerts and proactive monitoring mechanisms.

Other Requirements

Database Administration Install, configure, and maintain MS SQL Server (2016/2017/2019/2022). Manage database instances, schemas, tables, indexes, and storage structures. Perform database upgrades, migrations, and patching activities. Ensure database health, integrity, and consistency. 2. Performance Tuning & Optimization Analyze and optimize slow-running queries using execution plans. Perform index optimization, partitioning, and query tuning. Identify bottlenecks in CPU, memory, I/O, and storage. Implement best practices for performance monitoring and improvement. 3. High Availability & Disaster Recovery (HADR) Configure and manage: Always On Availability Groups Failover Cluster Instances (FCI) Log Shipping Replication (Transactional, Merge, Snapshot) Ensure DR readiness and perform failover testing. Design and implement backup and recovery strategies. 4. Backup & Recovery Design and manage backup strategies (Full, Differential, Log backups). Perform point-in-time recovery and restore operations. Ensure backup validation and compliance with RPO/RTO. 5. Troubleshooting & Incident Management Act as Level 3 escalation point for critical database issues. Perform root cause analysis (RCA) and provide permanent fixes. Handle production incidents and performance degradation issues. Work closely with application and infrastructure teams. 6. Security & Compliance Implement database security (logins, roles, permissions). Manage encryption (TDE, SSL, Always Encrypted). Conduct vulnerability assessments and audits. Ensure compliance with organizational and regulatory standards. 7. Automation & Monitoring Develop scripts using T-SQL, PowerShell for automation. Implement monitoring tools (SQL Server Agent, Extended Events, Profiler, SCOM, SolarWinds, etc.). Set up alerts and proactive monitoring mechanisms.
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.