Database Lead - SQL Server/T-SQL

<p><p><b>Key Responsibilities : </b><br/><br/>- Design, develop, and maintain complex SQL queries, stored procedures, functions, and analytical functions.<br/><br/>- Work with MS SQL Server tools and SSIS (ETL) for data extraction, transformation, and loading.<br/><br/>- Troubleshoot and support existing Data Warehouse (DW) processes.<br/><br/>- Perform production-level performance tuning for MS SQL to ensure high efficiency.<br/><br/>- Monitor SQL Server performance and availability; implement best practices.<br/><br/>- Participate in SQL code reviews to maintain coding standards.<br/><br/>- Manage database backup & restore, disaster recovery testing, clustering, and replication.<br/><br/>- Collaborate effectively with cross-functional teams and thrive under high-pressure environments.<br/><br/><b>Desired Candidate Profile : </b><br/><br/>- Education : B.Tech / MCA or equivalent qualification.<br/><br/>- Experience : Minimum 5 years in database development or administration.<br/><br/>- Certifications : Database Management/Development certifications preferred.<br/><br/>- Methodologies : Experience in Agile/Scrum methodology; familiarity with JIRA is a plus.<br/><br/><b>Technical Skills (Must-Have)</b><br/><br/>- Databases : MS SQL Server (2016/2019+), T-SQL, Data Warehousing concepts<br/><br/>- ETL Tools : SSIS (SQL Server Integration Services)<br/><br/>- Performance Optimization : Query tuning, indexing strategies, execution plans<br/><br/>- High Availability & DR : Clustering, Replication, AlwaysOn, Backup/Restore strategies<br/><br/>- Scripting & Automation : PowerShell, SQL Agent Jobs, BI/Analytics Tools : SSRS, Power BI, Tableau integration<br/><br/>- Cloud Databases : Azure SQL, AWS RDS<br/><br/>- Other ETL Tools : Informatica, Talend (basic exposure)<br/><br/>- DevOps/Agile Tools : JIRA, Git, Jenkins for DB deployment automation<br/></p><br/></p> (ref:hirist.tech)