Sankalp Chordia

Experience

1. Sql Server Database Administrator (Azure,iaas)

   HCLTech

   Jul 2016 — Present · Noida, IN

   Working as a Sql server DBA for client Microsoft:Responsibilities and skills:• Experience working on Azure and Hyper-v machines (Infrastructure as a service) and troubleshooting the same.• Troubleshooting Sql server clustering and Always-on issues on Azure servers using cluster logs.• Troubleshooting performance issues related to memory,cpu and io bottlenecks using errorlogs, Perfmon counters, SCOM,Event viewer, DMVs, etc.• Performing RCA for performance issues related to Sql server and cluster issues in Iaas environment.• Creating Power shell scripts for ad hoc requests and quality checklist for newly built servers and automating the Sql server configuration using those scripts.• Performing code reviews and query performance tuning by analyzing query plan, creating missing indexes and defragmenting indexes.• Troubleshooting issues related to space and log growth of a particular database.• Experience in using Microsoft’s SCOM and Dell’s Spotlight for monitoring and troubleshooting.• Implementing new changes in the schema using all its dependencies as requested by the client.• Taking part in weekly client meetings to discuss about issues and new requirements.• Using TECHEASE as a ticketing tool for incidents and change requests and for tracking hours.• Analyzing backup window for the databases so as to reduce IO load and increase the performance of the servers.• Troubleshooting Virtual machines related issues and windows server issues like NIC card or Network link failure, etc.• Changing the cluster settings in Iaas environment for relaxed monitoring.• Troubleshooting stored procedures with errors and exceptions.

Skills

• Microsoft Sql Server
• Sql
• Itil
• Microsoft Excel
• Cloud Computing
• Virtualization
• Database Administration
• Emc Storage