Python

Have you ever optimized queries and searched for heavy queries in PostgreSQL?

We'll wrap the model in a container, right?

Optimizing PostgreSQL for high write load (500+ records/sec)

Why did you decide to leave the team?

How to run synchronous blocking code (for example, a 1-second computation) in FastAPI on a route without blocking the EventLoop?

Middle

СБЕР

We have a dual-lever database — master and replica. We made a transaction, it went through, data appeared on the master. The power went out on the replica, the server crashed, data did not arrive there. What will happen when the server is restored?

CREATE TABLE public.ntik_model_case ( case_id serial4 NOT NULL, parent_case_id int4 NULL, CONSTRAINT ntik_model_case_pkey PRIMARY KEY (case_id), CONSTRAINT ntik_model_case_parent_case_fkey FOREIGN KEY (parent_case_id) REFERENCES public.ntik_model_case(case_id) );

The bank [name] wants to send SMS about a new mortgage offer not to all clients, but only to targeted ones — what model is needed here and what is important to consider from a business perspective?

What are metaclasses in Python? Why are they needed if inheritance exists?

What is the difference between the operators == and is?

What is GIL in CPython?.

Senior

amoCRM

Tell us a little about yourself: work experience, what you are looking for, why you decided to change jobs?

Middle

СБЕР

What are the differences between network and disk I/O from the perspective of asyncio in Linux?

Tell about exception handling in Python: what is the structure and what are its blocks?

# 2. Write a metaclass that prohibits subclasses from overriding the do_not_override method if it exists in the base class.

What is the difference between threading and asyncio?

Why did you decide to switch to development?

What does the process from commit to deployment on the stands look like?

Middle+

СБЕР

Tell about your work experience and current project (HR question)

Does HTTP work on TCP or UDP? How does HTTP/3 ensure reliability over UDP?