Scroll To View More
Ivan Bojovic, Database Developer in Belgrade, Serbia
Ivan Bojovic

Database Developer in Belgrade, Serbia

Member since October 14, 2015
Ivan is a senior database specialist with experience in database design, database architecture, database optimization, database administration, and database development. He has over 11 years 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.
Ivan is now available for hire

Portfolio

  • LeadIT
    PostgreSQL, MySQL, Oracle, SQL Server, Data Science
  • Freelance
    MySQL, PostgreSQL, SQL Server
  • Fincore
    Oracle RDBMS, Oracle RAC on Exadata, Oracle PL/SQL

Experience

  • SQL, 13 years
  • Query Optimization, 11 years
  • MySQL, 11 years
  • Oracle, 11 years
  • Database Design, 11 years
  • Microsoft SQL Server, 6 years
  • PostgreSQL, 5 years
  • Data Science, 2 years
Belgrade, Serbia

Availability

Part-time

Preferred Environment

Any OS, TOAD, MySQL Workbench, pgAdmin III

The most amazing...

...thing I've recently worked on is the redesign of a large PostgreSQL database and the migration of that database to MySQL on AWS.

Employment

  • 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: PostgreSQL, MySQL, Oracle, SQL Server, Data Science
  • 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: MySQL, PostgreSQL, SQL Server
  • 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: Oracle RDBMS, Oracle RAC on Exadata, Oracle PL/SQL
  • 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: Oracle RDBMS, Oracle PL/SQL, Oracle DWH, Apteco FastStats
  • 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: MySQL, PostgreSQL, Informix, Oracle

Experience

  • MySQL Master-Slave Replication on the Same Machine (Publication)
    Developers often work on only one machine, and have their whole development environment on that machine. Testing database replication before deploying changes in this kind of a development environment can be a challenging task. In this article, Toptal engineer Ivan Bojovic guides us through a step-by-step tutorial on how to implement MySQL master-slave replication on one machine.

Skills

  • Languages

    SQL, PL/pgSQL, Bash Script, T-SQL, Python
  • Tools

    MySQL Performance Tuning, Sybase PowerDesigner, Toad, MySQL Workbench, TFS, Jira, Bugzilla, TortoiseSVN, Confluence, pgAdmin
  • Paradigms

    Database Design, Data Science
  • Platforms

    Linux, Oracle, Xamarin, MacOS, Windows, Jupyter Notebook, Amazon Web Services (AWS)
  • Storage

    Database Replication, MySQL, Database Modeling, PostgreSQL, Oracle PL/SQL, Microsoft SQL Server, SQL Server Management Studio, IBM Informix Dynamic Server
  • Other

    Query Optimization, Probability Theory, Machine Learning
  • Libraries/APIs

    Scikit-learn, Matplotlib, NumPy, Pandas

Education

  • Certificate - Python for Data Science in Data Science
    2017 - 2017
    UC San Diego - Online
  • DBA Certificate in MySQL
    2009 - 2009
    Oracle University - Athens, Greece
  • Master's degree in Mathematics and Computer Science
    1999 - 2007
    University of Belgrade - Belgrade, Serbia
I really like this profile
Share it with others