Allen McGuire

About Allen McGuire

Microsoft SQL Server DBA since 1998 for numerous companies of varying sizes and industries with a solid track record for up-time and performance. Strengths include installing, configuring, securing, tuning and administering Microsoft SQL Server versions through 2019. Proficient in failover cluster instances, availability groups, log shipping, replication, etc. Solid performance tuning skills using many tools developed by the SQL Server community.Specialties: SQL Server Administration - all versions, Windows Server Administration - all versions, Dynamics AX 2009 Administration, High Availability Solutions, Scalability Solutions, Disaster Recovery and Business Continuity Planning.

Experience

1. Sql Server Dba

   Main Street Technical Services

   Nov 2021 — Present

Education

• University of Wisconsin-Stout

  Bachelor's (BS), Applied Mathematics

  1992 — 1997

• University of Phoenix

  Master's (MS), Computer Information Systems

  2003 — 2005

Skills

• High Availability
• Vb.net
• Networking
• Performance Tuning
• Servers
• Data Integration
• Hyper-V
• Software Development
• Asp
• Data Architecture
• Database Design
• Data Migration
• Database Administration
• Iis
• Cluster
• Sql Tuning
• Active Directory
• Data Modeling
• Windows Server
• Business Intelligence
• Analysis Services
• Powershell
• Databases
• Database Security
• Sharepoint
• Internet Information Services (Iis)
• Data Warehousing
• Security
• Etl
• Microsoft Exchange
• Mysql
• T-Sql
• Replication
• Olap
• Sql Server Integration Services (Ssis)
• Dts
• Sql
• Sql Server Reporting Services (Ssrs)
• Ssrs
• Ssis