Open to opportunities

Oleh Pihnastyi

@olehpihnastyi

Message

Senior software engineer building secure AWS microservices and GenAI-powered backend systems with leadership.

Poland

Message

What I'm looking for

I’m looking for an environment where I can own backend and microservices on AWS, use GenAI/RAG in production, and keep improving performance through CI/CD and automation. I value Agile teams, mentorship, and aligning engineering work tightly with product goals.

I’m a Senior Software Engineer with 10+ years designing, developing, and optimizing enterprise-grade software solutions, including 5+ years in microservices on AWS. Over the last role, I developed AI-powered solutions for AWS DMS schema transformation using Amazon Bedrock and RAG, improving performance and efficiency for complex database migration scenarios.

I also focus on automation and metadata-driven migration workflows—designing solutions for loading and handling metadata for migrations across systems (e.g., Apache Hadoop to Amazon EMR using Hive metadata) and ensuring compatibility with RDS/Aurora and Redshift. With 4+ years of leadership experience, I coordinate delivery in Agile sprints, mentor teammates, and take ownership of modules end-to-end.

Experience

Work history, roles, and key accomplishments

Software Dev Engineer II

Amazon Development Center Poland

Jun 2021 - Jul 2025 (4 years 1 month)

Developed and supported AWS DMS schema conversion services using GenAI, designing solutions with Amazon Bedrock and RAG to transform schema elements during database migrations. Built metadata loading and processing solutions for migrations (including Hadoop to Amazon EMR via Hive metadata) and automated/optimized database migration for relational OLTP and data warehouse databases.

Team Lead, Software Engineer

DBBestTechnologies

Nov 2019 - Jun 2021 (1 year 7 months)

Coordinated team tasks for data loading and processing, provided recommendations for improvement, and trained new team members on workflows and software. Collaborated across departments to incorporate architectures and load metadata modules into database migration tools, and owned a module for statistical information preparation/processing for analysis of database dialects in migrations.

Data Loading Data Processing Team Coordination team training Metadata Integration Statistical Analysis of Database Dialects

Software Engineer

DBBestTechnologies

Dec 2015 - Nov 2019 (3 years 11 months)

Developed algorithms for loading metadata from various sources and handled customer needs related to metadata loading/processing modules. Performed code reviews, researched and analyzed new data sources for the application, and contributed to development strategy.

Java Spring Boot JPA Hibernate Docker SQL Pl SQL Junit Mockito Maven Gradle Git S3 Redshift Jira

Team Lead, PL/SQL Developer

BearingPoint, Inc

Nov 2013 - Dec 2015 (2 years 1 month)

Developed stored procedures for generating cashflow reports and reporting forms (journals, balance sheet, profit and loss) and supported implementation of the Debtors and Creditors module. Worked on PL/SQL-based reporting functionality within Jira-tracked development.

Pl SQL Cash Reporting Journal Jira Debtors and Creditors Module

Education

Degrees, certifications, and relevant coursework

National Technical University Kharkiv Polytechnic Institute

PhD (Doctor of Philosophy), Distributed Information Systems and Cloud Technologies

2010 - 2015

PhD (Doctor of Philosophy) at the Faculty of Computer and Information Technologies in the Department of Distributed Information Systems and Cloud Technologies.