Around 10 years of experience in Microsoft SQL Server Database and 1-year experience in AWS.
Automated DBA task via mail.
Make sure that the database is up and running fine 24/7 available to all
Application users as well as end-users.
Responsible for all types of backups and restoration of databases.
Creating proactive jobs to monitor SQL Services, SQL Instance and database stats using Power Shell scripts.
Creating Server Roles, Schemas, Auditing, Logins, Users, Credentials, Alerts, and Operators.
Knowledge in Creating a Store Procedure, Tuning Queries and Cursor with T-SQL required for Administration purposes.
Experience in handling SQL server 2000, 2005, 2008R2, 2012, 2014 and 2016 production and non-production databases.
Worked on High Availability in SQL Servers such as Log Shipping, Mirroring, Always On Availability Group, Clustering, and Replication.