TARIQ SAEED

acz55b@r.postjobfree.com - Mobile 516-***-****

PROFESSIONAL SUMMARY

Over 10 years’ experience as Microsoft certified SQL Server DBA, Database modeling, Implementation and System Administration, using Microsoft SQL Server 2000, 2005, 2008, 2012 and 2014.

Experience in SQL Server failover clustering, Always-On Availability Group, SRDF as DR solution, DBMirroring, log shipping and replication.

Experienced with Performance Tuning, Query Optimization and Security.

Excellent experience in SQL Server installation, configuration and administration.

Experienced as a production and development support DBA.

Worked independently as well as in team-oriented environments.

Excellent verbal, written communication and presentation skills.

Extensive experience in creating business, functional and technical documentation.

Excellent problem solving and conflict resolution skills and detail oriented.

CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA) SQL Server 2012

Microsoft Certified Database Administrator (MCDBA) in SQL Server 2005 Administration

Microsoft Certified Systems Engineer (MCSE) with Windows Server 2000

TECHNICAL SKILLS:

RDDBMS: MS SQL Server 2014, 2012, 2008, 2005, 2000.

Operating Systems: Windows 2012, 2008 R2, 2008 and 2003, Windows XP, MS DOS

Tools: SCOM, SQL Sentry, BBDA tool (BMC), Erwin, Remedy, JIRA, Performance monitor, T-SQL, SQL Profiler, SQL Query Analyzer and SQLCMD, Visual Studio 2010 and higher, SVN for Version Control

Programming Language: C# .NET, PowerShell, T-SQL, VBScripting

EDUCATION

MS in Computer Science, Preston University Pakistan (Islamabad campus) - 07/01/2002

PROFESSIONAL EXPERIENCE

J.P. Morgan, NY Feb 2011 to Present

Role: Database Management Lead - VP

I'm responsible for supporting Mission Critical Application for Hedge Fund Services (HFS) and Private Equity Funds Support (PEFS) and provide technical assistance to team members including offshore (EMEA/APAC) DBA Team.

Worked SQL DBA to provide 24*7 dedicated production supports for HFS/PEFS all environments which includes SQL Server 2014/2012/2008 R2 cluster servers and SSRS 2008 R2 servers.

Work on and supported MS SQL Server advanced features such as Clustering, Always-On Availability Group, DBMirroring, database table partitioning, Log shipping, DBMirroring and SRDF to synch the DR servers with production servers.

Provide production support and troubleshoot performance issues using SQL Sentry and other monitoring tools to identity the bottleneck.

Responsible to support and troubleshoot performance issues during Regression/stress testing in UAT environment.

Working on SQL Server 2016 standards deployment and implementation Planning

Worked on multiple datacenter migration and upgrade projects which includes SQL/SSRS/SSIS 2012/2008R2/2005/2000 servers.

Identity automation opportunities and implemented solutions to improve efficiency, reliability and productivity to reduce DBA administrative hours.

oAutomated Always-on Setup and configuration using PowerShell 5.0 on Windows 2012 R2 with SQL Server 2014.

oAutomated DR DBMirroring Setup and configuration using PowerShell 3.0.

oAutomated Database refresh process with data masking for QA and DEV environment.

oAutomated SQL Server Stop/Start Process for Wintel Patching with SCOM integration. This allows us to maintain current state of all SQL related services before and after patching completes on large number of servers.

oMulti-Threaded Database Maintenance scripts which reduce SQL Maintenance window and provide DBA better control to troubleshoot performance issues.

oSQL Server 2008 R2 installation and configuration automation using PowerShell 3.0.

This provides end-to-end SQL build and eliminates manual DBA work which is now replaced with SCCM SQL Server installation package.

UBS, Stamford CT December 2005 to Jan 2011

Role: Senior SQL DBA

As a DBA responsible to support Critical Production Applications such as Cash Management & Payment System and Business Intelligence 2005/2008 Applications for Risk Analysis Applications.

Responsible to provide 24*7 dedicated production supports for production servers which include SQL Server 2008/2005/2000 cluster servers and Analysis services 2008 servers.

Implemented EMC SRDF for SQL Server 2005/2008 clusters to implement BCP solution.

Implemented Storage V-MAX and DMX4 storage for Analysis services 2008.

Evaluated SSD (Fusion IO Cards) for Analysis services 2008 for MDX queries performance.

Responsible for installation, configuration and troubleshooting SSAS 2008 cubes.

Responsible to support and troubleshoot performance issues during Regression/stress testing in UAT environment.

Responsible for analyzing and testing for new hotfix/Service Packs of SQL Server.

Analyzing and tuning database structure to improve the performance by using index tuning wizards, profiler and execution plans.

Responsible for code reviews and improve the stored procedure performance using different methods of database optimization.

Responsible for installation and troubleshooting of SQL Server 2005 Reporting servers and Development of SQL Reports with SQL Server 2005 Reporting Services.

Involved in developing and troubleshooting of different DTS \ SSIS Packages.

Installing and Supporting SQL Failover clustering to provide 3 node high availability solutions.

Created documentation for SQL Server installation and for disaster recovery processes.

Experience with Global Request System (GRS) and Global Change Management System (GCMS) processes using remedy software.

Travel Click, IL August 2005 to December 2005

Role: SQL Server DBA (Consultant)

This is a short term project to improve the design of the database, performance and high availability solutions.

Migrated production server from standard edition to Enterprise edition.

Installed SQL Server 2000 Failover clustering to provide 2 node high availability solutions.

Analyzed existing database structures and improved the database performance by using index tuning wizards, profiler and execution plans.

Modified the existing database model to add additional application functionality and improve the performance using ERWIN data modeling tool.

Improved the Stored procedure performance using all database optimization methods.

Implemented the log shipping environment to provide the backup server strategy.

Created the appropriate backup strategy for production, test and development servers.

Created the documentation to do disaster recovery processes.

Implemented the transactional replication between the production servers.

Analyzed the stored procedure code and modify for the better performance.

Contact this candidate