Oracle OCP for 11g, Database Developement, Oracle OCI

Rudy Caballero

Oracle Certified Professional Database Administrator

Professional Summary:

Highly skilled Oracle Professional DBA with several years of experience. Accomplished in Oracle Database Administration, query tuning, mentoring, data modeling, data analysis, and more. I am a value-added contributor as I enjoy developing database software using native PL/SQL and APEX technologies. My depth of knowledge includes creation of microservices using Podman, and Infrastructure and code using Terraform in the Oracle OCI.

Professional Certifications:

Oracle OCP earned March 2017

Technical Skills Summary:

Languages:

Oracle PL/SQL, ANSI SQL, Microsoft T-SQL, Linux Bash Shell, AWK, Korn Shell, C#.NET, ASP.NET, JSON

Operating Systems:

Red Hat Enterprise Linux Server release 5*, 6*, Oracle Linux 7,8, CentOS release 6.8, UNIX Sun/Solaris, AIX, Windows 19c Datacenter Server, IBM MVS, DOS/VSE

Development Tools:

Oracle SQL Developer, SQLcl, SQLDeveloperWeb, VSCode, PL/SQL Developer (All Around Automations), Toad 12. * DBA suite, SQL Navigator, MS SQL Management Studio, Visual Studio Pro 2005, 2003, SQL* Plus, SVN, PVCS Version Control, MS Visual Source Safe Version Control, AccuRev Source Control, GIT, Liquibase

Cloud:

Oracle OCI, ADB, SaaS, APEX, OCI/CLI

Databases:

Oracle19c - 7.3.4, SQL Server 2015,2008

Database Tools:

Oracle APEX, ORDS, Edition Based Redefinition (EBR) 18c, Oracle Advanced Queuing (AQ), APEX administration, ORDS listener administration, RESTful services, RMAN backup, ASH, ADDM, AWR, Oracle Data Pump, Oracle OEM CC 13.5, legacy import/export utilities, Oracle SQL Developer and Data Modeler, Toad DBA Suite, SqlCL, and SqlDeveloperWEB.

Professional Experience:

Oracle Corporation, Austin, TX (Remote) Apr 2022 – Sep 2025

Oracle DBA

Served on a DEVOPS team supporting internal APEX development initiatives. Responsibilities: database administration on Oracle19c container database, CI/CD Pipeline Support, APEX Upgrades, ORDS upgrades, ADB Management, SQL tuning, patching, database troubleshooting, and data loading with Oracle Data Pump.

Other Accomplishments:

Created a Containerized Open LDAP implementation using PODMAN.

Developed a reverse proxy implementation using NGINX

Performed development and maintenance on an internal APEX application (DB_TRACKER)

Used Liquibase to perform all database deployments

Developed Restful services hosted by DB_TRACKER Application

Accomplished in use of JSON in the Oracle Database

Highly skilled in the Oracle OCI Cloud Environment

Strong DBA, PL/SQL, and BASH Shell Skills

Applied APEX upgrade to more than 100 container databases using custom developed automation

Troubleshooting CI/CD Pipeline issues

Mentoring on PL/SQL coding, data modeling, and using of Oracle Data Pump in the OCI environment

Architected an Infrastructure as Code (IaC) solution using Terraform

APEX and ORDS administration

Developed a custom solution to perform management, notification, and disposal of abandoned ADB databases in the Cloud

Amentum Corporation, Hanford, WA Oct 2019 – Apr 2022

Senior Oracle Database Administrator

Amentum serves as a subcontractor for the Hanford Nuclear Site Waste Cleanup Project. In the role of Oracle Database Administrator, responsibilities include supporting the Waste Treatment Plant Engineering Department in preparation for planned live operations beginning in 2023. The project focuses on converting decades-old nuclear and hazardous waste into glass through vitrification, enabling safer long-term storage and management. Duties include:

Providing database administration for 15 Oracle Databases (versions 12c and 19c).

Installing and configuring Oracle Enterprise Manager Cloud Control version 13.5.

Applying routine security patches to Oracle products.

Conducting SQL query tuning, database performance troubleshooting, RMAN backup configuration, and installation and configuration of Oracle ORDS and APEX.

In addition, designed and implemented an Oracle-based custom ETL solution using DBMS_SCHEDULER, Materialized Views, XML and JSON generation from SQL, and DBMS_JAVA.

Supported the use of Oracle ORDS/RESTful services in the ILAW Production Application and implemented Oracle ORDS in an Oracle19c database on Windows19c Server with SSL support. Developed a custom solution for running ORDS continuously as a Windows service on Windows 19 Datacenter Server.

Promoted Oracle SQL Developer and Data Modeler tools as cost-effective alternatives to TOAD development tool.

Demonstrated an Oracle APEX-based Project Management application; however, an organizational decision had already been made in favor of MS Teams Foundation Server.

Konami Gaming, Las Vegas, NV Dec 2013 – Oct 2019

Senior Oracle Database Administrator

Database Administration: Perform database administrative tasks for 11g and 10g databases: create, configure new databases, configure RMAN backup, perform SQL Tuning using Explain Plan, SQL Tuning Advisor, and Oracle SQL Monitor. Perform database upgrades 10g => 11g, database performance troubleshooting using ASH, AWR, ADDM, ADRCI, and the Toad Spotlight Tool. Create and configure Oracle Data guard physical standby databases, perform RMAN Database Cloning. Created a custom Oracle Resource Plan for the Synkros application to stabilize busy casino environments, perform SQL tuning using SQL Explain Plan, SQL Tuning Advisor, Oracle Real Time SQL Monitor. Frequently involved in SQL Tuning and performance improvement efforts.

Database Development:

Architected, designed, developed a custom Oracle Advanced Queueing Messaging Solution with the following features:

1-way data replication using a publish / subscribe model

A suite of event-based message broadcasts using JSON format

An event-based batch job initiator used to handle ad hoc job requests

Implemented as Oracle 18c SQL/JSON

Oracle REST services via ORDS

Highly skilled in use of Oracle SQL Developer Data Modeler Tool

Extensive software development using ANSI SQL with PL/SQL stored procedures, packages; developed, tested, deployed custom Oracle database server utilities such as Oracle Listener “Keep Alive” process using Bash Shell, also developed a similar process for APEX ORDS Listener. Designed and developed a custom job scheduling system using PL/SQL to leverage the Oracle DBMS_SCHEDULER; designed, developed several custom LINUX Bash scripts leveraging the use of the AWK language. Reverse engineered Synkros database model using the Oracle Data Modeler.

APEX Application Administration: Administer APEX application deployments and the ORDS listener, perform troubleshooting of APEX InfoSynk Local application, created custom reporting features for InfoSynk Local by using BASH and AWK along with Oracle External Tables leveraging pre-processor .bash scripts to consume Linux Host OS level data used for database health monitoring.

Customer Support: Perform Synkros Casino Management System 24 hour on call DBA/application support; also, provided DBA support for new customer implementations; application trouble ticket support.

Additional work history is available on request.

Educational Background:

Oracle Certified Database Administrator Professional for 11g, March 2017

Oracle Certified Database Administrator Associate for 11g, March 2015

San Diego State University, San Diego, CA

General Education

Coleman College, La Mesa, CA

C.I.S certificate

Tacoma Community College, Tacoma, WA

General education courses with emphasis on Business/Information Systems.

Language Skills:

Bilingual: English, Spanish

Contact this candidate