Salim Tanwar

Experience

• 

  Allscripts India

  Jul 2012 - Dec 2016

  Database Support Analyst

  >> Worked in Client Technical Services (CTS) Team which is Proactive Application Monitoring team in Allscripts.>> Worked on Alert Handling and Monitoring.>> Had an internal monitoring tool called eGurkha Agent or eG Agent (which is a service) that would run on client servers and trigger alerts if thresholds are met or exceeded.>> Received Alerts sent by eG AGent in internal tool called Pulse (Previously Dashboard) and handle alerts according to Standard Procedures and Documentation.>> Create cases using CRM tools like Salesforce / SNOW and engage various Product Support Teams if required.>> Worked with Client Experience Account Managers (CEAM) to prepare monthly reports which would be shared with clients.>> Perform daily task activity which is analyzing and verifying overall Server health, like CPU utilization, MSMQ count so on and so forth.>> Check data file and log file free space on SQL Server Database. Check for blocking and long running open transactions, so on and so forth.>> Provided 24 * 7 On-Call support. Show less

• 

  Allscripts

  Jan 2017 - Mar 2018

  Technical Support Consultant

  >> Worked in Product Support Team to provide support for Allscripts Solutions like Sunrise Clinical Manager (SCM), Employee Health Record (EHR) and Touch Works EHR.>> Worked in Sunrise Backend team which would deal with Application performance issues like slowness experienced to users while using application and also L1 priority issues like Application down.>> Reviewing eToolKit traces ( Extended Events trace), which is a trace that would run on client's SQL Server Database Server 24 * 7.>> Identify slow running queries, fetch their execution plan and review them.>> Open Development Assist with Development team for queries that would require code change for optimization.>> Take the optimized code (Stored Procedures) and deploy them in Client's TEST and PROD system and validate the performance. Show less

• 

  Allscripts India

  Mar 2018 - Nov 2021

  Senior Database Administrator

  >> Worked in Product Support Team to provide support for Allscripts Solutions like Paragon, Sunrise Clinical Manager (SCM), Employee Health Record (EHR) and Touch Works EHR.>> Worked in Paragon Systems Support team which would deal with Application performance issues like slowness experienced to users while using application and also L1 priority issues like Application down.>> Reviewing Block Duration trace ( SQL Profiler trace) and Blocked Process Report, which is a trace that would run on client's SQL Server Database Server 24 * 7.>> Identify slow running queries, fetch their execution plan and review them.>> Perform first level of troubleshooting like updating statistics / rebuilding indexes on a table, recompile Stored Procedures and validate the performance.>> Identify lead blocker in the database in case of blocking in the database and clear them by taking client's permission.>> Identify long running open transaction in the database that would cause performance issues, provide its details to the client and help them in clearing it.>> Open Development Assist with Development team for queries that would require code change for optimization.>> Take the optimized code (Stored Procedures) and deploy them in Client's TEST and PROD system and validate the performance. Show less

• 

  Altera Digital Health

  Nov 2021 - now

  Expert Database Administrator and Team Lead

  >> Worked in Product Support Team to provide support for Allscripts Solutions like Paragon, Sunrise Clinical Manager (SCM), Electronic Health Record (EHR) and Touch Works EHR.>> Worked in Paragon Systems Support team which would deal with Application performance issues like slowness experienced to users while using application and also L1 priority issues like Application down.>> Reviewing Block Duration trace ( SQL Profiler trace) and Blocked Process Report, which is a trace that would run on client's SQL Server Database Server 24 * 7.>> Identify slow running queries, fetch their execution plan and review them.>> Perform first level of troubleshooting like updating statistics / rebuilding indexes on a table, recompile Stored Procedures and validate the performance.>> Identify lead blocker in the database in case of blocking in the database and clear them by taking client's permission.>> Identify long running open transaction in the database that would cause performance issues, provide its details to the client and help them in clearing it.>> Open Development Assist with Development team for queries that would require code change for optimization.>> Take the optimized code (Stored Procedures) and deploy them in Client's TEST and PROD system and validate the performance. Show less