John Couch Email & Phone Number

Peoria, AZ, US

Scottsdale, Arizona, US

• Managed a team of 9 engineers supporting the day to day operations and management of the virtualized platform running Windows and CentOS systems running on VMWare VXRail, VSAN, Nimble and limited interactions with AWS.
• Responsible for conducting weekly 1-1’s, performance evaluations, interview and hiring of new employees, disciplinary processes and terminations.
• Working with team to ensure properly defined technical standards, SOPs and policies for the setup, configuration and administration of AIPs supported platforms.
• Working with team to define KPIs in relation to area of the technical business.
• Defined SLAs for ticket assignments and tracking to ensure proper response time and completion of business requests.
• As a technical manger I maintained my previous responsibilities of managing the DBMS platforms and assisted in architecting solutions to resolve performance issues…etc.

Scottsdale, Arizona, US

• Responsible for the standardization, documentation and administration of the MongoDB, MariaDB and SQL Server environment.
• Defined and created an automated installation process for new SQL Server builds using PowerShell.
• Defined security protocols and documented standards for SQL Server and its access.
• Defined, documented and implemented standardized processes for CDC and TDE implementation within the SQL Server environments.
• Developed 3 different standardized processes for login auditing using Server Audit, Extended Events and Logon Trigger. This was done to satisfy different use cases.
• Documented and developed PowerShell script for the Audit team to run quarterly audit reporting against SQL environment.

Tempe, Arizona, US

• Responsible for the standardization, documentation and administration of Azure SQL Database, Azure Managed Instance and other SQL related resources not managed by the internal IT staff.
• Investigated the use of Azure SQL Data Sync for cross region data synchronization.
• Setup and administered Azure SQL Data Sync for the migration of database tables and associated data between multiple Azure SQL Databases. Using bi-directional synchronization allowed for the application to failback if.
• Developed and deployed Extended Event Session for capturing Top Offending queries based on customized attributes at time of deployment. XE files were stored in Azure Blob storage.
• Assisted Teammate in development of XE session for capturing User Login Tracking by defining a standardized template for creation, deployment and logging.
• Developed and deployed custom C# application for reading XE files from Azure Blob Storage and providing necessary SQL statements to query the XE files based on files selected.

Chandler, Arizona, US

Database Architect at Insight

Chandler, Arizona, US

 Managed an international team of 5 DBAs supporting the day to day operation and management of a DBMS environment consisting of SQL Server, MongoDB and Sybase on both and virtual hardware. Defined technical standards for setup, configuration and implementation of supported DBMS platforms in a physical and virtualized environment. Managed and prioritized.

Chandler, Arizona, US

 Installed, configured and administered SQL Server 2000/2005/2008/2012 (32/64 bit) DBMS on Windows 2003/2008/2012 Server (32/64 bit) in both clustered, and non-clustered environments running on both physical and virtualized environments.  Installation and configuration of Windows 2003/2008/2012 multi-node clustered environments using standardized drive.

Madison, Wisconsin, US

 Installed, configured, upgraded and administered SQL Server 7.0/2000/2005/2008 DBMS on Windows NT/2000/2003/2008 Server (32/64 bit) on both clustered (active/passive), and non-clustered environments for 30 plus clients on 85 plus servers. Maintained databases ranging in size from a few hundred megabytes to 1.5 terabytes. Configured and administered.

Phoenix, AZ, US

 Installed, configured and administered multiple instances of SQL Server 2005 on a stand-alone server for Development, Test and Production. Designed and documented logical and physical database schemas using Visio. Developed, tested, modified and implemented new and existing database functionality using Transact-SQL (Procedures, Functions and.

New York, NY, US

 Installed, configured, upgraded, and administered SQL Server 2000/2005 DBMS platforms in clustered, active/passive, and non-clustered environments. Worked with senior IT management, business analyst, developers, and users to draft, review, and acquire sign-off of systems and applications requirements. Designed and documented logical and physical.

Columbus, OH, US

 Managed Infrastructure team consisting of 15 employees, conducted monthly 1-1’s, performance evaluations, interviews and hiring of new employees, disciplinary processes and terminations. Planned and managed the relocation of the company datacenter to a new facility. Managed and prioritized team sponsored tasks, projects and resources to ensure ability.

Columbus, OH, US

 Worked with senior IT management, business analyst, developers, and users to draft, review, and acquire sign-off of systems and applications requirements. Designed and built application test environments on VMWare Workstation 3.2/4.0. Installed, configured and administered Microsoft Exchange 2000/2003. Installed, configured and administered DBMS.

 Installed, configured, upgraded, and administered SQL Server 2000 and Oracle 8.0/8i DBMS platforms in clustered, active/passive, and non-clustered Windows 2000 environments. Installed and administered Microsoft Exchange 5.5. Installed and administered SilverStream, Jrun, Blazix, IIS and Jakarta-Tomcat web servers. Created and managed project plans.

 Installed, configured, upgraded, and administered SQL Server 7.0/2000 and Oracle 8.0/8i DBMS platforms in a non-clustered Windows NT/2000 environment. Designed, developed, and implemented client server and N-Tier based solutions for online order entry, provisioning, point of sale, customer information tracking, and employee information and benefits.

 Designed, developed, and implemented client server and N-Tier based solutions for online order entry and provisioning using PowerBuilder 5.0/6.5, PFC and Oracle 7.2/7.3 in a Windows NT environment. Designed and documented logical and physical database schemas using PowerDesigner 6 and Erwin. Designed and developed framework objects for use in.

Williamsville, NY, US

 Designed, developed, and implemented client server based solutions for chemical analysis, facilities management, online order entry, provisioning and call center tracking using PowerBuilder 5.0/6.5, PFC, DB2, and Oracle 7.2/7.3 in a Windows NT environment. Designed and documented logical and physical database schemas using PowerDesigner 6 and Erwin..

 Designed, developed, and implemented client server based solutions for unemployment insurance claims tracking, and materials management using PowerBuilder 5.0, Visual Basic, Visual C++, custom built foundation class libraries, and multiple DBMS platforms consisting of Sybase System 10/11, Oracle 7.3, DB2, Microsoft SQL Server 4.0, Informix, and SQL.

New York, NY, US

 Responsible for the analysis, design, development, and implementation of client server based solutions for customer information tracking and budget analysis using Powerbuilder 4.0/5.0, PVCS, Watcom and SQL Anywhere in a Windows NT Server environment. Planned, tested, and implemented disaster recovery solution.  Installed, setup, and administered Watcom.

 Monitored and maintained a worldwide corporate network encompassing an IBM 3090/600S mainframe running 11 MVS images as guests of VM, an IBM ES/9000 mainframe running VM, an IBM9672 PTS mainframe running 7 MVS images, several servers running Unix, Windows NT, Novell File Services, Microsoft Mail, and Lotus Notes. Managed IBM 3480 and 3490 tape drives.