•Expertise in Query Optimization, Performance tuning, DMV'S, analysing Locks.•Verifying and tuning SQL Queries written by developers by using execution plan, Database tuning advisor and improving efficiency in database including reindexing, updating statistics.•Troubleshooting escalated performance issue on production environment for premier/VIP customer•Intensive experience in Monitoring and tuning SQL server and database performance tuning using SQL Server Management… Show more •Expertise in Query Optimization, Performance tuning, DMV'S, analysing Locks.•Verifying and tuning SQL Queries written by developers by using execution plan, Database tuning advisor and improving efficiency in database including reindexing, updating statistics.•Troubleshooting escalated performance issue on production environment for premier/VIP customer•Intensive experience in Monitoring and tuning SQL server and database performance tuning using SQL Server Management Studio. •Identify the root cause of performance issue(Blocking, High CPU, Deadlock) and resolving them•Fixing hygiene issue for every Severity -2 Incidents & post-mortem review. •Assisting and collaborating solution Architect/ACE engineer to solve Azure SQL Performance/Availability issue on ERP and CRM side.•Ensuring minimal downtime for DB migration and failover.•Troubleshooting issue to with log file full and database size increasing beyond threshold.•Experience in solving database issue with index fragmentation, Optimization of Query, Index tuning, Update statistics, SQL Error. Show less

•Expert in analysing and fixing SQL Server performance issue such as high CPU, memory, blocking, wait stats, deadlock & storage issue.•Analysing SQL Execution plan, Performance reports and troubleshooting performance issue using Query store and extended events. •Optimize slow queries by creating Index, update stats, Query Hints & plan guides.•Debug complex customers issue using Kusto Explorer.•Creating DB maintenance plan. DB Backup and restoration… Show more •Expert in analysing and fixing SQL Server performance issue such as high CPU, memory, blocking, wait stats, deadlock & storage issue.•Analysing SQL Execution plan, Performance reports and troubleshooting performance issue using Query store and extended events. •Optimize slow queries by creating Index, update stats, Query Hints & plan guides.•Debug complex customers issue using Kusto Explorer.•Creating DB maintenance plan. DB Backup and restoration activity•proficiency in creating and managing SQL server Agent Jobs•Analysing clients environment and providing recommendation on SQL performance metrics like CPU, Memory & SQL server configuration in case of overall performance issue•Helped app team/customer support to debug common SQL Server issue before reaching out to Engineering team•Helped database monitoring team to detect & create alert for DB performance and Availability issue before customer raised an Incident •Applying Microsoft recommended best practices on SQL Server•Providing 24/7 on call supports for customers of Microsoft. •Troubleshooting database connectivity issue.•Troubleshooting escalated issue on production environment for premier or VIP Customers of Microsoft within SLA. •Performing SQL DB Tier Upgrade/Downgrade & Hyperscale Migration ensuring minimal downtime. •Assisting support engineer in resolving broad business and SQL server technology problem in a timely manner •Experience in using SQL DMV to identify SQL server issue.•Strong knowledge in SQL Concepts and T-SQL scripting •Administering thousand of azure SQL DB for different customers.•Speaking with clients/application and development team regarding SQL issue till it gets resolved.•Review every customer reported incidents and add Automation alert to detect those specific issue and self heal before customer gets impacted Show less

Create, manage and optimize resources in Azure including virtual machine, storage accounts &networking components. This involves using the Azure portal

Sonata Software trained on various software technologies and tools