TECHNICAL SKILLS:

Oracle Skills: ORACLE RDBMS (10g, 11g) Oracle RAC/ASM Sym Replication SQL*Plus,PL/SQL SQL*Reports Oracle App Server Discover 2000 Materialized Views SQL*Forms 3.0, 4.0 Pro*C Hardware AIX HP SUN

Operating Systems: Unix AIX Windows Linux x86, Redhat 2.0 HP - UX 10 VAX MS-DOS AIX Power 6,7

Software: SAP ECC6, HANA, Netweaver 7.5, BI, CRM, DM, GTS, Portal, Virsa, PI, BOBJ Oracle, DB2, SqlServer, Mysql, DB2, Unix shell scripts, sybase Informatica 7.2 perl5, OCI Apache, Filemaker 5.5 MS Access, Progress db MS Excel, C, C++ Various High Level Languages BMC Sql Backtrack Crystal Reports

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA/DB2 DBA/SAP Basis Admin Consultant

Confidential, San Francisco, CA

Responsibilities:

• SAP Project Lead at Confidential in Cloud Managed Service Delivery group
• Activated Search in DB2 databases. Backed up and restored DB2.
• Backed up Oracle Databases.
• Monitored Oracle databases for SAP systems.
• Wrote shell scripts to grant access to user tables
• Monitored DB2 databases, troubleshoot DB2 and SAP user access errors.
• Supported SAP systems including BOBJ, Data Services, ECC6, BW on Oracle and Hana Live databases
• Backed up and restored Hana databases. Upgraded Hana databases.
• Performed BW migration import from oracle to Hana. Installed BPC add - on.
• Upgraded BOBJ and Design Studio. Configured audit on BOBJ and Design Studio
• Installed Hana database components using Lifecycle Manager, command line and Hana Studio
• Performed Hana database security.
• Modified Hana database memory settings using Hana Studio
• Configured CTS+ using domain links
• Created OSS messages to troubleshoot SAP issues
• Wrote shell scripts to monitor production and development systems.
• Documented processes and procedures.
• AIX/Unix administration tasks (smitty)

Senior Oracle DBA/SAP Basis Admin Consultant

Confidential, San Francisco, CA

Responsibilities:

• 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

Confidential, Fremont, CA

Responsibilities:

• 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/SAP Basis Admin

Confidential, San Jose, CA

Responsibilities:

• 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

Confidential, San Mateo, CA

Responsibilities:

• Oracle 10g DBA for 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 Setup Streams and standby databases 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.