Aleh Dushkin - CV PostgreSQL DBA

Projects (Work experience more than fifteen years)
Company Robust Integrity LLC
Period From 11.2021 Present time
Job Position PostgreSQL DBA
Customer Robust Integrity is Home automation and artificial intelligence company
Participation Duties: PostgreSQL database installation, configuration and performance tuning, data import and export, database reliability and scalability, backup and recovery, replication, ETL procedures, data engendering design.
Database system for marketing to identify potential customer based on messages in social networks and channels. BERT NLP Neural Network model was used and trained on gathered data. As a result from application the right moment to make an offer to the potential customer was identified.
Participated in product roadmap design, plan development. Estimate feasibility, provide flexible solution architecture for hardware and software components.
Implemented performance monitoring, identifying and preventing performance problems, running vacuum, index rebuild, and identifying slow queries, provided recommendations for index creation and database structure.
Tools
PostgreSQL, PgBouncecr, Python, C#, Linux

Methodologies SCRAM, Kanban, Lean, XP, Critical chain

Company AVIDACARE LLC
Period 03.2018 11.2021
Job Position PostgreSQL DBA
Customer AVIDACARE is an innovative company, developing and bringing new products to the market in telecommunication and healthcare industries.
Participation Duties: PostgreSQL installation and performance tuning, partitioning, data import and export, database reliability and scalability, data transformation for analysis.
Database implementation for automatic robotic dispensing of medications and related medical service platform, interop API to web .
Database performance tuning for Image Recognition, was used to real-time identification of Bar and QR Codes on a package with medications. Challenge was camera, light and surface unique distortions, so a series of images was stored.
Data analysis for medication compliance.
Integrate Blue Tooth blood pressure measurement device data.
My tasks include:
- I was responsible for finding solution in crucial image-recognition and video-conference data storage
- research and development for robotic medication dispense database
- tasks assessment, planning and scheduling
- manage support team
- ensure timely execution of tasks, making changes to the requirements, guidelines for documentation
- participated in new job candidates interviews
Tools
PostgreSQL, PgBouncecr, pgBackRest, Python, C#, Enterprise architect, Mono, Microsoft Visual Studio

Methodologies SCRAM, Kanban, Lean, XP

Company AVIDAMO (GH holding AG, Switzerland)
Period From 04.2015 03.2018
Job Position Database Solution Architect
Customer AVIDAMO is an innovative company, developing and bringing new products to the market in telecommunication and healthcare industries.
Participation PostgreSQL database installation, support and development.
Developed a platform for healthcare (participated in hardware and software development), remote VOIP communication, alarm handling, ability to order products, value-added services (internet radio, weather plugin)
Managed a distributed virtual team, discussed project goals with customer, estimated the work breakdown, explained tasks to developers and reviewed team performance, developed server data structures and procedures, document turnover, interfaces to billing and call center, visual interface and web access API.
I maintained project plan and groom backlogs for sprints, arrange the challenges according to strategic business values, facilitate team communication, delegate the development objectives and control the deliverables.
Tools
PostgreSQL, PL/SQL, Python, C#, Mono, Microsoft Visual Studio, Microsoft Project, Enterprise architect, XMind, Web API, Java script, HTML,

Technologies Microservices architecture, WebApi, WebSockets, PostgresQL, Linux, WPF, ASP.net, IIS, MVC

Company Belsoft Traning Center
Period From 03.2014 07.2014
Job Position Traner
Customer Belsoft – enducational center
Participation IT Trainer/Coach – lectures and Trainings in relational database technology, ITSM/ITIL

Company TechCall (USA)
Period From 03.2011 04.2015
Job Position Database Team Lead
Customer TechCall is a global software outsourcing company
Participation Participated in several projects for US Enterprise customers (financial and retail business). Planned development activities, Designed the architecture of automated trading systems and environment for real-time order execution system in financial markets. Took part in development of trading system and algorithms for trading in US stock and ETF securities.
My duties ware spanning the domain area and development, to find creative ideas, estimate requirements, and plan for implementation sprints.
Leaded the development and support activities for financial database systems for clients form USA. The projects included data mining, BI, and support for software and hardware.
The scope of my responsibility included development and planning, support, mentoring new team members, designing the database solution architecture and producing necessary project documentation.

Tools
PostgreSQL, Oracle, C#, Microsoft Visual Studio 2012, SQL, Jira, Microsoft Project, MatLab.

Technologies ASP.net, MVC, IIS, Oracle, Exadata, Linux, Multithreading

Issued by State University,
“Physics and Electronic” department,
1993-1998.

Issued by Economics Academy
2009
“Financial and Bank business”, Diploma with excellence.

Database Management Systems

PostgreSQL, Oracle, MySQL, MSSQL

Programming languages

Python, SQL, PL/SQL C#, Perl,
Java Script, C++


Methodolgies

Agile, SCRUM, Kanban, Waterfall, PMI/PMBOK

System Analysis

Enterprise Architect, XMind, SWOT,
Prototyping, Requirements analysis

Tools and technologies

PostgreSQL, PL/SQL,
pg_dump, pg_repack, pgbench, pgbackrest
Oracle RAC, Oracle DataGuard,
git, Jira, VSCode,
Python, Shell, .Net
Data Analysis, Data Science,
TCP/IP, UDP

Operating systems

Linux (Debian, Ubuntu, CentOS, OpenSUSE)
Windows, WindowsServer, Windows Embedded
AIX

Английский

<p>Foreign languages<br>
English (Fluent) IELTS 7.0</p>

<p>Additional Trainings:<br>
- PostgreSQL administration<br>
- Database performance tuning<br>
- Oracle Database Certified Professional <br>
- Business and personal development<br>
- System Analysis<br>
- Logic structural approach to problem solving<br>
- Leadership, public speech<br>
- Agile, SCRUM Certified <br>
- ITIL v.3 Foundation<br>
</p>