SQL Server

Key Responsibilities

• Architect, design, and implement solutions across Visual Studio environments (SSIS ETL, ASP.net, administrative automation, data warehousing)
• Develop, support, and troubleshoot T-SQL code, C#, and PowerShell solutions
• Build and manage CI/CD pipelines using Azure DevOps, Docker, and other best practices
• Perform database administration (DBA) tasks for MS SQL Server environments (On-Prem VM/Azure VM & Azure SQL)
• Design and optimize database schemas for OLAP and data warehousing requirements
• Develop, support, and promote SSRS reports and SSAS cubes
• Monitor system performance and perform performance tuning using tools like SQL Profiler, Query Analyzer, Execution Plan
• Follow Agile/Kanban methodologies for project delivery
• Document solutions, pipelines, database structures, runbooks, and automation procedures
• Collaborate with cross-functional teams and ensure adherence to best practices
• Maintain high attention to detail and ensure high-quality deliverables