PROFESSIONAL SUMMARY

• Experienced Oracle DBA in Oracle database administration that includes installation, upgrading, patching, configuration, migration, cloning, security, monitoring, performance tuning, and backup and recovery
• Upgraded, patched, and maintained Oracle E-Business Suite Financial application releases from 10.9 to various 11.5 releases and to 11.5.10.2
• Migrated databases and applications to new servers for E-Business Suite, Banner, and local applications on Sun Solaris, HP Tru64, DG Aviion, and MS Windows platforms
• Installed and upgraded Oracle 10g/9i/8/7 production and development databases for E-Business Suite Applications and Sunguard Banner applications in Sun Solaris, HP-UX, DG UX, and Windows environments
• Installed Oracle Grid Control Management on Oracle release 11g and agents to monitor database performance and tune databases along with OEM and user written scripts
• Designed Oracle web physical layout and installed Oracle database, Application Server, and web cache/load balancing front-end on Unix and Linux platforms
• Wrote SQL scripts for Banner payroll and Unix scripts to monitor the database and the operating system
• Upgraded Oracle databases from release 7 to 8 to 9i to 10g for local and Oracle E-Business Suite applications
• Installed Oracle Application Server portal with failover for web applications and installed and configured web cache/load-balancing front-end

Database Systems: Oracle 11g/10g/9i/8/7
Oracle Applications: E-Business Suite Financials 10.9 to 11.5.10.2, Sunguard Banner payroll and
student systems, local applications
Operating Systems: HP UX, DG UX, Linux SuSE 9/10, MS Windows NT
Database Tools: SQL*Plus, PL/SQL Developer, OEM 10g, PL/SQL
Hardware: Sun Solaris SPARC; Linux x86-64; HP Tru64; DG Aviion; Windows NT

ACCOMPLISHMENTS

Oracle Database Administrator 1993 - 2009
Confidential,Tulsa, OK

• Upgraded and maintained Oracle EBS financial releases from 10.9 to 11.5.10.2 working with finance programmer and finance managers, installed Oracle EBS financial patches and troubleshot and resolved customer error messages working with Oracle Support as needed
• Cloned Oracle EBS software and database from production to test system to provide a platform for the customers to test and, also, set up a procedure to clone the Banner database from production to test
• Installed, configured, patched, upgraded, migrated, cloned, maintained security, monitored and tuned, backed up and recovered Oracle databases using both RMAN and user written scripts from version 7 to version 10g
• Migrated databases, Application Server, and web cache to new servers including migrating from Windows NT and DG Aviion to HP Tru64 to Sun SPARC Solaris
• Eliminated need for Discoverer desktop license by upgrading Discoverer 4i to Discoverer 10g, making Discoverer Plus available to customers and migrating the customer workbooks to Discoverer 10g

Oracle Database Administrator (Continued)

• Successfully migrated EBS from multi-node to single-node and to a new server and upgraded Oracle E-Business Suite Financials (AP, PO, GL) to new release, in one upgrade, disk space was sparse and the upgrade required many patches and took several days to complete so was able to involve programmers in upgrade
• Created and maintained the platform for the company main website by installing an Oracle database, Oracle Application Server (Portal) with failover, and Oracle web cache/load balancing front-end and upgraded to new releases to maintain Oracle support
• Installed Oracle Grid Control Management Services on a newly created 11g database and installed the agents on the servers to be monitored and monitored databases using OEM
• Successfully resolved database and finance error messages and troubleshot Oracle and end-user problems related to Oracle, assisted programmers and other IT personnel with related challenges/solutions, and worked with managers/assistant managers of various departments to resolve problems
• Upgraded Banner software releases in order to stay in support, installed patches and troubleshot errors and contacted Banner support when needed, worked with the programmers to move changed and new programs to production
• Created and assigned security roles for Banner by working with department managers to determine the access each job position should have to Banner forms and reports
• Wrote SQL/SQL*Plus scripts to provide information needed for departmental reports not provided by Banner and particularly wrote many reports for the Payroll department for which customers were pleased to receive the data needed formatted as they wanted
• Wrote OS scripts and set up as cron jobs which would send email messages to the system administrator and myself when certain conditions occurred, such as disk space reached certain percentage “full”. This provided knowledge of various problems and ability to resolve issues in a timely manner.

Senior Programmer Analyst 1982 – 1993
Confidential,Tulsa, OK

• Designed, wrote, and implemented a CICS online system for the television department including database tables, reports, input screens and batch file input, resulting in a system that allowed the department to view ratings and costs of various markets
• Wrote and debugged COBOL and CICS programs as needed to upgrade, maintain, troubleshoot the Partner mail system
• Maintained the McCormack and Dodge accounting programs and system by debugging and upgrading the programs as needed and writing new programs
• Redesigned and rewrote the Restricted Accounting programs and system to bring it in house from an outside vendor
• Improved performance on SQL scripts that were running very slowly by researching SQL tuning and writing guidelines for tuning scripts and giving presentation to programmers

EDUCATION/SPECIAL SKILLS

BSBA in Accounting, Confidential,University .Fayetteville, AR
Confidential,College, Tulsa, OK, Various classes
(System Analysis/Design, C-language, Networking, Intro to Java, HTML, Introduction to
Web Page Design, etc)
Oracle Education classes in RAC and Database Administration