Vincent Holman
Orlando
Summary
Highly skilled Database Administrator with experience in managing, maintaining and troubleshooting databases. Equipped with strong problem-solving skills, adept at overseeing database design, structuring data security measures and ensuring optimal performance. Previous work resulted in improved system efficiency, increased data accuracy and reduced downtime through successful implementation of effective database management strategies.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Database Admin II
Frontline Insurance
Lake Mary
07.2024 - 08.2024
- Provided database administration services for Frontline, focusing on various DBA activities to ensure optimal database performance and reliability.
- Regularly monitored database and SQL tasks, addressed SQL job failures, and managed disk space. Resolved any abnormalities to ensure seamless operations.
- Established and adhered to schedules for non-critical system maintenance, upgrades, and performance testing to minimize downtime and maintain system integrity.
- Housed database servers for various applications within the organization with one of the biggest applications being Guidewire. Maintained the servers which was in SQL Server and made sure the servers were running properly.
- Worked with my manager to manage user access to the servers, including adding/removing new members as required to maintain proper access controls.
- Analyzed and optimized SQL queries for improved performance. Resolved SQL query and database server performance issues to enhance efficiency.
SQL Database Administrator
CereCore/Parrish Medical
Titusville
12.2023 - 07.2024
- Company Overview: Was on a 6 month contract to hire with CereCore/HCA for this Database Admin position with Parrish Medical Center. Worked the contract from December 11, 2023 until May 10, 2024. Converted to permanent employee of Parrish Medical Center on May 13, 2024.
- Troubleshooted performance issues with the servers in SSMS. Resolved bottlenecks, blocking sessions, deadlocks etc.
- Reduced query response times by 53% through proper index optimization and query tuning.
- Implemented a comprehensive disaster recovery plan, ensuring 99.99% data availability. The plan included implementing log shipping, Always-On Availability Groups, database mirroring and failover clustering
- Managed and created SSRS reports for physicians and doctors at Parrish Medical Center. Worked with Access Management team on creating access controls for these reports in SSRS.
- Developed and enforced database security protocols, resulting in a 50% reduction in security breaches. This included implementing role based access controls and transparent database encryption on the servers.
- Worked with various vendors at Parrish Medical Center on SQL Server Installations, database and server creations and creating access controls for the vendors.
Database Administration Analyst II
Conduent Business Services, LLC
Morrisville
06.2020 - 12.2022
- Integral member of a 3-person DBA team, directly reporting to the department manager/AVP.
- Wrote proficient T-SQL queries for ad-hoc scripting, stored procedures and functions.
- Developed SQL reset jobs that provided Dev and UAT instances with latest production data for dev testing. Developed, deployed and maintained SSIS packages
- Through applying appropriate indexes, was able to cut down package run times from 10 hours to 1 hour.
- Became proficient in SQL Profiler and estimated/actual execution plan analysis and became successful in optimizing long running queries and cut down execution plans.
- Lead a project where I monitored and executed SMTP file transfers via MoveIT application. Oversaw 60+ instances hosting numerous databases.
- Architected high availability/disaster recovery strategies for backup retention. Configured Always On Availability Groups and backup retention policies for Dev, QA, and Prod SQL instances.
Associate Database Administrator
Allscripts Healthcare Solutions, Inc.
Raleigh
04.2019 - 04.2020
- Gained proficiency in DBA tools, created SQL jobs, developed stored procedures, and effectively monitored databases for performance.
- Managed all database activities, including monitoring the performance of each database server, diagnosing and resolving job failures, upgrading database servers, and optimizing complex SQL queries.
- Played a big part in converting the License Compliance DB in SQL Server from On-Prem to Microsoft Azure.
- Implemented steps to ensure high availability and disaster recovery for database servers.
- Developed and modified 50+ SSIS packages to support the License Compliance process.
- Lead a project where I facilitated and lead the information gathering of SQL configurations and pricing for the conversion of 3 of our databases into a single server in Microsoft Azure. Worked with a team from Microsoft on this project.
- Provided remote support to a team of Power BI developers in India, assisting them with data visualization/reporting tasks and ensuring smooth operations.
IT Metrics Analyst / Production Management Analyst
MetLife, Inc.
Cary
03.2014 - 03.2019
- The primary metrics analyst person for the applications maintenance support team, responsible for compiling and analyzing key performance data.
- Implemented root cause analysis, predictive analysis reports for business leaders throughout various departments at MetLife. These reports helped business leaders make informed decisions.
- Delivered comprehensive metrics and data analytics to support service, problem, incident, and portfolio management teams. Produced detailed weekly and monthly analytics reports for these areas.
- Created T-SQL queries for data manipulation upon stakeholders/customers requests.
- Assisted department management by providing metrics for predictive and root cause analysis, aiding in decision-making and process improvement.
- Implemented and utilized SSMS, writing complex queries to generate and deliver data insights for internal clients.
- Developed proficiency in using SQL Server Reporting Services (SSRS) and other ad-hoc reporting tools, including Microsoft Excel, QlikView, and Power BI, to support diverse data visualization and reporting needs.
Education
Master of Science - Information Technology
North Carolina A&T State University
Greensboro, NC05.2018
Bachelor of Science - Electronics and Computational Technology
North Carolina A&T State University
Greensboro, NC05.2012
Skills
Technical Skills:
- Database security
- Disaster recovery/High Availability (Always On Availability Groups, Log Shipping, Database Mirroring and Snapshot, Failover Clustering)
- Performance monitoring
- ETL development
- T-SQL development
- PowerShell Scripting
- Data analytics
- Worked with SQL Server versions 2008-2022
- Database Migration (From On-Prem to Microsoft Azure)
Soft skills
- Effective Problem solving
- Attention to detail
- Reliable/Punctual individual
- Great Team collaborator
- Effective communicator
- Time management
- Project leadership
- Great Decision-making
- Multitasking
- Self Motivator
Affiliations
- SQL Orlando- SQL User Group Community in Orlando.
- Blacks in Technology-Orlando Chapter.
- Gamma Zeta Chapter, Epsilon Pi Tau International Honor’s Society for Professionals in Technology.
Certification
- Information Technology Infrastructure Library (ITIL) Foundations, 01/2015
- Lean Six Sigma Yellow Belt, 05/2019
In Progress
- Microsoft Azure Foundations
- Lean Six Sigma Green Belt
- Azure Database Administration
- Azure AI Fundamentals
Timeline
Database Admin II
Frontline Insurance
07.2024 - 08.2024
SQL Database Administrator
CereCore/Parrish Medical
12.2023 - 07.2024
Database Administration Analyst II
Conduent Business Services, LLC
06.2020 - 12.2022
Associate Database Administrator
Allscripts Healthcare Solutions, Inc.
04.2019 - 04.2020
IT Metrics Analyst / Production Management Analyst
MetLife, Inc.
03.2014 - 03.2019
Master of Science - Information Technology
North Carolina A&T State University
Bachelor of Science - Electronics and Computational Technology
North Carolina A&T State University