We provide IT Staff Augmentation Services!

Oracle Resume

Orlando, FL

OBJECTIVE

Seeking Oracle Database Administrator position where proven strengths in database management will provide a significant contribution to company growth.

SUMMARY

Database Administrator with extensive experience in Relational Database Management Systems, i.e. Oracle, DB2/UDB, Sybaseand associated development software on a variety of platforms including UNIX (HP-UX and Sun Solaris) AIX, RISC,Linux and Windows.

EXPERIENCE

Confidential, Orlando, FL May 2008 - Jan. 2009
Database Consultant (Oracle)

Project: Oracle Sales Orders Database on Linux:

  • Created the data model.
  • Installed and configured the Linux O/S.
  • Installed and configured the Oracle 11g software.
  • Created the database.
  • Used RMAN to create backups.
  • 4.) Used SQL Loader to insert the initial data.
  • Created the forms for data entry.
  • Created the reports for sales orders, delivery tracking, customers and payments.
  • Tuned the database for optimal performance.

Confidential, Jacksonville, FL April 2005 - July 2007
Database Consultant (Oracle and DB2/UDB)

Oracle (on Sun Solaris):

  • Mortgage PhD:
  • Data modeling.
  • Installed and configured the Oracle software including the creation of multiplexed redo logs, rollback tablespaces and segments, placing the database in archived redo log mode, writing the backup scripts for both hot and cold backups and exports.
  • Implemented the database model including creation of the tablespaces, tables, users, roles and profiles.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Upgraded the database to the current release as required.
  • Installed Oracle patches as required.
  • Configured Oracle*Net.
  • j.) Installed the JDBC thin driver.
  • k.) Recovered the database as necessary both partially (using either import or archive logs as required) and full database recovery (using hot backups with archived redo logs).
  • l.) Tuned the database for optimal performance.
  • m.) Migrated the database from Oracle 8i to Oracle 10g.
  • n.) Coverted cold backup shell scripts to RMAN backups.
  • o.) Incident and Change Control Management using Remedy.

2.) MaxClaims:

  • Installed and configured the Oracle software including the creation of multiplexed redo logs, rollback tablespaces and segments, placing the database in archived redo log mode, writing the backup scripts for both hot and cold backups and exports.
  • Implemented the database model including creation of the tablespaces, tables, users, roles and profiles.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Upgraded the database to the current release as required.
  • Installed Oracle patches as required.
  • Configured Oracle*Net.
  • Installed the JDBC thin driver.
  • Recovered the database as necessary both partially (using both imports or archived redo logs logs as required) and full database recovery (using hot backups with archived redo logs).
  • Tuned the database for optimal performance.
  • Migratedthe database from Oracle 8i to Oracle 10g.
  • Incident and Change Control Management using Remedy.

Oracle (on HP-UX, Sun Solaris, AIX Linux and Ms Windows):
Worldwide On-Call 24/7 Support:

  • Provided on-call support every four weeks for our in house databases and client-owned databases that we created, maintained, upgraded, de-bugged and recovered. This include support of Oracle 10g RAC databases using ASM.
  • Incident and Change Control Management using Remedy.

DB2/UDB (on AIX, HP-UX, Linux and MS Windows):
Ford Billing System:

  • Installed the database software on both platforms.
  • Configured the databases (production, test and development).
  • Created the SQL scripts to populate, maintain and cleanup the databases.
  • Wrote the backup procedures.
  • Assisted the developers\' with de-bugging their SQL code.
  • 6) Tuned the developers\' code for optimum performance.
  • Tuned the database for optimal performance.

Confidential, Jacksonville, FL Sept. 1998 - April 2005
Database Administrator (Oracle and Sybase)

Oracle on Windows:
Genesis (repository of corporate knowledge):

  • Installed and configured the Oracle software including the creation of rollback tablespaces and segments and redo logs.
  • Implemented of the database model including creation of the tablespaces, tables, users, roles and profiles.
    3.) Created automated backups on our MS Windows computers using Windows Scheduler, ArcServer backup software with the database in archived redo log mode using hot backups. Also wrote the scripts for a nightly database export.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Configured Oracle*Net.
  • Assisted the developers with Oracle*Forms, Oracle*Reports and Crystal Reports.
  • Incident and Change Control Management using Remedy.

Oracle on Sun Solaris:
Mortgage PhD:

  • Data modeling.
  • Installed and configured the Oracle software including the creation of multiplexed redo logs, rollback tablespaces and segments, placing the database in archived redo log mode, writing the backup scripts for both hot and cold backups and exports.
  • Implemented the database model including creation of the tablespaces, tables, users, roles and profiles.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Upgraded the database to the current release as required.
  • Installed Oracle patches as required.
  • Configured Oracle*Net.
  • Installed the JDBC thin driver.
  • Recovered the database as necessary both partially (using either import or archived redo logs as required) and full database recovery (using hot backups with archived redo logs). Installed, configured RMAN and migrated all backups to RMAN. Performed database recovery using RMAN.
  • Tuned the database for optimal performance.
  • Migrated the database from Oracle 8i to Oracle 10g.
  • Incident and Change Control Management using Remedy.

Oracle on HP-UX:
Planview (PeopleSoft Application):

  • Installed and configured the Oracle software including the creation of multiplexed redo logs, rollback tablespaces and segments, placing the database in archived redo log mode, writing the backup scripts for both hot and cold backups and exports.
  • Implemented the database model including creation of the tablespaces, tables, users, roles and profiles.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Upgraded the database to the current release as required.
  • Installed Oracle patches as required.
  • Configured Oracle*Net.
  • Installed the JDBC thin driver.
  • Recovered the database as necessary both partially (using both imports or archived redo logs as required) and full database recovery (using hot backups with archived redo logs).
  • Tuned the database for optimal performance.
  • Migrated the database from Oracle 8i to Oracle 10g.
  • Incident and Change Control Management using Remedy.

Oracle on Linux, Sun Solaris and MS Windows:
Misc. Reporting Databases:

  • Installed and configured the Oracle software including the creation of rollback tablespaces and segments, redo logs and placing the database in hotback mode, writing the backup scripts for both hot and cold backups and exports.
  • Implemented of the database model including creation of the tablespaces, tables, users, roles and profiles.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL and PL/SQL code.
  • Tuned the developers\' code for optimum performance.
  • Configured Oracle*Net.
  • Installed the JDBC thin driver.
  • Recovered the database as necessary both partially (using both imports or archived redo logs as required) and full database recovery (using hot backups with archived redo logs).
  • Tuned the database for optimal performance.
  • Migrated the database from Oracle 8i to Oracle 10g.
  • Migrated data from Sun Solaris to Linux using transportable tablespaces..
  • Incident and Change Control Management using Remedy.

Sybase on Sun Solaris:
Max:

  • Installed and configured the Sybase software including the creation of the transaction log and configuring it.
  • Implemented the database model including creation of the databases, tables, views, indexes and users.
  • Ran developers\' scripts and procedures to populate, maintain and cleanup the database.
  • Assisted developers with de-bugging their SQL code.
  • Tuned the developers\' code for optimum performance.
  • Performed DBCC on a weekly basis.
  • Tuned the database for optimal performance.
  • Recovered the database as necessary.
  • Migrated the database from Sybase 11.x to Oracle 8i.

EDUCATION : Confidential

PROFESSIONAL CERTIFICATES

  • Certified Oracle Professional Database Administrator, 8i
  • Certified Oracle Professional Database Operator, 8i

DATABASE ADMINISTRATION SCHOOLS

  • Oracle Database Administration
  • IBM DB2/UDB 8.x. Database Adminsitartion for Oracle Database Administrators
  • Sybase 11.x Database Administration for Oracle Database Administrators

ORACLE DATABASE ADMINISTRATION SCHOOLS

  • Oracle Database Adminstration
  • New Features for Oracle Database Administrators (version 7.x - 10g)
  • Oracle Trouble-shooting and Problem Resolution
  • Oracle Backup and Recovery, including RMAN and Data Guard
  • 5.) Oracle Performance Tuning

ORACLE APPLICATION DEVELOPER SCHOOLS

  • SQL
  • SQL*Plus
  • PL/SQL
  • Oracle Forms
  • Oracle Reports
  • Oracle Enterprise Manager, (Ms Windows, Client Server and Web based)
  • Oracle Designer/Repository
  • Oracle Discoverer
  • Oracle*Net

ORACLE TOOLS

  • SQL
  • SQL*Plus
  • PL/SQL
  • Oracle Forms
  • Oracle Reports
  • Oracle Designer/Repository
  • Oracle Discoverer
  • Oracle Enterprise Manager (MS Windows, Client Server and Web-site versions)
  • Oracle Warehouse Builder (ETL Tool)

Hire Now