Rohit Adnaik
Profile Summary
Hands-on 3+ Years of Experience in SQL Server Database Administration.Experience in Performance Tuning issues like Memory, CPU, Disk I/O, Statistics.
Experience in resolving Blocking and Deadlock Issues by using SQL commands/DMV's.
Configured and troubleshooting in Always ON.
DR -Troubleshooting & Maintaining Database High Availability solutions Log-Shipping, Mirroring, Replication, and Hardware Failover Clustering.
Worked for Upgrade and Migration activities.
Installation and Configuration of MS SQL Server 2019, 2017, 2016, 2014, 2012.
Performing Database Refresh activity whenever required.
Expertise in Backup/Recovery, Installation, Configuration, Troubleshooting.
Monitoring and Maintaining Production, Test, and Development environments.
Managing Security (Creating Users, Logins, and Roles, Granting Permissions).
Configuring of DB-mails.
Creating Maintenance Plans and Troubleshooting SQL Server Agent Scheduled Jobs.
SQL Server Updates (Patching): Checking for service pack/patches that need to be installed on SQL Server and install it.
Daily Activities include Monitoring Database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases.
Creating Indexes wherever required.
Maintaining all critical databases & server-related information in an Excel sheet.
Basic Knowledge of BI technology like SSIS and SSRS.
Have experience with Ticketing Tool: Services Now.