We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

2.00/5 (Submit Your Rating)

Marinadel Rey, CA

CAREER OBJECTIVE: To obtain a full-timeposition as anOracle Database Administrator, offering the opportunity to utilize my technical expertise in a progressively challenging Oracle environment.

Experience

Confidential, New Holland (CNH)
Racine, WI (remote/telecommute) 8/06 - 11/11
Oracle Database Administrator

Accomplishments:

  • Co-managed over 35 production/development Oracle databases in a Unix environment
  • Migrated all Oracle databases from Solaris to AIX platform
  • Helped setup/configure SQL*Backtrack software for nightly database backups
  • Helped make current/new production Oracle databases SOX (Sarbanes-Oxley) compliant
  • Provided 24x7 Oracle DBA support as part of on-call team rotation
  • Helped implement more proactive database tuning standards (as part of database performance SLA)
  • Upgraded production/development Oracle databases from version 9i to 10g and 10g to 11g
  • Successfullyinstalled & configured ER Studio / DB Artisan to create database schemas & ER diagrams
  • Reviewed data conversion scripts to ensure correctness, tested in pre-production environment prior to running in production
  • Worked with Unix team to help migrate databases from Solaris to AIX platform

Responsibilities:

  • Troubleshooting and resolving database / application issues
  • Keeping all Oracle databases current with Oracle Security Patches
  • Tracking database growth trends for capacity planning
  • Mentoring development team on database performance tuning and capacity issues
  • Helping implement database and application change requests
  • Performing routine hot / cold database backups via SQL*Backtrack / exports to disk
  • Installation and configuration of Oracle database software
  • Performing database migrations from different OS platforms
  • Applying necessary Oracle upgrades / patches
Database / Hardware Summary:
  • Database sizes: 40 GB - 2 TB
  • Database versions: 9.2.8.0 - 11.2.0
  • Hardware platform: AIX & Solaris Unix
  • 24x7 databases: 10

Confidential
Cypress, CA 8/04 - 8/06
Sr. Oracle Database Administrator

Accomplishments:

  • Served as lead DBA managingover 40 production Oracle databases in a Unix environment
  • Backup support for Oracle HRMS payroll & financials application for Oracle E-Business Suite Rel. 11.5
  • Migrated / standardized all production Oracle database backups to RMAN / TSM
  • Briefly supported Disney account for Oracle RMAN / TSM backup configuration
  • Migrated 1.5 TB database from Solaris Unix server to AIX server
  • Helped make current/new production Oracle databases SOX (Sarbanes-Oxley) compliant
  • Provided 24x7 Oracle DBA support as part of on-call team rotation
  • Helped implement more proactive database tuning standards (as part of database performance SLA)
  • Upgraded production Oracle databases from version 8i to 9i and 9i to 10g
  • Successfully implemented and configured OEM to proactively manage mission-critical databases
  • Worked with Unix team to successfully implement HACMP for high availability databases

Responsibilities:

  • Troubleshooting and resolving database / application failures
  • Keeping all Oracle databases current with Oracle Security Patches
  • Tracking database growth trends for capacity planning
  • Mentoring development team on database performance tuning and capacity issues
  • Helping implement database and application change requests
  • Performing routine hot / cold database backups via RMAN / exports to disk
  • Performing database migrations from different OS platforms
  • Applying necessary Oracle upgrades / patches
Database / Hardware Summary:
  • Database sizes: 25GB - 1.5TB
  • Database versions: 8.1.7.4 - 10.2.0
  • Hardware platform: AIX & Solaris Unix
  • Max. online users: 155
  • 24x7 databases: 10

Confidential
Redmond, WA 1/02 - 5/04
South San Francisco, CA 6/97 - 12/01
Oracle Database Administrator

Accomplishments:

  • Managed 15-20 Oracle databases for PeopleSoft development environment
  • Provided DBA support during upgrade to PeopleSoft 8 & PeopleSoft 8.3 HRMS / payroll applications
  • Provided DBA support during PeopleSoft Time & Labor implementation
  • Achieved 99% uptime while co-managing 45 Oracle databases (15 production) on a 24x7 basis
  • Provided DBA support during implementation of PeopleSoft 7.5 HRMS / payroll applications
  • Collaborated with project team to implement 24x7 e-commerce application using Coldfusion middle tier
  • Successfully implemented and configured OEM to proactively manage mission-critical databases
  • Worked with team leads to successfully implement standby databases for high availability applications
  • Gained experience using SharePlex replication software from Quest

Responsibilities:

  • Troubleshooting and resolving database / application issues
  • Starting-up / shutting-down PeopleSoft application servers, process schedulers and web servers
  • Providing on-call support for 24x7 operations
  • Mentoring development team on database performance tuning and capacity issues
  • Creating production, development, QA, staging or standby Oracle databases
  • Performing routine hot / cold database backups / exports to disk / tape
  • Installation and configuration of Oracle database software
  • Performing database migrations from different OS platforms
  • Applying necessary Oracle upgrades / PeopleSoft 7.5 patches
Database / Hardware Summary:
  • Database sizes: 600 MB - 170 GB
  • Database versions: 7.3.2-8.1.7
  • Hardware platform: HP & Sun Unix
  • Max. online users: 245
  • Largest table: 23.7 GB / 165+ million rows
  • 24x7 databases: 2

Confidential
San Francisco, CA 9/96 - 3/7/97
Oracle Database Administrator

Responsibilities:

  • Working with development team to tune SQL / PL-SQL batch jobs
  • Providing DBA support for application developers / SAS programmers

Confidential
San Ramon, CA 11/95 - 8/30/96
OracleDatabase Administrator

Responsibilities:

  • Recovering Oracle database from media failure
  • Troubleshooting and resolving database / application issues
  • Performing weekly cold backups of database and file system

Confidential
San Jose, CA 10/94 - 11/95
OracleDatabase Specialist

Responsibilities:

  • Writing ad hoc queries using SQL*Plus and PL/SQL
  • Creating Unix shell scripts to clean data before loading into database
  • Importing data from legacy systems using SQL*Loader

Education & Certification

Oracle 9i & 10g (OCP) DBA certifications
B.S. Business/MIS

UC Santa Clara Extensions | Oracle Relational Database Management
UC Santa Clara Extensions | Oracle RDMS Database Administration
Quest Software | Shareplex Replication software for Oracle Sun Educational Services (SA-135) | Fundamentals of Solaris System Administration
Sun Educational Services (SA-238) | Solaris System Administration
Sun Educational Services (SA-3XX) | Managing Oracle on Solaris 2.x
Oracle Educational Services | Oracle Backup and Recovery
PeopleSoftUniversity | Server Administration
PeopleSoftUniversity | Data Management Tools I

We'd love your feedback!