SUMMARY:

• A certified DBA and Azure SQL database professional with 5 years of experience supporting SQL Server in production, test, and development environments. Has worked with business intelligence tools including SSIS. Extensive work history includes managing and troubleshooting High Availability solutions and is proficient with T - SQL.
• Has experience with Performance Tuning and Query Optimization.
• Upholds exceptional oral and written communication skills. Has implemented automation enhancements to deployment and is well-versed with SQL Azure. As a U.S. citizen, Abdul Hafeez is ready to start a new opportunity immediately.

TECHNICAL SKILLS:

Database: Azure SQL, SQL Server 2016, 2014, 2012, 2008R2 Databases

Operating System: Windows Server 2012, 2008 R2, Windows XP, 7, 10 and VMware

ETL Tools: SSIS/DTS, Data Factory

Reporting: SSRS (SQL Server Reporting Services), VISIO 2007/2010

Data Modeling: ERWin, Visio, Toad Data Modeler, SQL Server Database Diagram

ThirdParty Tools: RedGate, Idera, ERWin, Visio, Toad Data Modeler, OpNet, SolarWinds

Networking: Active Directory, TCP/IP

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator/DBA

• Installed and configured SQL Server 2016, 2014, and 2012 in development, test, and production environments
• Configured and managed Database, Replication, and Alwayson using SQL Server 2012, 2014
• Installed and configured SQL Server Reporting Services (SSRS)
• Upgraded SQL Server from lower version to higher version such as 2008R2 to 2012, as well as 2014
• Migrated On Premises SQL Server Databases into Azure SQL
• Migrated Oracle 11gR2 and 12c databases to SQL Server 2014
• Applied Service Pack on SQL Server as a routine maintenance work
• Executed performance tuning on databases, T-SQL codes and database servers
• Wrote T-SQL scripts, created and managed Views, Triggers, Stored-Procedures
• Utilized DBCC to check database conditions
• Was involved with Database Design and creating E-R Diagrams by applying Backward and Forward Engineering
• Performed ETL operations using SSIS Packages to load data from various sources such as text files, Excel, and CSV files to SQL Server databases. Also performed SQL Server data dump to Excel, and CSV files
• Performed daily report database refresh using production database
• Used Export/Import Utilities and SSIS Packages to load data from Oracle, and MySQL to SQL Server reporting databases
• Developed, managed and deployed reports using BIDS, SSDT in SSRS (SQL Server Reporting Services)
• Designed and managed database backup and recovery strategy for purposes of Disaster Recovery as well as for Point- in-Time Recovery
• Monitored and troubleshooted databases and servers on a daily basis by viewing Error Log, space usage and solving problem based on business needs
• Scheduled jobs and alerts for purposes of monitoring backups, database health check, disk space, memory, and CPU
• Developed Maintenance Plans for databases for purposes of rebuilding indexes and updating statistics

Confidential

SQL Server DBA

• Migrated and Upgraded SQL Server 2005 and R2 and 2012 in different environments
• Configured database monitoring software OpNet for SQL Server Server and applied OpNet mostly for tracing SQL/TSQL transactions, execution time, and blocking
• Performed database/infrastructure physical design, and configured storage for data and log files
• Provided support for clients’ applications using T-SQL by creating database structures such as tables, indexes, views, triggers, functions, stored procedures
• Developed and maintained scripts, utility jobs, and their performances
• Implemented and managed Database Mirroring, Replications, and Log Shipping technologies for High Availability solutions
• Based on client requirements developed, tested, and implemented database backup and recovery strategies
• Monitored data activities such as database status, logs, space utilization, extents, checkpoints, locks and long transactions
• Recommended application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards
• Adhered to Change Control Procedures. Developed and executed scripted changes requests in accordance with change control procedures
• Managed security on tables, objects, and procedures by defining roles and rights
• Was involved with handling index partitioning for large tables
• Created, administered and maintained SQL Server databases in production, development, test and staging environment for various groups such as Developers, QA Testers, Analysts, and Users
• Handled Fine Tuning Operating System in coordination with Server and Network Administrator to utilize resources efficiently for Databases and Applications
• Worked independently and as a team member promptly handling any assigned tasks by immediate supervisor

Confidential

MS SQL DBA

• Migrated and Upgraded SQL Server 2005 and R2 and 2012
• Managed database administration in production environment with server configuration, performance tuning, and maintenance
• Managed SQL Server High Availability and Disaster Recovery strategies
• Performed data transformation services and Bulk Loads with SSIS and BULK INSERT, ETL operations
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals, and AAG
• Worked on logical and physical database modeling with UML and ERWIN tools
• Applied Dynamic Management Views(DMVs) and dynamic management functions for identifying long running queries
• Managed Clustering and Server consolidation
• Worked in Disaster Recovery Planning and Security Management operations
• Managed DR processes including SQL Server Replication, Log Shipping and Database Mirroring
• Worked on configuring SQL Server with minimum privileged access
• Handled multiple SQL Instances on Clustered environment for Server Consolidation projects built on SAN using RAID levels
• Troubleshooted performance issues, fine-tuned databases and analyzed indexes
• Worked on SQL Server 2012 migration from SQL Server
• Experienced with 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations
• Maintained individual service accounts for SQL Server services on a cluster with different security groups to raise security mark
• Conducted memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments