Erwin Spencer

Technical Architect/Oracle DBA

Email: ad2myx@r.postjobfree.com

Mobile: 972-***-****

Professional Overview

Mr. Spencer is a senior Oracle DBA with over 20 years of database consulting experience encompassing multiple companies and industries. His expertise rests in multiple Oracle database versions including Oracle 6, 7, 8i, 9i, 10g, 11g12c and 19c. He also has experience utilizing RAC and DataGuard and in several flavors of Unix including Linux (RedHat, SuSe, Fedora), Solaris, SunOS, HP/UX and AIX, SCO-Unix, TSO. He has successfully completed numerous projects involving new database deployments, upgrades, platform migrations, complete and partial database recoveries, data recoveries and patching. He has also performed several Oracle RAC installations and upgrades and database migrations to AWS cloud and Oracle OCI . Has appetite to learn new technologies and constantly improve technical skills.

Technical Expertise

DBMS Systems:

Oracle (19c, 12c, 11g, 10g, 9i, 8i, 7, 6), RAC, Data Guard, Oracle Financials 11.5.9 iAS, AP (9.4, 10.5)

ERP Tools:

ERwin, S-designer, Oracle Designer 2000, Oracle Forms, Oracle Developer, Oracle Financials

DBA Tools:

Oracle Enterprise Manager/Grid Control/Cloud Control (10g, 11, 12C, 13c), SQL Developer, BMC Patrol, HP OpenView, RMAN, ASM, TOAD, SQR Workbench

Middleware:

WebSphere, Tuxedo (TP Monitor)

Hardware:

Sun Fire Series, Sun Sparc (10, 20, 2000), IBM P690, IBM P670, IBM RS/6000, IBM SP2, SAN, NAS, EMC HP 9000, Compaq Proliant, RAID, EMC, NetApp

OS, Networks:

Solaris, AIX HP/UX, Red Hat Linux, VMware, Fedora, Windows NT, X Windows (Motif), Veritas Cluster Software (VCS) TCP/IP, IBM HACMP, Windows (10, XP, 2000, 7)

Languages:

UNIX Shell (Korn, Bourne, Bash), AWK, SED, C, Pro*C, SQL*Plus, PL/SQL, Pro*Cobol, exposure to Python, Rubrik backups

Education

B.S. Microbiology –Texas Tech Univ, Lubbock, TX

PROFESSIONAL AND BUSINESS EXPERIENCE

PERFICIENT, INC., Dallas, TX Dec-2015 to Jan-2023

Oracle DBA/Technical Architect

Project: Internal DBA Practice/SupportNet

Responsibilities:

Assist in developing basic infrastructure tasks/procedures/scripts for DBA Practice/Client support

Provide Oracle database/environment support for various clients. National Geographic, Galderma, Fortegra, SPE, Mercer, TRAC Intermodal, GameStop, G6/Hospitality, GlenRaven, Maritz

Perform OEM/Cloud Control installation, configuration, maintenance, monitoring rules/notification, Weblogic management, maintenance, patching as associated with OEM Cloud Control

Develop install Linux O/S scripts to monitor and report client and internal database issues, application and O/S events and issues

Database platform and cross-platform migrations from on-premise (Solaris, AIX, Linux) to AWS and Oracle OCI environments with container databases(CDB) and pluggable databases (PDB)

Configure RMAN backup to AWS S3 storage

Provide database maintenance/patching, tuning, table indexing, Oracle CRS infrastructure patching, perform database TDE

Develop and schedule for periodic execution scripts to monitor DR readiness and StandBy Database redo apply status, Provide Oracle Dataguard support for DR execution and functionality

Provide environment migration (Solaris to Linux) using Transportable Tablespace method, compilation verification of C, Pro*C, C++ programs in support of in-house developed application

Run AWR reports, check presence and settings of init parameters, check running processes to identify possible application OLTP performance lags.

Check new 19c database init parameters, linux system environment in their new OCI environment to identify performance lag issue impacting testing in the development/test environments.

Provide patching for Oracle databases in RAC environment and without.

Set up shell scripts to monitor/report RAC instance status when OEM or other tools are not available.

Install and debug RAC configurations in Oracle 12c environments

Set up shell scripts to regularly clear audit logs system wide beyond a certain date

SOUTHWEST AIRLINES, Dallas, TX Mar-2014 to Dec-2015 Consultant/SR Oracle DBA

Responsibilities:

Maintain, Tune, Support Oracle 11g databases running in EMC/NetApp RAC environment on Solaris 8 O/S and RedHat

Application migrations through full life-cycle (Development to QA to Production)

Database troubleshooting, performance monitoring and tuning

Application troubleshooting and performance tuning

24x7 Production on-call rotation

UNIX Shell scripting to support Enterprise database and cluster monitoring, CRON processes, database creation and automated database reporting, table indexing as needed

Daily monitoring of database backup, space utilization, performance and OS utilization.

Oracle CRS upgrades(11g)

Utilize 12C OEM in database monitoring and support

SAN space management to support numerous databases

Remote database work performed as needed for scheduled procedures and 24x7 On-Call support

Install 12c CRS, upgrade 11g CRS to 12c CRS

INTERSTATE BATTERIES, Dallas, TX Jul-2013 to Mar-2014 Sr. Oracle DBA

Responsibilities:

Install Oracle 11g databases to Linux RedHat environments

Database troubleshooting

RMAN Backup and recovery

Performance monitoring, tuning and problem resolution

Application support

JD Edwards upgrade database migration and support

SQL Script execution to meet user requests

Configuration of Oracle OEM 12c, patch as needed

Application team interface for problem resolution

Project/database documentation creation

Oracle SR submission

RMAN / Export backups and recovery

SQL query tuning to support applications

Database replication, migrate data copies from/to databases environments

24x7 Production on-call rotation

CITIGROUP, Irving (Las Colinas), TX Sep-2012 to Jun-2013 Consultant/Oracle DBA

Responsibilities:

Install Oracle 10g and 11g databases to Solaris/AIX environments

Database troubleshooting

Performance monitoring, tuning and problem resolution

SQL Script execution to meet user requests

Database monitoring and admin from GRID

Application team interface for problem resolution

Project documentation creation

Oracle SR submission

Physical database migration from datacenter to datacenter

RMAN backups and recovery

Database standby testing

Database patching

Database failover, switchover and flashback testing

SOUTHWEST AIRLINES, Dallas, TX Dec-2007 to Dec-2012 Consultant/SR Oracle DBA

Responsibilities:

Install Oracle 10g and 11g EE software to Linux servers (SuSe, RedHat)

Create RAC databases in Oracle 10g RAC (SuSe) environments and 11g RAC environments (SuSe, RedHat)

Maintain, Tune, Support Oracle 11g, 10g and 9i RAC databases running in Fujitsu/Siemens RAC environment on Solaris 8 O/S, and SuSe and RedHat

Application migrations from 9i to 10g databases, from 10g to 11g

Application migrations through full lifecycle (Development to QA to Production)

Interaction with third party vendors and internal management to coordinate and assist in third party application installation, tuning and troubleshooting

Database troubleshooting, performance monitoring and tuning

Application troubleshooting and performance tuning

24x7 Production On-Call rotation

OEM and GRID configuration

UNIX Shell scripting to support Enterprise database and cluster monitoring, database creation and automated database reporting

Daily monitoring of database backup, space utilization, performance and OS utilization

Install local agents and configure GRID to help monitor RAC databases and OS environments

Oracle Database and Cluster installation on Linux (SuSe and RedHat)

Data migration/refresh from production to QA/SAT and development.

Remote database work performed as needed for scheduled procedures

SAN space management

Created a backup and refresh/update process for all CRON configurations on development, QA and Production UNIX machines using native shell scripting and a centralized repository

Monitor OLTP processes from critical pilot/flight attendant application time tracking/update system. (check for locks, memory consumption, possible network issues.

Monitor database connectivity during periodic scheduling of pilots/attendants via listener logging and audit logging to verify users and activity being performed while investigating database performance.

ALCON LABS, Fort Worth, TX Aug-2007 to Nov-2007 Consultant/Oracle Apps DBA

Responsibilities:

Database cloning, upgrades, machine migrations (AIX and Windows 2003)

Proprietary application and database migrations

Database troubleshooting

Develop and document process and procedure to migrate Oracle v8 databases and applications to Oracle v9 databases (using UNIX shell scripts, SQL*Plus, PL/SQL)

OEM configuration

AMERIPATH INC., Carrollton, TX May-2007 to Aug-2007 Consultant/Oracle DBA

Responsibilities:

Data migration using Oracle export/import, Oracle DataPump

Utilized Dataguard to maintain the standby databases in the RAC cluster

ORABPEL installation and support

Oracle Application Server support and maintenance

Tier 1 Production support, on-call support, 24/7

Data and Database Backup and recovery

Support of multiple large 10g terabyte databases and applications in a RAC environment

Development support in an Oracle 10g environment

Query/Code evaluation for performance tuning and lock contention resolution

Code Migrations

Data loading, purging using SQL or PL/SQL

Database cloning in Sun Solaris environments (UNIX)

Oracle database problem resolution with Oracle Metalink

Tuning database, application, SQL and PL/SQ

Capacity Planning

OEM installation configuration

ALLIANCE DATA SYSTEMS, Richardson, TX Dec-2005 to Apr-2007 Consultant/Oracle DBA

Responsibilities:

Development Support of numerous databases of various versions and sizes (8i, 9i, 10g)

Database creation, upgrades, cloning, tuning, troubleshooting, daily monitoring and security

Migration of Non-ASM databases into ASM

Application debugging and tuning

Development and Production database lifecycle testing

Installation and configuration of Oracle Enterprise Manager (now part of Oracle Fusion Middleware) on HP*UX to monitor and manage 30+ databases.

Configuration and management of parallel Oracle Application Server, allowing SQL access from the application server web interface.

Creation of various PL/SQL packages, procedures, scripts, functions, triggers to automate some DBA tasks and provide users restricted access to some DBA responsibilities such as killing sessions.

RMAN to manage files within Oracle ASM

Code and Data migrations

Data Conversion

SQL Server data to Oracle conversion

VECTORSGI, Dallas, TX Sep-2005 to Dec-2005

Consultant/SR Oracle DBA

Responsibilities:

Evaluation and performance tuning of VECTORSGI application modules and database code (PL/SQL, SQL*Plus scripts, Packages, Procedures and Triggers)

Oracle error resolution in application and database

Correction of application modules errors

Evaluation of in-house and client databases for tuning improvements in support of VECTORSGI Application software

Production and development support (database and application)

DCSI, St. Louis, MO Dec-2004 to Sep-2005 Consultant/Oracle DBA

Responsibilities:

Evaluation of application modules (PL/SQL, Pro*C, etc.) for tuning improvements

Evaluate physical databases for potential issues and tuning improvements (Windows, Unix environments)

Assist developers with code design, development, testing and implementation

Provide management with physical/logical perspective of application databases at client sites and suggest tuning and installation improvements

Troubleshoot and resolve existing application problems (tuning, Oracle errors, etc.) at various client sites

Provide developers and support technicians with direction to identify and resolve Oracle Forms, PL/SQL, SQL/Plus related issues

ALLIANCE DATA SYSTEMS, Richardson, TX Sep-2004 to Dec-2004 Consultant/Oracle DBA

Responsibilities:

Modified as needed database triggers, stored procedures, Oracle Forms (6i) to support modifications to Banner application

Created and tuned new code (PL/SQL, triggers, stored procedures, SQL*Plus scripts, Shell scripts, Pro*C and Pro*Cobol) to meet design project requirements and acceptable performance standards

Made tuning recommendations for database and applications when warranted.

Production Support of Banner Application

Database and application troubleshooting and problem resolution

Direct interaction with client to resolve database and application issues

TEXAS-NEW MEXICO POWER, Ft. Worth, TX May-2004 to Sep-2004 Consultant/Oracle DBA

Responsibilities:

Developed database triggers, stored procedures, Oracle Forms (6i) to support modifications to Banner application

Created and tuned new code (PL/SQL, triggers, stored procedures, SQL*Plus scripts) to meet design requirements and acceptable performance standards

Designed, created new database tables to support modifications to Banner

Made tuning recommendations for database and applications when warranted

ALLIANCE DATA SYSTEMS, Richardson, TX Sep-2003 to May-2004 Consultant/Oracle DBA

Responsibilities:

Troubleshoot and correct reported problems with PL/SQL, Pro*C and Oracle Forms (6i) programs supporting SCT Banner Application

Tuned existing PL/SQL and Pro*C programs

Created new PL/SQL, PL/SQL Packages and Procedures, Triggers, Pro*C and SQL*Plus programs in support of the SCT Banner application and Oracle 8i database

Made tuning recommendations for Oracle 8i databases when tuning issues are recognized

Utilized UNIX shell scripts or commands to manipulate large input/output data files

Details on additional projects prior to 2004 are available upon request.

Contact this candidate