David Buckingham Email & Phone Number

Greater Nashville Area, Tn

Modeled and implemented modifications to the Redshift database. Enhanced and tuned Redshift queries. Designed and implemented Airflow DAG’s (Python3 based) to handle Redshift data ingestion.

Greater Nashville Area, Tn

Recruited for expertise in SQL Server transactional and data warehouse implementations. Performed design and security best practices review on transactional database that was being migrated from Oracle to SQL Server. Performed design best practices review on data warehouse implementation and all SSIS packages.

Greater Nashville Area, Tn

Model and implement SQL Server 2012/2014 dimensional data warehouses, as well as operational data stores, in healthcare settings, sourcing from custom data sources in addition to standardized X12 and HL7 ODS data sources. Size and scope of the databases and data volume vary from client to client. Client and in-house work using Redshift.NOTE: Acquired WPC Healthcare in April 2017

Greater Nashville Area, Tn

Model and implement SQL Server 2012/2014 dimensional data warehouses, as well as operational data stores, in healthcare settings, sourcing from custom data sources in addition to standardized X12 and HL7 ODS data sources. Size and scope of the databases and data volume vary from client to client.NOTE: acquired by Intermedix April 2017

assigned to WPC ServicesRecruited to model and implement SQL Server 2012 dimensional data warehouses in healthcare settings, sourcing from standardized X12 and HL7 ODS data sources. Size and scope of the data warehouses vary from client to client.

Recruited to build and lead a data warehouse team charged with creating a consolidated warehouse for all of Press Ganey's products' data sets, including implementation of master data management. Consolidated data warehouse is implemented on SQL 2012, with preparations being made for migrating to Parallel Data Warehouse (SQL 2012-based) Near term size will be 22 TB, with eventual size likely exceeding 100 TB New and exising analytic products represent a significant query workload requiring high performance and low latency response times Operational data stores include SQL Server 2008, Oracle, DB2, and RavenDB

assigned to Press GaneyRecruited to be the primary SQL Server resource for the team developing a new product intended to replace two existing products. Additional duties include performance tuning; reviewing data architecture; and help implement industry best practices. New product will be implemented using CQRS and support a JSON communication layer Developing a SQL code generation utility to drastically reduce database development effort

Greater Nashville Area, Tn

Recruited as a senior database administrator to provide level 3 support to both the application support team and the production database administration team. Additional duties include proactive monitoring and performance tuning existing products; review and improve database server and solution architecture; and help implement industry best practices. Reviewed and provided recommendations for SQL database server architecture in new data center Assisted in tuning an aged application/database and building out a replacement platform Provided technical and solution assistance to database development teams

assigned to The Active NetworkRecruited as a senior database administrator/developer to assist with performance tuning existing products, improve the quality of the T-SQL and SSIS packages, and help implement industry best practices. Operated under an agile SDLC (Scrum variant). Performed code review of all T-SQL code (900+ SP’s, 300+ functions, 275+ views) to provide detailed feedback Used agile database refactoring techniques extensively to improve quality, clarity, and performance of many stored procedures and functions Created template-based Service Broker implementation to allow population of existing reporting database and a new dimensional data warehouse  Reviewed indexing strategy to remove unused indexes, improve existing, and add useful new indexes Improved SQL knowledge and solution design of the other developers Provided 3rd level production application support

assigned to DataAdvantage/Press GaneyRecruited as a senior database developer/administrator to assist with new product development, migrate legacy customers, and to implement industry best practices to their SQL Server implementations. Operated under an agile SDLC (Scrum). Performed development tasks to support new product development Implemented proper maintenance routines with improved reliability Improved performance of numerous stored procedures and external processes by adding/enhancing indexes and rewriting the queries as appropriate Worked with management to improve the deployment/implementation process Improved SQL knowledge and solution design of the other developers Provided 2nd level production application support, in addition to 1st level support for DBA responsibilities

assigned to MedSolutionsRecruited as the senior database administrator to implement industry best practices to their SQL Server implementations, as well as improve their deployment process and mentor the junior DBA. Operated under an agile SDLC (Scrum). Implemented proper maintenance routines with improved reliability Worked with development architects to institute better T-SQL coding practices Worked with management to improve the deployment/implementation process Performed functional and performance-related T-SQL enhancements Mentored junior DBA in administrative practices, SQL Server specific knowledge, and SQL coding Provided 2nd level production application support, in addition to 1st level support for SQL functions Improved SQL knowledge of the other developers

Managed the database team, including administrative and development responsibilities. Created professional development plans for team members. Mentored skills and knowledge to database team and system administration team. Performed full review of database architecture, including database structure/code, SQL Server configuration, OS/hardware configuration, cluster configuration, and SAN configuration/LUN layout Planned the upgrade from SQL 2000 to SQL 2008, including identifying code updates required to complete the upgrade Planned the SAN upgrade, include performing benchmarking tests to determine the proper LUN layout to accommodate the increasing throughput requirements Revised existing Windows 2003/SQL 2000 active/passive cluster configuration to become more stable and planned change to 4-way active clusters utilizing Windows 2008/SQL 2008 Established database-related guidelines and policies, following best practices Identified implementations that deviated from best practices and initiated projects to rectify them Collaborated with .NET architects to ensure the database environments would meet their needs, as well as to ensure solutions fit within best practices Served as a member, and eventually the chairperson, on the Solutions Architecture Review Board

assigned to Link2Gov/Metavante (now FIS)Recruited to improve the stability and throughput of the database systems, as well as mentoring the more junior team members. Led the database portion of the “production split” project (a major project doubling the production hardware, but separating applications across the two environments). Improved performance of the database servers by reconfiguring the server settings and identifying key queries requiring tuning Improved reliability of database servers by correcting the inconsistent settings on the clusters Completed the “production split” project on time and without any post-implementation issues, except for one minor issue

Recruited to administer and performance tune SQL 2000 and 2005 instances of data warehouses primarily used for claims-based reporting. Improved performance of staging and data warehouses through query tuning, as well as OS/hardware/SAN tuning Established new backup strategy utilizing Red Gate’s SQL Backup Pro to reduce backup times and bandwidth consumption Wrote and executed SSIS and bcp data imports Administered EMC CX-500 SAN and performed secondary system administration Improved SQL knowledge of the other developers

assigned to HCA Physician ServicesRecruited as the primary SQL developer and to assist Operations with administrative tasks as necessary. Operated under an agile SDLC (Scrum). Performed functional and performance-related enhancements Utilized agile database/database refactoring techniques Implemented DB Ghost/Packager Plus for building, testing, and deploying databases Provided 2nd level production support, including deployment assistance Improved SQL knowledge of the other developers

Managed the MediClaim .NET/database development team. Instituted new policies, procedures, and guidelines following best practices. Created professional development plan to improve team skills and techniques. Led architecture changes to improve performance and product manageability.

Assisted in the design and implementation of significantly more efficient metadata-driven data load process. Tuned and redesigned many of the stored procedures for better performance and maintainability.

Maintained 66 SQL 2000 and SQL 7.0 Servers housing over 800 databases. Planned, coordinated, and executed the production migration of over 240 databases to new SQL Servers. Maintained 99.99% production uptime on the production SQL Servers. Provided 24x7 production support.

Installed, configured, and maintained Windows Servers, clusters, and SQL Servers. Provided 24x7 production support.

Managed the Empower development team, in addition to providing deployment and production support. Responsible for the over-all design of the application framework and batch processing engine.

Designed and built new transactional processing engine. Designed and built real-time HL7 lab encounter interfaces.