---
title: "PostgreSQL | Skills We Assign For | Azendo"
description: "PostgreSQL as a primary datastore — what its feature depth removes from a stack, what needs owning, and the Azendo roles assigned for it."
url: "https://azendo.co/skills/postgresql/"
---

[Skills](https://azendo.co/skills/) Data stores and query 

# PostgreSQL.

PostgreSQL is an open-source relational database known for correctness, extensibility and a strong feature set — JSON storage, full-text search, geospatial types and window functions in the core product. It is a common default for new backend work and a common destination for migrations away from licensed databases.

## Where PostgreSQL fits on a long engagement.

Postgres often replaces two or three other components. Document storage, search and reporting queries can live in it up to a scale most products never exceed, which removes real operational surface from a small team. Reaching for a separate search cluster before Postgres has actually been outgrown is a common and expensive early decision.

What it does need is someone who owns it. Vacuum behaviour, connection limits, index bloat and long transactions are the recurring sources of incident, and none of them are visible until they are. A database with no owner degrades quietly for a year and then loudly in one afternoon.

## What an assigned team does with PostgreSQL.

A database gets its own owner around the point where the second engineer is afraid to change it. Before that, the application team can carry it; after that, deferred maintenance starts accumulating in a place nobody is looking, and it surfaces as an incident rather than as a ticket.

On an assigned team the database owner is usually part-time capacity rather than a full role, sitting inside [data engineering outsourcing](https://azendo.co/services/data-engineering/) alongside the pipeline work rather than as a separate engagement.

## What we use PostgreSQL for.

* Consolidating a sprawling data layer Search, documents and relational data in one system, so there is one thing to back up, monitor and understand.
* Migration from a licensed database Moving off per-core licensing, usually a schema and stored-procedure problem rather than a data problem.
* Making growth survivable Partitioning, indexing and query work done before volume forces it, rather than during an incident.

## How PostgreSQL capacity is assigned.

Where the database is the product's backbone, a database administrator is assigned under data engineering outsourcing alongside the engineers building against it. What that figure covers is set out in [how the monthly fee is built](https://azendo.co/pricing/).

## Roles we assign PostgreSQL for

* [Database Administrator Data engineering](https://azendo.co/services/data-engineering/database-administrator/)
* [Backend Developer Software development](https://azendo.co/services/software-development/backend-developer/)
* [Full Stack Developer Software development](https://azendo.co/services/software-development/full-stack-developer/)

## Service lines it sits in

* [Data engineering](https://azendo.co/services/data-engineering/)
* [Software development](https://azendo.co/services/software-development/)

Capacity is agreed as a committed monthly capacity across a discipline, not per skill.

## Related in data stores and query

* [SQL — skill we assign for](https://azendo.co/skills/sql/)
* [MySQL — skill we assign for](https://azendo.co/skills/mysql/)
* [MongoDB — skill we assign for](https://azendo.co/skills/mongodb/)
* [Snowflake — skill we assign for](https://azendo.co/skills/snowflake/)
* [BigQuery — skill we assign for](https://azendo.co/skills/bigquery/)
* [Redis — skill we assign for](https://azendo.co/skills/redis/)
* [Prisma — skill we assign for](https://azendo.co/skills/prisma/)
* [Postgres — skill we assign for](https://azendo.co/skills/postgres/)

## Tell us what your roadmap needs PostgreSQL for.

A service delivery manager replies with the disciplines we would assign, the monthly capacity and what the first month looks like.

[All skills we assign for](https://azendo.co/skills/)