Ivan is available for hire
Hire IvanIvan Friščić
Verified Expert in Engineering
Data Engineer and DB Developer
Location
Krapina, Croatia
Toptal Member Since
January 14, 2022
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
Availability
Part-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.
Skills
Languages
SQL, T-SQL (Transact-SQL), SQL DML, Stored Procedure
Tools
SQL Server BI, Microsoft Power BI
Storage
Databases, SQL Server DBA, SQL Server 2016, SQL Server 2017, 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
Other
SQL Server 2019, Data Engineering, Data Architecture, Reports, Performance Tuning, High Availability Disaster Recovery (HADR), IT Project Management, ELT, Data Modeling, Cloud, Site Reliability Engineering (SRE)
Paradigms
ETL, Business Intelligence (BI)
Platforms
Azure
Frameworks
Windows PowerShell
Libraries/APIs
Azure Blob Storage API
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
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