Stephen Wire Email & Phone Number

• Working in all aspects of designing and maintaining a large longitudinal database.
• Created processes for data import, data clean up, and data matching
• Developed front end utilities to manage processes related to data, security, and server performance
• Developed backend processes to report on server performance, long running queries, log file size issues, and reboots
• Account and database security management, created backend automated process and front end display to quickly search and show all security roles for servers, databases, and users.

Cincinnati, OH, US

• As a consultant learned how to handle working with multiple clients simultaneously in their vastly different and fast changing environments, developing skills in requirement gathering, organization, prioritization.
• Tasked with SharePoint farm builds, migrations, upgrades, and data imports from single server to fully redundant multi-server high availability load balanced environment using SQL clusters or SQL Always-On for.
• Created Azure Functions to read and write to and from both SharePoint Online and SharePoint On Prem. Used to create functionality such as custom end of day email notifications on all changed work items in a site.
• Trained users to use SharePoint Online, create sites, lists, content types, permissions, and basic workflow functionality.
• Created a series of PowerShell scripts to monitor server and network performance for short term and long-term tracking. Functionality includes ping times, network transfer speed, CPU and Memory usage of all farm.
• Built an all in one SharePoint server in Azure using MSDN credits. Created a PowerShell scripted menu for other developers to configure their Azure accounts, setup the storage, copy the VHDs, create the VM, and have it.

Frankfort, Kentucky, US

• Responsible for installing, configuring, and administering SharePoint 2007, KnowledgeLake Imaging product suite, Team Foundation Server, and SQL Servers
• Researched, designed, and wrote a custom windows application to migrate 1.1 million documents from the old imaging system to the SharePoint/KnowledgeLake system
• Created a SharePoint 2010 environment for upgrading the KnowledgeLake Imaging system. Upgraded and migrated the SharePoint 2007 databases to the 2010 environment
• Created a secure DMZ environment and moved the necessary applications to the DMZ
• Database administrator over multiple SQL servers and SQL clusters
• System Administrator for both internal and external web servers

• Developed coding standards, was UI team point of contact, and assisted others learning XML/XLS
• Built interactive application using XML/XSL, JavaScript, VB COM, and SQL