Douglas Nichols

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:

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.