Ivan is available for hire

Ivan Bojovic

Verified Expert in Engineering

Database Developer

Belgrade, Serbia

Toptal member since June 18, 2020

Expertise

Data Engineering MySQL Data Analysis API SaaS AWS RDS Excel Development SQL Database Database Administration

Bio

Ivan is a senior database specialist with experience in DB design, architecture, optimization, administration, and development. He has a lot of experience with MySQL, Oracle, PostgreSQL, and other database systems and is a certified MySQL DBA. He is a great team player with a proactive attitude. He is also proficient in AWS Serverless (Lambda, S3, AppSync, Cognito, DynamoDB, and more), as he used to work for five years as a back-end lead engineer in his own startup.

Portfolio

LeadIT

PL/pgSQL, T-SQL (Transact-SQL), Database Design, Linux, Windows...

Freelance

PL/pgSQL, T-SQL (Transact-SQL), Database Design, Linux, Windows...

Fincore

Database Design, Linux, Windows, Oracle PL/SQL, Oracle, Toad, SQL, Oracle RAC...

Experience

SQL - 17 years
Oracle - 11 years
Database Design - 11 years
Query Optimization - 11 years
MySQL - 11 years
PostgreSQL - 9 years
Microsoft SQL Server - 6 years
Data Science - 2 years

Availability

Part-time

Preferred Environment

MySQL Workbench, Toad, pgAdmin, MacOS, Visual Studio Code (VS Code), GitHub, Terraform, Notion, AWS Management Console

The most amazing...

...thing I've recently worked on is my own AI-based startup where I became proficient with AWS Serverless.

Work Experience

Owner, Senior Database Specialist

2016 - PRESENT

LeadIT

Designed a database (PostgreSQL) for the newest generation software for SBB (the biggest broadband company in South-Eastern Europe).
Successfully collaborated with two big clients via Toptal (SQL Server and PostgreSQL).
Optimized and redesigned the database for Embroker (a US company for online insurances).
Built a machine learning model (using Python) that predicts the final time for marathon runners based on their stats in the first half of the race.
Took part in the database development team in Fincore (Oracle PL/SQL).

Technologies: PL/pgSQL, T-SQL (Transact-SQL), Database Design, Linux, Windows, MySQL Workbench, Oracle, MySQL Performance Tuning, SQL, Data Science, Microsoft SQL Server, MySQL, PostgreSQL, Amazon Web Services (AWS), Amazon Aurora, Database Optimization, Database Administration (DBA), Database Modeling, Data Modeling, Data-driven Design, Data Architecture, Architecture, Amazon DynamoDB, NoSQL, Data Engineering, Databases, Scalability, AWS Lambda, Amazon RDS, Lambda Functions, Database Performance, SQL Server Management Studio (SSMS), pgAdmin, Python, Query Optimization, Database Replication, Sybase PowerDesigner, MacOS, Bash Script, Amazon Cognito, GraphQL, AWS AppSync, Amazon S3 (AWS S3), Stripe API, Shopify API, Amazon API Gateway, TypeScript 3, SQL Performance, Visual Studio Code (VS Code), Terraform, GitHub, Notion, AWS Management Console, Search, Docker, Data Recovery, Microsoft Excel, Data Pipelines, Database Structure, Database Transactions, Transactions, ETL, ELT, MySQL DBA, SQL Triggers, SQL Stored Procedures, Geospatial Data, MySQL Server, Oracle DBA, Database Development, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, ETL Tools, Snowflake, Agile, Data Auditing, Data Analysis, SaaS, Stored Procedure, API Design, Web Scraping, AWS CLI

Senior Database Specialist

2010 - PRESENT

Freelance

Optimized database performance in several freelance projects.
Migrated a PostgreSQL database to MySQL on AWS.
Redesigned a database solution in several freelance projects.
Optimized performance of numerous queries.
Automated database administration tasks in several freelance projects.
Designed a few MySQL and PostgreSQL databases from scratch.
Used SQL Server Spatial Data.

Technologies: PL/pgSQL, T-SQL (Transact-SQL), Database Design, Linux, Windows, MySQL Workbench, MySQL Performance Tuning, SQL, Microsoft SQL Server, PostgreSQL, MySQL, Amazon Web Services (AWS), Amazon Aurora, Database Optimization, Database Administration (DBA), Database Modeling, Data Modeling, Data-driven Design, Data Architecture, Architecture, Amazon DynamoDB, NoSQL, Data Engineering, Databases, Scalability, Amazon RDS, Database Performance, SQL Server Management Studio (SSMS), pgAdmin, Python, Query Optimization, Database Replication, Sybase PowerDesigner, MacOS, Bash Script, Amazon Cognito, GraphQL, AWS AppSync, Amazon S3 (AWS S3), Stripe API, Amazon API Gateway, AWS Lambda, TypeScript 3, SQL Performance, Lambda Functions, Visual Studio Code (VS Code), Terraform, GitHub, Notion, AWS Management Console, Search, Docker, Data Recovery, Microsoft Excel, Data Pipelines, Database Structure, Database Transactions, Transactions, ETL, ELT, MySQL DBA, SQL Triggers, SQL Stored Procedures, Geospatial Data, MySQL Server, Oracle DBA, Database Development, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, ETL Tools, Snowflake, Agile, Data Auditing, Data Analysis, SaaS, Stored Procedure, API Design, AWS CLI

Senior Database Specialist

2013 - 2016

Fincore

Introduced PL/SQL unit testing using SQL Developer.
Refactored a lot of poorly written PL/SQL code.
Helped the support team with numerous support requests related to Oracle.
Helped set up Oracle RAC on Exadata in the client's production environment.
Developed numerous new functionalities using PL/SQL.

Technologies: Database Design, Linux, Windows, Oracle PL/SQL, Oracle, Toad, SQL, Oracle RAC, Exadata, Oracle RDBMS, Database Optimization, Database Administration (DBA), Database Modeling, Data Modeling, Data Architecture, Architecture, NoSQL, Data Engineering, Databases, Scalability, Database Performance, Query Optimization, Database Replication, Bash Script, Bugzilla, TFS, SQL Performance, Visual Studio Code (VS Code), Search, Data Recovery, Microsoft Excel, Database Structure, Database Transactions, Transactions, MySQL DBA, SQL Triggers, SQL Stored Procedures, MySQL Server, Oracle DBA, Database Development, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, ETL Tools, Data Auditing, Data Analysis, PL/SQL, Stored Procedure

Senior Database Developer

2011 - 2013

GTECH

Contributed to PL/SQL development.
Maintained an Oracle DWH solution for several clients.
Wrote several Python scripts as part of the ETL process.
Designed and maintained a business intelligence solution in Apteco FastStats.
Helped design and optimize the database.

Technologies: Database Design, Linux, Windows, Oracle PL/SQL, Oracle, Toad, SQL, Oracle RDBMS, Database Optimization, Database Administration (DBA), Database Modeling, Data Modeling, Data Architecture, Architecture, Data Engineering, Databases, Scalability, Database Performance, Jira, Query Optimization, Database Replication, Bash Script, Bugzilla, TFS, SQL Performance, Search, Data Recovery, Microsoft Excel, Database Structure, Database Transactions, Transactions, ETL, ELT, MySQL DBA, SQL Triggers, SQL Stored Procedures, MySQL Server, Oracle DBA, Database Development, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, Data Auditing, Data Analysis, PL/SQL, Stored Procedure

Senior Database Architect

2006 - 2011

European Dynamics

Set up MySQL master-slave replication with automatic fail-over between two master nodes.
Designed several database solutions for very large projects.
Proposed a hardware and architectural solution for several large projects.
Administrated MySQL and Oracle databases on Solaris and Linux (including OS administration).
Participated in numerous technical and project meetings with clients.
Participated in all aspects of project cycles, including tendering, analyses, architecture, design, development, testing, delivery, and support.

Technologies: Database Design, Linux, Windows, MySQL Workbench, Oracle PL/SQL, Oracle, MySQL Performance Tuning, SQL, IBM Informix, PostgreSQL, MySQL, Database Optimization, Database Administration (DBA), Database Modeling, Data Modeling, Data Architecture, Architecture, Data Engineering, Databases, Scalability, Database Performance, Jira, pgAdmin, Python, Query Optimization, Database Replication, Sybase PowerDesigner, Bash Script, Bugzilla, IBM Informix Dynamic Server, TortoiseSVN, Confluence, SQL Performance, Search, Data Recovery, Microsoft Excel, Database Structure, Database Transactions, Transactions, MySQL DBA, SQL Stored Procedures, MySQL Server, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, Data Auditing, Data Analysis, PL/SQL, Stored Procedure

Experience

String Format Validator

A small Oracle PL/SQL function I developed, which uses regular expressions to check whether the input string matches the required format. I use it to validate different types of customer document numbers—passport, ID, tax number—as each type of document for each country has its own required format configured in our database.

Australian Curated Marketplace for Baby Equipment

http://www.markot.com

Markot is a curated marketplace for the most sought-after baby brands worldwide. It was a completely custom eCommerce solution done using the headless Shopify API. I was responsible for the whole back-end solution, including the fully custom bidding engine. The back-end solution is a full AWS serverless, using Cognito, Lambda, AppSync, DynamoDB, Aurora PostgreSQL, S3, API Gateway, etc. Terraform was used for managing the infrastructure. We enforced trunk-based development (regular deployments to PROD using feature flags, complete CI/CD solution using GitHub Actions, and massive coverage of end-to-end tests for web and mobile). I was responsible for the whole back-end team and coded a big part of back-end solution myself.

Optimizing DB Performance for Yoga Alliance

https://www.yogaalliance.org/

I was a part of the development team that maintained the Yoga Alliance system. I was involved in designing database schema for new features and writing complex SQL queries for analytics. Apart from that, I was responsible for fixing various performance issues.

Education

2017 - 2017

Certificate - Python for Data Science in Data Science

UC San Diego - Online

2009 - 2009

DBA Certificate in MySQL

Oracle University - Athens, Greece

1999 - 2007

Master's Degree in Mathematics and Computer Science

University of Belgrade - Belgrade, Serbia

Skills

Libraries/APIs

NumPy, Pandas, Stripe API, Shopify API

Tools

MySQL Performance Tuning, Sybase PowerDesigner, Toad, MySQL Workbench, Terraform, Microsoft Excel, AWS CLI, TFS, Jira, Bugzilla, TortoiseSVN, Oracle RAC, Confluence, pgAdmin, Amazon Cognito, AWS AppSync, GitHub, Notion

Languages

T-SQL (Transact-SQL), Python, SQL, Stored Procedure, PL/pgSQL, Bash Script, Snowflake, GraphQL, TypeScript 3

Paradigms

Database Design, Data-driven Design, ETL, Database Development, Agile

Platforms

Linux, Amazon Web Services (AWS), Oracle, AWS Lambda, MacOS, Windows, Jupyter Notebook, Docker, Visual Studio Code (VS Code)

Storage

Database Replication, MySQL, Database Modeling, PostgreSQL, Oracle PL/SQL, Amazon Aurora, Database Administration (DBA), Databases, Database Performance, PL/SQL, Data Pipelines, Database Structure, Database Transactions, SQL Triggers, SQL Stored Procedures, MySQL Server, Oracle DBA, Microsoft SQL Server, SQL Server Management Studio (SSMS), IBM Informix Dynamic Server, Amazon DynamoDB, NoSQL, IBM Informix, Oracle RDBMS, Exadata, Amazon S3 (AWS S3), SQL Performance

Other

Query Optimization, Database Optimization, Data Modeling, Data Architecture, Architecture, Data Engineering, Scalability, Amazon RDS, Lambda Functions, Search, Data Recovery, Transactions, MySQL DBA, Solution Architecture, Data, APIs, Technical Architecture, Monitoring, ETL Tools, Data Analysis, SaaS, API Design, Probability Theory, ELT, Data Auditing, Data Science, Machine Learning, Amazon API Gateway, AWS Management Console, Geospatial Data, Web Scraping

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