Manage and maintain all systems within the SQL Estate - ~120 SQL Instances; ~1500 DatabasesAll environments - Development, QA, Stage, and ProductionInteract with Business Users, Developers, and Infrastructure teams to ensure quality service.Responsible for documenting all database maintenance procedures. Enforce best practice standard and maintain policies and procedures to ensure regulatory compliance.Performance tuning / Backup and Restore / High Availability / Disaster RecoveryChange Release Management (SQL specific)/ Patching (SQL & O/S)SQL Server 2005-2019, SSIS, SSAS, SSRS, SQL Sentry Monitoring Services, Red Gate Toolbelt, Visual Studio, TFS, Azure Devops

Help organize the Louisville SQL Server & Power BI User Group.

Database Design and Administration. Development and management of all integration (SSIS) and ETL processes.Design and deployment of an Enterprise Data Warehouse (SQL Server 2012).Administrator of SharePoint technologies.SharePoint solution development.

Platform Lead / DBA for IBM Netezza SQL Appliance; SQL DBA for DB2-UDB platform; SharePoint site designer for Database Services team portal.• DBA in the data warehouse environment.• Netezza Administration responsibilities include backup/restore, performance tuning at server and query level, security configuration, workload/resource management, data distribution and data reclaim.• Development Support – Push DDL through environments, assist with query/table design, coach developers on best practices for optimal performance.• UNIX Scripting – BSH/KSH in support of automation/monitoring/alerting.• Performance tuning, monitoring and capacity planning for database systems.

Infrastructure Architect; Platform architect and senior engineer for the systems that support the hosted Sales and Marketing division of Microsoft Health Solution Group (AmalgaDemos.com).MS SQL Server DBA; Microsoft Dynamics CRM ArchitectTechnologies maintained:• Microsoft Windows Server 2008/2008R2• Failover Clustering - 9-Node cluster of Hyper-V server.• Virtualization (Hyper-V) - Management of 170+ virtual machines that support the sales/marketing and development divisions of Microsoft HSG.• Remote Desktop Services - Session Host, RD Gateway, Remote Application Access• System Center Virtual Machine Manager (SCVMM)• System Center Operations Manager (SCOM)• System Center Data Protection Manager (DPM)• Microsoft SQL Server 2005/2008/2008R2 - Optimization, performance tuning and data development (T-SQL)• Microsoft SQL Server Integration Services (SSIS)• Microsoft SharePoint 2007/2010 - Planned and deployed SP solution for Sales organization.• Windows Storage Server - 40TB SAN solution.• Microsoft Exchange 2010• Microsoft Amalga UIS 2009 - Installation, Configuration & Management.• Microsoft Dynamics CRM

• Managed Microsoft SQL Server 2005 backend. DTS integration between CRM & GP, custom SQL queries and reports.• Administration and customization of Microsoft Dynamics CRM version 4.• Administration and management of Microsoft Dynamics GP version 9.• Implemented Microsoft Dynamics ERP solutions for the company. Managed Migration from Goldmine/QuoteWerks/QuickBooks to Microsoft Dynamics CRM & GP.• Manage Windows 2003/2000 Server environment and all related supporting technologies – Active Directory, DNS, DHCP, SharePoint Services, • Administer Microsoft Exchange 2003 system. Managed migration to Exchange from legacy ISP-hosted solution.• Manage all related support and security related network services – system & security updates, corporate virus protection, etc.• Manage and support user workstations and troubleshoot all related issues.• Administer Cisco-based corporate network infrastructure – Routers, Catalyst switches and PIX firewalls. Including VPN connectivity from several satellite offices.• Administer Cisco Voice-Over-IP systems – Call Manager and Unity Voice Mail.• Provide support to Sales and Marketing as chief networking technology engineer.• Developed repeatable procedures and scalable processes to assist in efficient administration.

• Implemented real-world Windows 2000 Active Directory solutions. Many migrations from Windows NT 4.0; Designed Security models; Group Policies, and Software Distribution points for ease of management. • Design and deployment of Exchange 2000 messaging and collaboration solutions to many various customers.• Serve as an outsourced IT Engineer. Helping customers manage their current network infrastructure in addition to encouraging solutions to achieve better efficiency from their technology investment.• Design and implement secure VPN networks for a variety of customers• Design/Proposal/Implementation of a "network closet" project for a local county government center. All Cisco products; switches, router and firewall.

• Managed and maintained and Microsoft Windows 2000 network infrastructure – multiple domains.• Maintain Microsoft® BackOffice products: Exchange Server 2000, SQL Server 6.5/2000, Proxy Server and IIS.• Database programming with T-SQL (triggers, stored procedures, etc.) and SQL Server.• Lead engineer in designing / implementation of telecom data center. Focusing on fault tolerance, redundancy, and disaster recovery.Implemented Compaq based Storage Area Network solution.• Proficient with Compaq Proliant class servers, and highly competent regarding most enterprise level systems.• Network Management software: HP OpenView Network Node Manager, and Compaq’s Insight Manger.• Supervise a group of engineers responsible for monitoring a high volume transaction-based system.• Designed and managed a WAN environment consisting of 200+ sites across the US. Cisco Systems equipment: 1700, 2500, 2600, 3600, 4000, 7200 series routers; AS5300 series access servers; Catalyst 1900, 2900, 5500 series switches.• Extensive network security experience implementing / managing firewalls, high level Cisco access list control (ACL), Cisco Local Directors.• WAN technologies include Frame Relay, X.25, limited ATM, and point-to-point. RIP, OSPF, EIGRP, limited BGP, NAT, XOT, and high level access-lists.• Network / Telecom cabling: CAT5, CAT3, patch panels, T568A, T568B, 25-pair, T1, Ethernet, etc.• Experience with a Northern Telecom Meridian PBX systems.

• Managed and administered Microsoft Windows NT 4.0 infrastructure – WINS, DNS, DHCP and User Management to include MS BackOffice products, including Exchange Server 4.0, SQL Server, Microsoft SMS 1.2, Proxy Server 2.0, and IIS 4.0.• Network Management Software: HP OpenView Network Node Manager, and Compaq Insight Manager.• Managed a LAN/WAN for a computer-based training company. Nodes in Dallas-TX, London-UK, and Sydney-AU consisting of approximately 100 workstations and 30 servers. • Developed and executed a migration from a Raptor Firewall to a Cisco PIX Firewall solution.• Administered a Lucent DEFINITY G3si phone switch system including DEFINITY AUDIX voicemail. Also maintained a Lucent Multipoint Conferencing Unit (MCU) for video-conferencing, and conference bridging.

• Administered a NT based WAN. Several domestic business offices connected by frame relay. • Manage and maintain Microsoft BackOffice products, including Microsoft® Exchange Server, Microsoft® Systems Management Server, and Microsoft® SQL Server.• First exposure to WAN components including routers, CSU/DSU’s, ether-switches, hubs, and fiber transceivers.• Administered installation and integration of the companies WAN to the Internet.

• Supported the Microsoft Windows 95 operating system as well as the CompuServe online service.• Offered technical support regarding Internet connectivity, network setup and modem controls. • Also presented service in answering questions regarding billing and account setup for an on-line service. • Gained experience in Windows 95 and Windows/NT v3.51.

• Provided quality customer service to qualifying customers regarding all Microsoft® Desktop and Operating system software packages. Specializing in Windows 95 support.