Prakash Patel

404-***-**** ac8huy@r.postjobfree.com

www.linkedin.com/in/prakash-patel-16951a10

Professional Summary

Results oriented DBA professional with 15 plus years of professional experience in database design and systems development.

Strong experience in in installing, configuring, managing, monitoring and troubleshooting SQL Servers 2000, 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017.

Extensive experience of T-SQL in complex queries, constructing triggers, user defined functions, views, indexes.

Expertise in relational database modeling and design, data dictionaries, and data integrity.

Expertise in Data Extraction using the Microsoft DTS/SQL Server Integration Services (SSIS).

Expertise in deployment of SSRS – SQL Server Reporting Services.

Expertise in PCI DSS compliance, data tokenization and encryption.

Experience in Creating SQL Agent Jobs and Sending Alerts using SQL Mail, Database Mail.

Database Upgrade for all versions of SQL Server from SQL 2000 to SQL 2017.

Experience working in very large database (VLDB) environment with database size in terabytes.

Solid experience in SSAS – SQL Server Analysis Services.

Solid experience and outstanding knowledge of high availability and disaster recovery (HADR) SQL Server solutions, including Always-On Availability groups, Log shipping, Replication, Database Mirroring and SQL Server clustering.

Experience of Data Migration from Development to QA to Production.

Backup monitoring and disk space monitoring on Storage Area Network (SAN).

Excellent communication, presentation and interpersonal skills.

Strong troubleshooting and organizational skills.

Create and update SQL server build standards and security standards and user guides for SQL Servers.

Extensive experience in Clustered and Non-Clustered environment.

Experience as 24/7/365 on-call production support DBA.

Experience working in multi-database environment with Oracle DBAs.

Education

Master of Computer Applications, South Gujarat University, India in 2002.

Certifications

Microsoft Certified Professional

Microsoft Certified Database Administrator (Microsoft SQL Server 2000)

Microsoft Certified Technology Specialist (SQL Server 2005)

Microsoft Certified IT Professional: Database Administrator (SQL Server 2005)

Microsoft Certified Technology Specialist (SQL Server 2008)

Microsoft Certified IT Professional: Database Administrator (SQL Server 2008)

Technical Skills

Technologies

VC#, VB, Java, Web Services, Agile Methodology, JIRA, COM/DCOM, ActiveX controls, ASP, ASP.NET, VB Script.

Platforms

Operating System (Windows Server 2012, 2008 R2, 2003, 2000)

Database (MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, 7; Oracle 11g)

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).

Development Tools

SQL Server Management Studio (SSMS), Visual Studio 2015, 2013, 2012, 2010, 2008, SSIS 2014, 2012, Business Intelligent Development Studio, Report Builder, SQL Server Data Tools (SSDT), Microsoft Silverlight, TOAD for Oracle, PowerShell.

Versioning System

TFS, VSS, Subversion, CVS, Git.

Other

SQL Profiler, Database Tuning Advisor, MS Project, MS Office, Argent Job Scheduler, Foglight, Redgate, Voltage tokenization.

Data Modeling Tools

ER Studio.

Professional Experience

Worldpay, Atlanta, GA May 2015 - Present

Sr. SQL Server DBA

Project: CMDB – Configuration Management Database

The CMDB was created to host configuration for all the database activities and other batch activities and items. This database is used to keep track of inventory items and processes. Many of the tasks were automated in database like create ID for new items based on environment (DEV/Stage or Prod/DR/Restricted or not) and related schedule frequency.

Technologies: SQL Server 2017, 2016, 2014, SQL Profiler, Database Tuning Advisor, Visual Studio 2015, 2013, 2012, SSDT, Report Builder, ER Studio, Microsoft Silverlight, VC#, Java, Web Services, Agile Methodology, JIRA, COM/DCOM, ActiveX controls, ASP, ASP.NET, VB Script.

Responsibilities:

Database logical design and physical design.

Creation of constraints and functions and stored procedures.

Created application interface in Silverlight to enter and update configuration items.

Manage permissions for different users to database as well as interface.

Database replication between Prod and DR for CMDB database.

Automated data archive for log tables based on configuration.

Creation of SQL jobs for alerting appropriate groups for failed or missing activities.

Created PowerShell scripts to monitor database and other processes based on configuration items in CMDB.

Compression of data in tables with different levels of compressions (page/row/no) based on the requirement.

Annual encryption key rotation for databases encrypted with Transparent Data Encryption (TDE).

Created process log which runs every 30 seconds on every SQL Server and captures a snapshot of processes and logs into a table which can be used to diagnose issues.

PowerShell script to capture all server information from Active Directory (AD) and discover SQL Servers in the network and record and update information in a table.

PowerShell script to check if any system login is locked out or not.

Created a SharePoint report which auto refreshes and displays any failed or out of order component.

Created SQL jobs to capture disk free space on every SQL Server every night and based on that predict future disk space issues and alert appropriate users.

Capture and record SQL Server clustering information like active node using PowerShell.

Created SQL Server Agent start up jobs which gives SQL Server start up information like start time, active node, passive nodes, SQL Server version and any job got cancelled due to SQL Server shutdown/restart.

Created SQL stored procedure which calls a SQL job and waits for its completion which is mainly used to call SSIS package from Argent job schedular.

Automated User Access Management for production database access to users which manages user access levels and duration based on requirement.

Daily database restores from production to Business Intelligent (BI) servers.

In-house development of data warehouse which gathers data from different production sources to BI environment.

Data tokenization and detokenization using voltage to move data between restricted network zone and not restricted network zone.

Data replication from SQL view to table to replicated protected data to not restricted network zone.

Database upgrade from SQL 2008 to SQL 2012 and SQL 2014.

Implementation of Distributed Always-On availability group on SQL 2017.

Data center migration for Stand-alone SQL Servers and clustered SQL Servers.

Deployment of SQL Server Reporting Services (SSRS) reports to SharePoint using Visual Studio 2015.

Documentation of Standard Operating Procedures (SOP) and knowledge transfer (KT) sessions with team members.

Worldpay, Atlanta, GA Nov 2012 – Apr 2015

Sr. SQL Server DBA

Project: Table partitioning

Converted monthly databases to single database with table partitioning for large tables. Instead of keeping 24 monthly databases with same structure, one database created. The very large tables with 1 billion+ rows are partitioned based on dates and sliding windows to keep the required number of days (2 years) only online and delete older records.

Technologies: SQL Server 2008/2012 enterprise, SSIS 2012, Visual Studio 2012/2013, Argent Schedular.

Responsibilities:

Logical and physical design of database and objects.

Creation of partition functions, partition schemes, tables, indexes, stored procedures.

Automate partitioning by scheduling t-sql script in SQL Agent jobs.

Automate data deletion for older dates and database file deletion.

Automate creation of daily partitions and monthly files in database.

Implemented automated sliding window-based partition management for large tables.

Creation of staging tables with same structure as production tables and same indexes and switch partition is used to switch data from staging to production tables which is very fast.

Creation of SSIS packages and SQL jobs to run Argent schedular jobs to copy data from very large text files (10 GB – 7 million rows) to SQL tables.

On-call production support for mission critical databases.

Worldpay, Atlanta, GA Apr 2010 – Oct 2012

SQL Server DBA

Project: Database Disaster Recovery (DR)

Database DR (hot-hot and hot-standby) between two data centers Atlanta and Philadelphia. In case of actual disaster Philadelphia servers should be ready to take the production load with a very little down time (RTO) and zero data loss (RPO).

Technologies: SQL 2008, SQL 2008R2, SQL Server replication, Windows Clustering

Responsibilities:

Installed clustered SQL Server instances in windows clusters.

Worked with Microsoft support for cluster installation related issues.

Implemented database mirroring between data centers.

Configured Peer to Peer (P2P) replication between two databases and during data center migration added one more node (3 node P2P) just for migration to avoid downtime.

Worked with developers to help them with mirrored database connection string.

Created stored procedures to handle different identity ranges for different data centers.

Created scripts to generate different identity ranges and update existing tables without table drop/recreate.

Configured Merge replication for a database

Applying patches in round robin fashion on cluster nodes and switching mirrored databases.

Worldpay, Atlanta, GA Sep 2009 – Mar 2010

SQL Server DBA/Developer

Project: Database Backup automation

Created stored procedures to handle database backups (Full/Differential/Log) for all databases on the server. Stored procedures were copied to all the servers in environments and daily SQL Agent jobs scheduled to run those stored procedures.

Technologies: SQL Server 2005, SQL Server 2008.

Responsibilities:

Create DBA_STATS database on each server.

Create stored procedures to run backup with parameters for type of backup, storage location, encryption, compression etc.

Automated managing backup files on data domain.

PCI, DSS compliance and data tokenization and data encryption including encryption key management

Database deployment from development to QA to Stage to Production

Develop scripts for routine tasks and automation

Manage database encryption.

Chicago Public Schools, Chicago, IL Feb 2009 – Aug 2009

SQL DBA

Worked as a SQL DBA giving production support to different departments of Chicago Public Schools. Managing more than 50 production SQL Servers of SQL 2005 and SQL 2008.

Technologies: SQL Server 2008, MS SQL Server2005, ER Studio 7.5, Redgate backup

Responsibilities:

Setting up new SQL Servers 2005, SQL Server 2008 and configuring the required users.

Database design and data modeling using ER Studio.

Regular monitoring of servers, this includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Managing Replication, Database Mirroring, Log shipping and SQL Server clusters

Data Upgrade from SQL 2000 to SQL 2005 and to SQL 2008

Creating and deploying reports using Reporting Services

Managing SQL Server nodes on Cluster.

Working with SQL Server 2008 in Development environment.

Managing backups using Red-gate.

24/7 On-call support and production support.

Georgia Pacific, Atlanta, GA Sep 2008 – Feb 2009

SQL DBA

Worked as a SQL DBA giving production support to different departments of Georgia Pacific. Managing more than 50 production SQL Servers located at 2 different locations.

Technologies: SQL Server 2008, MS SQL Server2005, ER Studio 7.5, Redgate backup

Responsibilities:

Setting up new SQL Servers 2005 and configuring the required users.

Database design and data modeling using ER Studio.

Restoring and copying Production Databases.

Regular monitoring of servers, this includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Managing Replication, Database Mirroring, Log shipping and SQL Server clusters

Managing SSIS packages/DTS packages

Managing backups using Redgate.

24/7 On-call support and production support.

Intel, Beaverton, OR Mar 2008 – Aug 2008

SQL DBA

Worked on backend of Localization project of a Health care project which includes taking different measurements on a clinical device and send results to doctors and send recommended schedules of medicines to patients in local language.

Technologies: SQL Server 2008, MS SQL Server2005, ER Studio 7.5

Responsibilities:

Setting up new SQL Servers 2005 and configuring the required users.

Database design and data modeling using ER Studio.

Restoring and copying Production Databases.

Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

Managing and troubleshooting Replication, Database Mirroring, Log shipping and SQL Server clusters

Resolving various performance issues and running DBCC commands, SQL Profiler and NT monitoring tools.

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. SQL Authentication

Managing databases, tables, indexes, views, stored procedures, enforcing business rules with triggers and user defined functions.

Cleary Gottlieb Steen & Hamilton LLP, New York, NY Dec 2007 – Mar 2008

SQL DBA

Cleary Gottlieb Steen & Hamilton LLP is one of the leading international law firms, with 12 closely integrated offices located in major financial centers around the world.

Technologies: SQL Server 2000, SQL Server 2005

Responsibilities:

Setting up new SQL Servers 2000 and 2005 and configuring the required users.

Restoring and copying Production Databases.

Maintain and troubleshoot Replication issues by continuous monitoring of replication.

Regular monitoring of servers, this includes Backup Job Monitoring and troubleshoot all the issues on regular basis.

Installing SQL Server service packs based on the errors and flaws that are found in the application.

SQL Server Administration, service start, pause, stop, failover.

Resolving various performance issues and running DBCC commands, SQL Profiler.

Xcel Energy, Minneapolis, MN June 2006 – Oct 2007

SQL DBA

Worked on supporting database for various applications including Billing and Financial applications running on SQL Server.

Technologies: SQL Server 2005, Microsoft Visual Interdev, Hyperion / Brio, VB.NET, VB Scripting, ASP.NET.

Responsibilities:

Documented Disaster Recovery Plans and participated in disaster recovery.

Running Index tuning wizard, implementing Log Shipping.

Monitoring SQL server, Application logs and analyzing the logs.

Maintaining both Development and Production servers in sync.

Creating users and assigning permissions. Windows and SQL Authentication.

Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.

Data conversion, database upgrade from SQL 2000 to SQL 2005

Writing the Stored Procedures, checking the code for efficiency.

Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.

Working with various departments while developing their applications, assisting in Database design, phasing from development to QA and to Production environment.

Rebuilding indexes on various tables.

Involved in Installing, configuring and maintenance of SQL Server 2005.

Working with Oracle DBAs for application support.

Reliance, Silvassa, India Oct 2002 – June 2006

SQL Developer

Project: Production Tracking System

Technologies: SQL Server 7, SQL Server 2000, SQL Server 2005

Responsibilities:

Database Design, schema, tables, rules, constraints, defaults. Write and tune Stored Procedures, Triggers and schedules for SQL Jobs, Stored Procedures, Jobs & Alerts, Stored procedures & Alerts notification via SQL mail. Effectively handling the Data Transformation Services. Index Tuning

Contact this candidate