HARSH PATEL

Senior MS SQL Server DBA/Production Support

SUMMARY:

Senior MS SQL Server DBA/Production Support with Extensive knowledge in Administering SQL Server in Production environment

Over 8+ years experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2014, 2012, 2008 R2 and 2005 in Production, Development & Replication Environments.

Extensive experience in installation, configuration, and maintenance of MS SQL Server 2016/2014/2012/2008 R2/2008 and 2005

Expert in Upgrading and migrating from SQL server 2000/2005/2008 to SQL server 2014/2012/2008 R2

Sound experience in Microsoft Azure and Amazon EC cloud based implementation

Hands on Experience in implementing SQL Server 2016, 2014 and 2012.

Expert in Implementing Async and Sync Mirroring for HA and DR

Experienced in working with production 24/7 Environment

Expert in performance tuning database for slow running queries and resolving user problems

Extensive use of DMV’s for troubleshooting Performance and user query issues

Experienced in Database Backup, Recovery and Disaster Recovery procedures.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.

Expert in setting up AlwaysON availability groups for DR and HA on 2014 and 2012

Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2012/2008 R2/2005 to provide robust database solutions.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities

Expert in Table Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.

Created maintenance plans to perform index defragmentation, re-indexing and update index statistics.

Proficient in troubleshooting database issues.

Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.

Experience in Managing Security of SQL Server 2012/2008 R2 by creating Database Users, Roles and assigning proper permissions according to business requirements

Expert in creating packages in SQL Server 2012/2008 R2 using SSIS

Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services(SSIS),Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)

Experience with Reporting Services (SSRS) and Analysis Services (SSAS).

Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.

Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.

Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications

Team player with Good communication, interpersonal and business analysis skills.

Good team player with strong analytical skills.

TECHNICAL SKILLS: MS SQL Server 2016/2014/2012/2008R2/2008/2005, Windows Server 2012/2008 R2/2008/2003, VMWare, Amazon ECC, Microsoft Azure, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS). Data Modeling, Star Schema Modeling, Snow Flake Modeling, OLTP, OLAP Tools, SQL, IDERA Diagnostic Manager, Apex SQL Monitoring Tools.

PROFESSIONAL EXPERIENCE:

07/2015- Present METLIFE, Somerset, NJ

Senior MS SQL Server DBA/Production Support

Description: MetLife, Inc. is the holding corporation for the Metropolitan Life Insurance Company, or MetLife for short, and its affiliates. MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries.

Role: Primary role to manage all production, dev and UAT servers heavily involved in resolving performance issues and give performance related solutions for database slow and slow running queries. Gave extensive production support for all Production servers

Responsibilities:

As a Production support DBA responsible for maintaining 170+ SQL Servers in Production

Gave 24/7 Production support on OLTP/DSS and Cloud based applications

Installed SQL Server 2016/2014 and 2012 on windows 2012 and 2008 R2 servers, applied service packs and security fix for all servers.

Upgraded server from MS SQL Server 2008R2/2012 to MS SQL Server 2012/2014/2016

Planned migration of Databases from Lower version to higher version

Resolved user problems and server related issues for servers, databases and performance

Gave Level I,II and Level III support for all Production issues

Used DMV’s to troubleshoot performance related issues for worst performing queries

Analyzed query execution plans for slow running queries and gave solutions

Implemented Failover clustering for Active/Active and Active/Passive SQL environment

Managed SQL Servers in Physical, Virtual and Clustered environments

Implemented Database Mirroring on SQL Server 2008 environments.

Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.

Planned and Implemented AlwaysON availability groups for 3 replicas

Implemented systems in Amazon EC and Microsoft Azure based cloud systems

Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries

Used SQL Server Performance Monitor to troubleshoot Server, CPU, Disks, Memory and tempdb bottlenecks.

Implemented Async and Sync Mirroring on SQL Server 20114/2012 for DR and HA

Used third party monitoring tools like Diagnostic Manager, Foglight, Litespeed and SQL Compare

Upgraded server from MS SQL Server 2008R2/2012 to MS SQL Server 2012/2014/2016

Did heavy migration of SQL Servers from lower version to higher version ( SQL Server 2014/2016)

Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.

Created the standard documents for Disaster recovery testing and implemented them.

Implemented transactional replication for data refresh and reporting

Managed all Publisher, Distributor and Subscriber database environments for the replication

Did extensive database sizing and capacity planning for production servers.

Experienced with creating logical and physical database design for development projects.

Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Scheduled package execution in SSIS

Installing packages on multiple servers in SSIS

Extensively worked on SSIS for data manipulation and data extraction, ETL Load

Created extensive reports using SSRS (Tabular, Matrix)

Created the backup schedule for production, test and development servers.

Worked with developers to do the database schema changes and database restore requests.

Involved in restore operations to refresh the data from production to test servers.

Experienced in troubleshooting production servers and fixed the user and application issues.

05/2013-04/2015 MASSMUTUAL Life Insurance, Enfield, CT

Senior MS SQL Server DBA/Production Support

Description: Founded in 1851, Massachusetts Mutual Life Insurance Company (MassMutual) is an American mutual life insurance company with 1800 offices and 13 million clients worldwide. Mass Mutual is one of the largest Life Insurance companies globally and was ranked 93rd in the Fortune 500 list (as of 2013).

Role: Primary role to manage all production servers, gave 24/7 support, Upgrade/Migrate SQL Servers, Performance tuning slow running queries.

Responsibilities:

Upgraded SQL server 2008R2 to SQL Server 2012 on standalone and clustered environments and applied service pack.

Interacted with application team at the time database migration from SQL Server 2008R2 to SQL Server 2012/2014.

Interacted with Developers in troubleshooting application and database issues.

Identified, tested and resolved database performance issues to ensure data optimization.

Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.

Implementation of system wide security policies and trouble shooting.

Involved in installing SQL Server 2008R2/2012 on Development, Production and WTC (Testing) machines.

Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.

Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.

Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)

Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2008R2 to SQL Server 2012.

Involved in troubleshooting all the performance issues for different database applications.

Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.

Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa

Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.

Documented all the steps and procedures for future references.

Interacted with concern application team in fixing the problems when ever needed.

Created performance baseline reports using RML tool and documented for future use.

Involved in setting up database mirroring for production server

Configured replication methods like snapshot, transactional and merge replications.

Monitoring and scheduled jobs on production and staging environment.

Responsible in Monitoring and Troubleshooting SQL Server Performance issues.

Used the Execution Plan to improve the optimization of the T-SQL code.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Resolving performance related issues to Blocking, Deadlocks and long running queries

Provided 24 x 7 Production support for the database and application issues.

12/2011-04/2013 MERCK, Whitehouse Station, NJ

Senior MS SQL Server DBA

Description: Merck & Co., Inc. (NYSE: MRK), also known as Merck Sharp & Dohme or MSD outside the United States and Canada, is one of the largest pharmaceutical companies in the world. Currently, it is one of the seven largest pharmaceutical companies in the world both by market capitalization and revenue.

Role: Primary role to manage all production, dev and UAT servers, Involved in Backup Recovery and Disaster Recovery activity.

Responsibilities:

Upgraded most of SQL Server 2005 to SQL Server 2008R2

Involved with upgrade of databases from 2005 to 2008R2 in a Clustered environment.

Worked on SQL Server 2008 R2 with latest Service Packs.

Involved in Performance Tuning on Production, QA and Staging servers of the current project.

Involved in Monitoring Performance of different production servers.

Implemented Database mirroring for disaster recovery.

Maintained various databases for Production and Testing using SQL Server 2008 R2.

Planning the location of data, index, and Transaction log files on the disk.

Performance tuning, and optimization of procedures and queries.

Worked with SQL server Profiler.

Created the backup and restore strategy for production and development environment.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

Experience in creating and executing SQL Server Integration Services (SSIS) packages.

Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.

Performing fine Tuning of Database Application. Cleansing and solving Database troubles.

Used BCP and Bulk Insert utilities.

Worked with SQL Server Reporting Services (SSRS).

03/2009-10/2011 Syntel, Pune, INDIA

Junior MS SQL Server DBA

Role: Worked as a database administrator for multiple clients of Syntel which is a premier IT consulting company in India. Managed there databases and created extensive documents and plans for maintenance of database environments.

Responsibilities:

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.

Planned and modified the permission issues in the server.

Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.

Fine tuning the Database Settings as well as the Server Settings.

Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Creating, maintaining the users, roles and granting privileges.

Logical and Physical Data Modeling using AllFusion ERWIN.

Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.

Performed analysis and design of the application.

Did the database administrative job of Security, Backup/recovery, ODBC connections etc.,

Performed Database backups (operating system, flat file backups & export/import).

EDUCATION/CERTIFICATIONS:

Bachelor Of Engineering, Gujarat University, India

Contact this candidate