ERIN A. O’NEILL
geek@eonarts.com

Keywords
Oracle 8.x, Database hardware analysis, database installation & configuration, Hardware analysis for database, database design, database re-creation with Perl & shell scripts, Function and Design specifications, Documentation, Test Plans, Perl, SQL Loader, SQL Plus, Bourne shell programming, Oracle installation and configuration, Solaris, MySQL, CVS, Java, Apache.

December 2003 - Present 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.
• Installed and configured security tools such as mod_ssl, openssl and Stanford's Webauth.
• Wrote UNIX scripts to do regular backups and space management.

2003 - present www.bapc.info, San Francisco, CA
Web Engineer

• Updated web pages

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

• Migrated Oracle database 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.

• 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 Q&A 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