ERIN A. ONEILL
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
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.
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 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