Open to opportunities

Frank Jensen

@frankjensen

Message

I build reliable data pipelines, warehouses, and database systems for critical operations.

United States

Message

What I'm looking for

I'm looking to build and improve reliable database, ETL, warehouse, integration, and reporting systems that support critical business operations and measurable performance gains.

At Mendocino Farms, I migrate and validate critical ETL and warehouse workloads into Snowflake, rebuild guest-data synchronization for HubSpot-ready datasets, and support reporting across nearly 100 restaurants, 1.9M identified guests, and nearly 6M guest-linked orders.

I improved data availability by replacing an eight-hour daily refresh of 1.8M+ guest records with hourly incremental processing. I also diagnosed a major stored-procedure issue, reducing runtime from more than an hour to about four minutes, and corrected donation logic that saves the company about $1,000 annually.

Previously, I supported mission-critical SQL Server environments for the State of Idaho and built database, ETL, monitoring, reporting, migration, and recovery solutions. I’ve also developed borrower-eligibility processes, SQL Server-to-DB2 integrations, and performance improvements for Idaho Housing and Finance.

Experience

Work history, roles, and key accomplishments

Database Administrator

Mendocino Farms

Jul 2025 - Aug 2026 (1 year 1 month)

Migrated ETL and warehouse workloads from SQL Server to Snowflake, reengineered guest data sync during Paytronix-to-Sparkfly transition, and optimized stored procedures for performance.

Snowflake SQL Microsoft SQL Server ETL Stored Procedures Data Integration Reporting HubSpot Crunchtime Force for Good Toast Axial

Database Administrator III

State of Idaho

Oct 2022 - Jul 2025 (2 years 9 months)

Served as primary DBA for multiple state agencies, supporting SQL Server environments, building and optimizing stored procedures, and migrating SSIS to Azure Data Factory pipelines.

SQL Server Azure Data Factory SSIS PowerShell Power BI Stored Procedures Incident Management ServiceNow

Jr Database Programmer

Idaho Housing and Finance

Dec 2020 - Oct 2022 (1 year 10 months)

Developed stored procedures and SSIS processes for borrower eligibility, implemented index strategies improving runtime by 80%, and maintained synchronization between SQL Server and IBM DB2.

SQL SSIS Stored Procedures ETL IBM DB2 Twilio JSON Jira