Technical Skills:
Oracle 7/8i/9i/10g, SQL, PL/SQL, Perl,
Bash, ksh, JavaScript, JQuery, SAS, Java, C, Linux, FreeBSD, Solaris,
VMS.
Experience:
Database Administrator:
Amazon.com,
November
2004 - Present
Responsibilities:
- Manage 10g dataguard database ~300Gb
- Provide design documents, timelines, data model and workflow
specifications.
- Project lead in database monitoring, intranet reporting, SOX
monitoring and configuration tools.
- SOX reporting- maintain yearly verification and provide early
alerts on violations
- Provide DBA assistance where needed.
- Provide database backup and recovery tools support.
Perl developer/Database
specialist:
CDI,
July 2004 – Novermber 2004
Projects: Western Wireless:
- Design and document processes for customer tracking and reporting
system.
- Develop object oriented Perl scripts to upload disparate data to
Oracle system.
- Develop an automated reporting system for database integrity.
- Document all procedures and programs.
- Program bash, ksh and crontab scripts to perform various
automated processes.
Database Administrator :
VNU Publitec Amsterdam Netherlands ,
8/2001 – 6/2004
Responsibilities:
- Manage Oracle 7.3, 8i and 9i Databases on VMS and MS Windows: OL
AP/OLTP/DSS- backups, tuning, installations, setup and migrations
- Manage maintenance of backups, using RMAN, EXP, IMP and Veritas.
- Design and implementation plans for database projects: OLTP and
DSS using power builder
- Develop Triggers, SQL scripts and PL/SQL procedures in support of
data model and internal support.
- Provide database migration plans and scripts for customer
upgrades.
- Data warehouse design and development: ETL/Dimensional Modeling.
- Database and data warehouse performance tuning.
- Technical Lead for DBA group and interim manager for IT
department.
- Perform periodic code review and provide developers with
standards for database access and recommendations of performance
issues.
- Evaluate emerging technologies and software tools.
- Manage and maintain Solaris, FreeBSD and Linux systems.
- Develop bash, DOS, Perl scripts to maintain systems and automated
installations and backups.
Database Administrator:
National Wilms Tumor Study Group (NWTSG),
1995 to 2000
Responsibilities:
- Administer/Manage the NWTSG Oracle 8/8i database: OLAP/OLTP/DSS.
- Create, design and manage on line data forms and reporting
system.
- Design and develop data warehouse: DSS/ETL
- Design, code and develop programs in Perl, SQL, PL/SQL, HTML,
Bash, SAS, Java and JavaScript.
- Produce statistical reports as necessary for data managers and
NWTSG committee members.
- Manage maintenance of backups, database integrity, software
licensing and help documentation.
- Develop and maintain instructional material for users.
- Supervise programmers, word processing and data entry staff.
- Participate in project groups to design forms, letters,
questionnaires and reports for NWTSG studies.
- Assist in budgets and grant proposals.
- Represent the "Data and Statistical Center" (DSC) at regional
meetings.
- Develop data collection and retrieval methodologies for remote
sites.
- Work with the technical support staff to maintain networks and
computer hardware.
Projects:
- Data access system: A secure report and data entry systems
allowing remote and local users access to patient data and aggregated
statistical reports. The system utilized Oracle, Linux, Apache,
OpenSSL, mod_Perl, mod_SSL, Perl, SQL, postscript, HTML, Javascript,
gnuplot and other unix utilities.
- Automated FAX and email system: An automated fax and e-mail
system to provide reporting to institutions and researchers. System
design included Oracle, Perl, Sendmail and Hylafax.
- Tracking system: A tracking system of study activities and
patients status. System utilized REXX and SAS to maintain lists,
reports and monitor progress of tracking activities. Later updated to
work in conjunction with our web site.
Mathematics Instructor :
Seattle Community Colleges
,
1992 - 1995
Responsibilities:
- Taught college level courses in mathematics and computer science
at numerous colleges in the Seattle area.
Education: Master of Science in
Mathematics, Western Washington University 1987.
Certifications: Oracle OCP 8i
References provided on request.