Ivan Boitcov

Senior

Registration: 26.05.2022

Specialization: Database Architect

— Experienced Database Architect with 9+ years of designing and implementing cloud-based data solutions. — Specialized in AWS (RDS, Lambda, S3, EC2), with a strong focus on large-scale data migrations, high availability, and performance optimization across different RDBMS. — Experienced with NoSQL and columnar databases. — Skilled in infrastructure automation (IaC) and translating complex business needs into scalable, efficient data architectures. — Proven track record of working with cross-functional teams in Agile/Scrum setups.

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

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.

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)

Skills

Java

Python

PostgreSQL

Oracle PL/SQL

OOP scripting

SSIS (VS)

Talenda

Data grabbers

DevExpress

Metabase

SSRS

ETL

GitLab CI/CD

AWS

Bash

Oracle Apex

CI/CD

.NetCF

JSON/ XML

JQuery

SQL Server

SSAS

Jira

XML

Database Design

Query Optimization

Performance tuning

Partitioning

Replication

Data Migration

ETL

DWH

Security Management

Data Integrity

Data Auditing

HADR

Sharding

JasperReports

Oracle Apex

Airflow

ClickHouse

Greenplum

MongoDB

DynamoDB

Work experience

Database Architect

since 04.2025 - Till the present day |100HP Gaming

Oracle PL/SQL, PostgreSQL, PG, JSON, AWS, Data Lake, GitLab

● Optimizing database and cloud infrastructure to enhance data reliability, performance, and scalability across expansive gaming platforms.

Data Storage Architect

12.2024 - 04.2025 |Blockchain Sports

AI, PostgreSQL, AWS, Data Warehouse

● Designed a blockchain-based storage system from scratch at Atleta Network: led the design of a blockchain-based data storage layer focused on permanent file persistence with minimal retrieval latency and cost. Scope included architecture, proof-of-availability, TEE integration, and planning for Stage 2 deployment. ● Helped scale CryptoNavigator.AI project by driving monolith decomposition into microservices, implementing performance optimizations, setting up monitoring and data flow architecture, and advising the team on scaling strategies for future growth and data volume.

Senior Database Developer / Architect

06.2022 - 12.2024 |Softeq

PostgreSQL, AWS, SSL

Gjgardner - Construction Portal and mobile app. ● Achieved 20% reduction in AWS instance costs by optimizing PostgreSQL performance and query execution plans. ● Ensured 99.99% database uptime by implementing HA strategies with automated failover, replication, and scheduled maintenance on AWS RDS. ● Increased mobile app adoption by 35% through the design of an offline-first architecture, enabling remote access to construction data with seamless sync. ● Resolved recurring critical alerts and improved stability by configuring AWS CloudWatch and Performance Insights for proactive database monitoring. ● Improved database security posture by enforcing role-based access control, auditing privilege changes, enabling SSL connections, and implementing regular backup integrity checks.

Database Specialist

09.2021 - 06.2022 |Paysend

AWS, Oracle, ETL, PostgreSQL, data flow

● Optimized ETL processes, reducing load times for real-time financial data and improving data integrity. This involved the migration of ETL pipelines from Oracle instances to PostgreSQL, streamlining data flow, and enhancing system performance. ● Conducted a comprehensive audit of financial ETL processes, identifying and resolving data discrepancies in annual financial reports.

SQL Developer

08.2019 - 07.2021 |Forrards Group outsourcing

AWS, Oracle, ETL, SQL Server, VBA, PostgreSQL, .Net2.5

Worked on multiple client projects as part of outsourcing and outstaffing teams. ● Migrated legacy systems from outdated on-premises solutions (SQL Server + VBA) to PostgreSQL + Jasper-Reports, reducing licensing costs and long-term operational expenses. ● Led a team of four database developers on an EdTech migration, owning planning, code reviews, and delivery. ● Set up ETL pipelines for seamless data transfer and automated transformations, ensuring data integrity and performance for an EdTech migration project. ● Directed the migration from legacy on-premises Oracle to PostgreSQL on AWS RDS, reducing licensing costs and improving system scalability and performance.

ETL Developer / Database Specialist

06.2018 - 08.2019 |GoodBrains ‑ Voiceman

MVP, DBA, IoT, .NetCF, Java 8, PostgreSQL

VoiceMan - Voice-Activating Warehouse System (smart devices and IoT). ● Played a pivotal role in an IoT startup for warehouse automation, going beyond DBA responsibilities to contribute to the development of a mobile application. ● Delivered an MVP for a voice-activated warehouse management system, securing a grant and enabling the company to successfully enter neighboring markets.

SQL Developer

11.2016 - 06.2018 |Smart IT

ETL, PostgreSQL, Java 8, Oracle Apex

Monetka - Accounting & Store/Warehouse Ops for a Retail Chain. ● Built a custom ETL pipeline to sync Oracle master clusters with PostgreSQL, cutting sync time by 30%. ● Migrated web portal from Oracle Apex 4.2 to 5.0, reducing maintenance by 20% and improving stability. ● Boosted sales efficiency by 15% through algorithm-driven data analysis. ● Developed and implemented an accounting and management system for stores and warehouses, optimizing business processes and improving sales efficiency.

Educational background

Engineer (Bachelor’s Degree)

2011 - 2016

USPU, Ural State Pedagogical University, Engineering in information technology

Languages

RussianNativeIndonesianIntermediateSpanishElementaryEnglishUpper Intermediate