My name is Aleksandr Shelemetev and I live in Bulgaria.
I've been working in the IT industry since the 1990s. I have held various roles such as software developer, analyst, system administrator, DBA, and project manager. I received my engineering degree in 1994. I studied Python and Go in 2017-2018 on Coursera courses.
Currently, I work as a senior software engineer for Gcore company and study Haskell on a `University of Helsinki` course.
I've written a Short SQL Tutorial, which is currently only available in Russian, but I've also written posts about database architecture and SQL query optimization on the Codingsight site.
Python, Flask, Django, Celery, asyncIO, Go, Golang, REST, GraphQL, API, SQL, PostgreSQL, MySQL, MS SQL, TSQL, Oracle, PL/SQL, DBA, RabbitMQ, Redis, Git, GitLab, DevOps, docker, k8s, Kubernetes, DroneCI, CI/CD, Linux, microservices.
I've also worked with HTML, CSS, JavaScript, Node.js, Vue.js, Nuxt, Angular, d3js, Java, Haskell, nginx, ClickHouse, S3, .NET, C++, MS VBA, Delphi, and Pascal
My experience includes working in the following domains: Billing, Customer service, Insurance, Logistics, Document flow
The 1000(?)X speed-up with a decreased resource utilization. You can see the effect below.
The amount of time the task queue was processed in minutes instead of hours
DB CPU utilization was reduced
DB locks started to look insignificant
The acceleration of service activation is a significant improvement for clients. It means that they no longer have to wait for long periods of time before the service becomes active. The reduced activation time of 4 seconds is much faster than the previous duration of more than 10 minutes. This is likely to lead to a better overall experience for the client and may even result in increased customer satisfaction.
Before:After:
Assembly and testing of the project with a Drone CI is accelerated by 2 times from 12-16 minutes to 6-7 minutes.