Robert is available for hire

Robert Hurwitz

Verified Expert in Engineering

BI and Database Developer

Jacksonville, FL, United States

Toptal member since March 8, 2021

Expertise

Data Warehouse Windows Development SQL Database ETL Business Intelligence Development C#SSIS

Bio

Robert is a seasoned technology professional, having worked for 15+ years across roles ranging from application development, BI development, DB administration, solutions engineering, architecture, and technology leadership positions. At Direct Care Innovations, he reduced CPU utilization by 40% by improving application logic, rewriting stored procedures, and restructuring the databases' indexing strategy. Robert brings a pragmatic approach to technology and data challenges businesses face today.

Portfolio

Direct Care Innovations

Azure SQL, Azure, Azure PaaS, SQL Server DBA, Azure Data Factory (ADF)...

Step Up For Students

Azure Data Factory (ADF), APIs, C#, REST, Business Process Automation, Azure...

Step Up For Students

SQL Server 2008 R2, SQL Server Integration Services (SSIS)...

Experience

SQL - 16 years
SQL Server Integration Services (SSIS) - 13 years
Data Modeling - 12 years
SQL Server DBA - 12 years
Data Warehouse Design - 9 years
Azure - 7 years
Azure Data Factory (ADF) - 3 years

Availability

Part-time

Preferred Environment

Windows, SQL Server Management Studio (SSMS), T-SQL (Transact-SQL), SQL, Azure SQL

The most amazing...

...improvement I've made was reducing cloud compute costs by 20% while simultaneously improving performance by 50%, resulting in a 1-year ROI of more than 2,000%.

Work Experience

Director of Database Development

2021 - PRESENT

Direct Care Innovations

Optimized database performance by reducing CPU utilization by 40% over three weeks by improving application logic, rewriting stored procedures, and restructuring the databases' indexing strategy.
Reduced Azure spend by 20% by rightsizing PaaS resources.
Managed the development of data reporting capabilities within the organization to deliver value-added services and new reporting functionality within the SaaS product.

Technologies: Azure SQL, Azure, Azure PaaS, SQL Server DBA, Azure Data Factory (ADF), Data Warehouse Design, Data Modeling, C#, SQL, Business Intelligence (BI), Data Architecture, ETL, Databases, Data Pipelines

Technology Solutions Manager

2016 - 2021

Step Up For Students

Implemented 3rd-party solutions and designed integrations with in-house systems using REST APIs, Azure Logic Apps, Azure Storage, and Azure Data Factory.
Developed target state architectures along with intermediate transition architectures for data solutions, allowing for implementation and integration across business processes.
Led rapid response initiatives to deliver solutions to unexpected industry needs related to Covid-19, resulting in new revenue stream opportunities.

Technologies: Azure Data Factory (ADF), APIs, C#, REST, Business Process Automation, Azure, Azure SQL, SQL Server Integration Services (SSIS), ETL Development, Data Modeling, SQL, Solution Architecture, Business Intelligence (BI), Data Architecture, ETL, Databases, Data Pipelines

Senior Database and Business Intelligence Administrator

2010 - 2015

Step Up For Students

Designed and implemented high availability database solutions using a combination of SQL Server tools and virtualization.
Designed and executed the data mapping and migration from the existing MySQL database into a new SQL Server database schema using SSIS and custom T-SQL ETL processes.
Delivered ETL processes utilizing SSIS to stage, process, and load data into the Data Warehouse used by Analysis Services (SSAS) and other reporting tools.
Developed SSAS cubes using MDX calculations and SSAS tabular models to perform complex analysis.

Technologies: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Dimensional Modeling, Data Warehousing, Database Replication, High Availability Disaster Recovery (HADR), C#, ASP.NET Web Forms, ASP.NET MVC, Azure SQL, SQL Server DBA, Data Warehouse Design, ETL Development, Data Modeling, SQL, Business Intelligence (BI), Data Architecture, ETL, Databases

Database Administrator III

2011 - 2011

Black Knight

Administered and responsible for the performance, availability, and recoverability of 20+ servers and 100+ TB of databases.
Developed daily monitoring procedures using PowerShell.
Migrated several large databases (1TB+) between data center locations.
Managed troubleshooting and resolution of transaction log shipping and mirroring failures.

Technologies: SQL Server 2008 R2, Database Replication, Database Clusters, Log Shipping, SQL Server DBA, Disaster Recovery Plans (DRP), Performance Tuning, SQL, Databases

Software Developer

2005 - 2010

Florida Virtual School

Designed and developed database schema for new functionality including tables, views, functions, and stored procedures.
Led the organization and execution of software testing and the release of software and database solutions.
Led the implementation of transactional replication of data to be used for reporting.
Developed reporting solutions using T-SQL, Reporting Services, and Integration Services.

Technologies: ASP.NET Web Forms, Stored Procedure, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), Database Replication, SQL Server DBA, ETL Development, Data Modeling, C#, SQL, ETL, Databases

Experience

Performance Optimization

A performance optimization project for a client reaching the limit of their Azure infrastructure. I performed a full systems analysis of the application front end, services, and database back end, cataloging high numbers of dependencies on Azure SQL requests. I resolved several logic issues resulting in N+1 database calls by refactoring entity framework and LINQ queries in the application, as well as optimization stored procedures and the UI.

Student Information Data Warehouse

I led the design and development of an enterprise data warehouse in the education industry. I was responsible for the warehouse's modeling following the Kimball DW/BI lifecycle methodology, along with the ETL processes to integrate various systems of record. This warehouse and its reporting tools supported deep analysis into the performance of students and schools to provide unique recommendations for individual students.

Business Process Outcome Prediction

I led the design of a predictive data mining structure using decision trees to determine the outcome of a manual business process using user-supplied input data, along with engineering features based on external data providers. This enabled the business to automate an expensive and time-consuming process, while increasing the auditability of manual workflow.

Education

2004 - 2007

Associate's Degree in Electrical Engineering

University of Central Florida - Orlando, Florida, USA

Certifications

MAY 2019 - MAY 2021

Certified Scrum Master

Scrum Alliance

NOVEMBER 2009 - PRESENT

MCPS: Microsoft Certified Professional

Microsoft

Skills

Libraries/APIs

LINQ, Entity Framework

Tools

Microsoft Power BI, Azure App Service

Languages

SQL, T-SQL (Transact-SQL), C#, C#.NET, Stored Procedure

Paradigms

Dimensional Modeling, Business Intelligence (BI), ETL, Scrum, REST, Kimball Methodology

Platforms

Azure, Windows, Azure PaaS

Storage

SQL Server DBA, SQL Server Reporting Services (SSRS), Database Replication, SQL Server Management Studio (SSMS), SQL Server 2008 R2, Databases, SQL Server Integration Services (SSIS), Data Pipelines, Azure SQL, SQL Server Analysis Services (SSAS), SQL Server 2005

Frameworks

Windows PowerShell, ASP.NET Web Forms, ASP.NET MVC

Other

Data Warehouse Design, Data Modeling, ETL Development, Data Warehousing, High Availability Disaster Recovery (HADR), Data Architecture, APIs, Solution Architecture, Azure Data Factory (ADF), IT Systems Engineering, Scrum Master, Scrum Coaching, Business Process Automation, Azure WebJobs, Indexing, Decision Trees, Data Mining, Database Clusters, Log Shipping, Disaster Recovery Plans (DRP), Performance Tuning

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