Sr sql dba

DIPAK PATEL

SENIOR SQL SERVER DATABASE ADMINISTRATOR DATABASE ENGINEER

574-***-**** ********@*****.***

PROFESSIONAL SUMMARY

Senior SQL Server Database Administrator and Database Engineer with 17+ years of IT experience supporting healthcare, banking, insurance, mortgage, telecommunications, and data services environments. Experienced in SQL Server administration, upgrades and migrations, high availability and disaster recovery, performance tuning, production support, data warehousing, ETL, and operational monitoring. Skilled in supporting enterprise production platforms, partnering with application and infrastructure teams, and coordinating changes across development, test, UAT, and production environments.

CORE COMPETENCIES

SQL Server Administration & Engineering • Performance Tuning & Query Optimization • SQL Server Upgrades & Migrations

High Availability & Disaster Recovery • Backup/Restore • Clustering, Mirroring & Log Shipping • Security & Access

Production Operations & Incident Troubleshooting • Capacity Planning • Data Warehousing & ETL • Change Management

Monitoring & Observability • ServiceNow Implementation • Dynatrace Implementation • Cross-team Collaboration

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2000, 2005, 2008/R2, 2012, 2016, 2019, 2022; Azure SQL; Oracle 9i; MS Access; Cosmos DB

SQL Server tools: SSMS, SQL Server Agent, Profiler, Database Engine Tuning Advisor, Query Execution Plans, DMV, BCP/BULK INSERT

Monitoring / operations: ServiceNow, Dynatrace, Idera SQL Diagnostic Manager, Quest Foglight, PSSDIAG

BI / ETL / reporting: SSIS, SSRS, SSAS, data warehouse, data marts, ETL packages, Crystal Reports, SharePoint

Platforms: Windows Server 2003–2019, Windows clustering, VMware, SAN/NAS, LAN/WAN, Linux

Development: T-SQL, stored procedures, triggers, C#, Core Java, ASP.NET, JavaScript, XML

Tools / environments: Redgate, Quest LiteSpeed, SQL Safe, Visual SourceSafe, Serena, Visual Studio

PROFESSIONAL EXPERIENCE

CareCore / eviCore Bluffton, SC Dec 2013 – Present

Senior Advisor / Senior SQL Database Administrator

Administer, support, and monitor enterprise SQL Server production environments, including installation, configuration, patching, maintenance, and troubleshooting.

Install and support SQL Server 2008, 2012, 2016, and 2019; experience and skills aligned to SQL Server 2019 and 2022 platform administration.

Support database migration and upgrade activities; troubleshoot post-migration issues and maintain platform standards.

Perform daily database operations including backup/recovery, space management, resource utilization, capacity planning, and production issue resolution.

Analyze execution plans and stored procedures; recommend query, indexing, and configuration improvements to optimize performance.

Coordinate database schema and application changes with developers, business partners, and infrastructure/capacity teams; implement changes across DEV, SIT, UAT, and PROD.

Support implementation and operational integration of ServiceNow workflows for service requests, incidents, and change management.

Support Dynatrace implementation and monitoring enablement to improve application/database observability, alerting, and troubleshooting.

Environment: SQL Server 2000–2019, SSMS, SQL Diagnostic Manager, VMware, production change control

TEKsystems / Bank of America Jacksonville, FL May 2011 – Nov 2013

SQL Database Administrator

Supported, maintained, and monitored production database systems in a banking environment.

Upgraded legacy SQL Server 2000/2005 instances to SQL Server 2008 and 2012 and partnered with development teams on compatibility and adoption.

Configured and supported database mirroring and log shipping for disaster recovery; managed backups and restores using Quest LiteSpeed.

Tuned costly queries and database workloads to reduce logical I/O and improve performance.

Managed database access, logins, permissions, patching, hot fixes, capacity planning, and resource utilization.

Coordinated controlled code and configuration deployments across production, UAT, QA, and development environments.

Environment: SQL Server 2000–2012, Quest Foglight, PSSDIAG, SQL Server Central

Philadelphia Insurance Companies Philadelphia, PA Aug 2010 – Apr 2011

SQL Database Administrator

Supported SQL Server production, test, development, and clustered environments and participated in data-center migration activities.

Installed and configured SQL Server 2008 and clustered instances; managed replication, scheduled jobs, database maintenance, and DBCC checks.

Performed root-cause analysis using Profiler traces and system performance counters; recommended database and query optimizations.

Partnered with application, storage, and infrastructure teams to improve indexing, database access, and SAN storage utilization.

Environment: SQL Server 2005–2008, SSIS, SSRS, SQL Safe, Footprints, PSSDIAG

American Home Mortgage Servicing Inc. Irving, TX Nov 2007 – Jul 2010

Database Administrator / SQL Developer

Installed, administered, and upgraded SQL Server platforms; supported data-center move and database migration projects.

Managed clustered environments, backup and restore operations, log shipping, replication, SQL Agent jobs, security, and capacity planning.

Developed and optimized T-SQL stored procedures, triggers, indexes, and SSIS packages to support application and reporting workloads.

Used Profiler and execution plans to troubleshoot blocking and performance issues; partitioned high-activity tables to improve workload efficiency.

Collaborated with analysts, developers, system administrators, and architects on database design, access, and operational stability.

Environment: SQL Server 2000–2008, SSIS, SSRS, SSAS, VMware, SharePoint

AccuQuote Insurance Illinois May 2007 – Nov 2007

Database Administrator / Developer

Administered and developed SQL Server databases, including performance tuning, backup/recovery, disaster recovery, and security.

Created and optimized stored procedures, scripts, and XML-based data exchange; migrated DTS packages to SSIS.

Supported database upgrades, replication, log shipping, capacity planning, and application troubleshooting.

Environment: SQL Server 2000/2005, DTS, SSIS, XML, SQL Profiler, Redgate

Stericycle Illinois Jan 2007 – Apr 2007

Database Administrator / Developer

Installed SQL Server instances and migrated databases from SQL Server 2000 to 2005.

Supported high-availability and disaster-recovery practices, replication, scheduled jobs, patches, index maintenance, and database consistency checks.

Developed SSIS packages and reporting components and supported database design, data migration, and application teams.

Environment: SQL Server 2000/2005, SSIS, Reporting Services, DTS, SAN

Effective Teleservices Nacogdoches & Lufkin, TX / India Jan 2004 – Sep 2006

Data Analyst / SQL Developer

Designed and developed databases, indexes, stored procedures, triggers, constraints, and T-SQL business logic.

Maintained production, test, and development databases; tuned queries and supported data import/export using BCP and BULK INSERT.

Managed user access, scheduled jobs, technical documentation, and application database troubleshooting.

Environment: SQL Server 2000, T-SQL, ASP, VB.NET, JavaScript, Visual SourceSafe

EDUCATION

Bachelor of Engineering (B.E.), Computer Science

Contact this candidate