Oracle DBA

KENNETH C. HUGHES

Cell: 206-***-****

E-Mail: **********@*****.***

LinkedIn: http://www.linkedin.com/in/hugheskc

Website: www.kennethchughes.com 07/24/2020

RESUME OF EXPERIENCE, TRAINING, AND PUBLICATIONS

Oracle DBA 08/28/2020

PROFESSIONAL PROFILE .

• A vast amount of experience working for government agencies (US, State, and local), banks, fortune 50 companies, health care, Telecom, and small start-ups

• A professional who demonstrates a commitment to ensuring client success and satisfaction

• Clear concise planning and excellent analytical abilities

PROFESSIONAL SKILLS .

• Managed Dev, test, & Production VLDB, OLTP, & Real-Time databases

• Installed, and managed Oracle high availability Data Guard (10G,11G,12C)

• Proactive Oracle infrastructure and capacity planning

• Performed upgrades & patching, SQL, and index tuning

• Extensive development DBA experience creating logical/physical models, writing SQL & PL/SQL to identify

database structural strengths & weaknesses, loading data (ETL), database QA testing, and tuning databases.

• Data modeler modeling and designing VLDB, OLTP, & Real-Time databases

• Oracle Certified Professional trainer for OCP classes at Bellevue College

TECHNICAL SKILLS SUMMARY .

Methodologies: SCRUM, AGILE, Waterfall, IDEF, Martin Crows foot

Oracle Tools: Pluggable databases, RMAN, Data Guard, Golden gate, Data Pump, RAC

Applications: Python, Jupiter Notebooks, Anaconda Navigator, Power BI, Toad, TOAD Data Modeler, Erwin

Languages: SQL, PL/SQL, Linux Shell, Windows batch file scripting

Databases: Oracle versions: 5.2, 7, 8i, 9i, 10G, 11G, 12C, virtual Oracle databases

Operating Systems: LINUX (Red Hat, Oracle Linux, Centos), SOLARIS, Windows, Oracle Virtual Box

Capabilities: Database Administration (Dev, Test, Production), physical database design, Database Quality Assurance, best practices, Health checks, PCI and PII database security, Data Governance

PUBLICATIONS, PRESENTATIONS, AND USER GROUPS .

• Founding Member of Puget Sound Oracle Users Group

• Lectured on “Designing a High Security Database” at the “Computers and Technology Showcase” convention

• Wrote book on International Finance published in 32 countries

• Investment author for two newsletters "Dollars and $ence" and "Investors Exchange" published internationally

• Authored many technical documents such as Data Guard installation, Database upgrading, RMAN backup

AWARDS .

• Concert Inc., MCI, and British Telecom were awarded "Best Practices in the United States" from the Data Warehousing Institute (www.dw-institute.com) as a direct result of my data cleansing quality assurance & ETL processing re-design contribution to Concert's Financial Data Warehouse

EDUCATION .

• University of Washington Certified Oracle Applications Developer (2008)

• Oracle 11G SQL fundamentals (OCA) (2016)

• Oracle 9i Certified Professional (OCP) (2003)

• Oracle7 Certified "Master of Database Administration" (1997)

• Information Systems Programmer/Analyst, Honors Graduate (1988)

Computer Learning Center, Springfield VA. (Associate degree equivalent 32 college credits)

CAREER EXPERIENCE .

Oracle DBA –Blue Origin (Consultant Tek Systems) April 2019 to July 2020

Technical Environment: Oracle 11G/12C, RMAN, PL/SQL, Python and Windows scripting, Red shift support.

• Migrated production databases to new servers

• Created and managed Dev, Test, Stage, and Production databases

• Wrote scripts and monitored production and test databases for backup/recovery and database performance

• Resolved production issues

• Performed RMAN HOT and Cold backups

• Supported customer user accounts, DB performance, designing and building tables, indexes, procedure, profiles, roles etc.

Oracle DBA –Boeing Airplane (Consultant DXC) 4/2018 to Jan 2019

Technical Environment: Oracle 11G/12C, RMAN, PL/SQL, Linux shell scripting, RAC, Container Databases .

• Created and managed Container and Pluggable databases

• Built production, test, Development, and Data Guard databases

• Wrote scripts and monitored production and test databases for backup/recovery and database performance

• Resolved production issues

• Performed RMAN HOT and Cold backups

• Performed Multi-threaded (parallel) Data Pump backups and imports.

• Supported customers with account, performance, designing and building tables, indexes etc.

• Supported Golden Gate replication from Oracle 12g source to Oracle 12G target databases.

Oracle DBA –Trios Health (Consultant Pixieum LLC) 8/2014 to 4/2018

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting, Windows Server 2008 R2 .

• Built production, test, and Reporting databases

• Wrote scripts and monitored production and test databases for backup/recovery and database performance

• Resolved production issues

• Performed RMAN HOT and Cold backups

• Performed Multi-threaded (parallel) Data Pump backups and imports

Oracle DBA –Trios Health (Kelly Services) 5/2014 to 8/2014

Kelly Services cancelled their agreement with Trios Health and Trios wanted me to stay so they brought me on via Pixileum LLC.

Oracle DBA/SQL tuner –Nordstrom (Consultant Kelly Mitchel) 8/2017 to 12/2017

Technical Environment: Oracle 12C, RMAN, SQL tuning, Linux shell scripting, Linux .

• Wrote shell scripts and monitored production and test databases for backup success and database performance. Resolved production issues of all types. Tuned 37 SQL select statements for performance using SQL tuning advisor, explain plan, and a thorough knowledge of tuning techniques. Most if the time I was able to reduce the execution time by more than 60%

Oracle DBA – CBORD Inc. 8/2016 to 8/2017

Technical Environment: Oracle 11G& 12C, RMAN, Windows batch file scripting, Windows Server 2008 R2 .

• Wrote scripts and monitored production and test databases for backup/recovery and database performance

• Resolved production issues

• Automated database availability monitoring and alerting

• Performed RMAN and Data Pump backups,

• Applied CPU patches and database version upgrades,

• Performed monthly database health assessments for 30+ production databases and consulted with customers

(was responsible for over 60 production databases)

• Built, recovered, and Re-Synced over 15 Data Guard databases

Database Quality Metric measurement – Washington Health Plan Finder (Obama care) (Consultant Corus 360 group LLC) 1/2015 to 3/2015

Technical Environment: Oracle 11G & 12C, Erwin, SQL Optimizer, Database Examiner, PL/SQL, Toad, Power Point, Ms Excel.

• Worked with management to identify business needs and IT staff to solve problems and support their needs

• Worked with IT staff and management to improve their SDLC Technology – Architecture

• Identified measurable Database Quality metrics

• Presented database quality findings and recommendations to senior management

• Worked with team members to document lineage from database tables through SQL, to the java application front end

• Tuned problematic SQL

• Provided Data migration and archiving strategy recommendations

• Recommended database design changes with a focus on Database Design Quality (DDQ) metrics affecting:

(1) Database speed

(2) Ease and expense of making changes to tables and related software

(3) Accuracy of information in the database

(4) Prevention of corrupt or invalid database information

(5) Database performance as the amount of information increases over time (scale wide)

(6) Database performance as the number of concurrent users increase over time (scale up)

(7) Intuitive and consistent database design

(8) Identification of deviations from 1NF, 2NF, and 3rd Normal Form, impacts to software and the business

Marketing Data Modeler –- Nordstrom (Consultant for TPR) 8/2014 to 11/2014

Technical Environment: Oracle 11G&s12C, Toad Modeler, Visio professional .

• Logical and Physical Data modeler and database designer of the Marketing Operational Data Store (MODS) database. Created logical ERD’s, record layout proof of concepts, and MODS data dictionary including Source to Target mapping. Worked with stake holders to define the way Nordstrom uses marketing terms across marketing teams and Marketing channels

• Unica and File Maker analyst. Developed File maker programs and databases. Developed strategic plan for marketing Customer Life Cycle and touch point management. Created Unica flow charts for email trigger campaigns

• Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users

• Data Steward & Data Quality Assurance. Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance). Responsible for data retention (legal, analytical, operational life cycle management). Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal

Production DBA\Data Governance\Database Design –- VIX Technology (Consultant for Robert Half Technology) 7/2013 to 2/2014

Technical Environment: Oracle 11G&s12C, Data Guard, RMAN, PL/SQL, Solaris & Windows .

• Logical and Physical Data modeler and database designer. Reverse engineered several Databases using Toed Modeler. Worked with stake holders and development staff to create a data dictionary and ERD of several databases to assist with modifying existing application functionality

• Production/Development DBA. Managed high availability Data Guard databases, Wrote PL/SQL and used Oracle Wallet to maintain security over PCI data, created views to satisfy reporting requirements, Managed RMAN and Data Pump backup, built new databases and recovered crashed databases, used GRID, Spotlight, TOAD, PL/SQL, SQL Work Bench, and SQL Plus for every day monitoring, issue resolution, and maintenance

• Data Governance/Database design. Identified data lineage from application front end code via middle tier pl/sql code to database back end schemas and objects. Reverse engineered databases and created ERD’s that identify relationships, and subject areas each table/column affects. Created a data dictionary organized by subject area domains with lineage and physical design characteristics

Production DBA -- SNBL Inc. (Consultant for Robert Half Technology) 3/2013 to 6/2013

Technical Environment: Oracle 11G, RMAN, PL/SQL, Windows batch file scripting .

• Audited production and test databases for backup/recovery and database performance on Microsoft Windows Server 2008 R2. Performed database RMAN and Data Pump backups and resolved production issues. Wrote and tuned PL/SQL procedures. Wrote batch files to monitor database availability, perform RMAN and Data Pump backups, Version and delete Database backup files

Production DBA -- Cambia Health (Consultant for Kforce Professional Staffing) 9/2012 to 2/2013

Technical Environment: Oracle 10G/11G, Data Guard, TAF & FSF, Toad for DBA's, Linux Shell scripting .

• Installed, configured, patched, and upgraded database versions 10.2 and 11.2. on 10 databases. Installed Data Guard and TAF (Transparent Application Fail over) and FSF (Fast Start Fail over) on two databases. Performed RMAN backups, recoveries, and cloning on five databases, upgraded the database time zone version on 10 databases

Database Developer -- Fulcrum Technologies 2/2012 to 6/2012

Technical Environment: PL/SQL, Oracle 11G, Toad for DBA's, SQL Developer, Linux Shell scripting .

• Supported Fulcrum's largest customer AT&T with PL/SQL development

Production DBA -- Boeing Migration Factory group (Consultant for TaTa consulting) 8/2011 to 2/2012

Technical Environment: MS Office Suite, Oracle v.11.2, PL/SQL, Unix shell scripts, CASE tool Toad Modeler,

Oracle 11G, Oracle RAC & Golden Gate, Toad for DBA's on LINUX and HPUX .

• We moved 42 databases from all over the United States to three service centers in Seattle, Phoenix, and St. Louis in RAC/Linux and Service Guard/HPUX environments

• Worked with Golden Gate and Data Guard to build mission critical 24/7 databases and dramatically reduce down time while maintaining current data replication from the legacy database to the new target database

• Database Administrator managing 12 RAC and Non RAC production and development databases

• Authored a Migration Factory Staffing Plan for the project MGR

• Project saved Boeing 4 $million during the first 9 months with less than 150 databases moved

Database Designer/Administrator -- TWEDDLE Group (Consultant) 01/2011 - 08/2011

.

Technical Environment: Oracle 11G, PL/SQL, shell scripts, Toad Modeler, Database Examiner, Toad for DBA's . .

• Lead Oracle Development DBA and database designer of the first application of its kind to allow Toyota and Lexus automobiles to communicate with the WWW via a smart phone. Entune is a Real-Time processing application that enables occupants of the car to do things like make restaurant reservation, reserve parking spots at a garage before arrival. Get real time stock quotes etc.

Data Governance/Database design.

• Designed four databases to support Real Time interaction between the Car and the WWW, historic tracking of user activity, applications content management, and an analytical database for providing Business Intelligence

• Used CASE tool Toad Modeler and Database Examiner for reverse engineering, comparing database physical models against the actual database design, and for reviewing application and database functionality with end users

• Worked with end users and corporate executives to identify business processes and application requirements that could be part of a logical ERD and physical ERD

Production/Development DBA.

• Wrote Shell scripts and SQL scripts for building the entire database including table spaces, schemas, tables, grants etc.

• Wrote Unix shell scripts for proactive DB Health monitoring, import/export (Data pump)

• Authored/co-authored Production and Development standard operational procedures to ensure the confidentiality, integrity, and availability of the corporate data asset

• Conducted database DDL and DCL code reviews. Assisted management with development of SDLC procedures and entrance and exit criteria

Data Steward & Data Quality Assurance -- Capital One (Consultant for Pixileum Inc.) 08/2010 – 12/2010

Technical Environment: SQL server, Oracle, Teradata, PL/SQL, Ab-Initio, Linux, MS Excel, Visio . .

• Performed Data Governance work (Data Quality, Data Retention, and Data definition & value Governance)

• Worked with production DBA's to establish data quality assurance processes and data quality dash boards related to ETL between production database and analytical databases

• Performed Source-to-Target data mapping from production ->legacy analytical->additional analytical->data marts/reporting.

• Responsible for data retention (legal, analytical, operational life cycle management)

• Obtained, organized, and defined subject area Meta Data in applicable repositories (Ab-Initio, SQL Server, and Oracle)

• Documented and organized data quality assurance (best practices, Health checks, Data Quality rules) for business, analytical, legal

• Performed JAD session information identification & subject area segmentation to obtain high quality data for financial analytics, SOX, PII governance, and production/operations forecasting and management

Team Lead/Senior Oracle DBA -- "The Oracle Club" Study Group 04/2009 - 07/2010

Technical Environment: Oracle 10G&11G, Data Guard, shell scripts, Linux, Centos, Virtual servers, RMAN .

• Lead team of six IT professionals. Installed Oracle 11G Enterprise GRID with Data Guard, RMAN repository, and three "production databases" on nine virtual Oracle Linux servers running on a Centos and Windows 64-bit servers

Team Lead/Senior Oracle DBA -- Seattle City Light 07/2007 – 03/2009

Technical Environment: Oracle 10G&11G, shell scripts, Linux, Solaris, AIX, RMAN .

• Led a new team of six DBA’s in a business environment recently converted from vertical silos to a matrix organization.

• Responsible over 60 production databases used for billing, customer records, disaster management, electrical power management, enterprise resource management, weather tracking and prediction etc.

• Implemented policies for Oracle DBA roles and responsibilities, primary & backup database support responsibilities, working from home policy, and for Vendor/Contractor management

• Implemented plans and procedures for Emergency response, Backup and recovery

• Responsible for Oracle DBA cross training skill assessment and training plans

• Enterprise Data Governance committee member. Assessed and developed long-term strategic Data Governance goals, Data Quality Assurance processes, Data Retention Life Cycle policy, Data Steward responsibility points within the data retention Life Cycle, and Data Security policy

• Used RMAN and data pump for backing up databases

• Used Erwin for designing databases

• Performed Oracle database cloning and migration, used data pump, RMAN, and Data Guard

Team Lead/Senior Oracle DBA -- Kent School District 01/2004 – 05/2007

Technical Environment: MS Office Suite, Oracle (v.8, 10G, & 11G), Unix shell scripts, Solaris, RMAN .

• Supported a suite of applications used by over 3,000 staff members, 27,000 students, and 30,000 parents. Average concurrent sessions were between 500 and 700 Concurrent users on HP True 64 UNIX and windows 2003 servers

• Led a team of two Senior Oracle Database Administrators, one Contract Oracle Database Administrator and two Junior Oracle Database Administrators

• Responsible for Oracle Database Real Time performance monitoring, database troubleshooting & tuning, Vendor/Contractor management, database emergency response/Disaster Recovery (DR), and performed on call and support rotation responsibilities.

• Wrote an Oracle database reporting tool that collected Oracle database information every day and performed trend analysis and change analysis on current data compared to past data with over 50 reports

• Wrote an Oracle database backup application that Versions Hot and Cold backups, automatically deleted old backups in accordance with a retention policy, and recorded backup information in an Oracle database

• Performed data migration (ETL) to a replacement application/database using Erwin, SQL and PL/SQL, Data Pump, and Materialized Views. This resulted in a suit of 24/7 applications that had zero unplanned downtime over 12 months

Instructor, Bellevue Community College, GO2Cert.com 6/2001 – 4/2004

Technical Environment: MS Office Suite, Oracle (v.9, 10G, & 11G) RMAN, Erwin .

Taught the advanced and entry-level Oracle Certification classes

Classes taught

• Data Modeling

• Oracle 11g: SQL (with intro to PL/SQL)

• Oracle 11g Database Administrator I (user management)

• Oracle 11g Database Administrator II (Backup/Recovery & Network Administration)

• Oracle 11g Performance Tuning (advanced)

• Database Testing Concepts

• Database Architecture for Data Integrity, Performance, Scalability, Flexible (Logical and Physical Modeling)

• Technical Writing

• Software Quality Assurance

Administrative Responsibilities

• Designed and administered exams

• Provided direction to numerous students and student teams

• Interfaced with students and management concerning attendance, course content and University Policy

• Mentored students in Best Practices of database design and administration

• Created class materials for several classes

PRIOR CAREER EXPERIENCE .

Team Lead Enterprise Database Design

-- White House special project "Re-inventing government"

• Responsible for the overall design of database in 6 divisions of the USAID. Audited database design for 6 development teams to ensure information could move from one database into any other database as needed without data changes.

• Served as point of escalation and review/approval for key design issue decisions with regards to enterprise data and information

• Helped pioneer Enterprise Master Data Management, Data Quality Assurance, and Service Oriented Architecture before those terms were industry standards

• Worked with end users and corporate executives to identify business processes that can be part of a process model, Conceptual Model, logical ERD, and then a physical ERD

• Translated enterprise and business requirements into long-term information/data architecture solutions

• Developed, and audited enterprise databases for compliance with master data management, Data Quality Assurance, and Service oriented architecture road maps, best practice guidelines, and standards

• Defined and maintained best practice guidelines and standards for data stewardship, data modeling, database physical design, and DBA operations

• Advised business and technology groups on future technology options, outlining risks, costs, benefits and capabilities

Database Cleansing and Feeder System Architect & DBA Team Lead

-- Concert Inc. (a partnership between British Telecom, MCI, and AT&T).

• Re-Designed the Operational Data Store and Data Cleansing databases for Concert's Financial Data Warehouse.

• Lead Oracle DBA team Development/Production (Team of 3 DBA’s) for Concert's Financial Data Warehouse, Operational Data Store, and Data Mart databases

• This database system won the “Best Practices Award for 1997” from the Data Warehousing Institute. Saved over 50 million dollars in lost revenue through more accurate customer billing

Dev Team Lead -- Perot Systems

• Team Lead (myself, one DBA, one Data Modeler, and one business analyst) created a physical model, built, and was the production DBA for a database that received over 30 million Call Detail Records loaded into it every week. The application and database provided efficient and secure access to over 20 billion Call Detail Records for AT&T, Bell South, and Sprint customer billing on the east coast of the United States

Development/Production DBA -- United States Postal Service (USPS)

• Used Erwin to create and convert Logical designs into a Physical Database design to satisfy production mail-forwarding requirements for use in 250 mail processing facilities. Senior Database Administrator for 15 Dev, QA, and Test databases. Senior production DBA for databases in Cincinnati OH, Frederick MD, Reston VA, and Sacramento CA. This “Real Time” application was estimated to exceed four $million dollars in savings per year.

Contact this candidate