Firoz S.

ABOUT ME

 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

SKILLS