Ed Bishop Email & Phone Number

Madison, Wisconsin, Us

OneNeck IT SolutionsSystems Engineer III - Databases, July 2016 to Present• Remote administration of managed SQL Services via Cherwell ticketing system for external and internal clients for SQL Server 2000 to 2017. Internal clients are managed systems and telecom while external clients include government, finance, insurance, software, transportation, medical, software, and retail industries.• Responsible for strategic and tactical project development and improvement of processes and scripts• Client base has instance counts ranging from 1 to 3 digits per client with database sizes ranging from GBs to multi-TB per database and counts of a few to perhaps 50 databases per instance• Providing advice to internal and external clients’ DBAs, Business Admins, Project Managers, IT Directors, VMware , Network, OS and SAN admin teams re: best practices for their areas of expertise for properly supporting SQL Server implementations• On call primary DBA on rotating weekly basis handling all SQL Major Incidents and Priority 1 & 2 incidents outside of normal working hours • Perform system health checks and troubleshoot and resolve issues with client SQL installationsMS SQL Server (2000/2005/2008/2008 R2/2012/2014, 2016, 2017), Windows Server (2003, 2008, 2008 R2, 2012, 2012 R2), Failover Clusters, AOAGs, Mirroring, Log Shipping, Replication, Cherwell, Nagios, NimSoft, CommVault, NetBackup, Citrix, Juniper, VPN, RDP, VMware, WebEx, Skype

Sheboygan, Wi, Us

Performing duties as needed in regards to SQL Server:• ETL development for critical fraud detection process• Code improvement to take ETL enrollment process from hours to a few minutes• Added to the DBA team weekly support rotation• Writing internal white paper and supporting code for getting all SQL objects under source control• Writing internal white paper for architecture recommendations for a full system upgrade to a SQL 2014 in a clustered server Always On environment

SQL Server analysis, development, installation, configuration, advice and troubleshooting re: clients' systems.

Menlo Park, Ca, Us

• Consulting contract at Kerry Ingredients & Flavor - Monitoring and maintaining SQL Server 2008 R2 / 2012 systems with emphasis on troubleshooting issues with HA AG configurations, redefining backup strategies, collaborating on DR architecture and other strategic planning, and restructuring laboratory information management database

Hanover, Md, Us

• Consulting Contract at CDW - Large scale database migrations and training for corporate divisional acquisition

Milwaukee, Wisconsin, Us

• Oversight, planning, review and mentoring for SQL Server development for multiple development teams enterprise projects (team sizes 6-10)• DBE embedded in Hospitality team, extending software utilized in the Nursing Home industry into a major new customer base in the Hospitality industry• DBE responsible for consolidated corporate product database initiative• DBE corporate Software Configuration Management working on process improvements and database source control with Team Foundation Server• Developed enhanced system data capture and consolidation tool using SSIS/SSRS and SQL Server system tables, views, procedures and functions

Menlo Park, Ca, Us

• Consulting at Boumatic,Database Systems/Staff Analysis and Database Performance Tuning

Jp

Fujitsu America (Team Lead, Senior DBA, BA, Web Developer)• Database Development and Website Upgrades, Enhancements and Maintenance at CUNA Mutual, June 2008 – July 2010 • Database Development and Website Upgrades, Enhancements and Maintenance at Christus Health Care, July 2009 – December 2009• Business Analyst / DBA (Internal Project), June 2009 – July 2009 • DBA for Server Upgrade at Premium Drilling, January 2009 – February 2009 • Business Analyst Team Lead and Strategic DBA for Database Migrations at Ford Motor Company, September 2008 - May 2009 • Database Programming and Management Report Development at Employee Benefits Corporation, November 2007 - May 2008 • Website Integrations, Support, and Database Programming at CUNA Mutual Group, July 2007 - November 2007 • Database/ IIS/ FTP Troubleshooting and Configuration at Coldwell Banking, May 2007 - June 2007 • Software Quality Assurance and Oracle SQL Development at ShopBop.com, January 2007 - April 2007 • Database Support and Migration at Innovative Health Strategies (IHS), September 2006 - December 2006 • Website and Database Development and Support at Coldwell Banking, July 2006 - September 2006 • Personal Insurance Quote Software at General Casualty, April 2006 - July 2006 • Criminal Justice Software Analysis at Waukesha County, April 2006• SharePoint and Virtual PC Server Package Migration and Configuration at Fujitsu America (formerly Greenbrier & Russel), February 2006 - April 2006

Us

Note: Greenbrier and Russel was acquired by Fujitsu America but continued to operate as Greenbrier and Russel brand for approximately one year.

Houston, Texas, Us

• Consulting at US Bank, Custom Database ETL and Replication

Greensboro, Nc, Us

Beacon Technologies (Data Analyst)• In-House Training, October 2004 - February 2005 • Consulting at AQS, 50 State Solution Project, July 2004 - September 2004

Milwaukee, Wisconsin, Us

Exacta Corporation (Senior Web / Database Developer)• Consulting at Cleary Building Corporation, Web and Database Development

Princeton, New Jersey, Us

Applications and SQL Server DevelopmentCovance Management System - VB Programming, SQL Development, Quality Assurance, Project Management

Detroit, Mi, Us

Team Lead, PM, Senior Applications Developer• Application and Database ETL at Covance Labs Inc., August 2000 - August 2001 • Proposal Generation Software at Flad Inc., May 2000 - August 2000 • RAD Tool Development (Confidential Client), March 2000 - April 2000 • Donor Information and Special Event Management System at Big Brothers/Big Sisters, February 2000• In-House Training, November 1999 - January 2000

• Proposal Generation Application at CUNA Mutual Group, July 1999 - November 1999

Round Rock, Texas, Us

PerotSystems (Applications Team Lead)• Portico Customer Integration System at Thrivent (Formerly Lutheran Brotherhood), June 1998 - July 1999

Houston, Texas, Us

PM, BA, Applications Team Lead• Imaging & Workflow Development at GM Customer Assistance Centers, November 1996 - June 1998 • Systems Engineering Development Program, September 1996 - November 1996 • Imaging Software and MS SQL Server Database Development at Blue Cross/ Blue Shield, MA, April 1996 - September 1996 • Project Management Office for GM Service Readiness and Technical Documentation (SRTD) Division Project Management, June 1995 - April 1996

Master Of Business Administration (Mba), Management Information Systems, Human Resources

Business Administration And Management, General

Bachelor Of Arts (Ba), Psychology