Tell me about indexes: when to build them, when not to, and what types exist.
Senior
342
Kotlin
139
0
Tell me more about the billing service: what was stored, how did you interact with the contractor?
Senior
275
What is the difference between JSON and JSONB in PostgreSQL? What are the issues with Hibernate and JSON fields?
Senior
265
Have you used HQL, Native Query, JDBC directly? Batching in Hibernate?
Senior
237
Have you used Kotlin? Do you have experience?
Senior
231
Tell me about database sharding.
Senior
220
Tell me about replication in PostgreSQL: master-slave, what happens when a replica fails?
Senior
214
Do you know what Service Mesh is in Kubernetes?
Senior
209
How does the Dirty Checking mechanism work in Hibernate?
Senior
175
What does VACUUM do in PostgreSQL and why do dead tuples appear?
Senior
171
How to control load on handles (rate limiting)?
Senior
170
Have Kafka transactions (exactly-once semantics) been used?
Senior
167
Tell me about transaction isolation levels
Senior
167
Why can the Postgres query optimizer use Seq Scan in production but Index Scan in dev/ft with the same indexes?
Senior
160
Tell about partitioning in PostgreSQL.
Senior
158
Tell about optimistic and pessimistic locking, when to apply them?
Senior
158
Tell about monitoring and metrics in the project (Prometheus, Grafana)
Senior
156
Tell me about yourself and your work experience
Senior
156
How to solve the problem of concurrent updates of one entity from two Kafka topics (one topic overwrites changes from the other)?
Senior
155
What was the load on the services? What optimizations were applied?
Senior
139