Cliff Buckley, Developer in Sumner, WA, United States
Cliff is available for hire
Hire Cliff

Cliff Buckley

Verified Expert  in Engineering

Database Developer

Sumner, WA, United States

Toptal member since September 19, 2022

Bio

Cliff is a database developer with over a decade of experience in various roles within IT, from hardware support to management. He has led multiple teams, refactored poor-performing systems, and designed systems from scratch. Cliff excels with SQL, Oracle, Bash, Linux, and data warehouse design.

Portfolio

US RxCare
Leadership, Analysis, QA Testing, Code Review, Web Project Management, Jira...
Elixir Rx Solutions
Oracle 11g, PL/SQL Tuning, PL/SQL Developer, Ruby, C#.NET, Bash...
CVS Health
C#.NET, Data Architecture, Database Design, Data Engineering, Data Warehousing...

Experience

  • Microsoft SQL Server - 20 years
  • SQL Server Integration Services (SSIS) - 20 years
  • Database Design - 15 years
  • Linux - 10 years
  • Oracle - 10 years
  • Oracle 11g - 10 years
  • Data Warehouse Design - 6 years
  • MySQL - 4 years

Availability

Part-time

Preferred Environment

Windows, Linux, Microsoft SQL Server, Oracle, MySQL, Data Warehouse Design, Data Warehousing

The most amazing...

...project I've contributed to was the refactoring of an inventory publishing process and taking it from running in eight hours to just minutes.

Work Experience

Systems Management Director

2021 - 2023
US RxCare
  • Joined the company when the source control was scattered across each developer's personal Bitbucket account. Created a central team Bitbucket and got all code moved to this new team workspace.
  • Implemented Jira and Jira Service Manager to organize the teams better, significantly improving communication. Previously, the development team received all requests via phone, email, text, or direct message.
  • Used Confluence as a repository and began documenting the Classic ASP data loads and an updated system to ensure rules between the two were matched before implementation. The company had older software and no documentation.
Technologies: Leadership, Analysis, QA Testing, Code Review, Web Project Management, Jira, Confluence, Documentation, Git, Bitbucket, Jenkins, Data, Database Development, Databases, CSV, CSV Export, Data Migration

Software Engineer III

2013 - 2021
Elixir Rx Solutions
  • Improved the efficiency of the data loading process for calculating deductible and out-of-pocket balances.
  • Integrated a new rules tracking system (Decisions.com rules engine) to determine eligibility.
  • Refactored the eligibility process to improve visibility into what was being received.
Technologies: Oracle 11g, PL/SQL Tuning, PL/SQL Developer, Ruby, C#.NET, Bash, Windows PowerShell, ETL, ETL Tools, JavaScript, Stored Procedure, Documentation, Python, Source Code Review, Microsoft Word, Microsoft Excel, Visio, Azure DevOps, Data Validation, Quality Assurance (QA), SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database Design, Data, Database Performance, Database Development, Databases, Data Extraction, CSV, CSV Export, Data Migration

Database Architect

2008 - 2013
CVS Health
  • Redesigned an inefficient system entirely, which shortened a multi-day running government process so that it would run in just a few hours.
  • Mentored junior developers on database best practices and how to review queries for performance improvements.
  • Worked within an architect team, documented, and educated staff on the best practices through lunch-and-learn sessions.
  • Maintained and created ETL processes for loading a variety of data formats.
Technologies: C#.NET, Data Architecture, Database Design, Data Engineering, Data Warehousing, Documentation, ETL, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TFS, Microsoft Team Foundation Server, Visual SourceSafe, Data Validation, Quality Assurance (QA), Star Schema, SQL Stored Procedures, Data Management, Data Analysis, Database Architecture, Oracle Database Architecture, Relational Databases, Relational Database Design, Relational Data Mapping, Data, Database Performance, Database Development, Databases, Data Extraction, CSV, CSV Export, Data Migration

Data Warehouse Software Engineer

2001 - 2008
Oeconnection
  • Rebuilt an inventory publishing process with a team of three others to go from 6–8 hours to process inventory to less than 15 minutes.
  • Built the company's first data warehouse from design to ETL processes.
  • Launched a data analysis intelligence system building data marts off the data warehouse for multiple customers.
  • Completed various database and website tasks as assigned from external members' sites to internal tools (task tracking and a billing system).
Technologies: Data Warehousing, T-SQL (Transact-SQL), SQL, Stored Procedure, SQL Server DBA, C#.NET, Data Architecture, Data Engineering, Data Warehouse Design, Database Design, SQL Server Integration Services (SSIS), Documentation, ETL, SQL Server Reporting Services (SSRS), Microsoft Access, Quality Assurance (QA), Data Validation, SQL Stored Procedures, Star Schema, BizTalk, Data Management, Data Analysis, Data Visualization, Relational Databases, Relational Database Design, Database Architecture, Data, Database Performance, Database Development, Databases, CSV Export, Data Migration

Book Collector

https://github.com/buckleycd/BookCollector
A simple database designed to track a collection of books. The project is deliberately kept simplistic, so any developer can pick up the design and work with an ORM tool without needing to map to stored procedures. This is a personal project and was not sponsored by clients.

Data Warehouse

Designed and implemented an automotive parts inventory data warehouse using the Dimensional Modeling methodology.

The warehouse is fed data from an OLTP system, CSV files, and a proprietary format for the parts catalog.

The warehouse was built within six months with a team of four. The team was responsible for geographic hierarchy, customer dimensions, and some of the reporting.

Tools

Jira, DbSchema, Microsoft Word, Visio, Git, Microsoft Excel, Confluence, Bitbucket, Microsoft Access, Jenkins, TFS, Microsoft Team Foundation Server, Visual SourceSafe, MongoDB Atlas

Languages

T-SQL (Transact-SQL), JavaScript, SQL, Stored Procedure, C#.NET, Bash, Ruby, Python, Snowflake

Paradigms

Database Design, ETL, Dimensional Modeling, Database Development, Oracle Database Architecture, Azure DevOps

Storage

Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Architecture, Data Validation, SQL Stored Procedures, Database Architecture, Relational Databases, Databases, MySQL, Oracle 11g, PL/SQL Developer, SQL Server Reporting Services (SSRS), SQL Server DBA, Database Performance, PostgreSQL

Platforms

Linux, Oracle, Windows

Frameworks

Windows PowerShell

Other

Data Warehouse Design, Data Warehousing, Documentation, Leadership, Source Code Review, Data Engineering, Data Architecture, Data Modeling, Code Review, Star Schema, Data Management, Relational Database Design, Relational Data Mapping, Data Extraction, CSV, CSV Export, PL/SQL Tuning, ETL Tools, Analysis, Web Project Management, Quality Assurance (QA), Data Analysis, Data, Data Migration, QA Testing, BizTalk, Data Visualization

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring