Sql Server Ms

Kushal Patel

Senior SQL Server DBA

Email: - **.*******@*****.***

Phone: - 646-***-****

SUMMARY

Ten Plus years of IT experience with more than five years in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2016/2014,2012,2008 R2 and 2005 databases in Production, Test, Development, Replication and Cluster Server Environments.

Very good experience in Installation, configuration and maintenance of SQL Server 2016/2014,2012/2008 R2/2005.

Extensive knowledge of Relational Database Management Systems and Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and De-normalization and building Referential Integrity Constraints using AllFusion Erwin 7.1 and Visio.

Expert in cloud implementation with Microsoft Azure and Amazon AWS.

Expert in VMware and Virtualization technologies

Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands

Experience in MS SQL Server upgrades from MS SQL Server 2000/2005/2008 to 2016/2014/2012/2008 R2.

Expert in Setting up High Availability (HA) with AlwaysON Availability Groups and Clustering

Expert in HA and DR with Clustering, Mirroring and Log Shipping

Experienced in working in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server 2016/2014/2012/2008 R2.

Knowledge of implementation of software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs Interacted with the users and troubleshooting the problems involved with the development of stored procedure.

Experience in capacity planning, performance tuning, disaster recovery, troubleshooting, backup and restore procedures.

Expert level skills in High Availability, Disaster Recovery, Virtualization and Replication

Expert in installation, upgrade and configuration of 64 bit MS SQL Server databases in clustered (Active/Active, Active/Passive) and non clustered environments in SQL 2014/2012/2008 R2.

Expert in Log shipping/ Database Mirroring with SQL Server 2016/2014/2012/2008 R2.

Experience in implementing Snapshot and Transactional replication models with SQL Server 2008 R2.

Developed Backup and Recovery strategies for PRODUCTION environment.

T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.

Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities and using SQL Server latest DMV's.

Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).

Created complex SSIS packages using SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio

Extensive experience in data Extraction Transformation and Loading (ETL) between homogenous and heterogeneous systems using SQL SSIS tools, Data Transformation Services (DTS), bulk insert/delete(BCP), and XML operations.

Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).

Good Knowledge of LiteSpeed, IDEARA Diagnostic Manager, Foglight for MS SQL Server.

Expert in database modeling and reverse engineering in ERWIN and VISIO

Excellent communication skills, good team player and can work independently.

EDUCATION:

Bachelor of Engineering in Computer Science, India

TECHNICAL SKILLS:

Windows Server 2012/2008 R2/2003, MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000, Enterprise Manager, Query Analyzer, Oracle 10g/11i, DTS, MS SQL SSRS, SSAS, SSIS, SQL Profiler, ASP.Net 3/2.0, SQL, PL/SQL, Visual Studio 2008/2005, T-SQL, ERWIN, Database Modeling, Microsoft VISIO, IDERA SQL Diagnostic Manager, SQL Litespeed, Lumigent Log Explorer, Dell PowerEdge, HP Blade, Microsoft AZURE, VMWare, Amazon AWS

PROFESSIONAL EXPERIENCE:

InEight, Omaha, NE May 2016 – Present

Senior MS SQL Server DBA

Project: Project was to Manage existing Production environment in HA and DR. Also support existing databases and implement new database designs. Give performance solutions for existing databases for maximum throughput

Responsibilities

As a Database Administrator responsible for managing Production, Development QA and Integration Environment.

Worked Heavily on the Installation, Configuration and Maintained SQL Server 2008R2/2012/2014/2016 on Windows 2003, 2008, 2008R2, 2012.

Planned and Implemented SQL Server in Microsoft Azure and Cloud based systems.

Worked extensively for the database sizing and capacity planning for production servers and QA servers.

Responsible for Installing and configured SSRS, SSIS and SSAS Tabular Model.

Configured SQL Server 2012/2014 AlwaysON Availability Group for High Availability.

Responsible for Implementation of Backup and Restoration Strategy for Production, QA and Development Environment.

Created Database Maintenance Planner for the Production Databases which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Implemented Replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for Transactional Replication.

Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs.

Managed SQL Servers in 32/64 bit Clustered environments.

Implemented Database mirroring for disaster recovery in Production Environment.

Configured Log shipping architecture to provide backup server solution for many environments.

Monitored and managed all Publisher, Distributor and Subscriber database environments for the replication.

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

Created the SSIS packages, DTS to import the data from one Environment to other Environment.

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 )

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

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

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

Environment: SQL Server 2016/2014/2012/2008 R2, AlwaysOn Availability Group, Microsoft Azure, clustering, Mirroring, Logshipping, VMWARE, ERWIN, VISIO, T-SQL, Windows Server 2012 R2, 2012, 2008 R2, SSIS, SSAS, SSRS, LiteSpeed, Redgate, Foglight, IDERA Diagnostic Manager

Pitney Bowes, Omaha, NE Oct 2013 – May 2016

Senior MS SQL Server DBA

Pitney Bowes Inc. is an American provider of global eCommerce solutions, shipping and mailing products, location intelligence, customer engagement and customer information management solutions. Based in Stamford, Connecticut, the company has approximately 16,100 employees worldwide. It is one of 87 existing firms that have been members of the S&P 500 since its creation in 1957.

Project:

Primary role as a Production support DBA, managed a team of 4 DBA’s and supported HA and DR environment. Extensive interaction with DBA’s and developers in resolving production issues

Responsibilities:

As a Production support DBA responsible for managing production, development and QA environments and participated in on call 24/7 support.

Responsible for the database sizing and capacity planning for production servers.

Responsible for the Install, Configured and Maintained SQL Server 2005/2008/2008R2/2012 on Windows 2003, 2008, 2008R2, 2012.

Worked heavily on Space Management, I/O tuning, managing migration process, performance analysis and production support for large and complex database up to 6 TB.

Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs.

Configured SQL Server 2012 AlwaysON Availability Group for High Availability.

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

Implemented Replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for Transactional, Merge and Snapshot Replication.

Responsible for the Database backup and Restoration using SQL native tool.

Developed and Maintained SSIS Package to Extract and Load data from diverse source (flat file, excel, xml and oracle).

Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.

Worked heavily on Disaster recovery planning and Database Security for 180 servers.

Did heavy duty Migration / Upgrades from lower version of SQL Server 2008 R2 to SQL Server 2012.

Worked heavily on BCP utility to publish table output to text file.

Implemented Maintenance plane for the various databases and also responsible for the Database consistency check for all Databases.

Implemented Database Mirroring on SQL Server 2012 environments.

Configured and Maintained Log shipping on Primary and Secondary server with or without witness server on MS SQL 2012.

Design and Configured Partitioning of table and Indexes to Improve query performance in SQL 2012.

Implemented Data and backup compression to reduce I/O and maintained security respectively.

Simplify and Optimize complex query that involve multiple tables by using multiple joins and sub-queries to maintain administrative tasks.

Monitor server performance using SQL Profiler, Index tuning and debug T-SQL and fine tune SQL queries.

Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2008/2012.

Extensively worked with Developers to do the Database Schemas Changes.

Extensively worked with Developers and QAs for the Database restoration and Refresh the data from production to Pre-Production, QA and Development Environments.

Developed internal control technical documentation that sufficiently describe the maintenance responsibility for the production support team.

Environment: MS SQL Server 2012/2008 R2/2008/2005/2000, Windows Server 2012, 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SQL Delta, SSIS, SSRS, Clustering, Mirroring, Log Shipping, Replication.

PA Department of Community & Economic Development, Harrisburg, PA Mar 2011 – Sep 2013

Senior MS SQL Server DBA

The mission of the Department of Community and Economic Development (DCED) is to foster opportunities for businesses to grow and for communities to succeed and thrive in a global economy. Our mission is to improve the quality of life for Pennsylvania citizens while assuring transparency and accountability in the expenditure of public funds.

Project:

Manage Production, Development, and Test Environment. Gave 24/7 support to all environments. Project was to Migrate from Oracle to SQL server and manage HA and DR environments.

Responsibilities:

As a Production support DBA responsible for managing production, development and test environments.

Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2012/2008 R2

Migrated Oracle Databases in SQL Server 2012.

Worked heavily on critical stored Proc. And Functions.

Installed / configured SQL Server in Virtual Environments using VMWare.

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

Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs

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

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

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) and also Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.

Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS

Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS

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

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

Experienced with database sizing and capacity planning for production servers.

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

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

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.

Environment : MS SQL Server 2012/2008 R2/2008/2005/2000, Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

ING, Windsor, CT Feb 2010 – March 2011

Senior MS SQL Server DBA

In the U.S., the ING family of companies offer a comprehensive array of financial services to retail and institutional clients, which includes annuities, retirement plans, life insurance, mutual funds, managed accounts, alternative investments, direct banking, institutional investment management, employee benefits, and financial planning.

Project:

Manage Production, Development, QA and UAT Environment. Gave 24/7 support to all environments, managed servers in HA and DR. Project was to Upgrade SQL Servers from lower version to higher Version and manage HA and DR environments.

Responsibilities:

As a Production support DBA responsible for managing production, development and QA environments.

Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments

Installed / configured SQL Server in Virtual Environments using VMWare.

Installed SQL Server 2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.

Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008

Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008.

Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication

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

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

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle) and also Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.

Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS

Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS

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

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

Experienced with database sizing and capacity planning for production servers.

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.

Environment : MS SQL Server 2008 R2/2008/2005/2000, Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Blue Cross Blue Shield, Chicago, IL Jan 2009 - Feb 2010

Senior MS SQL Server DBA

The Blue Cross Blue Shield Association (BCBSA) is a federation of 38 separate health insurance organizations and companies in the United States. Combined, they directly or indirectly provide health insurance to over 99 million Americans

Project: Project was to Manage existing Production environment in HA and DR. Also support existing databases and implement new database designs. Give performance solutions for existing databases for maximum throughput

Responsibilities

As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 100 servers are production servers in which 30 were mission critical and 70 were business critical servers, remaining test and development servers.

Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.

Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment

Managed SQL Servers in 32/64 bit Clustered environments

Implemented Database Mirroring on SQL Server 2008 environments.

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

Implemented transactional replication for data refresh

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

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

Worked extensively with SQL Server DMV's for resolving performance bottlenecks

Worked extensively on Windows Perfmon for I/O bottlenecks

Upgraded server from MS SQL Server 2005 to MS SQL Server 2008

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)

Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.

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 )

Environment : MS SQL Server 2008 R2/2008/2005/2000, Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Barclays Capital, Exchange Place, NJ Dec 2007 - Dec 2008

Senior MS SQL Server DBA

Barclays Investment Bank (trading as Barclays, formerly Barclays Capital) is a British multinational investment bank headquartered in London, United Kingdom and a division of Barclays PLC. It provides financing and risk management services to large companies, institutions and government clients.

Project: The role was to support SQL Server Environments and get involved heavily with Off-shore teams in implementing builds and releases

RESPONSIBILITIES:

Managed All Production, Development and QA Environments running MS SQL Server 2005/2000.

Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.

Involved in Performance Tuning on Production, Staging and Test Servers.

Worked with Off-shore teams for builds and releases

Involved with maintenance of ACTIVE/PASSIVE Cluster Environments

Implemented Database mirroring for High Availability.

Maintained various databases for Production and Testing using SQL Server 2005.

Used AllFusion ERWIN to deploy any changes to the database and objects from test to production.

Worked with SQL Server Profiler and Perfmon.

Involved in Monitoring Performance of different production servers.

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

Performance tuning, and Optimization of Stored Procedures and Queries.

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.

Involved in creating reports using SQL Server Reporting Services (SSRS) as per the requirement.

Migrated DTS packages to SSIS packages.

Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2005.

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

Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.

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

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

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.

Environment : MS SQL Server 2008 R2/2008/2005/2000, Windows Server 2008 R2/2003/2000, Vmware, Vsphere, Virtualization, Ideara Diagnostic Manager, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Associated Press, Trenton, NJ Dec 2006 - Dec 2007

SQL Server DBA

The Associated Press is an American news agency. The AP is a cooperative owned by its contributing newspapers, radio and television stations in the United States, which both contribute stories to the AP and use material written by its staff journalists. Many newspapers and broadcasters outside the United States are AP subscribers, paying a fee to use AP material without being contributing members of the cooperative.

Project: Upgrade SQL Server from Lower version to Higher Version and manage and implement changes on SQL Server

Responsibilities

Upgraded most of SQL Server 2000 to SQL Server 2005

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

Worked on SQL Server 2005 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 2005.

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 and Worked with SQL Server Reporting Services (SSRS).

Environment : MS SQL Server 2005/2000, Windows Server 2003/2000, Vmware, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Contact this candidate