Kenneth L. Johnston, Jr.

Oracle Database Administrator (12c OCP)

DOD Clearance

719-***-****

http://www.linkedin.com/pub/ken-johnston/11/22/260

www.americandatabaseconsulting.com

CERTIFICATIONS

08/2019 SECURITY+ CERTIFIED - COMPTIA

08/2015 ORACLE CERTIFIED PROFESSIONAL (OCP, 12C)

10/2008 COMMVAULT 8 CERTIFIED

SUMMARY

Top Secret/SCI Security Clearance with poly

TECHNOLOGY EXPERTISE

SKILLS:

1. Oracle Database Administration (8i, 9i, 10g, 11g, 12c)

a. Performance Tuning

(BSTAT/ESTAT/Statspack/AWR/ADDM

b. Backup and Recovery (RMAN and

operating system level)

c. Installations, patching, upgrades

d. Troubleshooting

e. RAC (Installation, Configuration, DBA

maintenance)

f. DBCONSOLE and GRID Control

g. Oracle GoldenGate Installation/Configuration

h. Oracle Data Guard Installation/Configuration

2. Unix, Linux and Windows operating systems

3. Business reports and statistics

4. Management

5. Project Management

6. KSH scripting

7. Software implementation and configuration

8. Backup and Recovery

9. Consulting

10. Front line support

11. Troubleshooting

12. Oracle Application Express, installation and configuration

PROFESSIONAL EXPERIENCE

Work History

June 2018- Present - Lockheed Martin - Software Engineer – Oracle DBA Team Lead

Oracle 12c to 19c upgrade, tested, wrote documentation

Performed weekly team meetings

Designed and Built Oracle APEX 5.0 DBA Team Web Site

Wrote DBA Team Training Documents

Trained Team Members

Handle all database issues in the development environment

Ensure databases are up at all times

Tuning and Performance

Backup and Recovery – created RMAN cron scripts

Installations

Patching

Troubleshooting

Planning for future growth

Created Team Project Page for project tracking

Wrote daily database checks document

Write unix shell scripts

Write sql scripts

Develop team goals

Built Oracle 12c Portable Databases (PDBs)

Cloned 12c Portable Databases

Wrote multiple scripts for development environment

November 2017 to June 2018 - VOLT - Database Engineer assigned to Raytheon in Aurora, CO. APEX project. SCI Access: 12/18/2012

· Wrote bash scripts to assist with Point-In-Time Recovery requirements.

· Created test case environments for test cases.

· Assisted with applying developer application patches to database.

· Monitored the health of the development machines.

· Wrote WIKI page for new hires.

· Provided day to day guidance and recommendations on Oracle database functionality and performance.

· Applied Patch Set Updates to development databases.

· Provided technical advice on production systems/Data Guard troubleshooting

January 2017 - November 2017 - InSight Global - Oracle DBA assigned to Navy Marine Corp Internet (NMCI) project, Next Generation Enterprise Network (NGEN).

· Set up and document Oracle Wallet (Development/Test).

· Set up and document Oracle Transaction Data Encryption (Development/Test).

· Set up and document Oracle Crypto_Seed (Development/Test).

· Rebuild Oracle (Development/Test) database, document.

· Rebuild Oracle Enterprise Manager (Development/Test).

· Rebuild Oracle Recovery Catalog (Development/Test).

· Perform database rebuilds/restores for development (Development/Test).

· Assist NAVY with the application Content Discover.

· Assist NAVY with the application Model Office.

· Set up and document Oracle Crypto_Seed (Development/Test).

· Rebuild Oracle (Development/Test) database, document.

June 2016 - January 2017 - CompTech Industries - Oracle DBA assigned to Defense Logistics Agency.

· Review and Implement 12c STIG on Test/Development SUN SUPERCLUSTER machines.

· Researched many areas of Oracle for Team Lead and created multiple reports.

· Researched and Implemented Flash Recovery Area (FRA) requirements. Implemented

findings on the SuperCluster machines.

· Provided daily technical support to users having issues with the Oracle servers, HP and

SUN.

March 2015 - May, 2016- Innovative Management Concepts - Oracle DBA - Western Area Power Administration - Lakewood, CO - Federal Contractor

· Database Team Member for four regions throughout the United States

· Designed, developed and built the DBFacts database and application for the Vice

President of Application Systems.

· Installed, configured and maintained Oracle APEX 5.0 for the CORE DBA Team.

· Performed multiple 12c upgrades

· Wrote multiple Linux ksh shell scripts to automate backups and maintenance

· Responsible for production and development databases for the Upper Great Plains

division.

· Monitor all instances on a daily basis

· Perform all necessary database administrative maintenance

· Install all necessary Oracle CPU and PSU patches

· Wrote and implemented Linux bash scripts

· Automated daily RMAN full backups and Datapump full exports

· Automated daily clean up of .trc, .trm files

· Automated daily maintenance of the alert.log for all instances

· Supported the development team by doing refreshes to test, development instances

daily. This was done by RMAN cloning using catalog and nocatalog and also

datapump exports, importing them as full, schema or table level imports.

· Established crontab file for all the linux nodes used in the environment.

· GO-TO person for Linux administration needed for Oracle

· Tested and established all backup and recovery procedures.

· Tested and established 11gR2 (11.2.0.3) to 12C upgrade procedures

· Installed 12C binaries and upgraded all 11.2.0.3 instances to 12C non-cdbs.

September 2013 – March 2015 – Data Networks Corporation – Oracle DBA

United States Air Force Academy – Cadet Management Information Systems

Modernization Project (CAMIS)

· Installed and configured Oracle databases 11g

· Patched databases to latest version, 11.2.0.4.3

· Patched databases with latest PSU and CPU patches

· Configured and patched Linux 6.5 operating systems for Oracle installations

· Identified all PII data with IIA officer

· Exported legacy data using datapump into the modernization development databases

· Worked with developers and updated databases with non-sensitive data using pl/sql

· Established and setup all backup and recovery procedures using RMAN

· Created development template machines installing multiple applications

· Used VMWare VSphere to create VMWare Appliances

· Wrote the Disaster Recovery / Backup and Recovery Guides

· Recommended Oracle Sql Developer, Oracle Data Modeler which has been used

throughout the project.

· Recommended Oracle GoldenGate for the Migration/Replication tool which is being

used.

· Actively troubleshot all database performance and configuration issues

· Actively participated in the Agile Software Development process (SRUM)

· Researched and Recommended Oracle GoldenGate for Migrations/Replication.

· Installed and configured Oracle GoldenGate into the development environment

· Installed and configured Oracle GoldenGate Director, Client and Monitor

· Wrote installation and usage document for Oracle GoldenGate and Utilities

· Worked with developers on setting up sql translation and conflict resolution (OGG)

· Worked with Oracle support for all technical tickets, application research, licensing

· Implemented 11g STIG on all development nodes

June 2012h – Sept. 2013 – FGM/Novetta Solutions – Oracle DBA/System Administrator

· Top Secret Clearance

· National Security Position

. Cheyenne Mountain Air Force Station / NORAD Mission

November 2011 – May 2012 - Northrop Grumman Corporation - Database Developer III

· Secret Clearance

· Heavy Grid Control

· Microsoft Powershell Scripting

· Windows Permissions Review

· STIG reviews

·· Daily Database Monitoring using Grid Control

June 2010 – October 2011 – XTIVIA - Oracle Database Administrator - Colorado Springs, CO

· Provided health checks and audits of clients’ critical systems.

· Installations, patches, upgrades

· Performed daily Oracle DBA duties as requested or required for all

customer databases.

· RAC implementation and troubleshooting

· Data Guard implementation, troubleshooting, tuning, backups

· Performance Tuning

· Troubleshooting

· RMAN Backup and Recovery – Create RMAN scripts, create job

schedules through OEM for RMAN jobs to run.

· Regularly install and configure GRID Control

· Regularly work on Unix, Windows and Linux based operating

systems.

· Monitored and provided expert assistance to dozens of clients

including many fortune 500 companies using diverse Oracle

technologies, including RAC, Data Guard and ASM

· Built and maintained in-house test center on Solaris and ESXi 4.0

machines for XTIVA.

· Built VMWare images as needed for testing and supporting all

database groups at XTIVA which includes Oracle team, SQL

Server team, DB2 team and the Informix team.

· Migrations – upgrades from 7.3.4 through 11G

· Handled all CommVault clients – only certified CommVault

Systems Engineer in the Company

· Major contributor and designed of XTIVIA webpage for

CommVault Services.

· Provided training for Oracle certification requirements for all Oracle team members. Only Oracle certified OCP 10g DBA in the company.

· Filed service requests with Oracle, very familiar with the Oracle Support Process, (former Oracle Support employee).

· Worked with Oracle to maintain XTIVIA/Oracle Partnership requirements.

12/2009 – 2010 - Systems Engineering Services – Oracle Database Consultant

Production ORACLE RAC DBA – Assigned to VERIZON – Colorado Springs, CO.

· Assigned to tuning production team for the RAC systems using:

a. AWR and ADDM reports – I generated and reviewed daily

b. SQL Tuning Advisor – I ran against the high cost queries

c. DBMS_SQLTUNE

d. OEM GO-TO person for my team

e. Grid Control

· RMAN

a. Wrote RMAN backup scripts

b. Performed test recovery of backups

c. Maintained backup sets according to mean time to recovery requirements (MTTR) and SLA requirements.

· Ticketing System

a. Worked tickets assigned to database.

b. Worked with two ticketing applications used as part of daily DBA duties.

· On-Call Rotation

a. Required to participate in On-Call rotation as part of the DBA team

b. Worked tickets requiring immediate assistance

c. Worked tickets that had specific outage dates and database change requirements

d. Responded to emergency issues

· Built Two-Node VMware/Linux Oracle RAC

a. I provided RAC system for internal team training

b. Maintained the RAC through reimaging when required

c. Maintained host maintenance for the Virtual RAC environment

d. Provided RAC training to team members

· RAC infrastructure GO-TO person for team

a. Evaluated and monitored RAC performance

b. Monitored and resolved issues arising from interconnect traffic

c. Assisted team in indentifying all RAC performance issues

09/2008 – 12/2009 - CommVault Systems – CommVault 8 Certified

Database Consulting Engineer (Oracle Disaster Recovery Specialist), Ocean Port, NJ

· On-Site Professional Services Consultant

· Performed pre-onsite calls with customer to evaluate and understand requirements

· Evaluated customer environments and established disaster recovery backups

· Advised the customer of available CommVault technologies applicable to their requirements

· Installed CommVault software, installed agents, configured application

· Created backup policies and tested them on-site

· Worked with System Administrators on storage requirements (DISK, SAN,LAN,TAPE)

· Worked with Network Administrators on network requirements (Bandwith, Ports)

· Installed and configured CommVault agents on:

a.Oracle

b. Informix

c. SQL Server

d. SAP

e. Microsoft Exchange

f. VMware (Multiple VMware appliances)

· Worked directly with CommVault support on all issues

· Provided training and demonstrated Disaster Recovery Procedures

. Provided training and demonstrated Scheduling and Storage Policies

· Adapted to a variety of environments each with their own unique

challenges and opportunities

· Provided information on additional products that may assist the customer

in their environment. These recommendations were then sent to sales

for further action

· Troubleshot issues involving application installation, network, database,

magnetic and tape libraries, backup and recovery

· Attended Oracle World Conference (2009) on behalf of CommVault

12/2007 – 09/2008 The Centech Group Colorado Springs, CO

Senior Oracle Database Administrator

Responsible for all Oracle operations and tasks from end-to-end for The Centech

Group.

· Oracle 10g DBA

· Maintained 10g databases on Windows 2003 servers

· Administration of Oracle Master-to-Master Replication

· Established all backup and recovery procedures and policies

· Using RMAN, developed hot and cold backup scripts.

· Wrote operating system cold backup scripts

· Regularly performed performance tuning on the databases

· Established test and cloned machines

· Created Data Guard failover machines

· Used Enterprise Manager to administer the databases

· Used TOAD to assist the developers in maintaining and tuning pl/sql code.

· Troubleshot all database issues to resolution

10/2005 – 11/2007 Oracle Corporation Colorado Springs, CO

Dedicated Area Coordinator - Principle Engineer - for all of Oracle DATABASE Support

· Technical coordinator for all test machines in DATABASE support

· Technical advisor to the Director of Database Support

· Technical “GOTO” person for Database support test machines in

Database support

· Provided monthly reports on system and database usage to

management. All scripts and measurement analysis points for the

reports were developed by myself

· New projects were implemented with the system development life

cycle methodology (SDLC)

· Developed auditing procedures for all Unix platforms within Database support

· Installed, configured, and troubleshoot all crashdb and patchdb databases

· Create customized ksh scripts based on database supports requirements

· Assisted all database support personnel with installation/configuration

Major Accomplishments

. Developed, designed and wrote a ksh script that allows Oracle

support engineers to automatically rollout databases for customer

test cases. As a direct result of this script (PATCHDB), Oracle corporation

has implemented the script on a global basis for all support

engineers to use worldwide.

· Developed and designed new internal database group website

· Built two Windows 2003 Server machines for Oracle Database

Support Group. One machine was set up to serve out training examinations

and the other server performed as a file server (FTP machine). I provided the system administration on these machines.

· Researched and implemented VMware Workstation software for

Oracle Support. Developed a methodology for serving out VMware

images and appliances for Database Support use.

· I built over 50 VMware images and appliances which

included Windows 2000, Windows 2003, Windows XP,Linux and

Oracle Databases 8,9 & 10.

· Set up a global methodologies for support engineers to access the

VMware images for user locally or remotely.

04/2001 - 10/2005 Oracle Corporation Colorado Springs, CO

Database Administrator

· Responsible for installations of the databases, patch sets and one-off

patch sets on the global test center production machines.

· Maintenance of the global test center instances included:

a. Installations

b. Monitoring

c. Privileges

d. Restorations

e. Tuning and Performance

f. Troubleshooting

g. Configuration

· Installed and maintained HPUX RISC, Itanium and Solaris X86 RAC clusters

specifically, 9.2.0 and 10g with ASM databases

· Created and maintained the backup and recovery methodology for all

Global Test Center CLUSTER production machines through the

use of system level backups and RMAN backup.

· Worked with Oracle internal customers to create test space.

· Assisted customers with the installation and configuration of Oracle

databases

· Established Oracle's Global Test Center tuning guidelines for

production test instances.

· Created ksh/bash shell scripts and SQL scripts for daily instance operation

08/2000 - 4/2001 TUSC Lakewood, CO.

Oracle DBA Consultant

I provided complete Oracle DBA consultation services. Everything

from installation assistance to performance tuning both on the

database and on pl/sql procedures.

9/1999 - 08/2000 Oracle Colorado Springs, CO

Technical Analyst

Provided customer support for all core technology issues such as

Oracle Server, Windows, Unix, Oracle Application

Server and Networking.

Prior to working in off hours, I worked as an analyst in the RDBMS

group supporting Oracle Server issues and functionality.

9/1998 - 9/1999 Oracle Colorado Springs, CO

Associate Technical Analyst

Team Lead for Off-Hours Group

• Backup and Recovery GO-TO person for

off-hours group.

• Replication GO-TO person for off-hours group.

• RDBMS support analyst.

Military Experience

1983-1986 United States Air National Guard

Aerospace Ground Equipment Mechanic – Honorably Discharged

Education

3/2004 Colorado Technical University Colorado Springs, CO.

Master's Degree

Master's in Management of Information Systems

6/1986 University of Southern Colorado Pueblo, CO

Bachelor's Degree

Bachelor of Science in Business Administration - Management

Contact this candidate