Experience

Milwaukee Tool

• United States
• Manufacturing
• 700 & Above Employee

• IT Manager II, Data Operations

  • Oct 2023 - Present

• IT Manager, Data Operations

  • Jan 2021 - Present

• Lead Database Administrator

  • Apr 2019 - Jan 2021



Advicent – now part of InvestCloud

• United States
• Software Development
• 1 - 100 Employee

• Manager of Data Systems

  • Jan 2014 - Apr 2019

  • Responsible for SQL License audit.• Responsible for development documentation and execution on SQL Patching standard operating procedures. • Research, develop, deploy, MS SQL muti-subnet/ multi-site high availability solution leveraging Always On Availability groups. • Develop, document, and implement database code change best practices in a high availability environment.• Develop and document best practices, and deploy SQL Server Fail Over Clusters. • Research and deploy Windows Server Dedupe technologies to reduce backup storage footprint by 60%.• Researched, Purchased, and implemented MS SQL: Monitoring and alerting solution and backup solution.• Develop, Implement, Maintain, and test database backup and recovery strategy and procedures to meet or exceed requirements set by ISO.• Developed, Implement, maintain database disaster recovery plan utilizing MS SQL log shipping.• Created and implemented SSIS packages to meet the data needs of internal and external clients and met the requirements of both security and legal departments.• Developed, Implement, maintained database maintenance strategy leveraging SQL Agent jobs and stored procedures which included dbcc, index and table statistics.• Involved with/managed several $100k+ projects converting client hosted data from Oracle to on prem MS SQL• Work as a team member with other technical staff, to ensure smooth operation between data systems, development, platforms, wao and external clients.• Created the IT Data systems team from the ground up.• Provide off hours support, as needed, to support product enhancements, data uploads, and technical issues. Show less

• Senior Database Administrator

  • Dec 2013 - Apr 2019

  • Developed and implemented solutions to ensure data storage met HIPPA and PII standards leveraging TDE (transparent data encryption).• Develop, maintain, and improve database replication processes utilizing table based triggers.• Work with product development teams to streamline product implementations, design, and processes. This included: Standardization of rollout documentation used by DBA’s and development Standardization of rollout procedures used by DBA’s Creation and Implementation of DBA source control leveraging subversion.• Implement, maintain, and test database backup and recovery procedures, jobs, and associated stored procedures leveraging the NetApp storage solution.• Maintain, monitor, and improve database replication processes utilizing transactional replication.• Create and maintain database installation procedural documentation.• Support Data Analyst department and their use of DataStage and SQL. • Support product development projects in database design, requirements specification, testing, monitoring, troubleshooting, and debugging. • Held monthly SQL training for staff on areas for improvement in data structure design, stored procedure performance, and overall tips and tricks.• Conversion/Upgrade of SQL 2005 server to SQL 2008R2• Provide off hours support, as needed, to support product enhancements, data uploads, and technical issues. Show less



Zywave

• United States
• Software Development
• 500 - 600 Employee

• Senior Database Administrator

  • Jan 2013 - Dec 2013

• Database Administrator

  • Apr 2011 - Jan 2013

• Data Analyst

  • Apr 2008 - May 2011



Bryant & Stratton College

• Student

  • 2004 - 2010



NetworkersMSB

• Telecommunications
• 100 - 200 Employee

• Claims Data Analyst

  • Aug 2007 - Apr 2008

• Assistant Product Manager

  • May 2004 - Aug 2007



Baird

• United States
• Financial Services
• 700 & Above Employee

• Operations Analyst

  • 2000 - 2004