DBA / Database

How do transactions work in SQL Server?

Which grant is used to authorize the execution of a procedure?

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?

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

Explain the difference between WHERE and HAVING

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

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

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

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

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

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?

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

Middle+

Иннотех

What PostgreSQL parameters do you know for performance tuning?

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

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

Determine the tense of the verb and fill in the blank: 'Why ___ he calling now? Is it urgent?'