Experience

San Diego Data Processing Corporation

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• DBA

  • Sep 2007 - Present

• DBA

  • Sep 2007 - Present

  • SAP application support including ECC 6.04, CRM 7, BW 7.01, CE, Enterprise Portal, GRC AC, GRC PC, PI/XI 7.11, & Solution Manager on over 19 Prod & QA Windows Clusters and over 50 Prod, QA, Dev & Training VMs using over 150TB of Storage on SQL Server 2005/2008.• NetApp SnapManager 5x, Snapdrive 6x, SnapVault SQL Server, TSM & TDP used for backup & recovery for above.• Support SAP EAM Oracle on UNIX• SQL Server and Oracle performance & tuning, capacity planning• SQL Server database monitoring using Spotlight• Oracle database monitoring using Grid Control• VMware - Support vCenter upgrade for 4.0 to 4.1. Migrated vCenter from physical Win2003 Server to Win2008 VM, initial vCenter database create. vCenter backup & recovery.• Oracle software installation and patching on UNIX and Windows platforms• Work with customers and developers tuning SQL to improve performance.• Write UNIX Korn shell scripts & Windows command scripts to automate backup & recovery, database instance creation, RMAN script and database registration, etc.• Write PL/SQL database triggers, functions and procedures in support of in-house developed applications. Show less



Golden Hour Data Systems

• San Diego, CA

• Senior DBA

  • Aug 2006 - Sep 2007

  • Install and configure Oracle 10gR2 database on RedHat Linux • Install and configure Oracle 10gR2 Standby database • Migrate current production 9i to 10g for new application rollout • Test and document Failover/Failback process • Train Systems Engineers to perform Failover/Failback process • Write UNIX scripts to ship and apply logs • Develop and document Oracle instillation process and naming conventions • Document current database landscape and backup schedule • Develop, implement and document baseline database monitoring using DBControl • Configure test DR sandbox to develop, document, test DR process • Train staff using above documentation • Provide management with current production ER plot • Provide sql support to development staff • Responsible for ongoing database support Show less



Elan Pharmaceuticals, Inc.

• Greater San Diego Area

• Senior DBA

  • Dec 2003 - Jul 2006

  • Review and apply Quarterly Oracle Security Patches • Write, execute and review IQs for Database and Data Mart data warehouse database installs on validated systems. • Technical lead for 10g Grid Control R2 Installation. Configure, maintain Oracle 10.2 Oracle Management Server (OMS) and 10.2 & OEM Repository. • Deploy and maintain Oracle (Grid) agent on multiple platforms • Support internal and external customers on multiple applications running on over 90 Oracle 7x, 8x, 9x & 10x databases in production, certification, testing & training environments. Databases are on HP/UX & Windows platforms. • Work with customers and developers tuning SQL to improve performance. Reduced runtime of a customer written query from 35 minutes to less that 2 min. • Support for Data warehouse • Write UNIX Korn shell scripts & Windows command scripts to automate backup & recovery, database instance creation, RMAN script and database registration, etc. • Maintain & patch Oracle Applications Release 11.0. • Technical lead for OEM Installation. Configure, maintain & upgrade Oracle 9i Oracle Enterprise Manager (OEM) & OEM Repository. • Administer OEM via Super User • Technical lead for RMAN Installation. Configure, maintain & upgrade Oracle 9i RMAN interfacing with Veritas Netbackup v4.5. • Install, configure & implement Oracle network software (listener, LDAP w/OID). • Write PL/SQL database triggers, functions and procedures in support of in-house developed applications. • Maintain ISO900 Work Instructions Show less



Information Associates

• Programer/Analyst

  • 1979 - 1982