SQL Server Database Administrator/ Developer/ Architect

David Zahner

: Denver, CO. : 720-***-**** : **********@*****.***

SENIOR SQL DATABASE ADMINISTRATOR/ DEVELOPER

Computer Information Systems, IT Service Management, Networking

Highly accomplished expert and forward-thinking Leader in Database Development with 15 years of experience in SQL Server 2000 through 2014, .Net Programming and Technical Infrastructure. Over 12 years combining innovative technical expertise with a strong Team Management and consulting background to provide optimum IT service, support, and solutions in both public and private industries. Ensure maximum impact of systems and networks through focused awareness of enterprise requirements, as well as a commitment to end-user satisfaction. Direct high-impact technology implementations for hardware recommendations, query optimization, troubleshooting, providing guidance to team members, and collaborating with technical and non-technical teams throughout the organization. Proven record of accomplishment leveraging cross-functional expertise to develop robust, impactful business solutions as part of large-scale initiatives. Effective in fostering cross-functional collaboration between technical and non-technical personnel.

KEY STRENGTHS

Database Design ● Database Architecture ● Database Administration ● Strategic Planning & Tactical Execution ● Business Process Improvement ● Strategic Alliances ● Problem Solving ● Client Relationship Building ● Trend Analysis ● Networking ● Budget Administration ● Technology Integration

TECHNICAL STRENGTHS

Systems: Cisco, Windows (All versions) ● SQL Server (2000, 2005, 2008, 2012, 2014, Azure) ● PostgreSQL ● MySQL ● Cassandra ● MS Exchange ● Citrix ● Oracle

Languages: PL/SQL ● SQL ● TSQL ● Visual Basic ● Visual Basic.Net ● C#.Net ● ASP ● ASP.Net ● HTML ● XML ● CQL

PROFESSIONAL EXPERIENCE

BUSINESS DECISION DATA SERVICE, INC. BOULDER, CO, 2015-PRESENT

LEAD DATABASE ENGINEER

Architect and build entire data import system from design through deployment. Work with heterogeneous point-of-sale systems and data delivery systems with various formats.

Key Accomplishments:

Build robust and flexible data import system to interface with and automate the cleansing and standardization of any number of data formats including csv, APIs, Excel, SQLite, PostgreSQL, and MySQL using .Net code and SSIS.

Generate and maintain code structure for several APIs using JSON and XML.

Develop Python scripts for automating web interactions, downloading files, and importing data.

Design complex reports for clients, end-users, executives, and investors utilizing SSRS for publishing and delivery.

Assist in the planning and implementing of entire IT infrastructure including all servers, switches, firewalls, load-balancers, colocation, business software, email, domain, and workstations.

Manage network by running and terminating data cables, configuring switch ports, tracking and testing data cables.

Monitor, troubleshoot and resolve SQL performance issues from all systems.

Create web-based and form-based user interfaces for end-users to interact with back-end databases.

Handle all improvements and modifications to database structures and import system.

365DBA DENVER, CO, 2012-2015

OWNER/ LEAD DATABASE ADMINISTRATOR

Work with dozens of clients and stakeholders in varying environments to maintain system uptime, optimize .Net and T-SQL code, improve processes throughout the enterprise, and create new offerings.

Key Accomplishments:

Develop custom monitoring and alerting tool using centralized web services and customizable alert system based on unique thresholds and operators.

Orchestrate and implement 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.

Plan and execute multi-database migration from on-site databases to SQL Azure. Accomplish code reviews and consulting clients on system specifications.

Growing large-scale merge replication topology with 2500+ geographically disparate locations.

Successfully migrate all SQL servers from on-site server room to secure collocation facility and Azure.

Create reusable processing for several third-party API’s to automate dozens of interactions with these vendors.

Produce several ETL processes using C#.Net and SSIS to import and export data from the CRM system.

Create in-depth reporting for SharePoint data utilizing custom InfoPath forms with multiple submission data sources, web services, XML parsing, and SSRS.

Develop custom web and win-form applications for several clients as well as optimization and troubleshooting of existing SQL and .Net code.

MARKIT / WALL STREET ON DEMAND, INC. BOULDER, CO, 2007-2014

SENIOR DATABASE ADMINISTRATOR / DEVELOPER

Senior subject matter expert handling escalated issues and complex requests in large-scale, fast-paced SQL environment. Mentoring and training junior members of the DBA and SQL Development teams.

Key Accomplishments:

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.

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.

Developed a Java-based monitoring and alerting utility for Cassandra utilizing JMX as well as an automated maintenance utility.

Created a system by which 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.

Resident expert on replication environment using peer-to-peer, transactional, merge, and snapshot topologies; along with developing and presenting training on SQL replication internals to engineering teams.

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 from over 95 servers and more than 1075 databases up to 11TB in size:

Developed custom web and win-form applications for several clients as well as optimization and troubleshooting of existing SQL and .Net code.

NETQUOTE DENVER, CO, 2005-2007

OPERATIONAL DATABASE ADMINISTRATOR

Key Accomplishments:

Designed, tested, and deployed a replication scheme allowing real time reporting without locking or resource contention in the Production database environment as well as providing a means to separate OLTP and OLAP functionality.

Solely responsible for maintenance, optimization, contingency planning, and guaranteed availability of over 65 databases on over 15 Servers.

Accomplished complete disaster recovery procedures after system outage with production databases transferred and ready for connections within 5 minutes with zero data loss.

UC4 SOFTWARE, INC. BROOMFIELD, CO, 2004-2005

SUPPORT DEPARTMENT MANAGER / SYSTEM ADMINISTRATOR

Key Accomplishments:

Identified points of failure in existing escalation process and recommended new strategy to reduce resolution time by up to 72 hours per call.

Ensured primary IT systems support for all United States based employees; resolving connectivity issues, software and hardware installations, as well as general repairs.

INTUIT PUBLIC SECTOR SOLUTIONS DENVER, CO, 2001-2004

SUPPORT DEPARTMENT TEAM LEAD / TECHNICAL RESEARCH DEPARTMENT

Key Accomplishments:

Served on and advised expert panels for user groups and client meetings and created incentive program resulting in increased sales to other departments by 300%, increasing revenue by $70,000 per quarter.

Implemented Six Sigma project that decreased average call resolution time by 83% and increased client satisfaction 20%.

Developed several Visual Basic .NET applications for end users to automate tasks performed by Support engineers, reducing time on systems and upgrade related issues by an average of 3 hours per call.

Developed a SQL backup utility to allow users to backup SQL databases with any agent, saving over 1500 clients $400 each and ensuring a viable backup of data for disaster recovery.

EDUCATION & CERTIFACTION

Metropolitan State College of Denver, CO

BACHELOR OF SCIENCE, MAJOR: COMPUTER INFORMATION SYSTEMS

Comptia A+

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

CCNA (Cisco Certified Network Associate) Exp 2005

PUBLICATIONS

"Auditing Login Related Events in SQL Server", AUGUST 2013

e-Forensics Magazine, Issue 11/2013 (15) ISSN 2300-6986; 46-53

Contact this candidate