Publication
MySQL Master-Slave Replication on the Same Machine
https://www.toptal.com/developers/mysql/mysql-master-slave-replication-tutorial
Ivan is available for hire
Hire IvanIvan Bojovic
Verified Expert in Engineering
Database Developer
Belgrade, Serbia
Toptal member since November 26, 2015
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, Transact-SQL (T-SQL), Database Design, Linux, Windows...
Freelance
PL/pgSQL, Transact-SQL (T-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
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, Transact-SQL (T-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 Command Line Interface (CLI), Database Architecture
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, Transact-SQL (T-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 Command Line Interface (CLI), Database Architecture
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, Database Architecture
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, Database Architecture
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, Database Architecture
Project History
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
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 Command Line Interface (CLI), TFS, Jira, Bugzilla, TortoiseSVN, Oracle RAC, Confluence, pgAdmin, Amazon Cognito, AWS AppSync, GitHub, Notion
Languages
Transact-SQL (T-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, Database Architecture, 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.
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