PROFESSIONAL SUMMARY:

• 12+ years successful lead/manager experience in the web - based start up and follow-on scalability space as well as with established firms in social networking, entertainment, agriculture and packaged foods.
• 5+ years experience managing technically diverse application and data platforms and the teams supporting them
• Deep High Transaction Rate database design and optimization experience, including hardware configuration and tuning
• Deep Data Warehouse design and implementation skills
• 12+ years progressive growth as a SQL Server DBA, developer
• 12 years progressive growth as a data architect, including new data application modeling and creative re-factoring of existing applications
• Deep knowledge of SQL Server and MySQL internals and hardware configuration
• Experience with Microsoft, third party and custom built availability solutions
• 10+ years experience with MS and Cognos BI suites, including expert level SSIS, and mid level SSRS and SSAS competency
• Deep data warehouse ETL knowledge
• Able to communicate complex data layer concepts at any level
• A demonstrated passion for data layer technology, acquiring new skills and employing those skills with imaginative yet technologically sound solutions
• Experience in Software Development, Logistics, Manufacturing, Social Networking, Finance, Agriculture, Entertainment, Education and Government sectors

TECHNICAL SKILLS:

Database Platforms: MS SQL Server 2005/2008/2008 R2/2012 (Expert), MySQL 4.1- 5.5 (Expert), Oracle 8.1,11g (Familiar), DB2 (Familiar), Adabas / Natural

OS: Windows all to 2012 R2 (Expert), Linux (Fedora, Red Hat, Oracle) (Familiar), AS 400 (Exposed), IBM Mainframe

ETL: MS SSIS (Expert), EDI, DBAmp/Demand Tools/Jitterbit (Salesforce)

Programming: T-SQL (Expert)

VB Script (Familiar): Design Data Warehouse and High T-rate OLTP (Expert), .Net 3-Tier Application Design (Expert)

Tools: Erwin r8, ER/Studio, Visio

BI Tools: Cognos 11, SSAS (Intermediate), SSRS (Expert)

EXPERIENCE:

Data Services Manager

Confidential, Portland, ME

Responsibilities:

• Rebuilding and mentoring small team of DBAs and Database Developers.
• Implemented multiple marketing data marts, along with an MDM solution to reconcile marketing data sources.
• Managed the backend migration from SalesLogix to Salesforce.
• Designed and implemented numerous SQL Server / Salesforce integrations.
• Refactored and expanded the enterprise ODS, enhancing all SSIS packages for agility and robustness. Upgrading all SQL Servers to SQL Server 2012.
• Currently planning the upgrade of the global accounting platform from GP 2010 on SQL Server 2005 to GP 2015 on SQL Server 2012.
• Reviewing stored procedures and mentoring developers, focusing on performance.

Sr. Manager

Confidential, Monterey, CA

Responsibilities:

• Leading a newly established application delivery team of two managers and 15 programmer analysts.
• Completed an overhaul of legacy mainframe application programming practices, including fully documenting the 40 year old system, initiating coding standards, peer code review, weekly stand-ups to discuss and remediate bugs, and deep dives of functional areas to re-write code, including database refactoring, for efficiency, extensibility and robustness.

Consultant

Confidential, Soquel, CA

Responsibilities:

• Upgraded and optimized OLTP and Reporting SQL Server environments. Mentored on site developers in database principles and optimization.
• Recent (10/2013) upgrade from SQL Server 2008 to SQL Server 2012 Enterprise including implementation of new SQL Server features resulting in greatly enhanced performance.
• Re-factored a MySQL/Linux database back end for a web crawler application to correct concurrency and maintainability issues.
• Converted the large web-crawler MySQL 4 database to SQL Server 2005, migrating the very large search engine database into partitioned SQL Server 2005 objects and converting all database access to T-SQL stored procedures.
• Built a web-based social networking community 3-tier application using both SQL Server 2005 and MySQL 5.0. This app relied heavily on MySQL stored routines.
• Optimized an online financial application for growth and migration to SQL Server 2005. Prepared the data layer for migration to a 3-tier architecture.
• Re-factored fast growing OLTP database for conversion from 2-tier to 3-tier architecture. Optimized database objects for scalability and performance. Mentored the in-house DBA for this online micro-lending site.
• Developed and implemented BI architecture and underlying ETL for numerous Data Marts. Designed and implemented the current 2-tier ETL structure used to consolidate disparate enterprise data sources. Upgraded BI databases and ETL to SQL Server 2008 R2 from SQL Server 2000 . Designed and implement the current conformed Dimension schema replacing the old mart-specific dimension objects with a single database accessible to all data marts. Re-wrote numerous ETL procedures and re-designed underlying objects to reduce batch processing time of the Data Marts to a fraction of the previous duration.

Chief Data Architect

Confidential, Beverly Hills, CA

Responsibilities:

• Inherited an unusual, 70-server, SQL Server legacy environment utilizing “database scattering” methodology.
• Optimized, re-configured hardware, re-factored subsystems, enhanced functionality, and rolled out production code changes to enhance the serviceability of the old system.
• Next redesigned the entire data layer for migration from a 2-tier to a 3-tier .Net environment.
• Developed and implemented a unique strategy (similar to sharding) for maximizing MS SQL Server 2000 tps.
• With the application architect, developed and implemented a unique replication strategy for 100% up time.
• Implemented this new structure “in-place” and migrated the complex data model with no downtime while servicing millions of transactions per day.
• Supervised and mentored mid-level architects and DBAs of varying levels.
• Converted the high-volume ODS to SQL Server 2005 implementing partitioned tables for pivoted data.
• Converted the staging and reporting databases to SQL Server 2005 using SSIS and Reporting Services.
• Exported data to SQL Server 2005 based BI servers. Set up maintenance, disaster recovery, and high availability plans for entire data layer.

Data Architect, Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Designed and implemented several application databases in support of the Confidential Enterprise initiative.
• Consolidated over 40 disparate class schedule, contact, student information, alumni, staff, faculty and other databases into a single consolidated data structure.
• Created a unique, programmable subsystem to manage access permissions to this data across the entire enterprise and secured data against buffer-overrun and SQL injection vulnerabilities by converting access to the data layer to properly written and secured stored procedures.
• Designed a system for data transfer between the Confidential School of Business and the rest of USC using DTS and XML.
• Mentored junior DBAs, application developers, and assistants.

Data Architect, Lead DBA, Consultant

Confidential, CA

Responsibilities:

• As contractor, redesigned major subsystems of a large, complex database with few explicit relationships.
• Brought the data layer in-house from a remote hosting facility and optimized schema, re-wrote hundreds of stored procedures, and tuned hardware and DML for peak performance.
• The new production database greatly outperformed what had been experienced at the hosting facility - on inferior hardware.
• Re-designed the subscription algorithm, frame dial-up sub-system, and other major aspects of the database to increase flexibility and customer service response.
• Re-wrote stored procedures to take advantage of SQL 2000 specific functions.
• Migrated the production database to Oracle 8i.

Director, Database Management, Data Architect, Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Optimized an earlier SQL 7.0 based site as a contractor then recruited to design and implement the SQL 2000 data layer of a three tiered DNA architecture for a new portfolio management site.
• All business logic for the site resided at the data layer - requiring many hundreds of stored procedures, triggers and various Agent jobs to emulate a fast-paced stock trading environment.
• Optimized for quick delivery of data to the application layer and for maximum concurrency, the data layer was designed for unlimited scalability through the use of federated, clustered pairs of SQL Servers. Supervised and trained a junior DBA to take over day-to-day database maintenance.
• The model and data was sold to CBS Market Watch when Stockjungle closed it’s doors.

SQL Server DBA and Database Developer

Confidential, Irvine, CA

Responsibilities:

• Responsible for development and administration of all SQL Server Databases.
• Duties include consulting with client departments for development of customizing stored procedures and triggers, data integration and migration, and new SQL Server implementation and maintenance.
• Utilized several applications for developing user front ends including Cold Fusion for web based applications and VBA and Visual Basic 6 for LAN based client - server apps.
• Implemented Comshare’s Budget Plus financial package with a great deal of customization through the use of stored procedures to accomplish consolidations (roll-ups).
• Integrated Oracle8, Fox Pro and SQL Server 7 using SQL Server’s heterogeneous query functionality.
• Migrated the data warehouse from FoxPro to SQL Server. Designed Customer Service Web Portal database to support e-store and future product growth.