SUMMARY:

Oracle Certified Professional with 15 years of Oracle Database Administration including Oracle 9i, 10g, and 11g database backup and recovery, RMAN, Data Guard, PL/SQL, triggers, Oracle Applications Server, Oracle Enterprise Manager, Oracle WebLogic and Fusion Middleware, RedHat Linux, Sun Solaris, AIX UNIX, and Windows 2003. Considered one of the top Oracle DBA’s in the educational field. Rated "Substantially Exceeds Requirements" on annual performance reviews.

STRENGTHS:

Oracle database backup, recovery, and cloning on Oracle 10g and 11g platforms, including implementing remote and local Oracle Data Guard physical standby databases, implementing incremental and full Oracle Recovery Manager (RMAN) backups of multiple databases, and database disaster recovery using RMAN or SQL on RedHat Linux, Sun Solaris, IBM AIX UNIX and Windows 2003 servers.

EMPLOYMENT:

Confidential, San Antonio, TX

Oracle Database Administrator

Responsibilities:

• Managed eight RedHat Linux servers with a dozen Oracle 10g and 11g databases, applying Banner and Oracle patches and upgrades, implementing a test server and a development server including installing and configuring all of the software on those servers, standardizing on RMAN database backups across those platforms, cloning databases for test and archival purposes on the same platform and across platforms, performing database disaster recovery for business continuity, and extracting data and writing reports for the various departments across campus.

Confidential, Little Rock

Oracle Database Administrator

Responsibilities:

• I consistently received annual job performance review ratings of "Substantially Exceeds Requirements", and attained "Employee of the Quarter" and other awards from the Extension Service over my 16 year tenure.
• I made presentations at local, national, and international conferences, mainly on Oracle database disaster recovery, Oracle Data Guard physical standby databases, and RMAN.

Confidential

Computer programming consultant

Responsibilities:

• Maintain the Banner software on the RedHat Linux, IBM AIX UNIX and Windows 2003 servers (for my various database positions), including planning, coordinating, and applying upgrades and patches (for which I wrote our autopatch scripts on the IBM AIX). Recompile the Banner programs and regenerate the Banner forms and reports as needed when patches or upgrades are applied. ( Confidential ’s has eight RedHat Linux servers with a dozen databases, and the Extension Service has two IBM AIX UNIX servers, two RedHat Linux servers, and eight Windows 2003 servers, for the Oracle, Banner, and Web Server implementations, also with a dozen Oracle databases.)
• Maintain, plan, coordinate, and install Oracle upgrades and patches, install additional components, and monitor the health of our Oracle databases and Banner software on the RedHat Linux, IBM AIX and Windows servers. In addition to the RDBMS (relational database) installations on those servers, I also maintain the Oracle Application Server and WebLogic/Fusion Middleware (web server) software on three of the Linux systems and two of the Windows systems (which service the Banner forms and reports, Self Service screens, and Luminis portal requests).
• Maintain current, complete, and tested backups of our Banner data for our production and test databases. We are currently using Oracle's RMAN (Recovery Manager) to back up those databases on the RedHat Linux and IBM AIX database servers, and are using Symantec Backup Exec to back up our Windows database servers. Monitor the eight Linux and two IBM AIX database servers (production and test) for disk space availability. Recover the Banner database back to a given point in time as needed for disaster recovery. Clone our production Banner database and other Oracle databases as needed to provide test databases for various projects and to work on solutions for various problems (my cloning procedure takes under 30 minutes without having to take the databases down).
• Maintain our Oracle Data Guard standby databases on a remote site (Ft. Smith) and on a local server, monitoring space availability on both the remote and local standby servers. Assist with disaster planning and the disaster recovery testing to swap the modes (primary and standby) of the production and standby databases, and to run scripts on the remote site.
• Install and upgrade operating system software and compilers, such as for COBOL, C, and C++, along with utilities such as gzip, gnupg, snobol4, uvscan, and the vim editor.
• Attend and present at conferences and attend classes to keep up with the technology for Oracle and for Banner. These include the SunGardHE Summit conference and the Arkansas Banner User's Group (ABUG) conference each year, along with various Oracle classes held from time to time in the surrounding region of the country.
• Work with Financial Services personnel to develop and run SQL scripts for them such as reprinting vouchers, to diagnose and correct problems such as with payroll runs and with employment records, to clone (copy) the production Banner Oracle database to a test database as needed to assist with their software and procedure testing, and to restore the Banner database to an earlier point in time if a run goes awry or a data entry problem occurs. Enter and monitor Service Requests (SR's) into SunGardHE's ActionWeb site for Financial Services personnel without ActionWeb accounts.
• Work with HR (Human Resources) to pre - load data for yearly employee evaluations, to correct employee records, and to modify Banner to work better with employer-specific benefits. Also, create all user Banner accounts and add/delete/maintain the security classes and their assignments to those Banner accounts.
• Work with IT (Information Technologies) to fix Banner WebForms and Self Service password problems, to help with the Banner/Luminis portal integration, to install, upgrade, and maintain the Luminis portal and Oracle web server software, and to research and recommend software and hardware for Banner and other systems.
• Work with the Little Rock State Office personnel and the statewide county office personnel to fix their Banner and Self Service problems, and to assist them with Banner and Luminis portal issues.
• Work with the other universities around the State of Arkansas to help them solve their Banner and Oracle problems and challenges, such as recovering their database when a major failure occurs, teaching them how to do things in Oracle and Banner, helping them with Banner/Oracle data backups, and co-locating each other's standby databases for off-site disaster recovery storage.
• Maintain "Steve Rea's Oracle and Banner Tips, Tricks, and Scripts" web site (now located at Confidential) with information that is accessed from all over the world, with over 750,000 hits since its inception in 1997, and which is in the top 10 Oracle web sites on the various internet search engines. Major topics include step-by-step Oracle database disaster recovery, backups, restores, cloning using Oracle RMAN (Recovery Manager), e-mailing from Oracle (including attachments and multiple recipients), implementing and maintaining Data Guard local and remote standby databases, and applying Banner patches using my autopatch scripts.
• Member of the IT (Information Technology) section committee and the Banner committee, each of which meets monthly to discuss various issues, plans, challenges, and concerns. Member of the Promotion Committee which meets yearly to evaluate employee promotion-in-rank requests.