Sql Server Dba
Resume:
Hemangini Patel
***********@*****.***
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