Bhavin Patel

ad3511@r.postjobfree.com

760-***-****

Summary

Database Admin with over 7+ years of IT experience in SQL Server Database Administration, Management and Support of Microsoft MS SQL Server 2017/2016/2014, 2012, 2008 R2, 2005, and 2000 in Development, Test and Production Environments on various business domains.

Strong understanding and implanting the business logic like System Design, Database Design, SDLC, and have used many third-party tools for Database Administration, Design, and Monitoring and Troubleshooting like Idera SQL DM, ERWin, Toad Data Modeler, and OpNet.

■ Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating MS SQL Server 2017,2016,2014, 2012, 2008 R2, 2005, and 2000

■ Proficient with SQL Server Disaster Recovery, Backup/Restore and DR Solutions

■ Management of backup and restore, export and import, DTS and BCP utility.

■ Hands on experience and outstanding knowledge of High Availability (HA) SQL Server solutions including Mirroring, Log shipping, Replication, AlwaysOn, and Clustering

■ Experienced in setting up, configuring and supporting SQL Server replication in Snapshot andTransactional replication models.

■ Experienced in diagnosing and troubleshooting Performance related problems and have used different native and third-party tools for Performance Tuning, Some of the tools – Profiler, Execution plans, Database Tuning Advisor, PerfMon, Activity Monitor, Windows Event Logs and Idera Diagnostic Manager, OpNet, SolarWinds DPA and so on.

■ Good knowledge using DMV’s, system stored procedures to troubleshoot or to find metadata from SQL server. Using DBCC Utilities that checks database consistency on user databases.

■ Expertise in Security Issues such as creation and granting permissions on various objects.

■ Experience in creating packages, Scheduling Jobs, setting up Alerts & notifications using SQL Mail.

■ Migrating databases from older version to higher version naming from SQL server 2005/2008 R2 to 2012/2014

■ Develop and maintain database support documentation and work procedures.

■ Knowledge in various states of System Development Life Cycle (SDLC).

■ Creation of Tables, Views and user created Data Types, Indexes, Stored Procedures and Triggers.

■ Capable of handling responsibilities independently as well as a proactive team member with strong analytical skills.

■ Strong technical background with excellent problem solving and communication skills.

■ Have Experience Production and On Call Support 24/7 Education

■ Master of Computer Science, San Diego, CA 2009

■ Bachelor of Computer Science, India, 2005

Technical Skills

Operating Systems Windows Server 2016/2012R2, 2008 R2, 2003 R2, 2000 Databases MS SQL Server 2017,2016,2014, 2012, 2008 R2, 2005, and 2000, MS Access

Database Migration Migrated Oracle, MySQL, and MS Access Databases to SQL Server

Database Tools SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, SQL Client Configuration utility.

Activity Monitor, Performance Monitor, Extended Events, Database Tuning Advisor, Execution Plan, Job Activity Monitor, Built-in Standard Reports, BIDS/DTS, DMVs & DMFs, DBCC, SQL Server Configuration Manager, Live Query Statistics, Query Store, SSMA, DMA, Azure Database Migration Service Third Party Tools OpNet, SolarWinds DPA, ERWin, Toad Data Modeler,, and Idera SQL DM

ETL Tools DTS (Data transformation services), SSIS (SQL Server Integration Services)

Development skills SQL, Transact SQL (T-SQL): Writing Query and Scripts Reporting Tools SSRS (SQL Server Reporting Services) DR (Disaster

Recovery) and HA

(High Availability)

Solutions

Backup & Recovery, Log Shipping, Mirroring, AlwaysOn, Replication and Clustering

Data Security TDE (Transparent Data Encryption), IPSec, SSL, Data Masking, Column level security

Hardware/Storage SAN, RAID

VMware Installing, configuring, and administering

Web/Application

Server ● Administering Web Server (IIS-Internet Information Services) and deploying and managing applications

● Deployed apps in development, test and production App Servers

Professional Experiences

Client : DXC Tech

Austin, TX October 2017 to March 2020

MS SQL DBA

Key Responsibilities:

● Installed, Configured, and Managed SQL Server 2017,2016,2014, 2012, 2008 R2/2005

● Upgraded/Migrated/Server Decommissioning: Migrated, upgraded, and decommissions databases/servers from older versions to new versions like SQL Server 2005 and 2008 R2 databases to 2012 and 2014

● Migrated MS Access, Oracle, MySQL Databases to MS SQL Server 2012 /2014/2016/2017/2019

● Maintenance: Applied SP (Service Pack)/Hot fixes, Implemented Linked Servers within SQL Server environment and with Oracle and MySQL environment, Manage Alert and Incidents.

● Installed and Configured SQL Server Reporting Services (SSRS) in 2008 R2 and 2012

● High Availability (HA): Configured and Managed Failover Clustering, Replications, Database Mirroring, AlwaysOn, Log Shipping including Standby database for reporting purposes

● Disaster Recovery: Performed Backup and Recovery, designed backup strategies for Development, Test, and Production and Mission Critical Systems including Point-in-Time Recovery, automation and test procedures

● Performance tuning: Performed performance tuning for Server, Database, Query using different tools like Profiler, Execution plans, Perform, Counter, Database Tuning Advisor and third-party tools like SolwardWinds DPA,

● Programming/SQL Scripting: Wrote SQL/T-SQL scripts, Stored-Procedures, Functions Triggers

● Data Modeling: Worked on multiple Data Modeling projects including designing a database from scratch, crating tables, views, indexes, constraints, business rules, creating scripts, E-R Diagram, backward/forward engineering

● ETL: Designed, Implemented, and Managed ETL Projects using SSIS, and DTS, Migrated and Upgraded DTS packages to SSIS packages, Processed data from Flat file, CSV file, and Excel file using Export & Import utility, Performed Data dump from Oracle, and My-SQL databases to SQL Server Database using SSIS, and EXP/IMP tool

● Report Development:

● Installed, Configured, and administered SQL Server Reporting Services (SSRS)

● Developed, Deployed, and Managed Reports

● Managed Reports Security

● Tools Used: Developed Reports using BIDS (Business Development Studio), Report Builder 3.0, 2.0, and Data Tools

● Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities

● Migrated Reports and Reporting Servers

● Database Automation: Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment including creating test environment, Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files

● Troubleshooting: Monitored Server Activity, Error Log, space usage, and solving problem as needed, Worked with Application Team and App owner to resolve issues.

Environment: SQL Server 2019/2017/2016/2014/2012/2008R2/2008, Data Transformation Services (DTS), ASP.net Applications, IIs Application Server Windows Server 2012, 2008R2, AD (Active Directory), Oracle 10g, MySQL, SolwardWinds DPA- Database Tuning and performance monitoring, ServiceNow. Bank Of America, Addison, TX January 2015 to September 2017 MS SQL DBA

Responsibilities:

● Installation: Installed, Configured, and Managed SQL Server 2012, 2008 R2, & 2005 in Development, Test and Production Servers

● Patch Management: Applied SP (Service Pack) and HOT Fixes on SQL Server Database Servers

● Database Upgraded: Upgraded from SQL Server 2005/2008 R2 to 2012

● Database Migrated: Migrated from SQL Server to SQL Server

● Database Monitoring: Monitored Database Servers, Databases, Agent, Jobs, Alerts log files

● Backup/Recovery: Setup jobs and troubleshoot jobs related to backup, Recovered Database in POINT-IN-TIME

● Used DBCC and DMV for different purposes

● Created, Modified, and Managed Indexes (Clustered/Non-Clustered, Simple, Composite), Constraints

● Performance Tuning: Worked on performance tuning to improve performance for different applications, SQL/TSQL code using different Performance tools such as Query Execution plan, Database Tuning Advisor, Profiler, Monitoring Lock/block, Sessions, worked with Idera SQL DM to monitor and troubleshoot performance issues.

● Database High Availability: Installed, Configured and Managed Database Mirroring, Log Shipping, Replications, Always On Availability group and clustering

● Data Modeling: Worked on Data modeling projects for new system and reddening existing system, have used different data modeling tools ERWin, VISIO, and Toad Data Modeling, well versed with Backward & Forward Engineering for data modeling

● Database Programming: Wrote T-SQL, and Stored-Procedures for reports, and applications

● DTS/SSIS: Excellent in loading data, data conversion from Flat file, CSV file, Excel and from other Data Sources like Oracle, MySQL, and Access to SQL Server, Setup Jobs using SSIS package, Moved and Migrated DTS Packages to SSIS package

Environment: Windows server 2012/2008R2, 2003R2 IIS 7.5. SQL SERVER 2012/2008R2/2008/2005. Applications in ASP and ASP.net, Idera SQL DM.

Mattress Firm, Houston, TX July 2011 to December 2014 MS SQL DBA

Responsibilities:

● Installed, Configured, and Managed SQL Server 2012, 2008 R2, & 2005 in Development, Test and Production Servers

● Worked on performance tuning to improve performance for different applications, SQL/TSQL code using different Performance tools such as Query Execution plan, Database Tuning Advisor, Profiler, Monitoring Lock/block, Sessions, worked with Idera SQL DM to monitor and troubleshoot performance issues.

● Have used regularly DBCC and DMV for different purposes

● Created, Modified, and Managed Indexes (Clustered/Non-Clustered, Simple, Composite), Constraints

● Configured and Maintained Database Mirroring using Automatic Fail-Over in SQL Server 2012 / 2008 R2

● Configured Log Shipping as Standby database from Production database for Reporting purposes

● Configured and maintains SQL Agent job for multipurpose like backup restore database maintenance and DB Refresh

● Wrote T-SQL, and Stored-Procedures for reports, and applications

● Applied SP (Service Pack) and HOT Fixes on SQL Server Database Servers

● Upgraded/migrated from SQL Server 2005/2008 R2 to 2012

● Monitored Database Servers, Databases, Agent, Jobs, Alerts log files

● Setup jobs and troubleshoot jobs related to backup, Recovered Database in POINT-IN-TIME

● Excellent in loading data, data conversion from Flat file, CSV file, Excel and from other Data Sources like Oracle, MySQL, and Access to SQL Server, Setup Jobs using SSIS package, Moved and Migrated DTS Packages to SSIS package

Environment: Windows server 2012/2008R2, 2003R2 IIS 7.5. SQL SERVER 2012/2008R2/2008/2005. Applications in ASP and ASP.net, Service-Now, SentryOne.

Citizenship: U.S Citizen

Other Certification : Zend PHP5 certified programmer ( PHP, MYSQL expertise) Security Clearance: Clearable

References: References available upon request

Contact this candidate