DBA / Database

Tell us about the Always On High Availability technology in MS SQL Server.

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

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

What do you know about Agile methodology and Scrum?

How would you build a disaster recovery plan and configure replication for a client with a small on-premise database?

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

Tell us about the levels of transaction isolation in PostgreSQL.

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

What types of indexes do you know in MS SQL Server? Tell about clustered and non-clustered indexes.

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

What is the difference between log shipping and incremental backup?

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

If an index is not used in a SELECT query, how do you determine the reason and what actions do you take?

Have you had experience migrating between PostgreSQL and MS SQL Server?

Tell us about your experience with AWS and Azure cloud technologies. What tools have you used?

What do you know about Python libraries: pandas, NumPy, PySpark, SQLAlchemy, requests, PyYAML?

What PostgreSQL utilities do you know and have used?

What is autovacuum in PostgreSQL and why is it needed?

How to set up an emergency recovery plan and failover for PostgreSQL in AWS?

What is the difference between physical and logical replication in PostgreSQL?