DBA / Database

What PostgreSQL utilities do you know and have used?

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

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

What do you know about Apache Kafka?

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

What user authentication methods do you know in PostgreSQL?

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

What types of indexes do you know in PostgreSQL? Tell about B-tree indexes.

What is WAL (Write-Ahead Log) and why is it needed?

What types of backup do you know in MS SQL Server? Tell me about full, incremental, and log backup.

What monitoring tools for PostgreSQL do you know and have used?

Have you worked with replication topologies? Tell about your experience.

Have you worked with PgBouncer or PgPool? What are they used for?

Tell us about your experience migrating databases. What steps do you take during minor and major PostgreSQL updates?

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

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

What types of data storage do you know for cloud and on-premise solutions?

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

Have you worked with PgBarman or PgBackRest? Share your backup experience.

Tell about the steps of migrating a database from on-premise to cloud (AWS).