Ігор

Vacancy Senior Database Administrator (PostgreSQL, AWS).

Work experience

2015 - 2019 PrivatBank Db Engineer, DevOps.
monitoring, support for MySql Perl fast payment service.
Monitoring AWS Python Prometheus services.
DevOps support - environment deployment on servers and AWS.
Working with Athena, S3, Glue, App Runner, EC2, Auto Scaling, RDS, Redshift,
Lake Formation.
Created a Docker container for microservices.
Self-study with Kubernetes.
Written RegEx for Logstash.
Created Zabbix metrics and dashboards.
Kiiko Ihor.
Wrote a Python script OpetCV - mask face recognition.
Zaporizhzhe 69059
Wrote a Python script OpetCV - searching people's and tracking movements in
Ukraine
large video streams of.
[відкрити контакти](див. вище в блоці «контактна інформація»)
Wrote a Python script with scikit-learn and Seaborn for backoffice.
[відкрити контакти](див. вище в блоці «контактна інформація»)
Wrote a Python WebScraping model.
Skype zap-tar-13
Citizenship Ukraine
Category B driving license.
2019 - 2021 AlfaBank Leader PostgreSql.
monitoring and support of 20 production PostgreSql servers and 20 dev servers.
Language skills
PostgreSql 9.5 10 11 12.
Ukrainian, Polish,
English B1.
Query optimization - explain. Database migration and restoration. Porting the
database from the server to the Azure PaaS service and setting up access and
monitoring in the ecosystem.
Working with Azure Monitor, Azure for PostgreSQL.
Greenplum cluster development.
Development of a monitoring system with AI elements.
Self-study with DWH-Data Lake - Snowflake

2021 - 2021 Epam Azure Db Engineer.
Attestation training.
Working with Azure Data Explorer, Databricks, Anomaly Detector.
In 3 months of study, I did not pass the English language test. A2 instead of B1.
Junior's proposal did not suit me.
Self-study with Azure Stream Analytics, PySpark, SparkSQL, Apache Airflow,
Nifi.

2022 Tamga Db Engineer, Data Scientific.
Build of queries for sampling data from the OLAP cube and database to create a
scoring system. Calculation of statistical parameters of data from requests.

Design, installation, support: PostgreSql, MySql, Redis, MongoDb.Extensions
TimescaleDB, PipelineDB, pg_stat_statements, hstore.Self-learning:
Greenplum, Redshift, Snowflake. Setting up replication, Upgrade database
version. Use of systems of high availability of services
/ balancing sharding partitioning /.
Deploying instances in the clouds AWS, Azure, Google.
Working with services: EC2 - S3 - Athena - Redshift - AutoScaling.
Self-learning: App Runner - Lake Formation - RDS- Glue- SageMaker.
Working with services: Azure Monitor - Azure for PostgreSQL.
Self-learning: Data Factory - Azure Functions - ServiceFabric-Database
Migration Service - Data Explorer - StreamAnalytics-Anomaly Detector -
Databricks.
Self-learning: BigQuery.

Load testing tSQLt, SQLQueryStress.
Explain source profiling.

Porting - PostgreSql to Azure PaaS.
Introduction to technology: ОLAP - OLTP - DWH- DataLake.

Monitoring with: Zabbix, Prometeus, Percona Monitoring, pgCluu.
Development of streaming monitoring with AI elements.

Use of Scikit-learn - regression, search for anomalous data, datacleaning,
classification, clustering, data dimensionalityreduction,signal classification
and prediction.

Programming in languages Perl, Python, SQL, Bash, C. For graphical
presentation of data, I used - Seaborn.
Introduction to technology: Apache Nifi, Kafka, Airflow.

Writing test cases. Code test coverage calculation.
Creation of boundary tests

Additional Information.
Courses: Cloud Guru: - Linux – Azure.
Area of interest: BigData, Data Science, ML, DL.

Online profile.
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
resultType=PASSED