DBA / Database

How do transactions work in SQL Server?

How is AlwaysOn Availability Groups configured and what is the role of Windows Server Failover Cluster in this process?

Middle+

Иннотех

Provide an interesting problem you solved at your previous job.

Is it possible to throw exceptions inside a trigger? What will happen to the database and the RS Bank interface?

What motivated you to leave your last job?

What do you know about Docker and Kubernetes? How did you install and run PostgreSQL in Docker?

How to return a value from a procedure using a REF CURSOR?

What memory parameters do you know in PostgreSQL? Tell about work_mem, shared_buffers, and effective_cache_size.

How to perform a major upgrade of PostgreSQL in a Patroni cluster?

Have you heard of Nested Loop Join? What is it and when is it used?

Explain the difference between WHERE and HAVING

How do you understand that these specific indexes on these columns will help achieve performant queries? How do you determine high selectivity?

What do you know about CI/CD concepts and Jenkins?

What is the difference between synchronous and asynchronous replication modes in AlwaysOn?

Middle+

Иннотех

How will you create a Disaster Recovery Plan and set up failover in MS SQL Server and PostgreSQL?

Task 5: EXPLAIN shows type: ALL, rows: 200000, Using temporary; Using filesort. What does it mean and how to optimize?

What PostgreSQL parameters do you know for performance tuning?

How are Windows Server Failover Cluster and AlwaysOn Availability Groups related — are they interchangeable or complementary technologies?

Middle+

Иннотех

Translate the sentence: 'It helps now' (Present Continuous)

Discuss which of the developer problems from the video affect you personally (developer frustrations)