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 and DB2 DBAs to develop maintenance and troubleshooting processes that were similar regardless of platform, and got my first experience with SAN administration.Later, we virtualized our database servers with VMWare and I managed the VMWare deployment, SAN storage, and honed our failover cluster methodology. I developed jobs to handle backups, index maintenance, and consistency checks and initially integrated with Nagios, and later LogicMonitor and PagerDuty for 24/7 alerting.In 2013, I led a team to move us to AWS EC2. We used AlwaysOn Availability Groups and built more alerting and monitoring, while growing the total number of clusters and multi-tenant databases to support our growing list of enterprise applications, each with their own challenges including triage and tuning of databases, systems, and storage.Now, I lead an international team of DBAs to support 20 enterprise applications with multi-tenant and single-tenant architectures across 1600 servers.A typical week at Infor: • 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. • Capacity planning for current and future database deployments. • Write and maintain automation tools in T-SQL, Powershell, Perl, and bash and check them into source control.

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 and uptime. I achieved some real cost-reduction goals by reducing query times for reports and ERP processes from hours to seconds.A typical week at Para-Chem: • 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. • Develop, test, and maintain Crystal Reports for users.

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 was typically less than an hour. I also designed and implemented the first backup and recovery and disaster recovery process.