October 2005-Present – PodShow/Mevio, Inc, San Francisco, CA
Senior Database Achitect and Administrator

• Database and table analysis that led to schema, query, and data type change recommendations. Many of the recommendations were able to be immediately implemented for more improvement in the speed and stability of the databases.
• MySQL Server tuning for MySQL 4.1, 5.0 Servers. This keeps production MySQL servers running smoothly and dependably.
• Analysis of database stats for signs of problems so that new slow queries can be fixed.
• Worked closely with engineers so that they could create more robust database queries and tables.
• Created scripts to back up the MySQL database.

Manager of Production systems

• Worked closely with Rackspace to have our UNIX systems set up optimally for a dynamic website that is database driven.
• Managed IT personal for the local network and desktops.
• Oncall 24/7 to help pull systems out of crisis, add more servers and get the website back up.
• May 2005- October 2005 - Signatures Network, San Francisco, CA

Database Analyst

• MySQL Server tuning for a MySQL 4.0 and 4.1 Servers. Production MySQL server began to run noticeably faster.
• Linux Redhat Fedora Core 3 kernel configuration tweaking so that the MySQL server could run with more than 1024 open files and more procs.
• Database security analysis that lead to running the MySQL server in a more secure state and implementing various users and passwords with different sets of privileges.
• Database and table analysis that led to schema, query, and data type change recommendations. Many of the recommendations were able to be immediately implemented for more improvement in the speed and stability of the databases.
• Daily Analysis of database stats. This was often the first sign that the web servers and databases were in trouble.
• Misc. Linux System Administration tasks.
• Documentation on tuning a MySQL server and Linux kernel for a database server (implemented in a wiki).

2004 - 2005
Freelance Web and Database Developer

• Tatu.com: php and javascript demo website.
• Tatu.com:  Black box QA for online learning software, including filling out bug reports in Bugzilla.
• Photography website (bapc.info): Modified perl cgi scripts for easier maintenance, html production,created animated gifs from jpegs QA for the site.

December 2003 - August 2004 Media Solutions at Stanford University, Palo Alto, CA
System Consultant

• Analyzed security logging: Checked logs daily, added a logwatch script to report suspicious errors, installed a more secure FTP client/server, increased logging to accommodate system needs, cleaned up old user logins and changed passwords as needed.
• Installed and configured Apache Webserver, Tomcat and MySQL for dynamic web pages.
• Organized CVS including the creation of modules, developing processes for a build and starting the use of tags.
• Customized Bugzilla and set up to work with CVS for bug tracking for developers and project management.
• Installed Solaris OS onto two Firesun servers and migrated websites to new servers.
• Analyzed security requirements and trained staff in security.
• Installed and configured security tools such as mod_ssl, openssl and Stanford's Webauth.
• Wrote UNIX scripts to do regular backups and space management.

September 2002 - May 2003 IDG, San Mateo, CA
Database Consultant

• Migrated Oracle database containing millions of magazine pages of all technical publications from one Solaris machine to another one with a disk array.
• Tuned production database and new database.
• Analyzed hardware requirements, from basic necessities to the ideal.
• Configured Solaris for the Oracle database installation, which included determining optimal kernel parameters, setting up swap space, and disks formation. This was done for both the legacy production database and the new optimal one.
• Wrote UNIX scripts to do regular backups and space management of the Oracle database.
• Created a data model of a new web registration system for MySQL.
• Documented all the aspects of the Oracle database for the IT and Engineering group.

April 2001 - August 2001 Kaiser, Walnut Creek, CA
Software Engineer

• Created Java classes for reading multiple configuration files into a HashMap. extending the Exception class, writing to log files.
• Organized CVS including the creation of modules, developing processes for a build and starting the use of tags.
• Installed and configured Bugzilla and MySQL.
• Wrote shell scripts to back up the MySQL database, create nightly javadocs.
• Documented the software system and created a website for the documentation.
• Analyzed and constructed an engineer test suite.

July 1998 - May 2000 Macromedia/Andromedia, San Francisco, CA
Lead Database Software Engineer

• Involved in all aspects of software development from alpha to release. This includes but is not limited to creating original test plans, design and functional specs, creating and implementing UNIX installer and Oracle 8.x database components through to the final phases of QA and bug fixes.
• Created Perl scripts to install the Oracle configuration for the LikeMinds product, including user setup, tablespace, tables, indexes, and loading ASCII files into tables using SQL Loader.
• Modified the Oracle configuration for LikeMinds for better performance and to make it Y2K compliant.
• Wrote Bourne shell and Perl scripts to install the UNIX version of LikeMinds.
• Tested the Oracle database setup for performance, which included kernel parameters for the Solaris OS, Oracle tables, indexes, and tablespaces.
• Analyzed hardware requirements, from basic necessities to the ideal.
• Configured Solaris for the LikeMinds Oracle database installation, which included determining optimal kernel parameters, setting up swap space, and formatting disks.
• Installed Oracle 8.x for the engineers, QA engineers, and performance engineers on Solaris machines (approximately ten Solaris machines).
• Modified DOS scripts to install a Microsoft SQL Server configuration for LikeMinds.

Lead Build and Release Engineer

• Maintained CVS branches for the Aria and LikeMinds products.
• Set up build and release procedures; trained new build and release engineers.
• Built and released Aria and LikeMinds; always met build and release schedules.
• Modified and maintained Bourne shell scripts to automatically build Aria and LikeMinds.

Feb 1996 - May 1998 N/Volve, San Mateo, CA
Senior UNIX System Administrator and Webmaster

• Created Bourne shell and Perl scripts to manage daily tasks such as initializing and starting Web servers, running security checks, backing up scripts with Networker, and truncating log files.
• Wrote and implemented Oracle backup scripts for both cold and hot backups.
• Maintained and organized DNS.
• Debugged, modified, and assisted with QA on Java classes.
• Created CGI scripts to help the producers manage the Web servers.
• Installed, configured, and maintained six Web servers, including JavaWebserver, Netscape Commerce Server, and Apache Webserver.
• Implemented and maintained software firewall with various scripting security checks.

Sep 1989 – Feb 1996 Smith-Kettlewell Eye Research Institute, San Francisco, CA
System Administrator

• Migrated the Institutes networking needs off of an old outdated Server onto a new Sun UNIX Server.
• Resolved network and security issues. Configured and setup two Sun UNIX Servers.
• One server as the main Institute Server, the other was a central application server for matlab and other biomedical software.
• Administered and provided technical support for all systems, hardware and applications.
• Designed a database clinical research project.
• Wrote a bi-monthly computer column for the company newsletter.

EDUCATION

• IOUG (International Oracle Users Group) Master class in database administration, Las Vegas, NV. 1999
• IOUG Conference. University seminar for database administrators. Sessions covered PL/SQL (procedures, functions, packages, and triggers), data dictionaries, performance turning, index tuning, analyzing schemas, and Oracle file configuration management, Denver, CO. 1999
• City College of San Francisco, San Francisco. Course work: C++, C, Fortran, Telecommunications, Assembly for IBM, Assembly for PC, PC Graphics.
• UC Berkeley Extension, San Francisco. Course work: algebra and trigonometry.

Bachelor of Arts, San Jose State University, San Jose, CA