Data Oracle

Dexter Greener

*** ****** **

Fountain, Co *****

******.********@*******.***

719-***-**** (C)

719-***-**** (H)

SUMMARY

Over 23 years of experience in Oracle Database Administration on Oracle 7.2.2 OPS to 12c Multi-Tenant RAC databases on Linux, UNIX and Windows Platforms using various Monitoring tools to assist in proactively resolving any issues; also includes Backing up databases using RMAN or other tools to include testing backups.

Over 10 years of experience with Shell scripting (C, Bash and Korn Shell)

Experienced with Data guard, standby databases from 10g to 12c using DataGuard Broker or Golden Gate.

Worked with IT management in planning new projects which requires storage capacity, predicted CPU and Memory utilization and to include 20% extra to accommodate unseen loads and resource usage.

Excellent Communication and Writing Skills

TECHNICAL SUMMARY

Oracle Database Administration 6.0.14 to 12c

Oracle RACDatabase Administrator OPS / RAC 7.2.2.2 to 18c

Oracle RMAN Backup and Recovery

Oracle Apps DBA

Oracle Enterprise Manager (OEM) 9i to 12c

Standby Database using Data Guard, Streams, Golden Gate

Database Upgrades and Patching

Database NLS Language migration.

Database and Performance and Application Tuning

VCS DRE Failover testing

MySQL 5.0 – 5.7

OpenVMS, UNIX, Sun Sparc, Windows 2003-2008

PL/SQL, SQL, Cshell, Kshell, BASH

C/c++

Data Mining

Data Warehouse

Database creation

HP-UX

OVCA

OEL/Redhat Linux 5-7.2

Win 7/10 – 2008

ODA (Oracle Database Appliance)

Windows Office and Visio Pro

PROFESSIONAL EXPERIENCE

Arisant Aug 2019 – Jan 2020

Contract Oracle Migration DBA Englewood, CO

Oracle Database Appliance migrating from Exadata system to ODA system with database upgrade from 11.2.0.4 to 18.3.0.0.180747 on Bare Metal system. Resolve issues with the Web console and odacli issues through Oracle Support. Build out one oracle home for seven QA and Dev databases. Used export / imports method since schema tablespaces are now required. Developed an installation document for the client on how to provision and create databases for their Production and DR DB’s

Sigma SEP 2018 – Mar 2019

Contract Oracle APPS DBA Mechanicsburg, PA

Application DBA supporting development, testing and production communities. Migrated various PL/SQL code and critique code for performance enhancements. Give guidance on Oracle utilities and developed Domain indexes for fuzzy searches. Deployed ITIL approved procedures, maintenance adjustment to production as needed.

Lewis Fowler Nov 2017 – Jan 2018

Contract Oracle DBA Denver, CO

Build out on MySQL databases, Monitored Oracle Databases on Exadata Systems for Development and Build out ODA databases and system and migrated from Exadata to ODA system. OEM13c was used to monitor and had to patch OEM 13c for MySQL monitoring

All Staff Jul 2016 – Oct 2017

Oracle APPS Database Administrator (Contract) Remote Work

Upgrade 11gR2 RDBMS to 12cR1 RDBMS on multiple database.

Applied PSU patches every six months, worked with OLTP and DW Databases.

Build 12c New Databases on Production / QA and FT Solaris systems.

VCS DRE (Disaster Recovery Exercise) from on Physical site to another.

Refreshed QA databases from Production System.

Upgraded Database Applications and assisted in various trouble shooting to include scripts

Reviewed Pl/SQL programs from Developers and created a few for on spot problems for tablespaces and redo log files.

Execute application upgrade scripts on various databases.

Add / remove users from databases.

ROLTA ADVIZEX Aug 2007 – Feb 2016

Oracle Database Administrator (Consulting) Chicago, IL Consulting

Deployed various Patches (CPU & PSU) per maintenance schedule.

Deployed and Upgraded Databases and OPS/RAC clustered systems on Unix, linux, Windows. Documented system using Visio and Word

Troubleshoot various tuning issues concerning the database engines and application SQL.

Installed and configured OVCA (Oracle Virtual computing Appliance) with OVM for onsight Cloud Operation. Helped with training on the OVCA installation and was repeatable for the client satisfaction. Recommended to use Vmware instead of OVM.

Developed PL/SQL procedures for System Quick checks to identify any problems prior to the database goes into production.

Installed and Configured Golden Gate on various Servers to multiple Replications sites and completed a Proof of concept used for Golden Gate in a Heterogeneous application between MS SQL 2008 to Oracle 11.2.0.4 DB's. Used Enterprise Architect, Visio and Word to Document Processes required.

Taught and mentored Database operations, RAC / OPS operations RMAN SQL tuning for Apps DBA and developers, Data Guard, Standby databases, Streams, Golden Gate, and O/S systems tuning regarding databases most databases clients are working with OLTP and Datawarehouse systems.

Installed, configured and instructed DBA's on building a RACONE node on a ODA (Oracle Database Appliance) system and a Standby system. Used Word and Visio to Document processes and their Current Structure.

Resolved issues with the Standby Databases Networking protocols.

Assisted in migrating databases and storage arrays from older systems to the new current systems and documented processes using Word, Enterprise Architect and Visio.

Used RMAN Cloning Technique to move databases to new Hardware and created new standby databases to include cloning Oracle Homes.

Migrated character set from Western European to Multi-byte AL32UTF8.

Redesign Streams on for warehouse project and for other relevant systems to include RMAN Backups and Recovery, documented processes using word and visio

Restored various test, development and production databases and Tested Backup strategies used by the client.

Move single instance Databases into a RAC system Add and delete nodes from various RAC systems. Provided documentation using word and Visio.

Troubleshoot System, RAC and database problems pertaining to RAC.

Created and deployed scripts to clean out orphaned processes on the O/S (Operating System) and improve Cronos application performance.

Installed and configured VMWare Workstation 11/14 for development team utilizing OEL 7 (Oracle Enterprise Linux), Solaris 8, Windows 2008 for single Instance DBs.

Veterans Health Administration Center Jun 2005 – Aug 2007

Senior Oracle DBA (Contract) Denver, CO

Developed a database cloning system for 41 multiple copies of the IMPCS Database Developed Master/Master Oracle Streaming Replication used for Red to Black Data Security using Data Security Guard to verify that data can be passed to the unsecured sites using NSA stigs as a Guide.

Redesigned the IMPCS Data Archiving Procedures Developed Data Retention Policies for Backups/Recovery and IMPCS Data Archiving. Provided guidance to PL/SQL programmers for the VA HIPPA project.

Developed Backup and Recovery Strategies based on the Data Retention Policies Redesigned the System Architecture for the IMPCS database using multiple Disk Sets instead of one disk drive.

Oracle Corporation Apr 2000 – Aug 2005

Senior DBA / Apps DBA Consultant Denver, CO Consulting

Instructed and assisted onsite DBA's in building various databases for their clients to include standard tuning practices.

Resolved OPS 8.1.6 Database on AIX 4.2.2 Performance issues with the 8.1.6 database as installed via upgrading to 8.1.7 version.

Upgraded a 7.3.4 database on OpenVms to OPS 8.1.7.4b database, tuned the database for their applications of analytics.

Reviewed PL/SQL packages, procedure and functions with recommendations for performance.

Sprint PCS for Oracle

installed Oracle suite 11 on 7.3 database System DEC Alpha and applied patches to the same

installed and tested connectivity and application integrity with some data integration testing

MCI Corporation Colorado Springs Sep 1998 – Mar 2000

Lead Senior Database Administrator Production systems DEC Alphas. Responsible for tuning, backups using SQL-Backtrack and deploying new systems. Trained new DBA’s on various systems and projects to include training SysAdmin on the DEC.

Oracle Corporation Jun 1991 – Aug 1998

Senior Consulting ORACLE DBA Denver, CO Consulting

Eliminated 7 out of 12 NT Multidimensional systems by implementing Materialized Views. Documented procedures on Word and Visio.

Database tuning including RAC/OPS configurations for file locking, non-logging of tables and transportable tablespaces.

Installed Nagios for Oracle Database Monitoring.

MS SQL Server gateway to 8.1.7 database on OpenVMS problems with TNS connection issues from OpenVMS to Win2k systems.

Identified multiple Cartesian Products on People soft development and tuned sql statements.

Tune 8i databases on IBM AIX system concerning performance problems on disk I/O sub-systems.

Installation of 9i Data Guard and Trained onsite DBAs. Documented processes using word and visio.

Designed and implemented Multiple Databases (development, test and production) to include DW database where home grown ETL was developed to extract from an OLTP databases into the DW databases.

Designed and implemented 9i & 10g RAC databases for the Test, Pre-production and Production environments using Compaq DL580, MSA 1000 storage systems, Fabric Switches and a CSM blade to support hardware load balancing and failover.

Assisted in installation of all mentioned Hardware, memory cpu upgrades and HBA’s

Installed from O/S to 9iAS V2 & 10g AS, three application servers with a 9.0.2 and a 9.0.3 instance to support VA re hosting project. Created OCI C routines and PL/SQL procedures for Data Manipulation.

Developed a backup and recovery plan utilizing Veritas Netbackup and SQL*Backtrack.

Day to day database maintenance on HP-UX platform.

Upgraded Oracle 9i to 10g.

Installed and tested Streams Replication for a reporting database.

Designed and implemented database systems on HP-UX and DEC Alpha Systems.

Designed DW database for TELCOM switches.

Computer Science Corporation Colorado Springs Feb 1988 – Jun 1998

Architect the SDIN (Secure Digital Integrated Network) for early warning and communications using Timeplexes and Idnxes.

Deployed a three-man team to install and deploy worldwide network systems utilizing known satellite systems and assisted in their installations.

Task was to annotate required resources and hardware for this project.

SCIS Fallback project for multi-protocol network systems, build out new hardware from scratch using Z280 processors and front panel using 80386 processor for access.

Coded various bootstrap code for startup, monitoring and distribution from BODOT to 9.6k modems.

Ran and terminated Fiber Optic Cable throughout NORAD

EDUCATION

BS: Computer Science

Colorado Technical University --have not graduated due to consulting work.

ASSOCIATES: Electronic Engineering Technology

Technical Trades Institute Graduated with 4.0 GPA

PROGRAMMER ANALYST

U.S. Army --Graduated utilizing IBM 360/370 Main Frame Computer and COBOL

DATASTAX Online Feb 2018-March 2018

Cassandra Foundations and Administration

Cassandra Data Modeling

Cassandra Architect

ORACLE

Database Administration I & II

RAC Administration 9i - 12c

RMAN Internals

AMAZON Online May 2018 - Current

AWS Core essentials

CERTIFICATIONS

Software Engineer CTU

Fiber Optic Technician Air Force

Lay Director Walk 161

Other Training

VMWare 14 Work station installation and used for deploying Solaris, Linux and windows Virtual Systems along with databases for testing and diagnostics.

DXE Cassandra 3.0 Deployed multi node system (3) and tested it using Keyspaces and VMWare 12. Currently gaining knowledge on all aspects of Cassandra and its parameters located in Cassandra.yaml file.

Raspberry PI 3 B+ Deployed Micro Computer size of a deck of cards to assist in controlling the stage lighting system at Church using QLC+ DMX Software with PAR/Panel and spot light parameters implemented in QLC+ Software.

Behringer X32 16 Channel Sound System. Deployed at church and configured according to the Church’s requirements.

Training Refresh on Oracle 12cR2 and Data Guard and Golden Gate on Workstation 14 using VmWare

Contact this candidate