Jerry Sommerville

  • Wapakoneta OH

Platform as a Service Architect


As a IT Professional my work history includes Infrastructure design and deployment, Database design and operations using Progress, Oracle and SQL Server Database platforms.  I am also experienced in Disaster Recovery and Resiliency program management, UNIX and Linux Server infrastructures and administration, IT Operations Management and data center migrations. 

Work History

Work History
Sep 2015 - Present

Platform as a Service Architect

JP Morgan Chase

Define infrastructure standards and frameworks for supporting applications development and deployment to Development, Test, Quality Management,, Production and disaster Recovery facilities located in data centers around the world.  Technology road maps, deployment constraints, data center strategy development and strategic development technology stacks round out the work of this position.

Feb 2014 - Sep 2015

Lead Data Architect

JP Morgan Chase & Co.

Data Architect responsibilities include data design, database configuration, infrastructure design and deployment and operations support for global enterprise systems supporting Corporate Risk and Compliance Technology. Specialities include Oracle RAC 11g/12c, Exadata, SQL Server 2008 R2 and SQL Server 2012.  High Availability and Disaster Recovery designs, DR Plans and DR exercise programs. Applications include Data Warehousing, Anti-Money Laundering, Transaction Monitoring and Financial instruments Trade Surveillance.  Many of the systems supported with real-time end-user interactions and large data feeds using Informatica ETL solutions. 

Jul 2011 - Dec 2013

Data Architect

Marathon Petroleum

First as a contractor through TCI, Inc. and later as a Marathon employee I performed as a Data Architect responsible for Policy and Procedures , Tactical and Strategy Development, Technology Roadmaps and technical supervision of support personnel - both on-shore and off-shore support resources. Duties include Data Architecture for SAP Financials, Peoplesoft Human Resources, SAP Manufacturing, Oil Refining and Logistics systems. Projects include  a data center move from Texas to Ohio,  conversion of  all infrastructure from Physical to Virtual servers with application, OS or database upgrades as part of the migration. I was asked to lead the development and implementation of a Disaster Recovery Program involving Marathon and Third Party Support for all applications.  Managed DBA and Software Delivery for Data Management Group. Researched, acquired and implemented Imperva Database Monitoring, Audit Compliance and Database Firewall for data loss prevention and SOX audit compliance. I was asked to lead a project and a team of Infrastructure Architects implementing Private Cloud and Infrastructure as a Service(IaaS). 

Feb 2008 - Jul 2011

Lead DBA

Crown Equipment

Lead DBA for Oracle, SQL Server 2005/2008 and Progress Databases on UNIX and Windows systems. Developed Disaster Recovery Capabilities for Oracle and SQL Server environments. Supported development of Data Warehouse and Quality Reporting systems including data designs. Created documentation standards and standardized procedures for all facets of DBA activities for Oracle, SQL Server and Progress database environments. Created virtual environments for SQL Instances and standardized install and customization procedures for virtualized database environments. Training and mentoring for junior DBA position. Developed Web Applications supporting IS initiatives including Enterprise IS Assets tracking and Auditing for 68 branch locations and corporate headquarters. Automated security account deactivations for Oracle and SQL Server database environments with integration to PeopleSoft HR and Domain security. Created a SSRS library of standardized security reports to support Audit requirements Oracle, SQL Server and Progress environments.

Oct 2007 - Feb 2008

Data Architect

A.O. Smith, Inc. 

Data Architect.  Implemented ERP Systems.  Company acquired by Beloit, Tipp City, Ohio

Apr 2005 - Oct 2007

Senior DBA

Crown Equipment Corporation

Senior DBA New Bremen, Ohio.  Same duties as above (Lead DBA).  

Mar 2001 - Apr 2005

Manager, Enterprise Systems

Medex, Inc

Manager, Enterprise Systems.(later acquired by Smith's Medical) Dublin, Ohio.  Developed and implemented MFG/PRO ERP Systems world-wide. 

Mar 1996 - Mar 2001

Director Technical Services, Eastern US

Strategic Information Group

Consulting services  Director and Principle Consultant for the Eastern US Cardif-by-the-Sea, California .

Feb 1992 - Mar 1996

MIS Manager

Alcoa Building Products

MIS Manager Sidney, Ohio

May 1987 - Feb 1992

Systems Analyst

Alladdin Industries

Systems Analyst Nashville, Tennessee.  Implemented ERP Systems, develop Labor and payroll systems, capital management and control systems.


2007 - 2007

Oracle  9i SQL Programming

Oracle  University

Programming training

2006 - 2006

Oracle performance Tuning

Oracle University

Database training

2005 - 2005

Oracle DBA I and II

Oracle University

Database administration

1998 - 1998

Java Programming

ICON Computing

Software development

1997 - 1997

Use Case Analysis

Rational Software

Object oriented training.

1997 - 1997

Advanced Object Oriented Design Patterns

ICON Computing

Object oriented training

1997 - 1997

Object Oriented Analysis and Design

Rational Software

Object oriented training.

1993 - 1993

Database Administration & Performance Tuning


Progress Database technology training

1993 - 1993

IDEF Business Process and Data Modeling

ICON Computing

Data design

1991 - 1991

Unix Server Administration


Unix training

1990 - 1990

Progress Programming, version 6


Progress database technology training

1981 - 1983


Computer Training Institute

Two 600 hour certificates in Data Processing, Systems Analysis and Design, software development and Advanced Systems Development.

1979 - 1981

Associates Degree

Volunteer State Community College

General Business Administration



Language Skills

I don't speak geek, I speak English.

Interpersonal Skills

Skilled at developing relationships with staff, management, vendors, customers and other stake holders.

Presentation Skills

Experienced presenter before technical staff, peer companies at trade symposiums, senior staff and executive leadership.

Staff Development

Experienced supervisor and trainer dedicated in the mentoring and development of staff personnel.


Experienced in Database Logical and Physical designs using ERWin design tools.


Experienced in developing complex infrastructure and application diagrams in support of operatons, application development and for management presentations.


Development library of reports for IT systems administration, security audits, Access audits and operations metrics.

SQL Server SIS

Development and deployment of SSIS packages using SQL Server Job Agents and Autosys Automation Agents.