Ms. A. Elein Mustain
elein@varlena.com
510-637-9106

Objectives
----------
Database Architect:  Design and maintain database schemas working with engineering.  This includes primary support for SQL and stored procedures, support for DBA, engineers, marketing, analytics and reporting.  I am flexible and able to do database analytics and other tasks to do what is necessary to keep a database running smoothly.  I am interested in project management and management of development teams as well.

Experience
----------

More than 20 years working in the database industry working with Relational Database Systems.  Thorough knowledge of Relational Theory and Object Relational databases. Additional experience includes application development tools and reporting.

SQL, PL/SQL, postgreSQL stored procedures, e.g. plpgsql, plython, plperl, bash, *nix, C, perl, python

Principle experience is with PostgreSQL, although I easily work with other databases. I have worked for Ingres, Illustra and Informix database companies. I have experience with Oracle and Sybase and MySQL. 

I've worked with complete product lifecycles of large (databases) and small (reporting) projects and owned and managed my own contracting business.

Have recently trained with PMI instruction working toward Certification in Project Management (PMP).  I have completed the Pre-Certification tests. Also recebt training includes completion of Pre-Certification for Oracle PL/SQL Developer Certified Associate. 


Current & Recent Projects
-------------------------

* Database Engineer at Pandora Media, Inc. Pandora.com 2007-2010

Responsible for Reporting for Marketing, Business Development and Senior Staff, Senior staff relied on my daily reports to make pertinent business decisions. Critically important music royalties reports created and transferred.  Complex mass marketing email data constructed.  Business Development reports on vendors and devices created.  Others reports as needed. General SQL, and server side functions in various languages. Part of DBA team. Worked with Apache Hadoop Hive report generation and queries.

* Varlena, LLC (2003-2007)

Provided multi-national clients with needed PostgreSQL expertise and database design, including short questions and large projects.  Provided DBA and design support for PostgreSQL databases. Clients included Safeway (via NCR), BzzAgent, WilyTech, SCHARP, NOAA, Pandora and many others.

Author of PostgreSQL General Bits, a column about PostgreSQL--wrote weekly articles for 3+ years. http://www.varlena.com/GeneralBits/  The blog is not currently active but is still indexed and referenced in PostgreSQL help forums.

* Snapfish (2003-2003)
	
Manager of software engineering.  Coordinated with QA, Database Group, Release Process for major release.  Crystal Reports.

* Active with the PostgreSQL Advocacy group.

Program committee member for O'Reilly OSCON convention for 3 years. Vetted proposals and tutorials. Present in PostgreSQL booth at many conferences to answer questions and make suggestions. Member of SF PostgreSQL User Group.

* Open Source Report Writer called "ere" (artistic license, consulting required)

Varlena, LLC which provides training, support and consulting. Clients included Safeway, BzzAgent, WilyTech, SCHARP, NOAA and many others. Services include training, configuration and query tuning, database design.  http://www.varlena.com/Reports/

* Illustra Information Systems and Informix Software (1993-2000)

Gateways: Developed Sybase Gateway, 

Client tools: Research & design on Schema Browser tools. 

Technical Manager and Lead for the Server Side C-API for Informix IUS.
  
Managed team of 7 people and managed the team to develop the C-API. The team for the C-API included people in remote locations.  This API was the only method to create stored procedures at the time.  DataBlade groups depended on support from the C-API.

* Nextbus Information Systems (2000-2002)

Database Engineering Manager, Database Architect.  Brought file based storage into PostgreSQL and engineered access to metadata. Introduced reporting engine and system (later called ere) to produce complex reports for bus agencies.  Managed a team of 2 database experts.

* Ingres (Relational Technology Inc. and ASK Computers) (1988-1993)

Reporting Tools: Reworked character based reporting tools to add features and fix bugs.

Technical Manager, Reporting Tools Architect: Designed next generation of report engine based on Windows4GL.

* Earlier experience is available if required.

Education
---------
  University of California at Berkeley, A.B. Computer Science, 1981
  Mills College, Math & Computer Science, 1977-1979

Publications
---------------------------
Introducing Slony-I: http://onlamp.com/pub/a/onlamp/2004/11/18/slony.html
Building and Configuring Slony-I: http://onlamp.com/pub/a/onlamp/2004/12/16/slony_install.html
Modifying Slony-I Clusters: http://onlamp.com/pub/a/onlamp/2005/03/17/slony_changes.html 
General Bits: http://www.varlena.com/GeneralBits

Speaking Engagements
---------------------------

* IV Foro Mundial de Conocimiento Libre, Maturin, Venezuela 
  Introduction to PostgreSQL October 2006
* O'Reilly Open Source Conference, Portland, OR
  Tutorial: Introduction to PostgreSQL July 24-28, 2006
* O'Reilly Open Source Conference, Portland, OR
  TimeTravel in PostgreSQL July 24-28, 2006
* O'Reilly Open Source Conference, Portland, OR
  Tutorial: Introduction to PostgreSQL Aug 1-5, 2005
* O'Reilly Open Source Conference, Portland, OR
  Tutorial: Introduction to PostgreSQL July 26-30, 2004
* Roseville Linux User Group
  Talk: Overview of PostgreSQL June 28, 2004
* Netherlands Unix User Group (NLUUG)Open Source in Business
  Talk: PostgreSQL in Business May, 2004