About

Jon has  20+ years of DBA experience with Oracle, Postgres, and SQLServer. He is expertise in managing Oracle 19c, 12c, and 11g databases on UNIX/Linux, and Windows. He excels at integrating with teams, improving systems, and mentoring junior DBAs. Here’s a quick introduction from Jon himself to give you more insight into his approach and expertise:

 

Professional Skills
Business Analysis
100%
Linux
100%
Oracle DBA
100%
Oracle Audit Vault (OAV)
90%
OEM (Oracle Enterprise Manager)
90%
Oracle
90%
Work Experience

Jan 2024 - May 2024

TRPC / The Retirement Plan Company

Sr. Oracle DBA

  • Managing Oracle DBs on Windows
  • Shell scripting for monitoring and managing databases, including SQL scripting
  • Backup and recovery for all DBs
  • Oracle database Standby recovery on remote server using RMAN and archivelogs
  • Upgrade preparation for 11g to 19c migration
  • SGA/PGA Performance Tuning analysis

Dec 2021 - Jan 2024

PLS / Pittsburgh Logistics Services
Sr. Oracle/Postgres/SQL DBA

  • PLS / Pittsburgh Logistics Services - Sr. Oracle/Postgres/SQL DBA - Remote
  • Managing 11g and 12c Oracle DBs on Linux
  • Managing and Migrating to Postgres (Postgresql) DBs on Google cloud (GCP) VMs
  • Worked with GCP admins with GCP console access
  • Initial planning with GCP Big Query
  • Managing Microsoft SQLserver (MSSQL) DBs on GCP VMs

Jan 2021 to Dec 2021

Simon Fraser University
TennCare / State of Tennessee

  • TennCare / State of Tennessee - Sr. DBA - Remote
  • Managing Oracle Audit Vault (OAV) and reporting audit alerts and reports
  • Upgraded to OAV 20.4 auditing over 50 TB audit log records for 100 DBs retained 10 years
  • Planning with Amazon Cloud AWS admins for migration to AWS VMs for DB servers
  • Auditing data and monitors retained in AWS and Google Cloud (GCP) data buckets
  • Preliminary analysis of GCP Big Query and also Splunk for monitoring and reporting audit data
  • Oracle Databases 19c, 12c and 11g on Linux and Solaris

Education

1976

Bluffton University

BA Math

1980

Bluffton College

Minor Computer Science

Contact Me
Feel free to contact me