Oracle DBA, Mysql DBA, SAP Basis Admin, PL/SQL Developer

Claudia DAVIDSON

510-***-**** ********@*****.***

PROFESSIONAL EXPERIENCE

Senior Oracle DBA/Senior SAP Basis Admin

March 2013 – present

Pacific Gas and Electric San Francisco, CA

* Maintained support for over 50 SAP systems on multiple platforms including AIX and linux

* Upgraded Oracle from Oracle 10g to 11g, applied SAP recommended database patches

* Upgraded Oracle from 11.2.0.3 to 11.2.0.4

* Provided Basis and Oracle technical support to developers and end users

* added datafiles using brtools, resized datafiles using brtools

* Migrated databases and SAP systems to new datacenter servers.

* Wrote shell scripts to monitor production and development systems.

* Applied SAP recommended database patches, imported Portal certificates.

* Completed SAP system refreshes for ECC6 and the Portal including database restores using Tivoli (TSM), renaming the

database, recovering the database, STMS setup

* Trained new team members to do Basis and Oracle tasks

* Upgraded SAP from ECC6 EHP5 to ECC6 EHP6

* Upgraded SAP Netweaver 7.0 Portal to Netweaver 7.31 EHP1

* Installed and configured SAP Environmental Compliance (EC)

* AIX/Unix administration tasks (smitty)

* Configured SSO on SAP Portal

* Documented processes and procedures. Shared knowledge with team and trained new team members

* Shared weekly on-call support with Basis Team

* Created OSS messages to troubleshoot SAP issues

* Monitored Production and Development systems, abap dumps, system log, long running sessions, locks

Senior Oracle DBA/SAP Basis Admin

June 2012 – March 2013

Lam Research Fremont, CA

* SAP Basis Team Lead for Integration project and Basis Admin Group

* Maintained support for over 100 SAP systems on multiple platforms including AIX, SUN and Windows

* Completed SAP system refreshes for ECC6, DM, GTS, CRM (split stack), BW (split stack) including database restores

using Tivoli (TSM), renaming the database, recovering the database running BDLS or client import, STMS setup, import

version mgmt.

* added datafiles using brtools, resized datafiles using brtools

* Wrote shell scripts to monitor production and development systems.

* Setup RMAN backups and TSM backups

* Managed weekly Basis meetings and Project meetings

* AIX/Unix administration tasks (smitty)

* Troubleshoot SAP runtime errors, ABAP dumps, system errors.

* Added systems to solution manager to extract migration keys

* Created OSS messages to troubleshoot SAP issues

* Shared weekly on-call support amount Basis Team

* Provided Basis technical support to developers and end users

* Documented processes and procedures. Share knowledge with team and trained new team members

* Completed multiple tasks within deadlines

* Ran Monthly and Quarterly reports for the SOX audit

* Monitored Production systems, abap dumps, system log, long running sessions, locks

* applied SAP recommended database patches, setup SAP unix app servers

* modified SAP profile parameters, completed system error analysis

Senior Oracle DBA

January 2008 – June 2012

Novellus Systems San Jose, CA

* Team Lead for SAP Basis Administrator Group for over 30 SAP systems on multiple platforms including AIX, SUN and

Windows)

* Upgraded Oracle from Oracle 9i to 10g, applied SAP recommended database patches

* Created database triggers to for delta data updates used in BOBJ project

* Project lead for multiple projects, including ECC Portal Migration, Oracle 11g upgrade for over 30 servers and Oracle

Dataguard implementation.

* added datafiles using brtools, resized datafiles using brtools

* Monitored databases with AWR report.

* Completed SAP system dual stack refreshes for ECC6, DM, GTS, BW, including database restores and recovery,

renaming the database, running BDLS, STMS setup, import version management

* Trained new team members to do Basis and Oracle tasks

* Analyzed current production capacity and projected future capacity trends

* Setup RMAN backups and Tivoli (TSM) backups

* Wrote shell scripts to monitor production and development systems

* Upgraded to SAP Netweaver 7.1 with Enhancement Pack 4

* Ran Monthly and Quarterly reports for the SOX audit

* Managed multiple sql server databases on Sql Server 2008. Setup replication.

* Managed weekly Basis meetings and Project meetings

* Documented processes and procedures. Share knowledge with team and trained new team members

* Upgraded ECC6 EP3 to ECC6 EP4

* Completed Unicode upgrade and migration from SAP 46.C to ECC6 EP3

* Created OSS messages to troubleshoot SAP issues

* Shared weekly on-call support amount Basis Team

* AIX/Unix administration tasks- AIX lpars and Solaris zones, added LUNS to lpars and zones.

* Added Change requests using itticket software and maximo

* Provide Basis technical support to developers and end users

* Troubleshoot SAP runtime errors, ABAP dumps, system errors.

* Installed and configured PI, web dispatcher, Virsa, Portal

* Installed latest support stacks, Notes

* Monitored Production systems daily, monitored abap dumps, system log, long running sessions, locks

Senior Oracle DBA

May 2005 - November 2007

Epocrates San Mateo, CA

* Oracle 10g DBA for 1T Data Warehouse and RAC ASM Prod db on Linux

* Created Informatica mappings and workflows

* Created materialized views, tuned sql scripts and queries

* Upgraded databases from 9i to 10g, installed patches

* Installed oracle, patches, setup RMAN using Veritas Netbackup

* Moved partitions to read only tablespaces

* Created tables, indexes, ER diagrams

* Wrote XSL code to filter XML data

* Exported Mysql data to import into oracle, created Sql Server databases

* Created procedures for backing up and restoring Sql Server databases

* Created and modified plsql packages/procedures/functions

* Created shell script for monitoring database and applications.

MS Access DBA

June 2004 - February 2005

JHBaxter San Mateo, CA

* Development project to convert from Legacy system to Access and Vantage.

* Extract and convert data from Excel to MS Access.

* Create reports using Access and Crystal.

* Create and Modify Crystal reports in Vantage ERP Software.

* Wrote shell scripts for loading Journal entries into Progress db.

* Create rules in Vantage Product Configurator, modified forms, reports.

Senior Oracle DBA

January 2004 - May 2004

Akamai Redwood City, CA

* Oracle 8i/9i DBA on Redhat Linux and SUN

* Project to convert databases from SUN to Linux.

* Install Oracle, create databases, export/import users

* Installed and configured Weblogic

* Setup Apache, Netscape LDAP

* Installed DB2 on Redhat Linux, created db2 database, tablespaces, tables

Senior Oracle DBA/Developer

April 2003 - November 2003

PalmSource Sunnyvale, CA

* Oracle 8i DBA on SUN for Filemaker to Oracle conversion project.

* Wrote Pl/sql code to transform data from filemaker to oracle.

* Implemented logical and physical database architecture.

* Planned, developed and implemented Backup/Recovery.

* Created reports of bad data for analysis.

Lead Oracle DBA

June 2002 - January 2003

IPUnity.com Milpitas, CA

* Primary 9i DBA on SUN, installed oracle, created databases.

* Wrote shell scripts, perl scripts, Pro*c and OCI programs.

* Installed replication, setup fail-over and process daemon, configured TAF.

* Created shell script to restore from hotbackup.

* Documented perl install script, procedures.

* Performed Oracle DBA training.

* Created test plans, performed load tests.

Senior Oracle DBA

September 2001 - March 2002

Artizen San Carlos, CA

* Primary Oracle8i DBA on NT.

* Setup standby database on NT.

* Create dos batch scripts to maintain standby database, start db, stop db.

* Install Oracle, create database, document procedures.

* Install Veritas Backup on NT. Tested restores of hot-backup and cold-backup.

* Create hot-backup and cold-backup jobs to tape.

Senior Oracle DBA

January 2001 - June 2001

Kaiser Permanente Walnut Creek/CA

* Oracle8i (8.1.6) DBA on IBM RS/6000 for Call Center application.

* Migrated large databases( 75G to 500G ) from 7.3.4 to 8.1.6.

* Installed Oracle, created databases, created unix shell scripts.

* Created procedures, analyzed tables, indexes.

* documented procedures, processes, scripts.

* Export/Import of database,tables, users.

* Assisted other DBA with purge of large tables.

TECHNICAL AREAS

Oracle Skills:

ORACLE RDBMS (9i,10g, 11g) Oracle RAC/ASM

Sym Replication SQL*Plus,PL/SQL, Dataguard

SQL*Reports Oracle App Server

Discover 2000 Materialized Views

SQL*Forms 3.0, 4.0 Pro*C

Spatial Data Oracle WebServer

Oracle Financials Oracle Webdb (Portal)

Hardware:

SUN HP

DEC IBM

NT Server, MAC RS/6000

Operating Systems:

Unix Solaris 10

Windows NT Linux x86, Redhat 2.0

HP-UX 10 VAX

MS-DOS AIX Power 6

Software:

SAP ECC6, Netweaver 7.31, BI, CRM, DM, GTS, Portal, Virsa, PI

Oracle, Sql Server 2008, Mysql, DB2 Unix shell scripts

Informatica 7.2 perl5, OCI

Apache, Tomcat, IIS Weblogic 8.1, Filemaker 5.5

MS Access, Progress db MS Excel, C, C++

Strongmail Various High Level Languages

BMC Sql Backtrack Crystal Reports

Quest Spotlight, Vantage ERP

EDUCATION

California State University Sacramento

Bachelor Degree in Computer Science

CLASSES ATTENDED

Database Administration I, ORACLE

Database Administration II, ORACLE

ORACLE Forms 3.0, ORACLE Forms 4.0

Access 2.0, Excel 4.0,5.0

Advanced HTML Design

Informatica Development I

NOCOUG Member

Contact this candidate