• 11+ Years of IT industry experience in all aspects of Business intelligence applications with a strong background in Database development, Data Warehousing /Decision support systems and Business Intelligence
• Extensive experience of MS-SQL Server 2012, 2014, 2016 in production & development environment.
• Extensive experience and knowledge of backups, restores, recovery models
• Frequent database refresh of lower environments using production backups.
• Identifying blocking sessions, log shipping, mirroring and connectivity issues in SQL Server and coordinating with application team to resolve it.
• Experience using Performance monitor and SQL Profiler in diagnosing performance issues.
• Experience in detecting and troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Performing quarterly bcp exercise in SQL server i.e using its HA solution Mirroring and Log shipping.
• Strong Experience in working on BI Dashboards(Power Bi/Qlikview).
• Expertise on Power BI (Desktop & Service) with different sources such as Flat file,Salesforce, Azure Log Analytics, Web, MS SQL server & Tabular SSAS.
• Well experienced in ETL data flows using SQL Server Integration Services (SSIS.
• Experience on TSQL development .