Subject Matter Expert (Support&Ops)
Technology, Data & Digital · Software & Web Development · Software Engineering · Data Engineering
In short
The MSSQL L3 DBA role at HCLTech in Lucknow, India, requires 10+ years of experience in administering, maintaining, and optimizing Microsoft SQL Server environments. Responsibilities include ensuring high availability, performance tuning, security compliance, disaster recovery, and leading complex database projects.
Responsibilities
- Manage and maintain Microsoft SQL Server databases across various environments (Development, Test, UAT, Production).
- Perform database installation, configuration, patching, and upgrades.
- Ensure database availability, integrity, security, and optimal performance.
- Analyze and resolve performance bottlenecks, optimize queries, indexes, and configurations.
- Implement and manage SQL Server Always On Availability Groups, Failover Cluster Instances, Replication, and Log Shipping.
- Develop and test disaster recovery procedures and business continuity plans.
- Configure and monitor backup strategies, perform restore and recovery operations.
- Implement database security best practices, manage user access, roles, permissions, and encryption.
- Handle critical P1/P2 production incidents, perform root cause analysis, and provide fixes.
- Participate in On-Call and escalation support.
- Lead database migration projects and execute SQL Server upgrades.
- Develop scripts using T-SQL and PowerShell to automate routine DBA activities.
- Create and maintain operational runbooks, SOPs, and technical documentation.
- Work closely with application, infrastructure, and security teams, following ITIL processes.
- Ensure on-time resolution and quality compliance of escalated tickets.
- Perform value-addition activities like mentoring, preparing SOPs, and knowledge sharing.
- Act as a liaison to the business segment for communication and presentations.
- Validate Change Order Implementation Plans and participate in capacity planning.
- Ensure positive customer feedback and satisfaction through active participation in customer meetings.
- Validate analyses and reports for key business stakeholders.
Requirements
- Microsoft SQL Server 2012/2014/2016/2017/2019/2022
- SQL Server Always on Availability Groups
- Performance Tuning and Query Optimization
- Backup & Recovery
- Replication, Log Shipping, Clustering
- SQL Server Agent
- T-SQL Scripting
- PowerShell Scripting
- Database Security and Auditing
- Troubleshooting and Root Cause Analysis
- Monitoring Tools (SolarWinds, Dynatrace, etc.)
- Windows Server Administration (basic to intermediate)
Desired Qualifications
- Azure SQL Database / Managed Instance
- DBA Automation
- Cloud Migration Projects
- ITIL Processes
- CIS Benchmark Implementation
- Strong analytical and troubleshooting skills
- Ownership and accountability
- Customer-focused approach
- Excellent communication and stakeholder management
- Ability to work under pressure in critical environments
- Team collaboration and mentoring capabilities
Benefits
- Supercharge your potential.
- Find your career.
- Find your spark.
- A place that knows that helping its customers stay on top starts by putting its people first.
- Global technology company with over 223,000 people across 60 countries.
- Delivering industry-leading capabilities centered around digital, engineering, cloud, and AI.
- Work with clients across all major verticals including Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
#Database Administration#L3 Support#MSSQL#Microsoft SQL Server#Performance Tuning#High Availability#Disaster Recovery#Backup#Recovery#Security#Compliance#Automation#Scripting#T-SQL#PowerShell#Windows Server#Azure#ITIL
Company
HCLTech
Job Posted
3 weeks ago
Employment Type
Full Time
WorkMode
On Site
Experience Level
Senior
Locations
Lucknow, India
Applicants
Be an early applicant