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.

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.

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.

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..

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+.

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.

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.

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.

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.

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.

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.

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.