Cliff is available for hire

Cliff Buckley

Verified Expert in Engineering

Database Developer

Location

Sumner, WA, United States

Toptal Member Since

September 19, 2022

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.

Data Engineering Data Warehouse Design Data Warehousing Microsoft SQL Server SQL Server Integration Services (SSIS)SQL Database Development Databases Database Design Visio Jira Microsoft Excel Linux Oracle Oracle 11g CSV

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

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

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

Experience

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.

Skills

Languages

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

Tools

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

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

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, QA Testing, BizTalk, Data Visualization

Platforms

Linux, Oracle, Windows

Frameworks

Windows PowerShell

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.

Share your needs

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

Choose your talent

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

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