Objective

Talented, results-driven DBA with versatile, cross-platform experience in database architecture, installation, implementation, integration, development, deployment, and administration in local and remote environments for diverse client industries. Able to guide motivated, top-performing development and production support teams in the administration, installation, training, and support of database server hardware and software.

Skills Summary

• Operating Systems: AIX 5.2, Sun Solaris 9, RedHat, SuSe, Windows NT/2000/2003/XP
• Software: DB2 8 - 9.7, MySql 5, Sybase 12.5, Sybase IQ, Oracle 10g, MS SQL Server 7/2000, MS Access 97/2003, AS400/UDB, Perl, Korn Shell, VB/VBA, SQL/TSQL/PLSQL, Java 2, Eclipse 2.0, XML/XSLT, Visio, Embarcadero, Erwin, QuestCentral for DB2

Work Experience

Confidential
Nov. 2009 - Present Oakland, CA

The Office of the President is the system-wide headquarters of the University of California, managing its fiscal and business operations and supporting the academic and research missions across its campuses, labs and medical centers

DBA, IR & C

• Lead DB2/MySQL DBA for company 24/7 databases.
• Integrated expert level solutions while collaborating with developers on new APPLY UC OLTP and UC DATA WAREHOUSE databases.
• Recommended and implemented improvements in database auditing, monitoring.
• Designed and developed DB2 HADR systems.
• Migrated non-partitioned DB2 databases to multi-server/partitioned DB2 DPF cluster.
• Provided timely response and resolution to system critical events.

Confidential
Jan. 2007 - Nov. 2009 Pleasanton, CA

Global provider of enterprise-class software and on demand solutions for content archiving and electronic discovery. ZANTAZ solutions enable organizations to cost-effectively manage electronic document and messaging resources, fully comply with industry regulations and proactively manage complex litigation and discovery requests.

Sr. Database Administrator, Operations

• DBA for 30 production DB2 and MS Sql Server 24/7 environments.
• Developed complete migration process from non-unicode to unicode database.
• Defined and developed system to monitor database performance and capacity.
• Led engineering team in database application development.

Confidential
Mar. 2005 - Jan. 2007 San Mateo - Redwood Shores, CA

The world's leading provider of eBusiness and OnDemand application software. Siebel Systems/Oracle provided an integrated family of CRM application software enabling multi-channel sales, marketing and customer service systems to be deployed over the web, call centers, field service, field sales, reseller channels, retail and dealer markets.

Senior DB2 DBA, OnDemand Hosting Operations

• Production DB2 DBA for company 24/7 CRM OnDemand environments.
• Provided expert level solutions to improve performance for OLTP (3TB) /OLAP databases with more than 30000 OnDemand users.
• Recommended and implemented improvements in backup/restore and HA systems.
• Provided timely response and resolution to system critical events.
• Designed and developed sanitization application for scrabbling sensitive customer information before database is transferred to engineers and testing.
• Responsible for DB2/AIX/Linux/Solaris database application server set up and deployment for company largest customers and partners.
• Defined and generated key baseline metrics with which to monitor and report capacity and system performance.
• Implemented and scheduled in-house database monitoring and alert scripts using Korn shell and Perl.
• Assisted other members of the team in administration and configuration of Web Application Server, LDAP and Analytics Web.
• Participated in on-call rotation with support of 99.9% service availability across all environments.

Confidential
Nov. 2004 - Mar. 2005 Concord, CA

Confidential is a well-established dental insurance company with member base of approximately 7,000,000 across all states.

DBA, Development

• Built new provider database with primary responsibility for logical and physical design, implementation and support.
• Participated in defining corporate architectures and information strategy, including clustering and distributed service architectures.
• Developed data integration system between AS400/UDB, DB2 and MS SQL SERVER.
• Implemented complete ETL process for nightly data migration.
• Tuned SQL queries to improve data reporting performance.

Confidential
Jun. 1999 - Nov. 2004 Emeryville, CA

As a part of Neurology Department of UCSF, EGCRC specialized in neuroscience and studies the effect of alcohol on the brain and genetic system. EGCRC's databases are well-known sources of genealogy and genetics information for scientists and researchers around the world.

Database Administrator

• Development and administration of clinical and genetic DB2 and MS SQL SERVER databases including logical/physical design, coding stored procedures, triggers, UDFs, data migration, maintenance and alert systems, tuning and troubleshooting.
• Researched, recommended and implemented solutions to assist in system performance.
• Managed database security, availability, and integrity.
• Participated in evaluation, deployment and database related support for application development teams.
• Leaded planning, design, and usage of data resources for output and reporting capabilities.

Education

Confidential