Ivan F.

Ivan F.

Krapina, Croatia
Hire Ivan F. Hire Ivan F. Hire Ivan F.

About Me

Ivan is a highly skilled database specialist with over a decade of experience in various aspects of database management, including administration, development, business intelligence, and ETL. He boasts an MCSE certification, highlighting his outstanding proficiency in SQL Server. Throughout his career, Ivan has successfully engineered an automated application for trading securities, seamlessly integrated with stock exchanges. Additionally, he has crafted a comprehensive business intelligence sales solution for a prominent pharmaceuticals company. Ivan has also showcased his expertise in utilizing SSIS to establish seamless, bidirectional data integration between company applications and SAP. This integration involved crucial aspects such as staff, payroll, and organizational data.

AI, ML & LLM

SQL DML High Availability Disaster Recovery (HADR)

Backend

Azure Blob Storage API

Database

SQL T-SQL (Transact-SQL) SQL Server BI 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) SQL Server Reporting Services (SSRS) Azure SQL Database Performance SQL Server 2019

DevOps

Azure Cloud Services Azure

Other

Stored Procedure Microsoft Power BI Data pipelines JSON Data Engineering Data Architecture Reports Performance Tuning IT Project Management ELT Data Modeling ETL Site Reliability Engineering (SRE) Business Intelligence (BI)

Work history

Infobip
Sr DBA
2022 - 2024 (2 years)
Remote

  • SQL Server Administration - more than 600 servers and over 2500 databases.

  • High Availability

  • Replications

  • Performance tuning

SQLPro Consultants
Founder
2022 - Present (4 years)
Remote

  • Orion talent – Database optimization: query tuning and best practices setup.

  • StubHub - Migration of SQL Server databases from On-prem to AWS

  • QUAI ltd - Migration of SQL Server databases SSRS and SSIS from onprem, 2012 to 2022; performance tuning and implementing server level monitoring and alerting

  • Johnson & Johnson - Migration and optimization of a database imbued with intricate equipment and product information

  • GeneDx - Migration of SQL Server databases from Azure to Azure and Azure to OCI; creating Always on and replications from scratch, code optimization, and partitioning

  • Colorado State Legislative Branch - Migration of SQL Server databases and reporting services. On-prem, 2012 to 2019.

  • PMMC – Performance tuning. Optimizing 180 stored procedures. Final result, 10x less reads, 5x less CPU consumption, 5x faster execution times.

HRPRO
Sr Database Specialist
2017 - 2022 (5 years)
Remote

  • Database architecture

  • Code optimization

  • Azure and on-prem server administration

  • Code review

  • Performance tuning

Addiko Bank
Sr Database Associaate
2016 - 2017 (1 year)
Remote

  • Architecture and development of BI projects

  • ETL optimization

  • Project management

Education

Education
Master's Degree in Mathematics and Computer Science
University of Zagreb Faculty of Science (Mathematics Department)
2002 - 2009 (7 years)