NAOMI SMITH

**** *. **** ******

Tulsa, OK *****

918-***-**** Cell: 918-***-****

E-mail: abl0rl@r.postjobfree.com

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

. Installed, upgraded, and patched Oracle databases for production and

development for Banner applications in HP-UX, DG UX, and Windows

environments

. Migrated databases and applications to new servers on Sun Solaris, HP

Tru64, DG Aviion, and MS Windows platforms for Banner, E-Business Suite,

and local applications

. Wrote SQL scripts for Banner and Unix scripts to monitor the database and

the operating system

. 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

. Installed Oracle Application Server portal with failover for web

applications and installed and configured web cache/load-balancing front-

end

. Upgraded Oracle E-Business Suite Financial application releases from 10.9

to various 11.5 releases and to 11.5.10.2

. Upgraded Oracle databases from release 7 to 8 to 9i to 10g for local and

Oracle E-Business Suite applications

. Designed Oracle web physical layout and installed Oracle database,

Application Server, and web cache/load balancing front-end on Unix and

Linux platforms

Database Systems: Oracle 11g/10g/9i/8/7

Oracle Applications: Banner payroll and student systems, E-Business

Suite Financials

10.9 to 11.5.10.2, local

applications

Operating Systems: Solaris Unix, HP UX, DG UX, Linux SuSE 9/10, 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

Oral Roberts University, Tulsa, OK

. 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

. 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

. 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

NAOMI SMITH Page

2

918-***-**** Cell: 918-***-****

E-mail: abl0rl@r.postjobfree.com

Oracle Database Administrator (Continued)

. Cloned Banner and Oracle EBS software and database from production to

test and set up a procedure to clone the Banner database

. Upgraded and maintained Oracle EBS financial releases from 10.9 to

11.5.10.2, installed Oracle EBS financial patches and troubleshot and

resolved customer error messages working with Oracle Support as needed

. 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

. 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

. 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

. 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

. 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

Oral Roberts University, 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

University of Arkansas, Fayetteville, AR, BSBA in Accounting

Tulsa Community 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

Contact this candidate