← Back to list
senior
Registration: 26.05.2022

Ivan Boitcov

Specialization: Database Architect
— Database Architect with 8+ years of experience in cloud-based data solutions, specializing in AWS (RDS, Lambda, S3) and Azure Data Factory platforms. — Expertise in large-scale data migrations, high availability, and performance tuning across PostgreSQL, Oracle, and MS SQL Server environments. — Proficient in using IaC tools for infrastructure automation and optimizing complex data architectures. — Proficient in translating business requirements into effective technical solutions, while collaborating with cross-functional teams in Agile / Scrum environments.
— Database Architect with 8+ years of experience in cloud-based data solutions, specializing in AWS (RDS, Lambda, S3) and Azure Data Factory platforms. — Expertise in large-scale data migrations, high availability, and performance tuning across PostgreSQL, Oracle, and MS SQL Server environments. — Proficient in using IaC tools for infrastructure automation and optimizing complex data architectures. — Proficient in translating business requirements into effective technical solutions, while collaborating with cross-functional teams in Agile / Scrum environments.

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
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
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