DBA / Database

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

What are your current priorities when choosing a new job?

What is a transaction? Name the ACID principles.

Explain the phrase: 'Accept the things you cannot change' — what does it mean?

What timeout parameters do you know in PostgreSQL? Tell about lock_timeout, statement_timeout, transaction timeout, and session timeout.

BEGIN LOOP UPDATE table SET status = 'PROCESSED' WHERE category = 'OLD' AND ROWNUM <= 50000; EXIT WHEN SQL%NOTFOUND; COMMIT; END LOOP;

What type were subpartitions when range partitioning by month?

What is an autonomous transaction? How to use and declare it?

Tell us about the ACID principles — what does each letter mean: Atomicity, Consistency, Isolation, Durability?

Will using an indexed column speed up GROUP BY and ORDER BY operations?

What system databases are available in MS SQL Server?

What challenges were encountered during the creation of the Always On high availability cluster?

Tell us about your last project — what kind of project it was, what you did, what tasks you had, and what stack you used?

How to monitor replica lag from the master through the dashboard?

Tell me about ETL/ELT processes, dimensional tables, snowflake schema, and star schema.

What do you know about Apache Kafka?

Tell about your current position: responsibilities, team, infrastructure, tools.

How to perform a minor update of PostgreSQL in a Patroni cluster?

If a procedure is rolled back, will the result of the trigger (AFTER INSERT) that was fired within this procedure be preserved?

How do you determine that an index is needed for a query? How do you set up queries and what system tables do you use?