Popis životopisu
Highly knowledgeable and experienced Top DBA, Database Developer and Data Scientinst/Big Data engineer with business-savvy and driven nature. Proactive and resourceful professional with track record of success in designing developing and managing relational, NoSQL databases and modules to ensure customer needs are met and satisfaction remains high with every project.
Zkušenosti
01.09.2016 – 01.07.2017
AO "Fintech"
Senior DataBase Developer
● Analysis and research of existing PostgreSQL code, database architecture, relationships, and constraints; ● Designing databases (entity-relationship); ● Modification of existing code for PostgreSQL, in order to improve the quality of the work; ● Development of new functionality for new versions of the software subject to the restrictions of the previous version.
01.03.2014 – 01.06.2015
Bosca Fashion Group
DevOps
● Involved in administration of ERP System “Nebim” via MS-SQL ● Working with databases (T-SQL, DML, DDL, UDF, indexes and statistics) ● DBA MS SQL 2008 (failover clustering and HA Groups, partitioning of views, SSRS, DMV) ● Developed Telegram message bot in case of monitoring MS-SQL server status (SSIS, Telegram API) with authorization via certs. ● Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support. ● Migrated DTS packages to SSIS packages
01.05.2015 – 01.09.2016
OSG Record Managment
DBA
● Involved in administration of DWH and DocFlow systems (rssql, MS Windows Servers + Docuware + MS SQL + IIS + Exchange) ● Working with databases (T-SQL, DML, DDL, UDF, stored procedures, RBS(BLOB)) ● DBA MS SQL 2008 (failover clustering and HA Groups, partitioning of views, SSRS, DMV) ● DBA Postgres ● Implement and administering of monitoring systems (nagios, munin, monit, datadog) ● Developed applications for company analytics (C#,ADO.net) ● involved in implementing and administration of Asterisk (CentOS 5)
01.07.2017 – Do teď
Progress ltd.
Senior DataBase developer
● Database design, scripting migration of database structure, installation/configuration/refinement; * Active interaction with development team, business and preparation of recommendations for application developers; ● Maintain project documentation on the database. ● Understanding of principles of operation and characteristics of the DBMS to PostgreSQL. ● PL/pgsql dynamic SQL. ● Reading query plans, optimization. ● Work with extensions (extensions) PostgreSQL (*PostgreSQL hstore, postgis, ltree, postgres_fdw, pgrouting etc.) ● (Json, jsonb or XML) in a PostgreSQL DBMS. ● Database maintenance (vacuum, analyze, freeze). ● Working with databases in production. ● Work in the design tools database (power designer, Erwin) ● Full-text search ● Data marts Development ● Development of analytical reports (report designer pentaho) ● Development and maintenance of ETL (pentaho data integration) ● non-relational databases (redis, mongodb) ● Work with a stack of pentaho ● OLAP cubes Development ● DBMS ClickHouse (tabix)
