---
esco_uri: http://data.europa.eu/esco/skill/a8d07b5a-c1a1-42c6-9d53-db9c7a2ca996
esco_label: "PostgreSQL"
relation: optional
onet_soc: 15-1242.00
source: model-knowledge
confidence: high
qa_count: 0
generator: gemma3:27b (prompt-designed and spot-checked by Claude)
generated: 2026-07-10
---

# PostgreSQL — Database Administrator

For a Database Administrator (DBA), 'PostgreSQL competence' isn’t just *knowing* it exists; it's being able to reliably operate, secure, and optimize production databases built on it. Daily tasks revolve around things like user/role management (granting permissions, auditing access), performance tuning (analyzing slow queries with `EXPLAIN ANALYZE`, indexing strategies, configuring `shared_buffers`), backup & recovery (`pg_dump`/`pg_restore`, Point-in-Time Recovery - PITR using WAL archiving), and ensuring high availability (setting up replication – streaming or logical – and failover mechanisms). You'll be heavily using tools like `psql` for command-line interaction, potentially GUI clients like pgAdmin, and monitoring solutions to track database health.

## Weitere Anreicherung

Stage-2 source for future practitioner grounding: arXiv cs.SE (software-engineering preprints).
