Mohammad A.

ABOUT ME

Worked as SQL Server Database Administrator in Automatic Data Processing, Inc. from 2011 October to January 18th 2016. Currently working with TCS.
Managed and administered 3500+ database in 120instances.
Experience in deploying SSIS packages and SSAS cubes. Able to troubleshoot SSRS issues as well.
Extensive knowledge of configure and troubleshoot windows and SQL clustering, Log shipping, Replication, Always On and mirroring concepts.
Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor
Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
Fine tuning of database objects and server to ensure efficient data retrieval.
Designed and implemented incremental and full backup policies and procedures.
Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
Used database consistency checks using DBCC utilities.
Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot. Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2008/R2/2012/2016 Server.
Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks.
Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware.
Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.
Basic knowledge on PowerShell, C, C++, Java (core), C#.net, VB.net and ASP.net
Basic Oracle database concepts.

SKILLS