Experience on installing, configuring, Managing and Monitoring of all SQL server
Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.
Automation of SQL Server activities including scheduled and maintained routine Jobs, Alerts and Maintenance Plans.
Developed stored procedures, views, triggers using T-SQL
Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
Experience in writing complex SQL queries involving multiple tables inner and outer joins.
Monitoring SQL server jobs like backup, database space, log space etc.
Strong Experience in Backup, Recovery strategy and Database Refreshes
Experience in Database administration activities for DB security (creating users, logins and assigning permissions to them)
Having hands on experience in Database Mirroring and ensuring high availability to the database by testing the failover.
Good exposure in configuring and troubleshooting Log shipping and Mirroring
Having Knowledge of Replication
Have experience in SQL Server High-availability Hardware solution Clustering
Have experience in Implementing ALWAYSON
Have experience in applying Service Packs on SQL Servers