Gavin Hoffman Email & Phone Number

• I pioneered Infor's growth into SaaS with SQL Server. We had a few physical database servers and I built our first failover clusters and developed backup and recovery protocols for HA and DR. I worked with the Oracle.
• Meet with DBAs to mentor and suggest solutions to unique problems.
• Provide queue and incident management and assignment of tasks to support dozens of internal teams.
• Foster a DevOps mentality in order to share real-world issues with development and security teams and provide problem resolution.
• Detect and respond to critical issues before they affect up-time.
• Tune database clusters or individual customer databases, including T-SQL, indexes, troubleshoot job failures or inefficiencies, address issues in the Windows operating system, and solve performance problems with storage.

• I gained my first ERP experience at Para-Chem, and the environment included more users spread across multiple offices around the country. Since operations were 24/7, I had to address stricter needs in database tuning.
• Verify SQL Server backup integrity and maintain disaster recoverability requirements.
• Troubleshoot poor SQL Server performance and tune T-SQL, Windows, and storage to improve query times and accuracy.
• Write and maintain T-SQL code for stored procedures, views, and triggers.
• Work with our Independent Software Vendor to maintain and upgrade our ERP system.
• Manage and troubleshoot the EDI process for importing data into SQL Server.

I administered the Car Club's SQL Server and kept the membership and support databases tuned and running smoothly. I automated a lot of previously manual processes, including regular month-end reporting and accounting transactions. Prior to my arrival, the Car Club's monthly print magazine processes kept the system down for a day, but after automation it.