Position: Web Developer
Category: Python
English level: upper
Years of experience: 1


Developed 3 data solutions and prepared the data for trading strategies using pipelines and ETL/ELT.
Improved data accessibility by tuning the database and partitioning the tables which increased data searchability by 60%.
Designed and managed Postgresql database, including clustering, indexing, Timescale DB, Time-series db, replication, partitioning, pgcli, citus, and distributed db. 
Established blockchain infrastructure for data science pipelines (ELT/ETL pipelines) to combine trading data from cryptocurrency exchanges with Ethereum and Bitcoin's blockchain data using Docker and RPC connections.
Experienced in using AirFlow (including Python DAGs, Redis, Celery, and Postgresql metastore) to eliminate 90% of the existing challenges. The tool installed using Docker Compose.
Established FastApi framework to design and deploy 4 microservices and applied Sqlalchemy to access databases using ORM, Uvicorn to run the framework on the web, and Docker and Traefik to add SSL and load balancing.