Senior Oracle Database & Systems Administrator
Resume:
Joseph Gary Oprendek
Senior Database and Systems Administrator
Mount Laurel, NJ 08054
*********@*******.***
Linkedin - https://www.linkedin.com/in/j-gary-oprendek-5550914/
SUMMARY
I have been an Oracle DBA for over 30 years and have experience with Oracle on many platforms. I also have RAC, RMAN, OEM Grid Control Administration, Dataguard and Goldengate Replication, TDE experience, team management as well as much more to offer. I am proficient in AWS RDS, EC2, S3, Snowflake, Microsoft SQL Server and MySQL administration. I have many years’ experience as a Database and System Administrator on Oracle Database Appliances (ODA’s) I also have experience administering different flavors of Linux OS (Redhat and Oracle). I am goal driven and very diligent in my work. I believe I can be a valued asset to your team. US Government security clearance level “Secret”.
EXPERIENCE
Senior Database Engineer Federal Aviation Administration (contractor via LS Technologies/Tetra Tech)
06/2022 – Present
In my position in the ASG E-OSE I was brought in as an Oracle Database Administrator, but my scope of work has expanded significantly. My list of responsibilities includes installation administration and upgrades of Oracle ODA X9-HA systems. All Oracle installations, upgrades and patching duties on virtual machine environments. Microsoft SQL Server administration and maintenance. VMware vSphere manifest, virtual machine creation and maintenance. Redhat and Oracle Linux installation and administration, patching and upgrades. Windows Server patching and upgrades. Splunk application installation and administration. E-OSE customer database support and investigation into their issues. Assisting with building and racking server systems in the computer centers. I document all processes I am tasked with meticulously. I am constantly taking training on systems outside the realm of Database Administration so that I can be a greater contributor to the group as well as the FAA and LST/Tetra Tech. Federal Security Clearance “Secret”.
Senior Database Engineer Freedom Mortgage Corporation
08/2019 – 06/2022
Oracle On-Prem to AWS RDS – Migration of all on prem systems to AWS RDS. Set up Golden Gate Hub 19c on Amazon EC2 to centralize all Golden Gate Replication tasks. This I used to migrate the on prem systems to RDS. AWS RDS instance class and engine version upgrades. Coordinated and orchestrated upgrade from Oracle 12.x to 19.x for every Oracle database in the company. Performance tuning of ill performing systems. Active Data Guard standby of Data Warehouses and Data Marts. Database software installation, creation, patching on all RDS instances. Security Group tightening to conform with company standards.
Snowflake – When Snowflake was acquired, I personally took several online coursed to learn it at which time I had built all of the Snowflake systems including warehouses, databases, schemas, roles and users. Designed the role-based access methods and security policies. Managed user creation (local and SSO). Migrated system from Sandbox POC area account to Production account. Served as DBA-side project manager for entire Snowflake system.
OEM 13c – Installed and configured Oracle Enterprise Manager/ Cloud Control 12c and 13c. Configured targets, groups, credentials user and implemented monitoring templates tuned to Freedom’s needs. Created reports to email database information and statistics to dba team. Customized email generation to DOC for specialized alerts for monitoring. Trained DBA team on how to effectively use OEM. Implemented auditing as well as created audit reports.
Other DBA Tasks – Shell scripting for monitoring and alerting of system issues. Implemented auditing and audit reporting. SQL performance tuning. Created database inventory system using Oracle Apex to track database systems and associated resources using awscli to extract RDS and EC2 information and join it with information from OEM. Major Incident (MI) investigation and resolutions. On call 24/7.
Senior Database Engineer Pinnacle Foods Group, LLC
11/2013 – 04/2019
Senior Database Engineer Conagra Foods Inc
04/2019 – 07/2019
Put in place backup and recovery standards as well as the scripts to perform RMAN and datapump exports. I defined and set up database auditing standards and procedures. I hardened all critical Oracle passwords. Analyzed and proposed database migration from costly and unstable windows platforms to more cost-efficient Oracle Linux systems with ASM. I performed database consolidation to save the company money and other capital resources. I performed Oracle 9i, 10g migration to 12.2.0.2.x including PSU and CPU security patch implementations Installed Oracle Cloud Control 12c and configured all of the Oracle and SQL Server database server systems with agents to actively monitor the health of the databases. I wrote scripts and procedures within Cloud Control to run the backups, and other repetitive tasks with email and text alerts and automatic corrective actions. After 3 years I migrated the system to Oracle Cloud Control 13c. Set up dataguard high availability system for Peoplesoft HR system. Wrote procedures to refresh the lower environments and took the refresh time from about 26 hours down to about 6. I also prototyped and implemented Oracle TDE encryption on the system to provide a security layer in case of unauthorized intrusion into the system. Served as a Database and System Administrator on Oracle Database Appliances (ODA’s) as well as Linux Administration. Knowledge transfer after Conagra acquisition of Pinnacle Foods.
Senior Oracle Database Administrator Comcast Corp.
07/2010 – 11/2013
My duties include all database functions/monitoring/maintenance, on multi node 9i through 11g RAC systems. I am responsible for implementation of CPU/PSU patchset testing, documentation and installation. Wrote Unix shell scripts to assist in the maintenance of the systems. RMAN Catalog creation and backups, dataguard and golden gate. Issue ticket creation and resolution. I installed the Corporate Oracle Grid Control system for monitoring the databases and hosts for both the production and lower environment systems. I engineered and project managed system migrations from one data center to another when the data center was closed. Installed and configured Oracle Gateway for Teradata. Created from scratch a PHP/MySQL solution for gathering team status reports and presented it to senior leadership which won approval.
Senior Oracle Database Administrator Disys (at Amtrak)
06/2007 – 07/2010
Set up Dataguard standby databases on Oracle 10g. Set up Oracle Streams to replicate data from production so that the developers can still work with the data real time and won’t have to access the production database. All day-to-day duties such as backup/recovery, performance tuning and new development. Initiated a consolidation process to merge various databases into a fewer number of instances which saved thousands in Oracle license fees. Implemented security standards and procedures including password hardening and encryption, auditing.
Senior Oracle Database Administrator Radian Guaranty
12/2004 – 06/2007
I administer approximately 100 databases built on HP/UX. I am also the lead DBA for the company’s Data Warehouse. I have prototyped and the implemented the Oracle Transparent Gateway for RMS. This allows Unix databases to connect to RMS files on VMS so that we can access the data with Brio. I have prototyped and then implemented the upgrade from 9.2.0.6.0 to 10.2.0.2.0. I then migrated many of the databases to a 2 node RAC system with full failover and load balancing. I prototyped and then implemented the migration of our HP/UX PAS-RISC systems to HP/UX Itanium systems. I have analyzed and implemented many performance tuning changes from system to sql. I participate in all design and development sessions and try to steer the projects down a correct path with Enterprise goals in mind. I have designed and implanted many process improvement standards, as well as SOX auditing standards. I have implanted RMAN for the databases and have recovered successfully from catastrophic failures on more than one occasion. I have also been responsible for SQL Server development and support.
Oracle Database Administrator Comverse Network Systems
11/2000 – 12/2004
Administered multiple systems worldwide which run a 24x7 cellular phone network. Major accomplishments to date: I have been integral in redesigning our system to run on an active/passive OPS 8.1.7.4 configuration on Compaq Tru64 Unix 5.1a. This system runs Oracle from a shared cluster instead of on each local machine. I have also designed a no downtime upgrade process for our database schema which is fully automated so that there will be no loss of calls or revenues on any of our sites when an upgrade of the database is needed. I have rewritten the database installation process to be more streamlined and efficient thereby reducing the need human intervention. This has eliminated the likelihood of failure due to human error. I have written a completely automated process to upgrade Oracle 8.0.5 to Oracle 8.1.7 running OPS with 2 nodes. As the backup/recovery specialist I have set up backup and recovery procedures using RMAN. I have written nightly full backup and hourly archive log backup scripts as well as full recovery and point in time recovery scripts. I have created import/export scripts used by many others in the company. On two occasions so far, I have recovered databases from catastrophic hardware failures which have caused the database to be corrupted and unusable. I also write and implement performance and monitoring scripts and procedures so that we can take proactive measures to avoid downtimes. Setup replication from Master OPS databases to multiple OPS slaves. I along with others maintain the database repository which houses the data model for the database. I am currently working on the redesign of our system to upgrade to Sun and AIX servers with Oracle 10g RAC with EMC Clarion Disk Arrays. Also experimenting with converting our system to 2 node OPS on Linux. Unix scripting.
Oracle Database Administrator ADP
03/2000 – 11/2000
Oracle Database Administrator Oracle 8.0.4.0 and 8i (8.1.5) on Windows NT Service Pack 6 and Sun Solaris 2.6. My duties covered all Oracle DBA responsibilities as I was the only Oracle DBA. Major accomplishments: I had completely rebuilt and reorganized 7 instances which had all objects created in the system tablespace. I had split them into dedicated tablespaces which also separate tables and indexes. I had initiated backup procedures which include nightly exports and RMAN backups and archive log backups hourly. I had instituted naming conventions and change control processes. I had built many new databases. Implementing RMAN backups include creating the recovery catalog and writing the scripts to perform the backups. I had also implemented many performance and space monitoring scripts and procedures. I also traveled quite frequently to Roseland NJ and Parsippany NJ offices to aid in development processes and administer databases.
Oracle Database Administrator Cendant Mortgage
06/1995 – 03/2000
Duties covered all Oracle DBA responsibilities running on Sun Sparc OS. Also doubled and administrator/developer of in house MLCS mortgage processing application and database which i rebuilt over the course of six months for greater efficiency.
Programmer/Analyst Prudential Insurance Company
02/1994 – 06/1995
Cobol, CICS, JCL and SAS programming.
EDUCATION
Kubernetes for Beginners (Udemy) – 04/2025
Redhat 9 Administration (Udemy) – 10/2024
Oracle Database Security (Udemy) – 06/2023
VMware vSphere 7 Administration (parts 1-3) – 12/2022)
Oracle 19c RAC Administration (Udemy) – 08/2022
Oracle Multitenant Administration (Udemy) 08/2022
AWS RDS complete certification training (Udemy) – 04/2021
Snowflake (Snowflake Corp and Udemy) – 04/2021
SQL Server 2016 (Udemy) – 02/2019
MySQL (Udemy) – 04/2019
Teradata Administration – Teradata Corporation – 07/2017
Powershell Scripting – New Horizons Corporation – 07/2017
Oracle Linux 7 System Administration – Oracle Corporation – 07/2016
Oracle Linux 6 System Administration – Oracle Corporation – 06/2015
SQL Server 2012 Administration – New Horizons Corporation – 11/2014
Hyperion Essbase Database Administration – Oracle Corporation – 05/2013
Oracle Golden Gate – Oracle Corporation – 02/2011
Oracle 10g Spatial – Oracle Corporation – 12/2007
Bachelors of Computer Sciences – Burlington County College 12/1996
Oracle 10g RAC – Oracle Corporation – 06/2006
Oracle 10g New Features – Oracle Corporation – 06/2004
Network Administration – Oracle Corporation – 05/2001
Performance Tuning – Oracle Corporation – 06/2000
Backup and Recovery – Oracle Corporation – 01/2000
Database Administration – Oracle Corporation – 06/1999
Intro to SQL + PL\SQL – Oracle Corporation – 05/1999
SAS programming - Prudential Ins. Co., Horsham, PA - 02/1994 - 06/1995
Computer Learning Center, Philadelphia, PA – Associates Degree Computer Science 01/1994
Roxborough High School, Philadelphia, PA - Diploma, 06/1980
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate