Jonathan Andrews

Experience

• 

  General Electric

  Jun 1989 - Jan 1997

  • IT Project Leader

    Feb 1994 - Jan 1997

  • Programmer/Analyst

    Jun 1989 - Feb 1994
• 

  Nazarene Publishing House

  Feb 1997 - Oct 1998

  Senior Project Leader / Oracle DBA
• 

  Sprint Nextel

  Oct 1998 - Aug 2000

  Oracle DBA
• 

  Quintiles

  Aug 2000 - Feb 2011

  Work with multiple IT groups to provide centralized IT solutions that incorporate server infrastructure, database solutions, and network connectivity. Coordinates between developers, business representatives, and infrastructure teams. "Solution Integration." Team leader for a global group of DBAs. Hired staff and guided team to support a follow the sun support model. Continued technical responsibility for DBA activity. Provided primary support for a large number of databases.

  • Systems Engineer

    Jan 2008 - Feb 2011

  • Manager of Oracle DBAs

    Nov 2005 - Jan 2008

  • Senior Oracle DBA

    Aug 2000 - Nov 2005
• 

  CA Technologies

  Apr 2011 - Feb 2014

  Sr. Services Consultant

  Serving as a Senior Services Consultant for CA Technologies Managed and Hosting Services, which acts as an extension of a customer’s IT organization, providing end-to-end functional and technical support for mission-critical CA solutions.The role included building and supporting CA Hosting Services based in the Verizon CaaS cloud environment.I provided sole database support for our Oracle 11GR2 databases which includes Oracle ASM, Oracle RAC. I also supported Microsoft SQL Server databases.This was a "start-up" of sorts and this entailed defining standards for RAC and ASM to be modeled for multiple customers. Due to the nature of the team I did a lot of Linux administration for the database servers.I excelled in setting standards and documenting best practices. Show less

• 

  CSC

  Feb 2014 - Oct 2014

  Senior Oracle DBA

  Serving as senior DBA on contract positions. - Leveraging Oracle 11gr2 enterprise edition to support single node an RAC databases for a variety of applications- Oracle ASM support- Improving processes and procedures to manage databases over 3 different data centers.- APEX development to manage infrastructure and allow more focussed administration by DBA team.- Oracle Enterprise Manager 12c- Performance Tuning- RMAN and other backup configuring and testing

• 

  GE Transportation

  Nov 2014 - Jan 2017

  Lead Engineer Oracle DBA

  - Used Chef to automate Oracle 12c RAC, OEM, and restart database infrastructure creation. This afforded quick, repeatable processes for database creation and administration. - Create installation design for Oracle Golden Gate. - Installation of streams for reporting database/data warehouse. - Maintain and support Oracle 11g database infrastructure which includes data guard, RAC, restart, and OEM.

• 

  GE Grid Solutions

  Jan 2017 - Aug 2020

  Oracle Database Administrator

  Generated Grid Software solutions using Oracle 11g 12c RDBMS (RAC and restart). Providing support for developers and impending production.Reverse engineered Oracle 11g database, extracting PL/SQL for developers and created a deployable package.Worked to automate Oracle 19c deployment for Standard Edition restart and cluster solution using RedHat Pacemaker.MS SQL Server database upgrades.Worked on proof of concept setting up customer databases in Amazon Web Services environment.Configure NetApp filers for database storage. Show less

• 

  Radiant Systems Inc

  Aug 2020 - Oct 2020

  Senior Database Administrator

  Provide Oracle and SQL Server Database consulting for FAA program.- Oracle 11g, 12c, and 19c using Data Guard and RAC.- Microsoft SQL Server 2012.- Oracle Enterprise Manager 13c.

• 

  Wabtec Corporation

  Oct 2020 - now

  Senior Data Operations Engineer / Oracle Database Architect / CockroachDB DBA

  Supporting and developing train management systems database infrastructure.Oracle 19c and 12c.Oracle Golden Gate.Oracle Data Guard.Oracle OEM 13c.AnsibleCockroachDBKubernetes OpenShift