Having 3 years of IT experience in SQL DATABASE ADMINISTRATION of MS SQL Server 2014/2016/2019 in Production environments.
Involved in monitoring for production servers and non-prod servers, scheduled job incident management, and receiving incident requests from end users, analyzing these, and either responding to the end user with a solution or escalating it to the other IT teams.
Overview
3
3
years of professional experience
Work History
SQL Database Administrator
Tata Consultancy Services
Pune
02.2022 - Current
Worked on SQL Server Hardening for HSBC,CRISIL and Greenwich.
• Experience in installing, configuring, managing, monitoring and
troubleshooting SQL Server 2014/2016/2019
Experience with always-on configuration in a multi-subnet cluster.
• Experience in SQL Server DB Creation, Backup and Restore.
• Experience into SQL Server Upgradation from 2014/2016/2017/2019.
• Movement of Database (System and User).
• Managing Users, Roles and User Permissions.
• Responsible for effective space management.
• Experience in Database troubleshooting, performance tuning.
• Experience in Implementing and Troubleshooting Log Shipping and also done DC-DR drill Activity
on Production Environment.
• Troubleshooting database related issues on a daily basis.
• Working knowledge of SQL Server profiler for trace Analysis.
• Implementation and monitoring of database mirroring
• Analyzing Performance issues using performance monitor and profiler
• Knowledge of the relevant OS commands related to day to-day activities
• Creation of logins and database users
• Creation of new databases, tables & other objects.
• Migrating SQL Server databases.
• Applying SQL Server Hot fixes, patches & Service packs.
• Maintaining documentation for the site.
Database Administrator
Morgan Stanley
02.2022 - Current
Project Team: TCS - SQL DBA team.
Client Name : Morgan Stanley
Education
Masters of Technology - Transportation Engineering
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services