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