Контактна інформація

Шукач вказав телефон та ел. пошту.

Отримати контакти цього кандидата можна на сторінці https://www.work.ua/resumes/3600206

Досвід роботи

Senior Software Developer

з 09.2016 по нині (7 років 8 місяців)
INEK-Donetsk, Харьков (IT)

Development of the billing for a new paid streaming subscription service. The system is designed for calculating the content consumption by subscribers: issue invoices, calculation payments to content owners, integration with payment systems.



Environment: PostgreSQL, Python, SQL, PL/pgSQL, JSON, XML, Git, PowerDesigner, Amazon AWS: Looker, Data Pipeline, Redshift, AWS RDS, DynamoDB, AWS Lambda, AWS Athena.



The development of architecture on Python application.

The development of ETL to load data from DynamoDB to RDS PostgreSQL with use looker-API (coding on Python). And ETL to load data from RDS PostgreSQL to Redshift DWH (AWS Data Pipeline).

The development of logical and physical structure a database (including tarification schema).

Write stored functions PostgreSQL (PL/pgSQL)

Implementation of tarification scenarios (Python and PL/pgSQL)

The development of integration with payment systems (Vantiv, HyperWallet)

Senior DB Engineer, DB Engineer

з 04.2008 по нині (16 років 1 місяць)
INEC-Donetsk, Харьков (Maintenance and development of the billing systems)

Maintenance and development of the billing system "Unified automated system of complex calculations" (EASKR). The system is designed to automate the business processes of telecommunication companies for the installation, removal of technical equipment, stocks, tariff plans, traffic accounting and income / expenses of the company; construction of technical, statistical and accounting reports, tax records. Issue invoices to customers

Environment: SQL, XML, PL\SQL Developer, iReport, Subversion, Oracle, HP/UX, DBF.

Optimization PL / SQL and SQL code (hints). Optimisation of the physical structure DB (partitioning, indexing).
Development of ETL to load structured data from external systems in CSV format, DBF.
Create a system of data exchange with internal systems and external systems of the fiscal authorities, by means of DB-link, as well as structured data in XML format.
Development of universal XML structures for billing users of different groups.
Development and maintenance of synchronization with the GIS-system via a web service
Recovering damaged data, using Flashback
Data merge from multiple standalone databases to a single multi-tenant database.
Create reports of various format, such as TXT, PDF, XLS, DBF.
Introduced implementation of SQL queries with Oracle Analytical Functions; SQL queries runs 2 times faster.
Write stored procedures, triggers.
Synchronizing data in multiple databases.
Direct and remote communication with customers, requirement analysis.

DB Engineer

з 01.2006 по 04.2008 (2 роки 3 місяці)
KP SPKB ASUV, Харьков (Maintenance and development of the billing systems)

Maintenance and development of the billing system "Engineer by industry and individuals". The system to automate accounting water supply and sanitation.

Environment: SQL, PL\SQL Developer, Borland Delphi, Borland Kylix, CVS, Oracle, ASP Linux, DBF.

Write stored procedures, triggers, reports.

Sysadmin

з 09.2004 по 01.2006 (1 рік 4 місяці)
KP SPKB ASUV, Харьков (Maintenance and development of the billing systems)

Environment:BASH, Python, FreeBSD, ASPLinux

Setup and connection of internet and database servers.
Configuration and support iptables, squid, ldap, SMB, NFS, File-server, Jabber...

Assistant sysadmin

з 09.2002 по 08.2004 (1 рік 11 місяців)
KP SPKB ASUV, Харьков (Maintenance and development of the billing systems)

Lan Support.

Освіта

National University "Yaroslav the Wise Law Academy of Ukraine"

Specialist, lawyer, Харьков
Вища, з 2004 по 2009 (4 роки 5 місяців)

Kharkiv National University of Radio Electronics

Applied Mathematics Specialist, Харьков
Вища, з 1997 по 2002 (4 роки 10 місяців)

Знання і навички

Знання мов

Англійська — середній

Додаткова інформація

10 years of experience as an Oracle DB developer

Expert in SQL and PL/SQL, DB design, implementation and support.Strong experience in reporting and ETL. Additional experience includes disaster recovery, capacity planning and user support.

Excellent problem solving and interpersonal skills.
Strong analysis and reporting skills