Oracle Training Oracle Support
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices
 

Free Oracle Tips


 
HTML Text AOL
 


Resume
Terry O. - OCP

We only do consulting. 

No permanent job inquiries please.

 

Click here for Consulting rates.


BIOGRAPHY

Terry is an expert in PL/SQL tuning, Oracle Database Administration, and Oracle Applications administration.

A Certified Oracle Professional and a graduate of the University of North Carolina Asheville, Terry has extensive experience in managing and tuning complex Oracle applications.  

A noted Oracle Applications expert, Terry is expert in Oracle applications 10.7 and Oracle applications 11i. Terry also specialized in Oracle Applications tuning and has published Oracle Applications tuning articles for DBAzine. Terry is noted for his dedication, persistence and hard work.

PUBLICATIONS

Inside the Oracle concurrent Manager - DBAZine, January, 2003

EDUCATION/AWARDS

-   19921996 University of North Carolina Asheville, NC
      BS Computer Science with concentration on Information Systems
     3.0 GPA.

- 19901992 Blue Ridge Community College Flat Rock, NC
      Associate in Arts. - 3.92 GPA
.
-  Oracle Certified Professional

- President of Phi Theta Kappa Honorary Society.

- The National Dean's List 91-92 .


SKILLS

Oracle9i, JCL, PL/SQL, COBOL, TSO/ISPF, CICS, SQL, Oracle Web Server, MVS, Oracle Financials, Net8, NT, Solaris, HP/UX


CONSULTING EXPERIENCE


Tampa, FL Dec 2002 - Present

Citibank -- Tampa, FL
Oracle Applications DBA
Operating System: Sun Solaris

   -  Support and maintain 16 Oracle Applications 11.5.4 instances including production.
   -  Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
   -  Install Oracle database 8.1.7.
   -  Install and configure 9iAS.
   -  Install and configure Oracle Portal.
   -  Install NLS sofware when new language support is required.
   -  Configure JVM and jserv processes for load balancing.
   -  Configure form servlets.
   -  Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
   -  Apply database and applications patches.
   -  Perform SQL tuning.
   -  Assist developers with coding PL/SQL.
   -  Write korn shell and perl scripts.
 
Printceton Information -- Tampa, FL Jul 2002 - Dec 2002
 
 
PL/SQL Programmer

Operating System: HPUX 11

   -  Perform SQL tuning .
   -  Write PL/SQL programs for reconciling credit card transactions.
   -  Write PERL scripts for validating raw datafiles to load data into Oracle databases.
   -  Create database objects for custom applications.
   -  Perform SQL Tuning.

Name withheld (non-disclosure)
Oracle Apps tuning review
Performed Oracle tuning review for an NT-based Oracle application server.

Name withheld (non-disclosure)
PL/SQL Programmer

   -  Rewrote thirty-three PL/SQL stored procedures to increase performance.

Name withheld (non-disclosure)
Oracle Applications Database Administrator
Operating System: Sun Solaris 8

   -  Upgraded 8.0.5 database to 8.1.7 and implemented sever partitioning with 8.0.6 to enable Oracle Applications 11.0.3 to work with 8.1.7.
   -  Create test web servers, web listeners, form servers, concurrent managers, and databases from the production environment for 11.0.3.
   -  Apply database and applications patches

Name withheld (non-disclosure)
Oracle Applications Database Administrator
Operating System: HPUX11

   -  Create test web servers, web listeners, form servers, concurrent managers, and databases from the production environment for 11.0.3.
   -  Troubleshoot problems with web server, web listener, forms server, concurrent managers, and database on 11.0.3.
   -  Apply applications patches.
   -  Make changes to standard Oracle Applications forms and reports using Designer/Developer for testing purposes as advised by Oracle Support.
   -  Upgrade from 11.0.3 to 11i.
   -  Upgraded 8.0.5 database to 8.1.7 and implemented sever partitioning with 8.0.6 to enable Oracle Applications 11.0.3 to work with 8.1.7.
   -  Create custom concurrent requests to perform database maintenance.
   -  Write Korn shell scripts to monitor and maintain the Oracle Applications database.
   -  Write SQL scripts to monitor tablespace and extent growth.

Name withheld (non-disclosure)
Database Administrator / Developer
Operating System: SUN Solaris

   -  Install Oracle 8i databases.
   -  Interview users to gather requirements for database design.
   -  Create the application tablespaces, tables, and indexes.
   -  Write scripts to monitor database growth and gather statistics.
   -  Write PL/SQL packages and assist C programmers with developing programs to call the PL/SQL packages.
   -  Troubleshoot database problems.
   -  Performance tuning.
   -  SQL Tuning.
   -  Convert TCL code to PL/SQL
   -  Upgrade databases.

Name withheld (non-disclosure)
Database Administrator
Operating System: Sun Solaris

   -  Upgraded five databases from 8.0.6 to 8.1.7


EMPLOYMENT HISTORY




Wake County Public Schools -- Raleigh, NC -- Oct 97 to Aug 2000
Oracle Applications Database Administrator
Operating Systems: AIX, OS/390

   -  Support approximately 100 users on Oracle Financials 11.0.3.
   -  Apply application patches.
   -  Create and maintain custom responsibilities and menus.
   -  Installation of Web applications server, Oracle Applications server and Oracle Forms server. Configuration of DAD, WAS cartridges.
   -  Migrated 4 instances from MVS OS/390 to IBM AIX RS/6000.
   -  Set up to share APPL_TOPs over different instances
   -  Move all custom programs and reports to production. This involves enforcing naming standards, maintaining the custom application top , and setting up concurrent requests.
   -  Make changes to standard Oracle Applications forms and reports using Designer/Developer for testing purposes as advised by Oracle Support.
   -  Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
   -  Create test web server, web listeners, form servers, concurrent managers, and databases from the production environment.
   -  Create tablespaces, tables, and users for custom applications.
   -  Maintain user security.
   -  Maintain Oracle schemas and SGA region.
   -  Assist Programmers and Developers with Oracle problems.
   -  Write Korn shell scripts to monitor and maintain the Oracle Applications database.
   -  Write SQL scripts to monitor tablespace and extent growth.
   -  Perform analysis, coding, maintenance, and testing of applications using COBOL, CICS, ODE, MSA Information Expert, and JCL.
   -  Support GEAC Financials and GEAC Payroll applications.
   -  Answer users' questions on an ongoing basis.
   -  Resolve various application failures due to data entry errors or system errors. Involves identifying problems and implementing corrective actions.
   -  Write COBOL programs to convert legacy data to an Oracle Applications database.
   -  Write SQL*Loader control files for uploading legacy data to interface tables.


Orthopedic Appliance Company -- Asheville, NC -- Jul 94 to Oct 97
Programmer
Operating System: SCO Unix

   -  Write, test, and implement programs using DBASE IV.
   -  Design and build relational tables using DBASE IV.
   -  Interview users to gather requirements for database design.
   -  Perform Unix system administration.
   -  Create the application tables and indexes.
   -  Train users on in-house developed and commercial software.
   -  Troubleshoot and repair desktop computers.






 
 

 
 
 

 

 

Burleson Consulting

Email: info@remote-dba.net    -  Phone Toll Free (800) 766-
1884

Copyright © 1996 - 2011 by Burleson Enterprises. All rights reserved.