Postgresql in DevOps skills

What are the basic skills and requirements a DevOps candidate should have when working with PostgreSQL?
How to monitor it, deploy, etc.?

In my opinion an Operations candidate (DevOps is a culture, not a role) should be capable to perform at least the following actions:

• deploy postgres

• backup postgres

• restore postgres

• run some psql commands like select and some innerjoins

• knows what the effect on memory usage would be if a select * is issued

• No manual labour, only automation. Deploy the postgres using a pipeline like gitlab

• infrastructure as code

• monitor it, disk usage, memory, cpu

• the difference between a relational and non-relational database

• see also this Q&A

• there are tools like Flyway that are capable of applying version control to databases. This could facilitate to run it in a CI/CD.

StackExchange DevOps Q#14588, answer score: 6