Allen Mcguire Email & Phone Number

Andover, Ma, Ma, Us

SQL Server Database Administrator, providing expertise to a wide array of Navisite clients. In some cases I'm the primary DBA resource whereas with others I work with their team to ensure their environment is stable - an umbrella under which a lot of consideration resides. It would include installation, configuration, maintenance, applying updates/upgrades, performance monitoring/tuning, high availability, disaster recovery, scalability, predictability, etc. I strive for excellence in each of those areas by virtue of following industry standards, best practices, automation and attention to detail. As a resource for many clients, a key component of my success is the ability to multi-task and always think one step ahead of what the client may want or ask for. Planning for unforeseen activities is invaluable in our line of work!

Neenah, Wisconsin, Us

Operational Database Administrator, primarily tasked with monitoring and standardizing the configuration of roughly 150 instances of SQL Server. Installed and configured numerous Failover Clusters/Availability Groups, worked with them on a POC for a solid monitoring solution (installed/configured for POC), updated documentation for all instances and also got each instance current with Service Packs and Cumulative Updates.

Brillion, Wi, Us

SQL Server DBA (2008 R2, 2012, 2014 and 2016)===============================================================- Migrated all database instances from physical servers to virtual machines (P2V) which maximized the use of our hardware resources and saved the company a significant amount in licensing costs- Guaranteeing stability, scalability and optimal performance by using a combination of clustering and replication- Maximize resources by taking advantage of third party tools to augment administration, monitoring and automation: http://allen-mcguire.blogspot.com/2013/08/my-dba-toolbox.html- Developed solid approach to "working smarter, not harder" - outlined in my blog post: http://allen-mcguire.blogspot.com/2014/11/work-smarter-not-harder-utility-instance.htmlMicrosoft Dynamics AX Administrator (2009)===============================================================- Responsible for stability and monitoring of all components of AX infrastructure- Proficient at installing, configuring and administering various AX components: AOS, AFS, AIF- Very familiar with nuances of master planning, using various administrative approaches to decrease batch execution by 50% including linking tasks, index maintenance, batch groups/thread configuration, parallel processing (scheduling helpers), and a few key AX modifications- Administrator of various third party AX tools and utilities- Streamlined development methodology by controlling both the flow of application code and data, which required restores of production data into various non-production environments- Responsible for nearly 100 Windows servers and virtual machines- Authored numerous custom SSRS reports to assist with monitoring and maintenance of overall AX environment

Green Bay, Wi, Us

Data Services Responsibilities:- Planned and executed migration from SQL 2000 to SQL 2008/2008 R2- Scaled out database environment by configuring and administering replication (merge and transactional) to take pressure off core database systems- Created transactional replication publications to make data available for recurring activities, reporting and to provide read-only data where necessary- Used merge replication to support interactive applications that were geographically dispersed- Guaranteed high availability with use of database mirroring- Authored scores of advanced SSRS reports used to highlight various performance indicators of the entire eCommerce operation using combinations of gauges, graphs and raw data output- Managed >1.5TB data warehouse using the suite of SQL Server tools and utilities: Integration Services, Analysis Services and Reporting Services- Responsible for writing ETL processes to populate data warehouse for reporting and analytical purposes- Performed database administrative functions: installation/configuration, monitoring, performance tuning, backup/recovery and business continuity planningInfrastructure Responsibilities:- Managed upgrade of core networking assets and service contracts to provide significant increase in network capacity and performance- Managed the installation, configuration and migration to Exchange 2010- Managed Hyper-V implementation to consolidate and re-appropriate hardware resources- Managed implementation of network load balancing to assure high availability of various resources- Managed WSUS implementation for automation of patch management of both workstations and servers- Managed implementation of Active Directory

De Pere, Wi, Us

Database Administrator for a financial services company. Was responsible for installing, configuring, securing and tuning database instances using clustering technologies to guarantee near perfect uptime to meet very strict service level agreements with clients and customers.

Madison, Wi, Us

I was responsible for securing roughly 80 SQL 2000 instances per what is called DIACAP standards. Such standards are provided by the Federal Government and are required for each company that interfaces with Government systems (Medicare, Medicaid, etc.).

Madison, Wi, Us

My primary role here was that of a SQL Server DBA, although I was also tasked with centralizing the various decision making utilities used so the data could be shared, reused, and reduced duplication of efforts among the various disciplines. The centralized system evolved to be their heavily utilized Intranet, which I developed in Cold Fusion running on IIS. I wrote custom applications for architectural planning, their Help Desk, and even an application we coined "Flad Bay", which assisted in selling off depreciated assets.I was also responsible for administering all their Windows Servers, Patch Management (WSUS), baseline security scans (MBSA), etc.

- Designed, developed, and managed SQL Server database for start-up third party billing company under very tight project constraints- Created backup and disaster recovery plans to guarantee system availability- Assisted in authoring our turnkey solution for online payment processing- Developed secure website for clients to manage their merchant accounts and online customers- Primary development platform was Active Server Pages and SQL Server 7.0

Bachelor'S (Bs), Applied Mathematics

Master'S (Ms), Computer Information Systems

Education record