Ivan is available for hire

Ivan Friščić

Verified Expert in Engineering

Data Engineer and DB Developer

Krapina, Croatia

Toptal member since January 14, 2022

Expertise

Data Engineering SQL Server Database SQL

Bio

Ivan is a database specialist with love for all things DB going back 10+ years. He brings a decade of experience with SQL Server (administration, development, BI, and ETL) and holds an MCSE certificate. He built an automated app for trading securities integrated with the stock exchange, a complete BI sales solution for a major pharmaceuticals company, and used SSIS to integrate bidirectional data between the company application and SAP that included staff, payroll, and organizational data.

Portfolio

GeneDx, LLC c/o Sema4

SQL, T-SQL (Transact-SQL), Azure, Site Reliability Engineering (SRE)...

Preferred Medical Marketing Corporation (via Toptal)

SQL, Microsoft SQL Server, SQL Stored Procedures, Database Performance...

Hrpro

SQL Server DBA, SQL Server 2016, SQL Server 2017, SQL Server 2019...

Experience

SQL Server DBA - 12 years
Performance Tuning - 12 years
T-SQL (Transact-SQL) - 12 years
Microsoft SQL Server - 12 years
Database Architecture - 12 years
ETL - 8 years
Data Modeling - 8 years
Azure - 5 years

Availability

Full-time

Preferred Environment

Windows, SQL

The most amazing...

...tool I developed was an online public application for trading securities that is easy to use, integrated with the stock exchange, and fully automated.

Work Experience

Data Engineer

2023 - PRESENT

GeneDx, LLC c/o Sema4

Migrated servers from an Azure tenant to a new Azure tenant and migrated servers on-prem from one domain to another.
Worked on performance tuning on mission-critical stored procedures. The most noticeable drop in execution times was from 36 seconds to 1 millisecond. All by doing clever rewrites.
Set up an analytical replica on a new server that way we diverted all analytical workload to a separate server with a near real-time copy of data.
Downgraded production AON Solution from Enterprise to Standard, resulting in substantial cost savings of $300,000 annually for the client.

Technologies: SQL, T-SQL (Transact-SQL), Azure, Site Reliability Engineering (SRE), Data Engineering, Stored Procedure, SQL Stored Procedures, Microsoft SQL Server, High Availability Disaster Recovery (HADR), Database Administration (DBA), On-premise, Database Migration, Cloud

Microsoft SQL Database Expert

2022 - 2022

Preferred Medical Marketing Corporation (via Toptal)

Optimized the performance of 50 stored procedures identified in an audit report, resulting in 4x less CPU usage, 5x faster queries, and 10x less data reads.
Held a lecture about the top 10 things not to do on a databases if you want good performance. The lecture included examples of their stored procedures, where I identified "bad" code and showed them how to correct it.
Wrote a short cookbook on how to properly code on SQL Server to get out the best performance.

Technologies: SQL, Microsoft SQL Server, SQL Stored Procedures, Database Performance, Database Administration (DBA), On-premise

Database Specialist

2017 - 2022

Hrpro

Developed a T-SQL script to transfer data from a source (old model) to a destination (new model) database. Comparing data in tables, transferring data that complies with the foreign key and required columns.
Made architectural changes to the database; split data and indexes to different file groups, and partitioned larger tables for a better performance boost.
Integrated bidirectional automated exchange of data between our application and SAP using SSIS.
Led a team of developers to upgrade clients to a new version of the application.

Technologies: SQL Server DBA, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server Integration Services (SSIS), IT Project Management, ETL, ELT, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Database Architecture, Data Modeling, Data Pipelines, Azure Cloud Services, Azure, Azure SQL, SQL Stored Procedures, Microsoft Power BI, Reports, Azure Blob Storage API, JSON, SQL DML, Performance Tuning, SQL Performance, High Availability Disaster Recovery (HADR), Database Administration (DBA), Windows PowerShell, On-premise, Database Migration, Cloud

Senior Database Associate

2016 - 2017

Addiko Bank AG

Developed new facts and dimensions in the Addiko Group BI.
Integrated new data sources to a metadata drive ETL.
Implemented Prevero as an IT project management role.

Technologies: SQL Server BI, SQL Server 2014, SQL Server Integration Services (SSIS), ETL, IT Project Management, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Database Architecture, Data Modeling, Data Pipelines, Business Intelligence (BI), SQL Stored Procedures, Microsoft Power BI, Reports, SQL DML, Performance Tuning, SQL Performance, Database Administration (DBA), On-premise

Head of DBA Department

2016 - 2016

Comminus

Developed an online public application for trading securities. Easy to use, integrated with the stock exchange and fully automated.
Developed a complete BI sales solution for a major pharmaceuticals company.
Mentored numerous employees and held multiple courses regarding database development, database administration, and database security.

Technologies: SQL Server DBA, SQL Server BI, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Database Architecture, Data Modeling, Data Pipelines, Business Intelligence (BI), SQL Stored Procedures, Reports, SQL DML, Performance Tuning, SQL Performance, Database Administration (DBA), On-premise

Data Management Specialist

2014 - 2016

Comminus

Developed an online public application for trading securities. Easy to use, integrated with the stock exchange and fully automated.
Upgraded, expanded, and optimized an existing application for portfolio managers that included error handling, translations, isolation levels, and automatons.
Developed a complete BI sales solution for a major pharmaceuticals company.

Technologies: SQL Server DBA, SQL Server BI, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL, T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Database Architecture, Data Modeling, Data Pipelines, Business Intelligence (BI), SQL Stored Procedures, Reports, SQL DML, Performance Tuning, SQL Performance, On-premise

Experience

Online Securities Trading Application

An online public application for trading securities. Easy to use, integrated with the stock exchange, and fully automated. I was the DB lead on the project, and created the database design and distributed tasks to other colleagues. I code reviewed and integrated the app with the stock exchange using SSIS.

SAP Integration

Exchange of data between our HR application and SAP. I used SSIS to integrate bidirectional automated data exchange between our application and SAP. It included employees, payroll, and organizational data.

Project Marketplace

An extension to our HR application. Project managers can list upcoming projects and employees can apply for suitable roles. I was the lead DB on the project, created the database design, stored procedures, functions, and views. Additionally, I distributed tasks among junior database colleagues.

Education

2002 - 2009

Master's Degree in Mathematics and Computer Science

University of Zagreb Faculty of Science (Mathematics Department) - Zagreb, Croatia

Certifications

SEPTEMBER 2016 - PRESENT

MCSE: Data Management and Analytics

Microsoft

JUNE 2016 - PRESENT

MCSE: Data Platform

Microsoft

JUNE 2015 - PRESENT

Microsoft Certified IT Professional: Database Developer 2008 (MCITP)

Microsoft

MAY 2014 - PRESENT

MCSA: SQL Server 2012/2014

Microsoft

JULY 2013 - PRESENT

Microsoft Certified IT Professional: Database Administrator 2008 (MCITP)

Microsoft

Skills

Libraries/APIs

Azure Blob Storage API

Tools

SQL Server BI, Microsoft Power BI

Languages

SQL, T-SQL (Transact-SQL), SQL DML, Stored Procedure

Storage

Databases, SQL Server DBA, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server Integration Services (SSIS), SQL Server 2014, SQL Server 2012, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Microsoft SQL Server, Database Architecture, SQL Stored Procedures, SQL Performance, Database Administration (DBA), On-premise, Database Migration, SQL Server Reporting Services (SSRS), Data Pipelines, Azure Cloud Services, Azure SQL, JSON, Database Performance

Paradigms

ETL, Business Intelligence (BI)

Platforms

Azure

Frameworks

Windows PowerShell

Other

Data Engineering, Data Architecture, Reports, Performance Tuning, High Availability Disaster Recovery (HADR), IT Project Management, ELT, Data Modeling, Cloud, Site Reliability Engineering (SRE)

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