We provide IT Staff Augmentation Services!

Oracle Dba Resume

2.00/5 (Submit Your Rating)

San Antonio, TexaS

SUMMARY

  • Extensive Oracle experience, with 11 Years as an Oracle Database Administrator. Design, develop, install, implement, administer, upgrade migrate, maintain and support Oracle databases.
  • Experienced with multi - tiered architecture and Unix System Administration. Innovative, creative, persistent, analytical and a self-starter. Strong planner, problem solver, team player, very organized and excellent communicator with technical expertise.
  • Experience with reorganization, data analysis, partioning, performance tuning, backup and recovery.
  • Experienced with database migration from server to server, and between the various versions of Oracle, specifically between Oracle 7.x, Oracle 8.x and Oracle 9i.

TECHNICAL SKILLS

Hardware: UNIX servers, NT Servers, Disk Storage Arrays and PC’s

Operating systems: Sun Solaris, HP-UX, AIX, DG-UX, Windows 95, 98, 2000, and NT

Software: Oracle RDBMS, HP’s Service Guard, shell scripting, Oracle Utilities, OEM, RMAN, SQL*Plus, PL/SQL, Desktop DBA, SQL*Net, Net 8

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

Oracle DBA, UNIX Sys Admin, SQL Programmer

Responsibilities:

  • Managed, maintained, backed up and updated Oracle databases. Introduced Oracle 8, 9i and built one Oracle 10g database.
  • Developed numerous SQL scripts to load various spread sheets for use by both Management and Client personnel.

Confidential, Houston, Texas

Contract Oracle DBA - ESD Infrastructure Team

Responsibilities:

  • Developed, implemented and monitored standard database shell scripts for export, Rman backups, monitoring databases and alert log reporting. Developed standardized server scripts for managing space, maintaining logs and maintenance routines. Established standards for server environments.
  • Tested and implemented standard set of scripts on 140 database and 40 servers.
  • Published Documentation on database standards which was presented and accepted.
  • Installed Oracle 9i on several servers and built 9i databases.

Confidential, Houston, Texas

Oracle DBA - Technical Infrastructure Team

Responsibilities:

  • Built and supported 27 Oracle non-SAP databases on six UNIX servers.
  • Designed, created, refreshed, supported and managed system environments to meet the needs of the ChevronTexaco ERP merger and consolidation activities. All services delivered on time despite a three-fold increase in the final environments versus the original plan.
  • Improved user performance 400% and eliminated rollback errors during revenue cycles by redesigning and rebuilding the PriceWaterhouse/Coopers redo log and rollback structure.
  • Modified Oracle OFA configuration for the production environments so each database had automatic failover capability with HP’s Service Guard. System delivered one month early.
  • Streamlined the refresh process - loaded production data into test, develop, and acceptance databases. Reduced the reload time in half while increasing the size of the load six fold.
  • Tuned the databases and disk space use on a regular schedule.
  • Successfully migrated eleven databases from 7.3.4.1 to 8.1.5 and then on up to Oracle 8.1.7, migrated two databases for oracle 8.0.x to Oracle 8.1.7, migrated six databases from Oracle warehouse. The f7.3.4.1 direct to 8.1.7. Built all of the associated Net 8 components. Databases ranged in size from 17 Gig up to 140 Gigabytes.

Oracle DBA

Confidential

Responsibilities:

  • Initiated, analyzed, designed and implemented the first partitioned Oracle database at Texaco. The resulting database provided up to a 20-fold increase in performance.
  • Developed the prototype for PC Polis (PC version of Production On Line Information System) and did the initial implementation. Analyzed Texaco Reserve data to develop a PC Reserves Information
  • Acquired a small IBM UNIX server from another Texaco entity as Upstream’s first server. Analyzed and projected future needs and acquired a larger IBM J30 server with 108 GB of disk space. Filled the dual role Oracle DBA and Unix System Admin for 26 months.
  • Developed and implemented backup, recovery and remote backup storage procedures; used these backups to successfully recover from every situation.
  • Proactive administration, preventative maintenance and monitoring of database performance resulted in the databases being available 99.43% of the advertised time.
  • Resolved major problems with the installation of new Sun Servers with Storage TEK disk array. Provided scripts that were used by Colorado Storage TEK personnel to verify both the problems existence and the final resolution

We'd love your feedback!