Hemangini Patel

614-***-****

ac1hob@r.postjobfree.com

Objective: Seeking a position as a SQL Server DBA to deliver innovative information technology solutions

Summary:

10+ years of IT experience including SQL SERVER 2016/2014/2012/2008/2008R2/2005/2000 Database Administration, Development, Performance Tuning and Windows System Administration.

Experience in New Installing, SQL Server stand-alone, virtualized, and clustered, Patch, Configuration & Maintenance of MS SQL server

SQL Server 2005 DDL/DML Triggers, Migration, Upgrading 2005 database to SQL server 2008R2/ 2012/2014/2016.

Creating Databases, Transactions, Tables, Joint, Indexes, Constraints, Stored Procedures, Triggers, Views, Functions and Cursors using SSMS.

Experience Database Security: Granting and revoking end user access to resources. Database Maintenance: backup and restore, Recovery and Disaster Recovery procedures, integrity checks, index rebuilds, assigning Roles To Users, usually as jobs, setting them up and periodically reviewing them to make sure they are operating correctly.

Expert in Monitoring SQL Server Performance, Troubleshooting using SQL Profiler, and Scheduling Jobs using SQL Server Agent. Index Tuning Wizard (or) DTA, Windows Performance Monitor and Maintenance plan. Performance Monitor/Profiler to resolve Dead Locks or long running queries.

Experience in implementing many types of High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.

Installation and configuration of Microsoft reporting, and integration services, (SSRS, SSIS, SSAS) ETL experience, Experience in creating SQL Server 2005/2008/2008R2/2012/2014/2016 Reporting services.

Creating the SSIS, DTS Packages for Data Migration and Modification using DTS Lookups and transformations.

Indexes (Clustered/Non-Clustered) and partitioning of VLDBs (Very Large Data Bases 900GB-1TB) for improving the Data base performance.

Troubleshooting system wide problems including Network, database & third party software.

Possess skills in Network, OS installation and Hardware troubleshooting.

Production (24 x 7) support.

Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated.

Experience with Windows Systems and VMware Administrator.

PROFESSIONAL EXPERIENCE

Client : Comerica Bank, Auburn Hills, MI

Duration : Oct2015 – April 2017

Position : SQL Server DBA/ Project DBA

Responsibility Installations and configurations of sql server 2008, 2008r2, 2012/2014/2016 applying service packs, and Upgrading Sql Servers 2005 to 2008 R2 and 2012

Database Migrated migration from SQL Server 2012 to 2014

Responsibility Database Migration 2005/2008/r2/2012

Created packages in SSIS, and SSRS, SSAS 2012, 2014/2016

Responsible for Database Backup and recovery. Monitoring the database backup, drive space, log space and Critical errors for all production servers.

Managed security on Production and Development environments.

Responsible for performance and Tuning.

Responsible for Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication

Implemented high availability technologies: Replication/Mirroring/Clustering/Log shipping and Always On.

Environment: MS SQL Server 2005/2008/2008R2/2012/2014 and 2016 VMware, Cloud Server, and Window Cluster

Working experience with Windows Systems and VMware Administrator

Client : AT&T, Dallas, TX

Duration : Oct2014 – Aug2015

Position : SQL Server DBA

Responsibilities:-

Installations and configurations of sql server 2008, 2008r2, 2012 and 2014 applying service packs, and Upgrading Sql Servers 2005 to 2008 R2 and 2012

Database Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Managed security on Production and Development environments.

Creating and maintaining various databases on Production and development environments using SQL Server 2008r2/2012/2014.

Installed and configured SQL Server Reporting Services.

Responsible for Database Backup and recovery.Monitoring the database backup, drive space, log space and Critical errors for all production servers,

Implemented high availability technologies: Replication/Mirroring/Clustering/Log shipping and Always On.

Windows Systems and VMware Administrator

Created and maintained various logins and managed security based on the required access.

Implemented and tested the point in time recovery of the production databases.

Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication

24x7 and on-call support duties

Environment: SQL Server 2008, 2008R2, 2012, and 2014 SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS, SSAS Windows Server 2000

PROFESSIONAL EXPERIENCE

Client : PNC Bank, Columbus, OH

Duration : Nov2013 – Jun2014

Position : SQL Server DBA

Responsibilities:-

Responsible for Database Maintenance and Security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.

Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.

Installations and configurations of SQL server 2008, 2008r2, applying service packs, and Upgrades

Microsoft SQL server in the following environments: Development, test, qa production, stand alone, clusters, and virtualized.

Extensively worked on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.

Implementation of Point in time Backup and Recovery Plans of all databases and maintain documentation.

Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.

Involved in setting up,managing and maintaining High availability technologies : Installation Cluster

Responsible for non-production and production support for SQL server database based applications and assist in trouble shooting production issues and application performance issues. Worked on Database Engine Tuning.

Windows Systems and VMware Administrator

Environment: SQL Server 2008, 2008R2, SQL Server 2005/2000, Windows Server 2003.SAN storage systems, .Net Frame Work

Client :Intersoft Technology, New Jersey

Duration : Jun‘2010 – Aug’2013

Position :SQL Server DBA

Responsibilities:-

Installations and configurations of SQL Server 2008, 2008R2, 2012 applying Service packs.

Creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.

Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.

Worked extensively on Data Maintenance like Re-indexing, Integrity Checking, Database Shrinking.

Involved in Scheduling Tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL Mail, Managing Alerts, Monitoring and Tuning. SQL Server, SQL Suggested better Scheduling Strategy for jobs to overcome Blocking and Dead Locks.

Responsible for rebuilding the indexes and tables as part of performance tuning

Responsible for maintaining High availability servers like Clustering and Log shipping, Mirroring and Replication

Created packages in SSIS, and SSRS, SSAS 2000, 2005, 2008, 2008R2.

Implemented Disaster Recovery for SQL Server DBA Production Database as Fail-Over or Standby Servers.

Responsible for Maintaining Production servers, Monitoring Performance issues, Trouble Shooting and Solving Production Issues. Experience working on Database Engine Tuning.

Environment: SQL Server 2008, 2008R2, 2012 SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS Windows Server 2003

Client :Credit Suisse, New York

Duration : Apr‘2007 – Mar ‘2010

Position : SQL Server DBA

Responsibilities:

Installations and configurations of MS SQL Server 2005, 2008, 2008 R2 Applying Service packs.

Microsoft SQL Server in the following environments: Development, Test, QA, and Production. Stand alone, clusters, and virtualized.

Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.

Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.

Maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purposes.

Implemented Data Transformation Services (DTS), BCP, and Log shipping and Bulk Insert.

Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring, Replication, and Clustering.

Production (24 x 7) Environment.

Created DTS packages in SSIS, and SSRS, SSIS, 2000, 2005

Responsible for Query optimization and Performance tuning.

Environment: SQL Server, Query Analyzer, Outlook, DTS, BCP, Enterprise Manager, Windows 2000 Server, SSIS, SSRS

Client :Progressive Insurance, Columbus, OH

Duration : Jan’2006-Jan ‘2007

Position : SQL Server DBA

Description:

This project deals with various management activities of progressive Auto Insurance policies within the organization and assists them by providing various interfaces and reports to ease their decision-making process.

Responsibilities:

Installation and configuration of MS SQL Server 2000/2005and applied service packs.

Administration of SQL Servers in Production and Development environment

Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose

Developed Backup and Recovery Strategies, and Disaster Recovery Plan

Successfully implemented indexes on tables for optimum performance.

Performed Index analysis for tables and came up with more efficient solutions to use Clusteredand Non-Clustered Indexes for significant performance boost using index tuning wizard.

High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.

Created SSIS packages to import data from MS Access, Excel to SQL 2005.

Created report models and deployed on report server using SSRS

Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.

Environment: MS SQL Server 2000/2005, Windows 2000 Advance Server, MS Excel, MS Access, SSIS and SSRS

EDUCATION:

BACHELOR OF ADVANCED ACCOUNTING, SQL SERVER DBA-INDIA

BACHELOR OF INFORMATION SYSTEMS IN STRAYER UNIVERSITY –USA

TECHNICAL SKILLS:

Operating Systems- Windows 2008, Windows 2003, Windows 95/98/ME/NT/2000/XP, VISTA

Window 7

RDBMS- MS-SQL server 2016/2014/2012/2008/2008R2/2005/2000

Languages-SQL, T-SQL Scripting, C++

Tools/Utilities- Enterprise Manager, Management studio, Profiler, Query Analyzer, Export & Import, DTS, SSIS-Integration Services, Replication, SSRS-Reporting Services, ETL, and SSAS. .Net Frame Work

Front End Tools-MS FrontPage 98/2000, MS Office 97/2000/XP, MS Project 2000, MS Outlook 97/2000

Database Modeling / Schemas -Erwin, UML

Web Technologies-XML, Visual Studio

Microsoft products-MS Office Suite- Word, Access, Excel, Word and Power Point, and MS-Access 97/2000/2003/2007/2010

Contact this candidate