Fred Woolverton
Macon,GA
Summary
Analytical and resourceful IT professional with over 20 years of demonstrated experience installing, configuring and administering multiple SQL server databases while fulfilling data storage and security requirements. Proven track of success managing large cooperate databases, backup/recovery, and performance tuning while delivering solutions tied to system efficiency and optimization Expertise in SQL Server database administration, software packages, physical and logical data modeling, and business/client requirement gathering and analysis. Highly instrumental in ensuring system health and network reliability, troubleshooting complex technical and data protection-related issues, and executing database maintenance. Adept at building strong relations with developers, management, and end-users to design new databases and improve service standards.
Overview
23
23
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Advocate Health
12.2023 - Current
- Company Overview: I joined Navicent Health in Macon, GA which was acquired by Atrium Health in Charlotte NC which merged with Advocate Healthcare in Illinois
- Client is involved in a major project to upgrade their production servers to SQL 2019 and migrate them to a set of 4 data centers which can provide adequate data throughput with minimum latency
- Completed a census of all existing SQL Servers in the environment to determine usage, application and version
- Reviewed existing servers (SQL 2008 & 2012) to make recommendations for upgrading to SQL Server 2019 & 2022
- Troubleshoot failed jobs, poor performance and bottlenecks and make recommendations for improvement
- Created scripts and procedures to facilitate moving SQL Servers from local domain to centralized data center
- Install new instances of SQL 2019 and 2022 to facilitate SQL upgrades
- Worked with app teams to upgrade apps and databases to latest versions
- I joined Navicent Health in Macon, GA which was acquired by Atrium Health in Charlotte NC which merged with Advocate Healthcare in Illinois
- Client is involved in a major project to upgrade their production servers to SQL 2019 and migrate them to a set of 4 data centers which can provide adequate data throughput with minimum latency
SQL Database Administrator
Accion Labs
03.2022 - 08.2022
- Company Overview: Contracted to Kindercare Education
- The client is involved in a major project to upgrade their production servers to SQL 2019 and migrate them to AWS
- Reviewed existing servers (all SQL 2008 & 2012 & 2016) to make recommendations for upgrading to SQL Server 2019
- Reviewed SQL Server configurations and database configurations across multiple tiers in several application stacks to make recommendations to conform to Microsoft Best Practices in an effort to improve database efficiency and performance
- Consulted with business leaders to document pain points related to database usage and performance
- Examined security procedures, AG group configurations, and maintenance practices for improvements
- Contracted to Kindercare Education
- The client is involved in a major project to upgrade their production servers to SQL 2019 and migrate them to AWS
SQL Database Administrator
LazyDays RV
05.2021 - 02.2022
- Company Overview: This business has experienced rapid expansion both geographically and financially
- Reviewed existing servers (all SQL 2008 & 2012) and quickly recommended some configuration improvements and a plan to upgrade to a newer version
- Database maintenance had not been conducted for a long time so I initiated jobs to run consistency checks, rebuild fragmented indexes and update statistics on a regular basis
- Architected plans to improve performance of very large databases by adding data files, moving indexes to their own filegroups and partitioning some huge tables
- Began a review of index strategy when I discovered some databases had as much as 70% of their file usage dedicated to indexes
- This included the removal of unused indexes, the consolidation of some indexes and moving all of them into their own filegroup
- This business has experienced rapid expansion both geographically and financially
SQL Database Administrator (ISG)
Carollo Engineering
05.2018 - 04.2021
- Architected a SQL Consolidation Plan that reduced 68 production SQL Servers (versions SQL2000 to SQL2014) and reduced the number to 24 while updating all from SQL 2000 and SQL 2005 to SQL2016 and putting Mission Critical databases on Windows Clusters for High Availability
- Updated Backup processes and procedures to ensure timely backups all databases including production, development and QA
- Improved MS SQL server performance through the design and implementation of a SQL monitoring system along with regular database maintenance and index utilization review
- Installed SQL Query Store in SQL 2016 and used it to identify and improve queries and stored procedures that were taking too long to complete
- Initiated a project of regular index review and updates to maximize performance
- Migrated 2 proprietary databases to Microsoft Azure to improve security and performance
- Installed SQL 2019 and moved several databases to that platform for testing prior to promotion to SQL 2019
Database Architect
Pull-A-Part
06.2016 - 05.2018
- Coordinated the implementation of a disaster recovery plan for corporate HQ using an Always On availability group
- Created an SSIS solution for data synchronization to multiple servers in 10 states
- Upgraded all servers to SQL 2012
- Participated in an AGILE Development environment
- Enhanced performance of the largest corporate databases through the use of multiple file-groups, files, and table partitioning
- Architected a new database solution that took 1 massive poorly functioning database and slit it into two streamlined databases one for inventory and one for finance that dramatically improved performance
- Reduced the average processing times from 5 minutes to 30 seconds in all remote servers by recoding some stored procedures and views in close collaboration with developers
SQL Server DBA
Benchmark Brands
08.2015 - 05.2016
- Executed a replication topology for supporting the business intelligence team to initiate real-time reporting
- Improved SQL Server efficiency by revamping the index strategy and upgrading several servers from SQL2005 to SQL2012
- Minimized blocking and wait times by administering the reconfiguration of all required servers
- Slashed the number of SQL Servers from 13 to 10 by redesigning the physical disk structure of several production SQL Servers
Database Manager, U.S.A.
Catlin Insurance Company
01.2014 - 08.2015
- Supervised the assessment and allocation of physical data storage for database systems based on a capacity planning protocol
- Conducted security measures, database transactions, and security audits for data protection while developing end-user database access control levels and providing full range of support to users
- Communicated with data owners and department managers to evaluate and create long-term goals for production databases
- Created a monitoring system to track such things as failed jobs, orphaned users, unsent database mail and alert SQL performance, disk space, and database status and size
- Composed database documentation and a series of stored procedures, SSIS packages, and jobs to automate routine tasks including backups and restores
- Ensured database access, consistency, and integrity by installing and deploying network components
- Assured business continuity and increased the speed of data retrieval by restructuring the disaster recovery process and the back end file structure of SharePoint databases
- Improved service standards and achieved project targets by working closely with IT project managers, infrastructure and programmer employees
- Built, motivated, trained, and led new staff members for performance optimization
- Devised and executed testing and change control procedures, a DDL auditing and reporting system for production and QA database modifications; improved data consistency and integrity by using database mirroring and database snapshots
- Conducted research and recommended database services and protocols for facilitating procurement and development efforts
SQL Server DBA/Developer
TSYS Merchant Solutions
03.2013 - 01.2014
- Collaborated with the CFO to ensure the creation and implementation of an automated sales commission process; designed two new databases, stored procedures, and SSIS packages to import and manipulate the logical data using ER/Studio
- Coordinated all backups and restore functions to maintain database replication, log shipping, and database cluster for DR solution
- Monitored database growth and SQL server performance through capacity planning
- Managed SQL Server database migration from MS SQL 2000 to MS SQL 2008
- Cultivated strong relations with internal clients to lead the replacement of manual reports with an automated reporting system while using SQL jobs, stored procedures, and SSIS packages
- Created a new SQL Database into which I imported several existing Access databases and rewrote the queries that extracted data for financial reporting
- Then replaced existing code with a system of SSIS packages to produce and distribute the reports
- Drove process improvement by diagnosing and troubleshooting complex SQL server production issues
- Attained organizational goals by designing the databases and different objects including tables, views, stored procedures, UDF’s, indexes rules and defaults on MS SQL server
- Deployed and administered SQL server 2008 and 2012 instances for development, UAT and production environments
Senior SQL Server DBA
Centers for Disease Control
04.2007 - 03.2013
- Company Overview: Consultant with HP Enterprise Solutions
- Participated in a 5 person team to monitor, administer and maintain 500+ servers with over 3,000 databases ranging in size from 12 TB to 5 MB
- These were all considered Mission Critical
- Consultant with HP Enterprise Solutions
Lead SQL Server DBA
Insight Corp
02.2006 - 03.2007
SQL Server Administration/ SQL Development
Tier Technologies
01.2005 - 01.2006
SQL Administration & Development
Drummond Co
12.2001 - 01.2005
Education
Bachelor of Arts - Urban Studies (Political Science emphasis)
Jacksonville University
MCDBA - SQL 2000
Oracle Database SQL Certified Expert -
Microsoft Certified Systems Engineer - (MCSE)
CompTIA - A+ and N
Microsoft Certification - G353-7761 SQL Server Database Administration
01.2016
Microsoft Certification - A637-4946 SQL Server: Database Administrator
01.2008
Skills
- SQL Server Database Administration
- Upgrades to newer SQL Versions
- Migrations to Azure and AWS
- Performance Tuning
- Backup & Disaster Recovery
- Data Center Migration
- Replication & Always-On
- SQL on Windows Clusters
- Performance Monitoring
- Query Tuning
- SSIS Packages Deployment
- Database Expertise
- Database Migration
- Environments
- Third-Party Software
Certification
- Microsoft Certification G353-7761 SQL Server Database Administration, 2016
- Microsoft Certification A637-4946 SQL Server: Database Administrator, 2008
- MCDBA SQL 2000
- Oracle Database SQL Certified Expert
- Microsoft Certified Systems Engineer (MCSE)
- CompTIA: A+ and N+
Technicalproficiencies
SQL Servers 7, 2000, 2005, 2008, 2012, 2014 & 2016, MS Access, Windows Server 2012, SQL Server to Server, Oracle to SQL Server, MySQL to SQL Server, MS Access/Excel to SQL Server, Databases from 5 MB to 12 TB, Production Servers from 12 to 230, Windows clusters, Symantec Clusters, VM Ware, Idera SQL Safe and Diagnostic Manager, Redgate toolkit, LiteSpeed Backup, Precise for SQL Server
Notablecontributions
- Executed a variety of ETL functions to import data from spreadsheets, disparate database platforms, and various file formats into SQL Server, formulated accurate excel reports and issued final results to users by utilizing SSIS.
- Configured transactional replication in to support reporting, merge replication at a remote mine, and even one instance of peer-to-peer replication for cross communication.
- Designed backup and automated restore processes to meet recovery SLA targets and refresh their environments.
- Developed a much faster process that used a lot less bandwidth by revamping a client’s poorly functioning ETL process.
- Led the migration of several instances from SQL 2008 to SQL 2019 while upgrading and migrating SQL Server 2000 instances through several intermediate step to SQL 2022.
- Ensured high availability which included Windows clustering and Always On Availability Groups with SQL 2012 to SQL 2019.
- Utilized Profiler, Extended Events, SQL Query Store, and PerfMon for monitoring and tuning server and query performance.
- Managed the installation and configuration of clustered and virtual environments, cloud VMs and remote DR instances.
- Proactively maintained databases with a keen focus on index defragmentation and statistics updates.
Timeline
SQL Server Database Administrator
Advocate Health
12.2023 - Current
SQL Database Administrator
Accion Labs
03.2022 - 08.2022
SQL Database Administrator
LazyDays RV
05.2021 - 02.2022
SQL Database Administrator (ISG)
Carollo Engineering
05.2018 - 04.2021
Database Architect
Pull-A-Part
06.2016 - 05.2018
SQL Server DBA
Benchmark Brands
08.2015 - 05.2016
Database Manager, U.S.A.
Catlin Insurance Company
01.2014 - 08.2015
SQL Server DBA/Developer
TSYS Merchant Solutions
03.2013 - 01.2014
Senior SQL Server DBA
Centers for Disease Control
04.2007 - 03.2013
Lead SQL Server DBA
Insight Corp
02.2006 - 03.2007
SQL Server Administration/ SQL Development
Tier Technologies
01.2005 - 01.2006
SQL Administration & Development
Drummond Co
12.2001 - 01.2005
MCDBA - SQL 2000
Oracle Database SQL Certified Expert -
Microsoft Certified Systems Engineer - (MCSE)
CompTIA - A+ and N
Microsoft Certification - G353-7761 SQL Server Database Administration
Microsoft Certification - A637-4946 SQL Server: Database Administrator
- Microsoft Certification G353-7761 SQL Server Database Administration, 2016
- Microsoft Certification A637-4946 SQL Server: Database Administrator, 2008
- MCDBA SQL 2000
- Oracle Database SQL Certified Expert
- Microsoft Certified Systems Engineer (MCSE)
- CompTIA: A+ and N+
Bachelor of Arts - Urban Studies (Political Science emphasis)
Jacksonville University
Similar Profiles
Christopher WashingtonChristopher Washington
Patient Trasnport at Advocate HealthPatient Trasnport at Advocate Health
Ali AbualhawaAli Abualhawa
Patient Transport Assistance at advocate healthPatient Transport Assistance at advocate health
Djaton WardDjaton Ward
Financial Advocate at Advocate HealthFinancial Advocate at Advocate Health