Pl Sql Oracle Dba

Travis “Michael” Johnson ******@*****.*** 608-***-****

Summary

Mr. Johnson has 22 years of experience as an Oracle Database Administrator as well as 10 years as a Mainframe programmer and Technical Architect. He has been involved in all phases of the system development life cycle, as well as quality control. He has worked well with all levels within an organization as well as with customers one-on-one. His team player abilities, dedication, enthusiasm, reliability, positive outlook, hard work ethic, and results oriented personality will fit well in any organization.

He has been working as an Oracle Database Administrator in a number of versions of Oracle, as well as different platforms and environments. He has extensive experience being on-call, production support, development, database maintenance, and performance tuning. He has also complemented his career well with nine years as a mainframe programmer and more than two years of experience leading a team of programmers to address the Y2K issue.

Mr. Johnson is a dual citizen who has both his US and Canadian Citizenship and can work in both Canada and the United States.

Education

3-year Bachelor Degree – Business Administration Information Systems

Computer Programming

St. Lawrence College, Kingston, Ontario, Canada

Professional Experience

Insight Global

Remote July 2022 – Present

Senior Oracle DBA/Azure

Raleigh, NC/Dallas TX

This project is a support role for the Azure Cloud environment with Oracle 19c databases. Mr. Johnson was there to support the team of developers and the Oracle Databases sitting in an Azure Cloud environment.

During this project, Mr. Johnson had the following duties and accomplishments:

●Worked with Oracle 19c, 12c / 11g administration and maintenance

●Attended daily status meetings using Jira and Agile Sprint methodology

●Investigate OEM blackouts

●Investigate Roles, System Privileges and Object Privileges

●Performance Tuning Analysis for the Oracle 19c database environment

●Modified ADF Pipelines (Jenkins)

●Control-M Scheduling Environment

●Oracle DBMS Scheduler – Scheduling Environment

●AZURE Cloud Environment - Portal

●ADF (Azure Data Factory) ETL Environment.

●VM Monitoring in Azure Portal

●Oncall

●Oracle RAT (Real Application Testing)

●Oracle AWR and ASH Reports

●Table partitioning

●Defragmenting tables up to 2.5B rows of data

●Anodot

●Oracle Virtual Indexes

●AZCopy – (Azure) upgrade

●Oracle RAT Troubleshooting

●Defragmenting Tables (2B+ row tables)

●AWR Report and ADDM Report Analysis

●Troubleshooting Deadlocks

●Github/Bit bucket

●SQL Profiles

Environment: Oracle 19c, Linux, Windows, MS Office 365, SQL, PL/SQL, Agile, Table Partitioning, AWS, Oracle ASM, Jira Sprints, Oracle OEM 13c, Azure

Tek Systems

Remote August 2021 – July 2022

Senior Oracle/SAP DBA

Seattle, WA / Raleigh, NC

This project is a SAP/Oracle Upgrade project from 12c to 19c. There is also Oracle standalone databases running on ASM that I am responsible for.

During this project, Mr. Johnson had the following duties and accomplishments:

●Worked with Oracle 19c, 12c / 11g administration and maintenance

●Attended daily status meetings using Jira and Agile Sprint methodology

●Creating weekly status reports

●Oracle RMAN Duplicate Database

●Oracle RMAN Backups

●Oracle RMAN Restores

●SAP Upgrades to Oracle 19c from 12c

●AWS work-station so I can connect from anywhere

●Cloning ASM instances up to 4TB

●Unix Mirror Technology to recover a SAP multi TB database in a few hours

●Brand new install of ASM on 19c with Standalone server

●Set Blackouts in OEM

●Remove monitoring in OEM for Hosts/Databases

●Stop and Start Agents in OEM

●Setup Snap (Sync/Split) Refresh from Active Data Guard to a new database

●Troubleshooting Vendors code and provide a code fix for special characters showing up in the database

●Trouble shooting Log File Sync Waits – Session Leaks at Logon

●Linux Shell Scripting

●Oracle DBMS Scheduler – Scheduling Environment

Environment: Oracle 19c, 12c, 11g, Linux, Windows, MS Office 365, SQL, PL/SQL, Oracle Data Pump, Agile, RMAN, Table Partitioning, AWS, Unix AIX 6/7.2, SAP, Oracle ASM, Jira Sprints, SAP Brtools, SAP Backup, Oracle OEM 12c/13c. Rubrik

Training – Oracle University

Remote May 2021 – June 2021

Oracle Cloud DBA

●Oracle Cloud (OCI) Foundations Course

●Oracle Cloud (OCI) Architect Associate Course

●Oracle Cloud (OCI) Autonomous Database Specialist Course

●Oracle Cloud (OCI) Infrastructure Security

Konami Gaming, Las Vegas, NV November 2020 – Apr 2021

Active Gaming License

Lead Senior Oracle DBA

This project was in the Casino Gaming Industry and I was brought on to do a lot of the DBA Development work.

During this project, Mr. Johnson had the following duties and accomplishments:

Work with Oracle 19c, 18c, 12c / 11g administration and maintenance

Performance Tuning of Application SQL Code

Attended daily status meetings using Jira and Agile Sprint methodology

Creating daily status reports

Wrote Technical Design Documents

Setup Edition Based Redefinition

Golden Gate Course

Oracle Streams support

Table Partitioning

Oracle Edition Based Redefinition

Oracle RMAN Duplicate Database

Oracle RMAN Backups

Oracle RMAN Restores

Oracle Analytics Server / Machine Learning (Business Intelligence)

Application Developer Support

Oracle VirtualBox (VBOX)

Oracle Job Scheduler

Environment: Oracle 19c, 18c (18.3), 12c/11g, Linux, Windows, MS Office 365, SQL, PL/SQL, ER-Win, Oracle Data Pump, Jira, Agile, Sprints, Toad, Oracle Streams, Edition Based Redefinition, RMAN, Golden Gate, Table Partitioning. AWS, Unix AIX 6/7.2, SAP, Oracle ASM, Jira Sprints, SAP Brtools, SAP Backup

Tek Systems / Presbyterian Healthcare Services, Albuquerque, NM October 2019 – July 2020

Senior Oracle DBA / Developer

This project was an initiative to clean up client’s provider data and to build the confidence in the data for the business.

During this project, Mr. Johnson had the following duties and accomplishments:

Work with Oracle 18c, 12c / 11g administration and maintenance

Performance Tuning of Application SQL Code

PL/SQL Coding to support ETL conversion of data from one system to another

PL/SQL Coding to extract data to send to our cleansing vendor

Data Modelling both Logical and Physical

Attended daily status meetings using Jira and Agile Sprint methodology

Wrote Business requirement documents

Creating weekly status reports

Wrote Technical Design Documents

Table Partitioning

Environment: Oracle 18c (18.3), 12c/11g, AIX Unix, Windows, MS Office 365, SQL, PL/SQL, ER-Win, Oracle Data Pump, Jira, Agile, Sprints, Oracle SQL Developer

Wellcare / Care 1st Arizona, Las Cruces, NM March 2017 – August 2019

Senior Oracle DBA

During this project, Mr. Johnson had the following duties and accomplishments:

Worked with Oracle 11g

Created weekly status reports

Built out the Server Specs for VM Server

Performance Tuning of Application SQL Code

Setup RMAN Backups

On-call 24/7/365

Oracle patching

Implementations

Building job aids for new jobs that were written or modified

PL/SQL coding to add new functionality to the warehouse

Worked with Oracle technical support

Attended weekly status meetings

New Insurance Rate Implementations once a year

Took a training session on Oracle Fleet Maintenance for Patching and Upgrading Databases

Environment: Oracle 11g, HP UX, Windows, Unix scripting (k-shell), MS Office Enterprise Ed., SQL, Oracle Recovery Manager (RMAN), PL/SQL, Oracle Data Pump, Dynatrace, Oracle OEM 12c

HP (former) / HPE (present), El Paso, TX July 2016 – September 2016

Senior Oracle DBA

Mr. Johnson was the DBA responsible for building all the documents to setup the RAC installations. These databases were in the Development, Test, Training and UAT environments. These databases where used 24 X 7 and so we had to Data Guard these databases out to another server as we could only have a very small window for downtime.

During this project, Mr. Johnson had the following duties and accomplishments:

Develop instructions to install RAC and prepare them for the Non-RAC to RAC conversion of their databases

Built all documents to Data Guard the existing Standalone out to another server so we could re-purpose the one server and use it as part of a 2 node cluster with a new server.

Oracle RAC experience on 12c

Worked with Oracle 12c and built all documentation to setup ASM and RAC for the 2 node cluster.

Attended weekly status meetings

Worked with Oracle technical support

Installed new Oracle Databases, Data Modelling

Built out the Server Specs for RAC servers

Responsible for PL/SQL ETL coding and performance tuning of Application SQL Code

Worked in ASM environment and setup Materialized Views for Replication

Setup Triggers and Stored Procedures for Replication, and Streams for Replication

Environment: Oracle 12c, RedHat Linux 6.1, Windows, Unix scripting (k-shell), MS Office Enterprise Ed., SQL, Oracle Recovery Manager (RMAN), PL/SQL, Backup and recovery using RMAN, Oracle Data Pump

HP (former) / HPE (present), El Paso, TX Toronto, ON, Canada February 2015 – July 2016

Senior Oracle DBA

Mr. Johnson was the DBA responsible for building all the documents to convert almost 40 databases from Standalone to RAC. These databases were in the Development, Test, Training and UAT environments. These databases were used 24 X 7 and so we had to Data Guard these databases out to another server as we could only have a very small window for downtime. Also Mr. Johnson was part of a team of seven Oracle DBAs and was responsible for the production support of 50 databases in an on-call support role.

During this project, Mr. Johnson had the following duties and accomplishments:

Architected the Standalone to RAC conversion of almost 40 dev, test, training and UAT databases

Built all documents to Data Guard the existing Standalone out to another server so we could re-purpose the one server and use it as part of a 2-node cluster with a new server

Built all documentation to setup ASM and RAC for the 2-node cluster

Worked with Oracle technical support

Worked with Oracle Cloud 12c and installed new Oracle Databases

Built out the Server Specs for RAC servers

Created weekly status reports

Worked in ASM environment

Setup Materialized Views, Triggers and Stored Procedures and Streams for Replication

Maintained documentation for a highly regulated and Quality Control environment

On-call Production Support

Provided support to the developers, testers and end-users of the application in a production environment

Backups and Recoveries of the database using RMAN

New Releases of the application code applied to the database

Backups setup in solman thru dbacockpit / db13

Got Brtools installed and worked at the command line for backups

Archived log backups setup in solman through dbacockpit / db13 and command line

Setup solman_setup trx to monitor our last good db backup, last good archivelog backup, brbackup last run, brarchive last run and db statistics last collected – also added notifications to me for the thresholds when they are breached

Restored database using brrestore without RMAN, and using RMAN and control files

Backup databases using brtools calling RMAN and without RMAN,

Added more space to diskgroup for ORAARCH

Rolling parameter changes on the RAC instances, rolling shutdown and startup for processes=900 to take affect

Tested out restoring from our backups that are taken both SAP / Oracle RMAN Restores and SAP Restores

Tuned PH7 – rebuild of indexes, increased SGA in ASM, increased db_writer_processes

Recovered SAP / Oracle DBS using brrestore, using RMAN, using native Oracle thru SQL*Plus – Hot Backups

Recovered SAP / ORACLE DBS using brrestore, using RMAN – Cold Backups

Environment: Oracle 9i/10g/11gR2, Solaris Unix, Linux, Windows, Unix scripting (k-shell), SQL, Oracle Recovery Manager (RMAN), Oracle Cloud; PL/SQL, Backup and recovery using RMAN, Oracle refreshes using Clone SNAP technology, TOAD, AWR, ADDM; Oracle Data Pump, Oracle Enterprise Manager Cloud Control 12c/11g Grid, BRTOOLS, BRRESTORE, BRARCHIVE, BRARCHIVE

ConocoPhillips, Bartlesville, OK February 2013 – January 2015

Senior Oracle DBA / SAP DBA

Mr. Johnson was part of a team of twelve Oracle DBAs and two SAP DBAs responsible for the production support of 1600 databases in an on-call support role. He was responsible for SAP DB support and supporting the application dbas and developers throughout our locations in the world. He also provided support to a team of offshore DBAs.

During this project, Mr. Johnson had the following duties and accomplishments:

Maintained documentation for a highly regulated and Quality Control environment.

On-call Production Support

Built out standby databases using Data Guard and the Cloud

Provided support to the developers, testers and end-users of the application in a production environment.

Converted standalone database to RAC using Rconfig

Performance Tuning of the SQL and helping the developers write more efficient code.

Backups and Recoveries of the database using RMAN.

Supporting SAP databases using Oracle as the db platform.

Worked and supported Oracle Cloud (12c)

Setup 6-node RAC Cluster for our Cloud Environment

Agent Blackouts in Cloud 12c and Agent installs in Cloud 12c

Responsible for 150 Oracle databases of my own, and when on-call responsible for 1800+ oracle databases

Responsible for 35 SAP databases of my own, and on-call for 70 when my counterpart if off

Created Monthly Status Reports for our CIO and Weekly Status Reports for Managers

SAP Restores and Cloning

Environment: Oracle 12c/11gR2/10g/9i/8i, Solaris 9/10 Unix, AIX Unix 5/6, RedHat 5/6 Linux, Windows, Unix scripting (k-shell), SQL, Oracle Recovery Manager (RMAN), Oracle Cloud; PL/SQL, Data Guard, BRTOOLS with SAP brarchive, brbackup, backup and recovery using RMAN, SNAP technology on an Oracle RDBMS, TOAD, Data Guard; Oracle RAC, EMC Vblock, Oracle Automatic Storage Management (ASM), AWR, ADDM, Oracle Data Pump, Oracle Enterprise Manager Cloud Control 12c Release 3/2/1, OEM Cloud Agents to monitor host (AIX / Solaris Unix Servers and RedHat Linux Servers), OEM Cloud Agents, Oracle Database Appliance (ODA) Patch, PI, BW, GRC, SAP Router

Cigna Dental, Sunrise, FL July 2011 – February 2013

Senior Oracle DBA

Mr. Johnson was on a team of three Oracle DBAs, and was responsible for the data warehouse support both in development and production. One of his primary responsibilities was tuning the Oracle kernel for the data warehouse. He was also involved in supporting the developers during the development of new releases of the application and tuning their SQL code. Mr. Johnson was also the main dba who implemented the changes to the production database each month on release night. He was also a backup on the OLTP system for on-call.

During this project, Mr. Johnson had the following duties and accomplishments:

Maintained documentation for a highly regulated and Quality Control environment.

Developed scripts to automate some of our daily checks.

Data modeling with Erwin.

Provided support to the developers, testers and end-users of the application in a production environment.

Tuning SQL and helping developers write more efficient code as well as tuning data warehouse DB kernel.

Backups and Recoveries of the database.

Dealt with all levels of the organization from the Vice President down

OID and LDAP for Oracle.

Worked with Oracle Grid Control and performed Table Partitioning: Interval, Range, Hash, List.

Worked in ASM environment and refreshed databases from Production to Performance Testing environment.

Environment: Oracle 11g/10g/9i, HP Unix 11.23, Windows, Unix scripting (k-shell), SQL, RMAN, Oracle Grid Control, ER-win, PL/SQL, ASM, Cloning of databases from Production to Performance Tuning Environment Quarterly

Covance – Central Labs, Indianapolis, IN May 2009 – June 2011

Senior Oracle DBA

One of the projects that Mr. Johnson is responsible for is a new development data warehouse project that will be 2TB in size on go-live. This project involves setting up three databases (Operational Data Store, Data Mart and Staging Area), which will encompass a reporting database. Used Oracle Replication to replicate changes to security tables, Oracle Change Data Capture (CDC) to capture changes, and as well as Oracle Streams for the OLTP replication. Mr. Johnson’s role was to build the data warehouse, setup replication, CDC, and Streams. Integrator tool.

During this project, Mr. Johnson had the following duties and accomplishments:

Built a Data Warehouse application that will be used for corporate wide reporting.

Maintained documentation for a highly regulated and Quality Control environment.

Developed scripts to automate some of our daily checks.

Data modeling with Erwin.

Provided support to the developers, testers and end-users of the application.

Performance Tuning of the SQL

Backups and Recoveries of the database.

Dealt with all levels of the organization from the Directors down.

Built Development, System Test, Performance Test and Production Environments.

Applied Oracle Upgrades and Patches to Oracle Kernel and databases.

Worked with Oracle Technical Support.

Worked with Oracle Grid Control.

Involved in Table Clustering and Table Partitioning investigation

Environment: Oracle 10g; HP Unix 11.23, Windows; Unix scripting (k-shell), SQL; RMAN, Oracle Grid Control; Erwin, Business Objects Data Integrator, SQL Developer, Oracle Streams, Oracle Basic Replication, Oracle CDC, Oracle Data Guard, Oracle Patching and Upgrades, Oracle SMTP Mail Server

Huntsville Utilities, Huntsville, AL Madison, WI June 2007 - May 2009

Senior Oracle DBA / SAP Basis Administrator

One of the projects that Mr. Johnson is responsible for is a new development data warehouse project. Also Mr. Johnson was responsible for setting up Oracle Databases and SAP environments in Development, Test, and Production. This project was taking an old Cobol mainframe set of applications and converting it to SAP. These projects involve setting up five OLTP applications, of which three are in the US and two are in Europe. These five OLTP applications are than replicated over to a central staging area and the changes are captured through Change Data Capture (CDC) using Business Objects Data Integrator.

During this project, Mr. Johnson had the following duties and accomplishments:

Built out the development, test and production SAP environments and Oracle databases.

Also build a Data Warehouse application that will be used for corporate wide reporting.

Backups and Recoveries of the database.

Applied Oracle Upgrades and Patches to Oracle Kernel and databases.

Data modeling with Erwin.

Developed scripts to automate some of our daily checks.

Provided support to the programmers, testers and end-users of the application.

Dealt with all levels of the organization from the CIO down.

AIX Virtualization and maintained documentation.

Worked with SAP Technical Support and supported SAP functional people.

Production Support of approximately 30 other applications and databases.

Involved in SAP Basis configuration, setting up Oracle RMAN to backup Oracle databases.

Setup Unix scripts to backup Oracle kernel and SAP kernel, including all configuration files needed by SAP.

Maintained documentation and provided support to the developers, testers and end-users of the application.

Developed scripts to automate some of our daily checks.

Dealt with all levels of the organization from the President of the organization down.

Environment: Oracle 10g/9i/8i/7.3.4; IBM AIX Unix, Windows, Unix scripting (k-shell), SQL, RMAN, SAP NetWeaver 7.1, SAP Router, SAP ERP 6.0, SAP PI 7.0, SAP BW (Business Warehouse 7.0), Oracle Enterprise Manager; ER-Win, Business Objects Data Integrator, Perl, Toad 9.5 DBA Module, TIBCO ActiveMatrixServiceBus, TIBCO DataExchange (ETL), TIBCO BusinessWorks

Other relevant experience:

Spins.com, Schaumburg, IL February 2007 – June 2007

DB2 DBA

Syncrude Canada Ltd., Fort McMuurray, AB, Canada November 2006 – February 2007

Senior Oracle DBA

Fujitsu Consulting (formerly known as DMR Consulting Group) November 1999 – November 2006

Senior Oracle DBA

Agricultural Financial Services Corporation, Lacombe, AB, Canada November 2004 – December 2005

Senior Oracle DBA

Canada Post Corporation (CPC), Ottawa, Ontario, Canada November 1999 – October 2004

Senior Oracle DBA / Oracle DBA

SKILLS SUMMARY

Skill

Year(s)

Oracle RAC

3

Oracle DBA Lead

2

Technical Architect Lead

2

Oracle RMAN – Backup and Recovery

20

Oracle Database Appliance (ODA)

2

Oracle Data Guard

1

Oracle Performance Tuning – PL/SQL and Instance

20

Oracle ASM

4

Oracle Patching / Upgrading

10

Oracle Creating Databases

20

Oracle Exporting / Importing

20

Oracle Streams

1

Oracle Change Data Capture (CDC)

2

Oracle Materialized Views / Replication / Triggers, Views, Sequences, etc.

20

Oracle AWR, Explain Plan TKPROF

20

Oracle OEM / Grid / Cloud Control – Support / Consumer

5

Toad / SQL Developer

15

PL/SQL Programming

6

Unix (AIX, Solaris, HP-UX)

20

Unix k-shell scripting

20

Linux (Redhat)

7

Facets

1

Erwin Data Modelling

3

Oracle / SAP DBA

4

SAP BRTOOLS

4

On-Call

30

Oracle Exadata (Free Oracle sessions, exposure to it)

Oracle 21c (Research Only)

1

Oracle 19c

1

Oracle 18c

1

Oracle 12c

3

Oracle 11g

10

Oracle 10g

6

Oracle 9i

3

Oracle 8i

5

Oracle 7.3.4 / 8.0

4

Data Warehousing

10

OLTP

30

Jira / Sprints / Scrum

1

Agile

14

Leadership (Y2K project and Oracle Upgrade project)

4

Hyperion Environment

2

Weblogic Environment

7

Cobol

12

JCL

12

IDMS/ADSO

8

Rexx

2

TSO/MVS

12

CICS

1

DB2

1

Technical Expertise

Cloud Environments

Azure

AWS

Programming/Scripting

Shell Scripting, SQL, PL/SQL

Databases

Oracle 19c/18c/12c/11g/10g/9i/8i/7

IBM DB2 / SAP

Database Utilities

Oracle ASM, Oracle Streams, Data Guard, Oracle RAC, Oracle Change Data Capture (CDC), Materialized Views/Replication, Triggers/Views/Sequences, AWR, OEM, Grid, Cloud Control, TKPROF, EXPLAIN PLAN, TOAD, SQL Developer, Oracle Data Pump, Golden Gate, Edition Based Redefinition, RMAN, OEM 12c/13c

Data Modeling Tools

ER-Win, Oracle Designer

Productivity Tools

Jira, Rally, Dynatrace

Operating Systems

Unix, Linux, Windows

Leadership

Leading a team of programmers to address the Y2K issue.

Leading a team of dbas to complete an Oracle upgrade project.

Contact this candidate