David Zahner

MCITP: DBA (MCDBA), CCNA, ITIL, A+

Denver, CO

SUMMARY OF QUALIFICATIONS:

Over 9 years of team management experience coupled with 14 years of

technical training and expertise focused on all aspects of SQL Server 2000

through 2012 as well as the .Net programming suite. Daily responsibilities

include hardware recommendations, query optimization, troubleshooting,

providing guidance to team members, and collaborating with technical and

non-technical teams throughout the organization.

PROFESSIONAL EXPERIENCE:

2014-Present Wipro Broomfield, CO

Senior Database Administrator

. Coordinated and executed migrations of dozens of SQL Server

instances with varying SQL Server versions from 2000 through

2012 utilizing log-shipping, virtual to virtual, physical to

virtual, and Double-Take as migration strategies with no data

loss and minimal downtime.

. Created monitoring and reporting tool using a combination of

PowerShell and SQL scripts for monitoring remote client

servers without requiring installations or customizations on

the target servers.

. Assisted in Process Improvement initiatives utilizing ITIL,

Six Sigma, and Lean methodologies.

. Trained SQL Server DBA team on troubleshooting and

optimizations as well as database corruption identification

and repair options.

2007-2014 Markit / Wall Street on Demand, Inc. Boulder, CO

Senior Database Administrator/ Developer

. Responsible for maintenance, optimization, contingency

planning, and guaranteed availability of over 1075 databases

on 95 servers up to 5 TB in size excluding the data

warehouse. The SQL Server environment accommodates maximum

batch requests per second of 9000 and daily averages of 2000

batch requests per second while maintaining less than 50ms

response times for most queries even when running against 1.1

Billion row tables/ 225 GB in data size.

. Developed a Java-based monitoring and alerting utility for

Cassandra utilizing JMX as well as an automated maintenance

utility built with .Net that performs requisite compression,

compaction, and repair on column families and keyspaces.

. Designed and implemented a conversion process for

transferring SQL Server data into a MySQL 5.5 database using

the Archive storage engine, reducing storage space by 95%

while keeping the data online; this deployment also required

using advanced scripting properties of SSIS to dynamically

create MySQL tables and XML files.

. Planned and installed more than 12 multi-node SQL Server

failover clusters some which included Analysis Services for

the migration and optimization of the data warehouse which

included a 20TB database.

. Created and deployed a C#.Net web application containing a

suite of self-conceptualized DBA tools specific to the needs

of the team; decreasing time and complexity of

troubleshooting and various maintenance window activities.

. Utilized in-depth knowledge of SQL Server internals to

conceive and document a process for correcting torn page

hardware errors with absolutely no data loss; this process

was used several times after a batch of servers with severe,

undetectable hardware problems were placed in to production.

. Created a system by which authorized members of management

could grant a limited number of temporary ad hoc permissions

on objects with restrictions and audit trail along with an

automated system for removing these permissions after a set

period of time, decreasing turn-around time for such requests

by up to 7 hours and reducing ticket volume to the DBA team

by approximately 20%.

. Resident expert on replication; recommended change in

existing publications making publication modification and

snapshot re-initialization less invasive by reducing creation

and application time from an average of 4 hours to a maximum

of 30 minutes along with developing and presenting training

on SQL replication internals to engineering teams. Also

implemented several instances of peer-to-peer replication in

Production environments.

. Developed and deployed enterprise-wide SQL Server performance

tracking and reporting tool using SSIS for data consolidation

and SSRS for delivery. These reports were used to increase

performance, project growth and usage statistics, and

troubleshoot system problems for over 150 servers and more

than 1275 databases up to 11TB in size:

2004-Present 365DBA Denver, CO

Owner/ Consultant

. Orchestrated and executed migration and upgrade of SQL Server

2000 environment with over 75 complex DTS packages to SQL

Server 2008 R2 with no downtime or data loss.

. Developed custom monitoring and alerting tool using

centralized web services and customizable alert system based

on unique thresholds and operators.

. Created in-depth reporting for SharePoint data utilizing

custom InfoPath forms with multiple submission data sources,

web services, XML parsing, and SSRS.

. Engineered entirety of several C#.Net / SQL Server web sites

and applications including www.365DBA.com,

www.ExpressNannies.com, www.MotorSportsRental.com,

http://www.attorney-quotes.com/, www.SEOTurboBoost.com.

. Migrated entire office and server environment from New Jersey

to Boulder implementing Remote Desktop environments for all

employees, standing up new and legacy hardware, deploying web

farm, and adding scalability to the operation.

. Developed custom web and win-form applications for several

clients as well as optimization and troubleshooting of

existing SQL and .Net code.

. Planned and executed multi-database migration from on-site

databases to SQL Azure.

. Responsible for drafting, maintaining, and growing large-

scale merge replication topology with 900+ geographically

disparate locations.

. Maintain regular blog entries at blog.365DBA.com.

2005-2007 NetQuote Denver, CO

Operational Database Administrator

. Designed, tested, and deployed a replication solution

allowing real time reporting and separating OLTP and OLAP

functionality.

. Conceptualized and implemented new disaster recovery solution

utilizing clustering, mirroring, replication, and log

shipping.

. Performed pre and post release reviews of T-SQL code for

logic and performance.

. Solely responsible for maintenance, optimization, contingency

planning, and guaranteed availability of over 65 databases on

over 15 Servers.

. Consolidated several disparate databases used for reporting

into a single OLAP database.

. Created .Net form and web-based utilities and applications

for simplified end user database interaction and data export

/ consumption.

. Maintained, migrated and developed several Report Services

instances with more than 250 reports and subscriptions.

. Devised and established a data archival process using several

types of ETL and SSIS methodologies.

. Implemented a and successfully utilized contingency/ data

availability plan for all production databases which created

warm standby databases at separate locations.

2004-2005 UC4 Software, Inc. Broomfield, CO

Support Department Manager / System Administrator

. Attended training to become resident expert on NSK (Tandem)

and third-party software package for critical path analysis.

. Identified points of failure in existing escalation process

and recommended new strategy to reduce resolution time by up

to 72 hours per call.

. Provided primary IT systems support for all United States

based employees; resolving connectivity issues, software and

hardware installations, as well as general repairs.

2001-2004 Intuit Public Sector Solutions Denver, CO

Support Department Team Lead 2001-2004

. Implemented Six Sigma project that decreased average call

resolution time by 83% and increased client satisfaction 20%.

. Developed several .NET applications to automate tasks

performed by Support Engineers, reducing resolution time for

Support issues by an average of 3 hours per call.

. Designed and created an internal ASP.Net application for call

monitoring purposes in an effort to quantify and report on

"Critical to Quality" aspects of Support calls.

. Applied extensive SQL knowledge to synchronize Accounting,

Sales, and Support application databases; ensuring real time,

reliable customer data in all departments.

. Developed training curriculum to address individual Support

Engineer needs.

. Created a testing lab for the Support department utilizing

thin client technology allowing Support engineers to access

every version of supported software without leaving their

desk.

. Served on and advised expert panels for user groups and

client meetings.

CERTIFICATIONS:

CCNA (Cisco Certified Network Associate) Exp 2005

MCTS SQL Server 2005

MCTS SQL Server 2008

MCITP SQL Server 2005 DBA

MCITP SQL Server 2008 DBA

ITIL V3 Foundation in IT Service Management

Comptia A+

PUBLICATIONS:

August, 2013 - Published: "Auditing Login Related Events in SQL

Server", eForensics Magazine, Issue 11/2013 (15) ISSN 2300-6986; 46-

53.

Contributor at http://blog.365DBA.com and www.SQL303.com

EDUCATION:

Bachelor of Science

Metropolitan State College of Denver

Major: Computer Information Systems

Denver, CO

COMPUTER EXPERIENCE:

Systems: Cisco, Windows (All versions), MS Exchange, Citrix, DOS, Oracle,

SQL Server (2000, 2005, 2008, 2012 Azure), PostgreSQL, MySQL, Cassandra

Languages: PL/SQL, SQL, TSQL, Visual Basic, Visual Basic.Net, C#.Net, ASP,

ASP.Net, HTML, XML, CQL

Contact this candidate