Track Manager (Support & Operations) (IN)
HCLTech
HCLTech
Seeking a seasoned MS SQL Server L3 Administrator to oversee, enhance, and support large-scale SQL Server environments. This role is pivotal for ensuring the robust performance, security, and reliability of our databases. Responsibilities include deep-level database administration, expert troubleshooting of critical incidents, and implementing advanced high availability solutions.
Join our team to manage and optimize enterprise SQL Server infrastructure. You'll be instrumental in maintaining production, UAT, and development databases, ensuring seamless operations and rapid resolution of complex issues. This is an opportunity to make a significant impact on critical database systems.
Administer and maintain Microsoft SQL Server databases across production, UAT, and development environments. Perform advanced database troubleshooting and provide L3 support for critical incidents. Design, implement, and manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, Log Shipping, Replication, and Clustering. Monitor database performance, proactively identifying and resolving bottlenecks. Conduct query optimization, index tuning, and in-depth performance analysis. Implement and manage robust backup, recovery, and capacity planning strategies. Ensure database security, manage user access, roles, and permissions effectively. Support database migrations, upgrades, patching, and version management. Collaborate with application teams to resolve database-related issues and enhance performance. Develop and maintain operational documentation, SOPs, and knowledge repositories. Uphold organizational security and governance standards. Participate actively in on-call support and major incident management.
Proven expertise in Microsoft SQL Server 2016, 2019, or 2022 administration is essential. Hands-on experience with SQL Server installation, configuration, and ongoing maintenance. Demonstrated ability in implementing and managing Always On Availability Groups, Database Mirroring, Log Shipping, Replication, and SQL Clustering. Advanced proficiency in T-SQL, Stored Procedures, Functions, and query optimization techniques. Solid experience in SQL Server performance tuning and monitoring. Expertise in designing and executing effective backup and recovery strategies. Familiarity with SSRS, SSIS, and SSAS. Experience with PowerShell scripting for automation. Knowledge of Azure SQL Database and Managed Instance is a plus. Experience with monitoring tools like SolarWinds, SCOM, Redgate, or SQL Sentry is preferred. A Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field is required. Must be willing to participate in a 24x7 support rotation, including on-call duties.
HCLTech
IT Consulting