Project Manager Sql Server

Eric Gray

**** ****** **., ******* ****, CA *****

707-***-**** / ******@*******.***

DATABASE ARCHITECT

Data Modeler SQL Server PostgreSQL Oracle DBA System Analyst Project Manager

I am Software Engineer with extensive experience designing, developing, and administering database

systems in Microsoft SQL Server, PostgreSQL, and Oracle. Expert at relational data modeling, SQL,

stored procedures, performance tuning, ETL processes, and scientific and business system analysis. I also

have experience in project management and agile methodologies.

PROFESSIONAL HIGHLIGHTS

• Database Architect – 15 years designing and building relational database systems for clients in

business, industrial, and scientific enterprises. Excellent communication skills developed working

with clients in the system analysis, data modeling, and quality control phases of database

development.

• Database Developer and Administrator – Designed, developed, and managed the Environmental

Protection Agency’s (EPA) AIRNow database (airnow.gov, airnowtech.org). AIRNow is a large scale

real time nationwide database of air quality and meteorological data for analysis and web site display.

• System Analyst – Consulting for Bay Area businesses over 10 years. Created applications for wine

and newspaper inventory management, payroll systems, accounts receivable systems, building

contract estimating, technical equipment support, medical patient records, and legal document management.

EXPERIENCE

BI ETL Specialist American AgCredit, Santa Rosa, CA 2013 – Current

• Designed new Extract Transform Load (ETL) system integrating data from offsite hosted loan

originating and processing systems. Built a code generator that produces thousands of lines of SQL to

populate a relational Operational Data Store (ODS) and a Dimensional Data Warehouse.

• Developed hardware and software specifications to meet system performance requirements and

Service Level Agreements (SLA). Performance tune complex SQL queries to meet rigid bank

processing deadlines.

• Using highly responsive high speed SQL Server technologies such as columnstore indexes, in-

memory tabular data models, and SQL analytical query extensions.

Senior Database Architect Sonoma Technology, Inc., Petaluma, CA 2000 – 2013

• Created the Environmental Protection Agency’s (EPA) AIRNow Oracle/SQL Server databases.

The system processes and forecasts air quality information for the USA, Canada, and Mexico.

• Created and project managed SQL Server and PostgreSQL air quality, meteorological, and fire

weather database systems for multiple US state agencies, Mexico, and Shanghai, China.

• Created a large scale Oracle Data Warehouse for quality control and data analysis of air quality

and meteorological data.

• Project managed the EPA Data Exchange Network Node at STI which processes complex state

agency XML data into AIRNow.

• Trained STI staff in database management and SQL programming.

Database Architect ESPC Inc. (Lawgic.com), Novato, CA 1999 - 2000

Created the SQL Server Database and Mid-Tier architecture for Web/Applet based Java application.

Application produced a variety of Legal and HR documents from an Expert Systems backend engine.

Software Engineering Consultant Bio-Rad, Hercules, CA 1996 - 1999

Designed and developed database and C++ applications for Bio-Rad Chromatography Systems.

Software Engineering Manager HealthVision, Santa Rosa, CA 1994 - 1996

• Project manager for Physician Assistant System to automate and classify clinical notes.

• Designed Hospital SQL Server decision Support systems to monitor patient records for errors.

• Designed and wrote knowledge base editors and parsers for medical professionals to analyze clinical

notes.

Lead Programmer Project Data Systems, Novato, CA 1993 - 1994

• Designed C++ Object hierarchy for company’s US Government (HUD) applications.

• Designed database architecture for above applications.

• Provided staff training in C++ and Object Oriented Programming techniques.

Software Engineering Consultant Park & Gray, Santa Rosa, CA 1989 – 1993

Park & Gray Software Services designed and developed 25 projects over 5 years. Our applications ranged

from Accounting to Wine Inventory. A client short list is provided below:

• The Press Democrat, Santa Rosa, CA: Equipment Inventory and Maintenance system.

• Parker Hannifin, Compumotor, Rohnert Park, CA: Technical Support Tracking System.

• City of Calistoga, CA: Purchase Order System.

• Cartesian Systems, Petaluma, CA: Scientific Instrument Control C++ applications.

SKILLS

Expert in relational data modeling and design, development, and performance tuning.

Expert in SQL programming, debugging, execution plan analysis, and database server optimization.

Experienced in System Analysis, software development processes, and project management.

Developed databases in Microsoft SQL Server (2005-2012), PostgreSQL (9.x), and Oracle (10g).

Current experience in Microsoft SQL Server SSRS, SSIS, and Altova’s MapForce

Excellent communication skills with staff and clients in scientific and business projects.

Experience in writing proposals, requirements, and specification documents.

Application programming experience in C++, Java, C#, .NET, and XML.

EDUCATION

• B.S., Computer Science, Sonoma State University

• Software Project Management Certificate, UC Berkeley Extension

Contact this candidate