Shagun Malhotra

Client-Hospitality Domain(North America Region)

• 2 years experience in IT as microsoft SQL Server DBA in supporting database environment.
• Providing database solutions for application-based issues/problems in 24*7 production support environment.
• Created new procedures and enhanced existing procedures and other SQL objects.
• Experience in Knowledge Transition of project.
• Working on user requirements and issues in form of tickets. Hands on experience with ticketing tools like SNOW(Service Now) and Accenture ITSM.
• Analyzed 500+ monthly service tickets, identified trends and suggested upgrades.
• Experience in performing DBA activities such as taking backups and performing database restoration.
• Experience with SQL Installation and upgrade activities.
• Proficient in troubleshooting issues and identifying root cause for same.
• Experience in performance tuning(Locks, Blocking, Deadlocks, Indexing and query tuning).
• Instrumental in Database Server Migration including all logins, jobs, packages, etc.
• Availability and disaster recovery solutions like log shipping and replication.
• Created powershell scripts to automate some of regular tasks performed by team.
• Presented and defended RCAs to client, stakeholders and vendors for major incident related to PMS Application.
• Worked on Backup tools like Commvault.

• Configured CISCO and HP devices(Switches, routers)
• Created helpdesk and technical support to hotel.
• Configured ruckus access points.
• Assisted in troubleshooting hardware and software problems.