SUMMARY

• 15+ Years of extensive experience in Information Technology as a Senior SQL Server Production DBA (Systems DBA, Operations DBA, Infrastructure DBA, Engineering DBA) in TEST, QA, UAT, STAGE, DEVELOPMENT and PRODUCTION Environments.
• 24 X 7 Production Database on Call Support.
• Experience in Installing, Configuring and managing SQL Server Instances in a Multi Node Clustered and Non - Clustered Environment.
• Extensive experience in Database Migrations and Upgrading (In Place & Side by side) of SQL Server 2000/2005/2008/2008 R2 over to SQL server 2012/2014/2016/2017.
• Expertise in implementing and maintaining Snapshot, Transactional, Peer to Peer and Merge replication in SQL Server 2000, 2005, 2008(R2)/ 2012/2014/2016/2017.
• Hands on experience in Designing Database Server Infrastructure, Virtual/Physical Environments, Database Engineered Solutions and Strategy for Data Recovery, High Availability and Disaster Recovery.
• Extensive experience with High Availability Design and Disaster Recovery solutions include Microsoft SQL Server Failover Clustering, Database Mirroring and SQL Server Log Shipping, R eplication, Always on High Availability Groups (Single and Multi Subnet AG Clusters)
• Extensive experience with backup and restore procedures using native and third party backup tools.
• Experience in allocating system storage and Capacity planning for future storage requirements for the database system.
• Experience in Designing, establishing a strategy to manage data across servers using linked servers.
• Experience in Configuring and deploying various applications using SSRS and SSIS packages in Test and Production environments.
• Expertise in Monitoring and Optimizing the Performance of Database using DTA (Database Tuning Advisor) and ITA (Index Tuning Advisor).
• Extensive experience with Batch processes using Import, Export, Backup, Database Monitoring tools and schedule jobs monitoring.
• Experience in customization and deployment of Third party application software with vendor interaction.
• Experience in creation and maintenance of T-SQL Procedures, Functions and Packages.
• Experience in SQL Server Patching both in clustered and non-clustered environments
• Experience in Incident, Change and Problem Management Processes

TECHNICAL SKILLS

Databases: SQL Server 2000, 2005, 2008, 2008(R2), 2012, 2014, 2016, 2017, Oracle 8, 8i, 9i, 10G, 11G, 12C, IBM DB2, IBM DB2/400 and MS Access

O/S: Windows 2000, 2003, 2008, 2008 (R2), 2012 (R2), and 2016 Servers

SQL Services: SSIS, SSRS, SSAS, DTS, SS Upgrade Advisor, SS Migration Assistant

Languages: T-SQL, PL/SQL, C, C++, ASP, HTML, VB, VB Script and Java Script

Tools: LightSpeed, Fog light, Solar Winds, SCOM, Red Gate, Informatica, PeopleSoft, Capacity Manager, Erwin Data Modeler, TOAD, IIS, MS Access, BMC Patrol, Fog Light, BMC Remedy, Service Now, VERITAS Storage Foundation, Dell EMC, NetApp, NetApp Snap Mirror, QLogic SAN Server, VERITAS Net Backups, Visual Studio .NET, Sandpiper VSU Snap Backups, ESPx Job Scheduler on Main Frame for Cold/Hot Backups, SQL Servers in VM Ware Environment, VMFS Clusters, RDM Clusters, VEEAM Backup and Replication 9.5, Cohesity, Backup Exec, EMC Avamar & Networker, SIMPANA CommVault Backups, SQL VM Server Machine Backups, Microsoft SQL Azure (Iaas, Paas), ASR, HA/DR in SQL Azure, SQL Database Support in Azure. SQL Database Backups, Migration between On Premises to Azure.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Senior SQL DBA

Responsibilities:

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered and non-clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2008(R2), 2012, 2014, 2016 and 2017 in clustered and non-clustered environment on Windows 2003, 2008 (R2), 2012 and 2016 servers.
• Involved in the database migration of SQL Server 2008 R2 databases to SQL Server 2012/2014/2016/2017.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2008(R 2)/ 2012/2014/2016/2017
• Involved in Implementation of the Always on Availability Groups in SQL Server 2012/2014/2016/2017 Instances.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• Performance Tuning of the SQL Server
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008/2012/2014 and 2016 Reporting Services.
• Strong Working Experience in Clustered and Non-Clustered Environment.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Maintained and managed Change and Release Management process for all database related change controls and releases.

Environment: SQL Server Versions 2008 (R2), 2012, 2014, 2016 and 2017 on Windows 2008 (R2)/2012/2016 Servers, TSM Backups, SAN Replication, DB2, Oracle, Nagios Monitoring, SCOM, vFire Core to implement ITIL Process for Release, Change, Problem and Incident Management, SQL Servers in VM Ware Environment, VMFS Clusters, RDM Clusters, AG Clusters, Cohesity Backups.

Confidential, Austin, TX

Senior SQL DBA

Responsibilities:

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered and non-clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2008(R2), 2012, 2014, 2016 and 2017 in clustered and non-clustered environment on Windows 2003, 2008 (R2), 2012 and 2016 servers.
• Involved in the database migration of SQL Server 2008/2008 R2 databases to SQL Server 2012/2014/2016/2017.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2008(R 2)/ 2012/2014/2016/2017
• Involved in Implementation of the Always on Availability Groups in SQL Server 2012/2014/2016/2017 Instances.
• Involved in both P2V and V2V Migrations for SQL Server 2008 R 2/2012/2014.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• Performance Tuning of the SQL Server
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008/2012/2014 and 2016 Reporting Services.
• Strong Working Experience in Clustered and Non-Clustered Environment.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Maintained and managed Change and Release Management process for all database related change controls and releases.

Environment: SQL Server Versions 2005, 2008 (R2), 2012, 2014 and 2016 on Windows 2003/2008 (R2)/2012 Servers, LightSpeed 6.5.1/7.1 and 8.0, Symmetrix Remote Data Facility (SRDF), Doubletake, DB2, Site Scope, BMC Patrol, Fog light, VERITAS Net Backups, QLogic SAN Surfer, BMC Remedy 7.1 and 7.6 to implement ITIL Process for Release, Change, Problem and Incident Management, SQL Servers in VM Ware Environment, VMFS Clusters, RDM Clusters, VEEAM Backup and Replication 9.5, Backup Exec, EMC Avamar & Networker, SIMPANA CommVault Backups, SQL VM Server Machine Backups.

Confidential

DBA Tech Lead

Responsibilities:

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered and non-clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2005, 2008(R2) and SQL Server 2012 in clustered and non-clustered environment on Windows 2003, 2008 (R2) and 2012 servers.
• Involved in the database migration of SQL Server 2000/2005/2008 databases to SQL Server 2008(R 2)/ 2012/2014/2016 .
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005/2008(R 2)/ 2012/2014/2016
• Involved in Implementation of the Always on Availability Groups in SQL Server 2012/2014/2016 Instances.
• Involved in both P2V and V2V Migrations for SQL Server 2005/2008/ 2008 R2/2012.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• Performance Tuning of the SQL Server
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008/2012 and 2014 Reporting Services.
• Strong Working Experience in Clustered and Non-Clustered Environment.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Maintained and managed Change and Release Management process for all database related change controls and releases.

Environment: SQL Server Versions 2005, 2008 (R2), 2012, 2014 and 2016 on Windows 2003/2008 (R2)/2012 Servers, LightSpeed 6.5.1/7.1 and 8.0, Symmetrix Remote Data Facility (SRDF), Doubletake, DB2, Site Scope, BMC Patrol, Fog light, VERITAS Net Backups, QLogic SAN Surfer, BMC Remedy 7.1 and 7.6 to implement ITIL Process for Release, Change, Problem and Incident Management, SQL Servers in VM Ware Environment, VMFS Clusters, RDM Clusters, VEEAM Backup and Replication 9.5, Backup Exec, EMC Avamar & Networker, SIMPANA CommVault Backups, SQL VM Server Machine Backups.

Confidential, TX

SQL Server DBA

Responsibilities:

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2000/2005 and 2008 in clustered and non-clustered environment on Windows 2003 and 2008 servers.
• Involved in the migration of SQL Server 2000/2005 databases to SQL Server 2008.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005 and 2008.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Temp db, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, and I/O and tuned and improved the overall performance of the server for many clients.
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005 Reporting Services.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Reviewed T-SQL code written by developers to follow better standards, procedures to optimize for better performance before QA deployment.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Involved in 32 bit to 64-bit Data Migrations, SQL 2000/2005 to SQL 2008 Migrations on Windows 2000, 2003 and 2008 Servers.
• Maintained Change Control and Release Management process for all database releases, data fixes
• Maintained a stable process of database refresh from production to internal environments.

Environment: SQL Server 2005 and 2008 SQL Servers on Windows 2003/2008 Servers, Visual Studio .NET, Oracle 10G, DB2, Toad, BMC Patrol, Lite Speed, VSU Snap Backups, Capacity Manager, MS Access, VERITAS Net Backups and ESPx Job Scheduler on Mainframe for Hot Backups

Confidential, CA

SQL Server DBA

Responsibilities:

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances Clustered, non-clustered environment.
• Involved in Installing, Configuring, Monitoring and Troubleshooting SQL Server 2000 and 2005 in clustered and non-clustered environment on Windows 2000 and 2003 servers.
• Upgraded the existing Servers from SQL Server 2000 to SQL Server 2005.
• Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, and I/O, tuned and improved the overall performance of the server for many clients.
• Involved in Physical and Logical design and Schemas for databases of new application.
• Tuning of SQL Sever Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Remote Monitoring of SQL Server 2000/2005.
• Developed and configured Database Mirroring.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. Designed and implemented capacity planning module to make future projections in terms of system resources.
• Developed and Configured Logshipping and Replication.
• Installed and Configured SQL server Failover Cluster and applied service packs.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Responsible in migrating DTS packages from SQL 2000 to SSIS Packages in SQL Sever 2005 databases.
• Installed, Managed and Deployed Reports using SSRS SQL Server 2005 Reporting Services.
• Installed, Configured, Developed and Deployed SSIS packages.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitored and tuned both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.

Environment: SQL Server 2000 and 2005 and Windows 2000 and 2003, Toad, Oracle 8i, Veritas NetBackup, Litespeed, Visual Studio.NET, SSIS, SSRS, Crystal Reports, Sybase, Informatica, Litespeed, Capacity manager, Foglight, SSMA, SSUA

Confidential, MI

SQL Server DBA

Responsibilities:

• Provided 24*7 Production support for 110 total numbers of servers out of which 78 Servers are production servers.
• Installed SQL Server 2000 on windows 2000 servers. Installed service packs and applied latest security fix.
• Installed and configured transactional and snapshot replication for production servers to other production servers available in remote locations.
• Installed and maintained MS SQL Fail over clustering with two nodes for mission critical database for high availability solutions.
• Created logical and physical data modeling using Erwin tool.
• Experienced with upgrading from SQL Server 7.0 to MS SQL Server 2000 server
• Worked with the application administrators to make sure applications are fine after the upgrade.
• Created log shipping for reporting purpose and backup purpose in case primary server failure for high availability solutions.
• Developed, Configured and Monitored Logshipping.
• Responsible for Migration and Upgradation of SQL Servers.
• Experienced with configuring SQL Server to run in optimal conditions.
• Involved in architecting the SQL Server environment, installation and maintained the SQL Servers for maximum database availability.
• Involved in backup and restore of the SQL Server databases.
• Experienced with improving server performance using windows performance Monitor.
• Involved in improving SQL Server database performance using Query analyzer Index tuning wizards, execution plans and profilers.
• Created the DTS packages to import the data from oracle, access databases in To the SQL Server.
• Experienced in creating documentations for the SQL Server and SQL Cluster Installations and apply service packs and SQL Server security administration Processes.
• Experienced with SQL Disaster recovery solutions and created the procedure to recover the databases in the disaster situations.

Environment: SQL Server 7.0/2000, Windows 2000/2003, Oracle 8, IIS 5.0, Visual Basic.Net, SQL Server Reporting Service, Crystal Reports, Litespeed, ErwinDataModeler, Sybase, DTS, ToadMS Access.