DBA / Database

What are hints and which specific hints have you used?

What do you know about Agile methodology and Scrum?

Tell me how you made backups on the project that you used.

Tell about the team composition on the last project.

What is LSN and how is it used to monitor replication lag?

What do you know about Git? What are pull requests and merge requests used for?

What configuration files do you know for PostgreSQL and what are they used for?

Заполните пропуски в предложениях (упражнение на времена глаголов): Will they help us next week?

Briefly tell about the previous project.

Tell me about indexes: when you create them, when it is good, and when it is bad?

What are window functions? Which ones have you used? How do they differ from GROUP BY?

Tell me about the main processes of PostgreSQL.

What is the difference between COUNT(*) and COUNT(1) — which one is better to use?

Task 1: Find the top 5 routes (departure_station, arrival_station) by the number of tasks for January 2025 from the harvester_tasks_queue table.

How does the locking mechanism and lock escalation work in SQL Server?

What are triggers? What types of triggers are there?

What is the difference between log shipping and incremental backup?

What is a primary key and a foreign key? What is the difference between them?

Was the data schema normalized in your project? How did you approach normalization?

How to approach designing tables with hundreds of millions of records?