
I have 4.6 years of experience as a Microsoft SQL Server Database Administrator. Being highly motivated professional with strong administration skills, to become part of a leading organization and fulfill my desire of acquiring knowledge and self motivated resourceful and productive team player with 24/7 on-call availability.
Having 46 years of experience in SQL DBA production support experience on SQL Server
Experience in installation and configuration on SQL server under the role of DBA, Versions 2012,2014,2016,2017,2019
Creating logins, database users and managing their privileges in SQL Servers
Implementing the different Backup Strategies and experienced in backup and Disaster Recovery
Monitoring space on server, handling issues with Log files, Shrinking Log and Data files
Experience in Database Consistency Checks using DBCC commands and checking server status using DMV’s
Daily activities include monitoring Database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases
Database files and file group management, Checking overall Server health
Performing the Database Refresh activities
Performing the Table Refresh activities
Experience in SQL Server High Availability technology like Database Mirroring, Log Shipping and Clustering, Alwayson
Had hands on experience on ServiceNow ticketing tool and SCOM monitoring tool
Creating jobs and maintenance plans
Experience in Database backup and restores
Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups, fixing backup failures, address and implementing resolutions
Configured DB Refresh and Fixing orphaned users through stored procedures
Experience in usage of Performance monitoring and troubleshooting
Upgrading the environment from SQL Server 2012 to SQL Server 2014 and 2014/2016/2017/2019
Managed the migration of SQL Server 2012 databases to SQL Server 2014/2016/2017/2019
Good communication, presentation and interpersonal skills
Providing 24/7 On-Call support for critical production databases