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 and Azure. • 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.• Developed procedure for reporting and repairing missing or misconfigured features on customer accounts.• Worked with developers to discover duplicate record entries and cleanup and enforce uniqueness on feature tables.• Documented and developed Windows and SQL Server Certificate reporting using PowerShell. • Recovered database server using Rubrik and documented to process for use by team.• Wrote PowerShell system status check script for validating SQL Servers after patching and/or restarts and build out.• Migrated existing local backups to Rubrik and documented steps for teammates on manual backups, manual restores, live mounts and replica log shipping.• Work with developers to define database design and development standards.• Setup and configured SQL Sentry for monitoring and alerting.• Worked with developers on restructuring, indexing and tuning poor performing queries.• Built custom C# application for data analysis to compare columnar data between Production and non-production systems to ensure no production data exists in lower environments.

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 the migration encountered issues. • 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.• Defined and documented Managed Instance deployment process to ensure standardized setup and configuration.• Developed and deployed database consistency check and index rebuild processes using Azure Pipelines to ensure Resource Governor use on Managed Instances. • Defined baseline criteria for Azure Vulnerability reporting and developed PowerShell script to deploy and standardize all environments. • Defined and implemented alerting thresholds and notification standards using PowerShell and Azure Pipelines for Azure SQL Database and Azure SQL Managed Instance.• Documented and deployed Redgate SQL Monitor configuration settings for alerting and notification to email, slack and VictorOps.

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 team sponsored tasks, projects and resources to ensure ability to meet defined timelines. Responsible for conducting weekly 1-1’s, performance evaluations, interview and hiring of new employees, disciplinary processes and terminations.  Worked with team to define goals and training plans, and managed teammate progress to ensure growth of their technical skills. Ensured cross training of teammates to ensure each teammate had the ability to work on multiple DBMS platforms. Tracked and maintained 1m budget, and provided recommendations during the budgeting process. Worked with multiple departments to define needs, design solutions and provide technical direction.

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 layouts and mount points. Mentored DBA team on technical issues, development, administration and standards. Worked with 3rd party application vendors and internal development staff to optimize database code and structure and improve performance of applications. Worked with Windows, VMWare and SAN administrators to define corporate standards for setup of SQL Server on both physical and virtualized environments.  Migrated company infrastructure from SQL Server 2000/2005 x86 to SQL Server 2008/2012 x64.  Performed several disk level swap-outs to align disks, increase space, restructure databases, cleanup environments and reorganize file layouts for log/data separation.  Administration of databases ranging in size from a few hundred megabytes to 4+ terabytes. Setup and configured auditing to track altering of objects in production. Configured and administered HA/DR solutions using Database Mirroring, Clustering and Replication. Developed, tested and implemented new database functionality using Transact-SQL (Procedures, Functions and Triggers), CLR and PowerShell. Created and maintained several SSIS packages used for porting and massaging data from various sources into SQL Server. Tuned and Optimized SQL Queries using SQL Profiler, SQL Sentry Plan Explorer, Execution Plans, Performance Monitor and DBCC Commands. Defined standardized processes for production support, change management, database administration and development.  Built custom solutions for tracking and reporting DBMS environment using C# and SQL Server.

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 HA/DR solutions using Database Mirroring, Clustering and Replication. Developed, tested and implemented new database functionality using Transact-SQL (Procedures, Functions and Triggers) and Linked Servers. Tuned and Optimized SQL Queries using SQL Profiler, Execution Plans, Performance Monitor and DBCC Commands. Defined standardized processes for production support, change management, database administration and development.

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 Triggers). Tuned and Optimized SQL Queries using SQL Profiler, Execution Plans, Performance Monitor and DBCC Commands. Defined standardized processes for production support, change management, database administration and development.

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 database schemas using Visio. Designed and standardized coding templates for database development of stored procedures, functions, and triggers. Designed and implemented a database server performance monitoring solution for storing system wide performance counters, as well as SQL Server specific counters to aid in reporting, troubleshooting and general monitoring of database systems. Developed, tested, and implemented new database functionality and data porting processes using T-SQL stored procedures, functions, and triggers, Linked Servers, DTS, BCP, SQLDMO, WMI, and VBScript. Defined standardized processes for production support, change management, database administration and development.  Created DTS packages to upload and extract data from multiple data sources using dynamically created workflow, ActiveX (VBScript) email notification, T-SQL, and other built in functionality.  Tuned and optimized SQL Queries using SQL Profiler, Execution Plans, Performance Monitor, and DBCC Commands. Administered Analysis Services and wrote MDX queries for business reporting.

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 to meet defined timelines. Worked with team to define goals and training plans, and managed teammate progress to ensure growth of their technical skills. Tracked and maintained 5m budget, and provided recommendations during the budgeting process.

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 platforms in clustered, active/passive, and non-clustered environments supporting Oracle 8.0.5/8i and Microsoft SQL Server 6.5/7.0/2000. Designed and documented logical and physical database schemas using Visio and Powerdesigner. Created SQL Server DTS packages to upload and extract data from multiple data sources using dynamically created workflow, ActiveX (VBScript) email notification, T-SQL, and other built in functionality. Created data import processes using T-SQL stored procedures, functions, and triggers, DTS packages, Linked Servers, BCP, SQLDMO, WMI, and VBScript. Developed and implemented new database business solutions using SQL Server stored procedures, functions and triggers. Tuned and optimized SQL queries using SQL Profiler, Execution Plans, Performance Monitor, and DBCC Commands. Converted existing Access 97/2000 database applications to .Net Client Server based solutions using C# .net and SQL Server 2000. Designed, developed, and implemented applications solutions for various business needs using C#, ADO.Net, VB.Net, Java, VBScript, ActiveX, DTS, Crystal Reports, and Perl.

 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 using Microsoft Project 2000 and Project Workgroup. Designed and documented logical and physical database schemas using Erwin and Rational Rose. Installed, setup, implemented, and administered Visual Source Safe for application version control. Developed use cases, realizations, test plans, and functional designs and layouts using Rational Rose. Developed DTS packages, stored procedures, and functions using PL/SQL and TSQL. Worked with senior IT management, business analyst, developers, and users to draft, review, and acquire sign-off of systems requirements. Worked with software development team to identify and document platform and database requirements. Designed, developed, and deployed web based solutions using Java, JSP, Dreamweaver, HTML, SilverStream 3.1/3.7.1, and VBScript in a Windows NT/2000 environment. Maintained databases, tuned queries, and administered user rights using TOAD and Query Analyzer. Configured and maintained a network consisting of 4 IBM Netfinity 5000 Servers running Windows NT/2000.

 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 tracking using PowerBuilder 6.5/7.0 and PFC in a Windows NT/2000 environment Developed framework objects derived from the PFC. Designed and documented logical and physical database schemas using Erwin and Modelmart. Developed packages, stored procedures, and functions using PL/SQL, T-SQL, SQL Station, SQL Lab, TOAD, and Query Analyzer.  Worked with business analysts and users to draft, review, and acquire sign-off of systems and applications requirements. Developed reports using Crystal Reports 7. Developed Unit Test Plans for QA testing.  Developed user manuals and trained users on in-house applications. Migrated existing application databases from Access 2000 to SQL Server 2000 and Oracle 8i. Migrated existing applications from Powerbuilder 3.0/6.5 to 7.0. Tracked application and database production issues using Clarify. Used PCMS version control software for mainframe applications.

 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 application development using Powerbuilder 5.0/6.5. Developed packages, stored procedures, and functions using PL/SQL, SQL Station, SQL Lab, and TOAD. Worked with business analysts and users to draft, review, and acquire sign-off of systems and applications requirements. Performed and approved database and application code reviews.  Migrated existing application from Powerbuilder 5.0 to 6.5.  Mentored junior application DBAs. Used SQA Team Test for Production issue tracking.  Used PCMS for code management and version control.

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. Developed DTS packages, stored procedures, and functions using PL/SQL, SQL Station, SQL Lab, and TOAD.

 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 Anywhere in a Windows NT environment. Performed data integrity analysis on existing Sybase System 10/11 database. Developed data porting processes to move data across DBMS platforms. Updated and maintained data reformatting processes written in Visual C++ and Visual Basic. Reviewed and modified existing stored procedures using T-SQL. Performed trouble-shooting and analysis on production application issues. Drafted and tuned SQL statements for use in application development. Performed quality assurance testing of applications, and responsible for release sign-off.

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 and SQL Anywhere DBMS. Planned, tested, and migrated company databases from Watcom to SQL Anywhere. Developed data porting routines to move data from the AS/400 to NT server platform. (SQL Anywhere.) Drafted database schemas using S-Designer Drafted and tuned SQL statements for use in application development. Integrated internally developed data encryption routine for securing passwords and data transfers. Setup and configured PCs on a Novell NetWare LAN using LAN Workplace, Windows 95, and Windows NT. Setup and configured PVCS for version control. Developed user manuals and trained users.

 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 using Multi-Image Manager (MIM). Managed production and test job schedules using JobTrac. Maintained tape library using EPIC. Created rules to automate the systems using Automate/MVS and REXX. Assisted IBM and EMC vendors with DASD firmware upgrades. Aided hardware upgrades, software installs and troubleshooting of technical issues. Performed nightly UNIX/ Windows backup and occasional restore of mail and file servers.