SQL L2 Infrastructure Administrator

Thiruvananthapuram, Kerala
Permanent
Full-time

6 hours ago

Job Description:Role Overview : We are seeking a SQL L2 Infrastructure Administrator with strong experience in on-premises SQL Server environments. The role focuses on maintaining stability, availability, and performance of database infrastructure hosted on physical/virtual servers within data centers. The candidate will handle operational support, incident resolution, and routine database maintenance activities.Key Responsibilities:

Monitor and support on-prem SQL Server instances across multiple environments (Production, UAT, DR)
Respond to s, incidents, and service requests within SLA timelines
Perform routine database maintenance:

Backup verification and restore validation
Index rebuild/reorganization
DBCC checks and health monitoring
Troubleshoot:

SQL Server performance issues (CPU, memory, disk I/O)
Database connectivity and login issues
Failed jobs, long-running queries, blocking/deadlocks
Manage SQL Server Agent jobs and scheduled tasks
Support user access management (logins, roles, permissions, AD-integrated access)
Assist with patching activities (Windows & SQL Server) in coordination with infra teams
Perform capacity monitoring (disk space, database growth, tempdb usage)
Validate and monitor HA/DR setups:

Always On Availability Groups
Failover Cluster Instances (FCI)
Log Shipping
Support backup and recovery operations, including point-in-time restores
Participate in release/deployment activities and perform post-release validations
Maintain runbooks, SOPs, and operational documentation
Escalate complex issues to L3 teams with proper diagnostics

Required Skills & Qualifications:

5+ years of experience in SQL Server Administration (On-Premises)
Strong hands-on experience with:

Microsoft SQL Server (2012 / 2016 / 2019 / 2022)
SQL Server Management Studio (SSMS)
Good understanding of:

Windows Server OS and basic system administration
Disk/storage concepts (SAN/NAS, IOPS, latency)
Backup & recovery strategies
Experience with:

SQL Agent Jobs
T-SQL (basic queries, troubleshooting scripts)
Performance monitoring and tuning basics
Familiarity with Active Directory integration for SQL Server security
Experience working with ticketing tools (e.g., ServiceNow)
Understanding of ITIL processes (Incident, Change, Problem Management)

L2 Support Expectations:

Own and resolve P2/P3 incidents independently
Provide initial diagnosis and coordination for P1 incidents
Ensure SLA compliance and proper documentation in tickets
Perform trend analysis and highlight recurring issues
Collaborate with L1 and L3 teams for faster resolution
Participate in on-call support rotation (if required)

Skills:SQL Server Administration,T-SQL,ITIL, Powershell,SSISAbout Company:UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.

UST

Apply Now