Having 4.6 years of experience in Administration of Database Management and MS SQL SERVER 2016, 2014, 2012, 2008 r2 in Windows environment.
Experience in MS SQL Installing, Redgate (Backup Tool) and configure to SSMS, Migrations, Upgrading, Configuration, Services packs and Maintenance of multiple SQL server environments.
Experience in Migrations from 2005 ,2008,2008 r2 to SQL Server 2016
Proficient in Database Backup, Recovery and Disaster Recovery procedures.
Familiarity with SQL server 2008, 2008 r2 ,2012, 2014 and 2016
Administering the MS SQL Server security by creating user logins with appropriate roles, dropping and granting the privileges to users and groups.
Experience in using Performance Monitor/Profiler to trace deadlock.
Experience in Database Mirroring, Replication and Log Shipping.
Experience in Query Optimization and Database Consistency Checks using DBCC commands.
Experience in creating and maintaining EC2 instances in Amazon Web Services.
Experience in creating and maintaining SQL Server RDS databases in AWS.
Managing and maintaining space issues in AWS for MS SQL Server.
Managing and maintaining the Data keeper and S3 backup storages in AWS.
Strong written and verbal communication to work effectively with cross-functional teams.
Self-motivated, responsible, confident and have the ability to multi-task and prioritize under changing and challenging workloads.