Senior MSSql Database Administrator - L3

SHI Solutions India Pvt. Ltd.; Hyderabad; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

SHI Solutions India Pvt. Ltd. in Hyderabad seeks a senior Microsoft SQL Server administrator to deliver L3 production support for a large database environment underpinning critical business applications.

You will focus on high availability, performance, and stability, with involvement in migrations and transformations requiring hands-on SQL server, HA/DR, and incident management. This role covers on-premises to cloud migrations, capacity planning, automation with T-SQL, PowerShell, and Python,

Qualifications

• 8–10 years of experience in SQL Server administration for large environments.

Responsibilities

• Database Migration: Plan, execute, and validate complex migrations from on-premises to cloud; upgrade versions.
• Capacity Planning: Monitor growth and forecast storage, CPU, and memory needs.
• Automation: Develop/maintain scripts (T-SQL, PowerShell, Python) to automate tasks and deployments.
• Database Management: Install, configure, monitor, and maintain SQL Server 2016+ and Azure SQL across dev/test/production.
• Performance Tuning: Identify bottlenecks and implement tuning solutions.
• HA/DR: Design and manage Always On, Failover Clustering, replication, backup/recovery strategies.
• Security: Enforce DB security policies, manage user access and audits.
• Fabric & Cloud: Support Microsoft Fabric, Power BI, and Azure data services including ADF and ETL workflows.
• Documentation: Maintain thorough DB configurations and procedures.

Skills

SQL Server Admin

HA/DR design

T-SQL

PowerShell

Python

Automation

Performance tuning

Troubleshooting

Azure SQL

Power BI

Tools

SQL Server 2016+

Always On AGs

Failover Clustering

Azure Data Factory

Job description

We are seeking highly skilled Microsoft SQL server administrators responsible for providing L3 level production support for large SQL server database environment supporting critical business applications. The role focuses on ensuring high availability, performance, and stability of database systems. The position may also be involved in database migration and transformation initiatives, requiring strong hands-on skills in SQL server administration, HA/DR technologies, and incident/problem management.

Coverage

• Weekdays – US after hours coverage with partial overlap with US based resources

Key Responsibilities

• Database Migration: Plan, execute, and validate complex database migrations, including version upgrades, on premises to cloud, and consolidation projects.
• Capacity Planning: Monitor database growth trends and forecast future capacity requirements for storage, CPU, and memory.
• Automation: Develop and maintain scripts (T-SQL, PowerShell, Python) to automate routine administrative tasks, monitoring, and deployments.
• Database Management: Install, configure, manage, monitor, and maintain SQL Server instances (specifically 2016 and newer and Azure SQL) across development, testing, and production environments.
• Performance Tuning & Optimization: Proactively monitor database performance, identify bottlenecks (CPU, Memory, I/O), and implement tuning solutions.
• High Availability & Disaster Recovery (HA/DR): Design, implement, and manage robust HA/DR solutions, including Always On Availability Groups, Failover Clustering, Replication, and backup/recovery strategies.
• Security: Implement and enforce database security policies, manage user access and permissions, conduct regular security audits, and address vulnerabilities.
• Troubleshooting: Provide expert-level troubleshooting for database-related issues, perform root cause analysis, and implement corrective actions swiftly.
• Fabric & Cloud: Provide L3-level operational and engineering support for Microsoft Fabric, alongside administration and optimization of the Power BI platform and Microsoft Azure data services, including Azure Data Factory (ADF), ETL workflows, pipeline orchestration, and compute resource management.
• Documentation: Maintain comprehensive documentation of database configurations, processes, and procedures.

Preferred Qualifications

• Microsoft certifications: SQL 2016 and newer/Azure SQL
• Proficiency with Power BI Platform.
• Experience in DevOps tools like TSQL, Jenkins, Ansible
• Azure certification is a plus.
• Minimum 8-10 years of experience is mandatory