Oracle Database Administrator Resume
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 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 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 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