← Back to list
Senior
Registration: 26.05.2022

Ivan Boitcov

Portfolio

Smart-IT - Simon

- Was engaged in the development of a trade management system in the retail company (more than 2000 stores), starting from scratch. - Developed own data integration system between Oracle database and PostgreSQL (Java 8 data grabber app). - Became a leading specialist in the company at Oracle Apex area (4.2 migration to 5.0 + writing plugins).

Goodbrains - Voice-man

Firmware development for mobile devices based on WinCE (.NetCF) and the integration of data into the PostgreSQL database via data grabber (Java 8)

Softeq - GJ Gardner

PostgreSQL + AWS Collaborate with FE / BE / BA members to release new features and business processes. Responsibilities: Working with PostgreSQL database: development, administration, solving problems of scaling and replication. Monitoring and maintaining AWS instances.

Skills

PostgreSQL
Oracle PL/SQL
OOP scripting (Bash / Python / C# / Java)
SSIS (VS)
Talenda
Data grabbers
DevExpress
Metabase
SSRS
ETL
GitLab CI/CD
AWS
Bash
Java
C#
Python
Oracle Apex
CI/CD
.NetCF
JSON/ XML
JQuery
SQL Server
SSAS
Jira
XML

Work experience

Data Storage Architect
since 12.2024 - Till the present day |Blockchain Sports
PostgreSQL, AWS, Data Warehouse
● Designing and building a data warehouse on Atleta blockchain network.
Senior Database Developer/Architect
06.2022 - 12.2024 |Softeq
PostgreSQL + AWS
Collaborate with FE / BE / BA members to release new features and business processes. Responsibilities: Working with PostgreSQL database: development, administration, solving problems of scaling and replication. Monitoring and maintaining AWS instances.
Database Specialist
08.2021 - 06.2022 |Paysend LLC
Oracle PL/SQL, PostgreSQL, PG, JSON, AWS, Data Lake, GitLab
• Development of financial business processes and logic in SQL (Oracle PL/SQL + PostgreSQL). • Looking for best solutions for the integration of financial data between the company and partners (considering data scaling). • Optimization of existing ETL/ELT processes (sources: Oracle, PG, JSON / XML data.) • Creating a new ETL processes for DWH and OLTP/OLAP. • Setting up and optimizing the structure of the database (PG) and its instances ‑ replication, sharding, backups, etc. • Setting access policies and roles for PG instances. • Implementation of an external BI reporting system based on Metabase. • Testing cloud storage solutions (AWS, Data Lake). • Documenting of all processes and existing legacy code in Confluence. • Working on a workflow optimization (was migrated all tasks and their assigners to Jira, helped set up replication and versioning systems in GitLab CI/CD)
SQL Developer
08.2019 - 07.2021 |Forrards Group outsourcing
PostgreSQL, .Net2.5, SQL Server, SSIS, SSAS, JQuery, DevExpress
• Development of a task and project management system for the government sector (.Net2.5 + PostgreSQL) • Financial exchange market startup in Southeast Asia (I was responsible for the development of the scalable architecture of the PostgreSQL database) • Managed a developers team on a project to migrate a reporting system (MSSQL 2012 + MS Access reports) to a new stack (MSSQL 2016 + DevExpress) for a large engineering company in the USA. • Individual Upwork projects: Car sharing aggregation app (PostgreSQL + JQuery), Alcohol distribution web‑portal (SQL Server + SSIS + SSAS)
Back-end developer
06.2018 - 08.2019 |GoodBrains ‑ Voiceman LLC
.NetCF, Java 8, PostgreSQL
• Was one of four people in a startup that produces smart warehouse equipment (warehouse management system and voice process control). Responsibilities: firmware development for mobile devices based on WinCE (.NetCF) and the integration of data into the PostgreSQL database via data grabber (Java 8).
SQL Developer
11.2016 - 06.2018 |Smart IT LLC
PostgreSQL, Java 8, Oracle Apex
• Moved to the IT department from the audit department to participate in the implementation of new business processes • Was engaged in the development of a trade management system in the retail company (more than 2000 stores), starting from scratch • Developed own data integration system between Oracle database and PostgreSQL (Java 8 data grabber app). • Became a leading specialist in the company at Oracle Apex area (4.2 migration to 5.0 + writing plugins) • Has grown to the senior developer of my department in one year, trained several new employees (ex‑students) after that.

Educational background

Engineer (Bachelor’s Degree)
2011 - 2016
USPU, Ural State Pedagogical University, Engineering in information technology

Languages

RussianNativeIndonesianIntermediateSpanishElementaryEnglishUpper Intermediate