John Gayer Email and Phone Number

Oversaw installation and support of numerous business-critical SQL Server and Oracle systems and databases on Intel and UNIX servers. • Spearheaded large-scale migration of over 300 Ford web and client / server applications to Visteon, including automated deployment and testing, measurably improving performance. • Spearheaded effort to develop distributed data warehouse at helm of 12-person technical team, providing data-enhanced local support that saved over $350 million per year… Show more Oversaw installation and support of numerous business-critical SQL Server and Oracle systems and databases on Intel and UNIX servers. • Spearheaded large-scale migration of over 300 Ford web and client / server applications to Visteon, including automated deployment and testing, measurably improving performance. • Spearheaded effort to develop distributed data warehouse at helm of 12-person technical team, providing data-enhanced local support that saved over $350 million per year. • Led 20-person team converting material control data to corporate application. Deployed manufacturing systems to new application; led DB2 DBA group.• Directed transfer of 300 Ford applications to Visteon, including system installation, data transfer, and application testing, to facilitate multi-billion dollar sale of 60 component part plants to Visteon. • Led 12-person team in converting divisional systems on numerous platforms to single corporate system, installing and configuring DB2 database platform and saving over $5 billion per year.• Facilitated $12 billion sale of 26 component part plants by directing transfer of key data and processes from Ford systems to buyer systems.• Played key role as DBA / subject matter expert in guiding development of joint Ford / IBM DB2 application benchmark. • Served as lead analyst on global PLM feasibility study of configuration management, bills of material, and engineering change management; identified opportunities for process improvement.• Led elite team conducting technical architecture review of vendor ERP packages including Baan, Oracle, QAD, SAP, and SSA; identified 100+ business process gaps and resolution strategies. Show less

Play key role in supporting Meridian Medicare and Centene Next Generation enrollment applications, as well as premium billing apps. Install and manage Oracle 12c and 19c software with Active Data Guard and RAC. Oversee outgoing operations including RMAN backup and recovery, performance monitoring in Oracle Enterprise Manager, and installation of Oracle 12c using AWS RDS. Support key purchasing application on Oracle 10. Serve as backup database administrator for SQL Server, Open Edge and… Show more Play key role in supporting Meridian Medicare and Centene Next Generation enrollment applications, as well as premium billing apps. Install and manage Oracle 12c and 19c software with Active Data Guard and RAC. Oversee outgoing operations including RMAN backup and recovery, performance monitoring in Oracle Enterprise Manager, and installation of Oracle 12c using AWS RDS. Support key purchasing application on Oracle 10. Serve as backup database administrator for SQL Server, Open Edge and Progress databases. • Played key role in assisting Meridian in expanding Medicare business. Evaluated Medicare enrollment software; selected Oracle-based package that fueled 120% growth within 3 years. • Stepped in to manage Centene Next Generation implementation to “Cloud First” architecture after current manager’s departure. Show less