David W. Clary, Database Administrator

David W. Clary
14235 E. Burnside
Portland, OR, 97233
(503) 278-0610
E: clary.david@gmail.com
LI: www.linkedin.com/in/dbadavidwclary

Technical Overview

Database Administration: 10+ years administering MS SQL Server (7, 2000, 2005, 2008, 2008R2, 20012, Azure). Skilled in native and third-party backups, restores, server design and implementation. Have set up and maintained log-shipping, transactional replication, database mirroring, SSAS cubes, SSRS reporting solutions and traditional vanilla SQL Server installations across a variety of platforms, physical and virtual. Expert in index tuning, data cleansing, and disaster recovery.

SQL Development: 12+ years programming in SQL and other database-query variants, including SQL Server, MySQL, Access, and LINQ. Database design, schema and architecture. Capacity planning, error handling, and scalability. Praised for performance tuning, troubleshooting, debugging/refactoring existing code. Adept at SSIS/ETL package design/development.

Web Development: 10+ years designing, programming websites with ASP.NET, C# and JavaScript.

Career History

Papa Murphy’s International, 2/2015-current, BI Developer/DBA

Managed teams of contractors to build out database systems and applications. Responsible for troubleshooting data and integration-related problems in PMI reporting stack. Designed SSIS packages for new integrations, including integrations between NCR POS systems and UltiPro HRMS. Developed SSRS reports, Tabular Model analysis cubes, and database schemas. Worked with leadership to develop a roadmap for BI for future growth and stability.

Tommy Bahama, 11/2014-1/2015, Database Administrator

Designed and implemented disaster recovery plan for a production server with third-party replication subscriptions, 3 terabytes of data and using a combination of log-shipping and custom code, improving our Recovery Time Objective from ~1 day to 15 minutes. Supported over 200 databases on 24 SQL Servers from 2000 to 2008R2 in production, development and training environments.

Picked up and absorbed most critical knowledge required to support entire IT team while other DBAs were on vacation in three weeks.

Energy Trust of Oregon, 4/2012-10/2014, Senior Database Administrator

Successfully built SSIS-based ETL packages for the import of raw utility usage data from Oregon’s four largest gas and electricity providers, integrating it into a normalized data structure. Challenges included bad data, duplicates, missing data and inconsistent flow.

Provided DBA support for a migration from Goldmine to MS Dynamics CRM, and then led an effort to refactor and tune entire company’s SQL code base, resulting in 80-85% performance increases, and resolving timeout issues plaguing our primary business application.

Upgraded 2008R2 servers to 2012. Built out Dynamics Great Plains server. Implemented transactional replication of three production databases to a secondary server for reporting purposes, resulting in fewer deadlocks and faster report query speeds.

Assisted BI team in migration from Business Objects to SQL 2012 SSAS, including writing stored procedures, SSIS packages, and working with project managers to track down and identify problems in migration code.

Genesis Information Systems, 2013-2014, Database Administrator

This is one of my highlights of 2013. Along with a small team of developers, I helped the state of Arkansas implement a portion of the Affordable Care Act, helping state workers and private individuals offer health insurance to the residents of the state, with the majority of the work being done on SQL 2008R2. A significant challenge involved not having any access to the production server at all – this forced me to write robust code that would run successfully in a black box, or roll back and return specific error messages indicating why it didn’t. The truest measure of our success: of all the states people heard of during this period whose integrations failed spectacularly, ours was not one of them.

Adecco, VanderHouwen, 2010-2012, Data Analyst

First at Adecco, then at VanderHouwen, contracted with various companies in the Portland, Oregon area, providing T-SQL coding expertise. The most difficult was a large legal services firm, where I worked with an e-discovery team to import, cleanse and transform large lists of customer data into manageable, normalized mailing lists.

VisionOne, 2008-2010, Senior Project Lead

As the project lead for Vision One, I acted as the web architect, developer, and database administrator for BevMo! – both their ecommerce and their store management backend — and Safeguard Banks’ B2B website. Using ASP.NET and C# backend for BevMo, I worked with their ecommerce team to add pages, make seasonal changes to layouts, and performed data analysis when inventory or other data errors occurred. Led (and successfully achieved) CISP and PCI compliance audit efforts. Winner of the 2009 VisionOne chili cook-off.

B3 Corp, 2004-2006, Database Administrator
Duties primarily revolved around maintenance of clustered, mirrored SQL 2000 database and log-shipped backup cluster. TSYS integration with Wells Fargo and Bank of America. Stored procedure tuning, bottleneck discovery/repair, planning, and troubleshooting SAN and other database hardware.

Ceiva Logic, 2002-2004, Database Administrator/Senior Developer
Responsible for day-to-day maintenance of high-use database, including regular backups, establishing production release policies, data architecture/design, analysis and redesign of existing code where necessary. Created/maintained web-based reporting tool, and several web-based applications for interacting with the database. Fully integrated FedEx shipping API into database through web tools, for automated shipping requests through our online store.