Skip to content

Database management

Schema design, tuning, backups and access control for PostgreSQL, SQL Server and MongoDB.

What this service covers

We design, tune and look after production databases: PostgreSQL, MySQL, SQL Server and MongoDB, self-hosted or on managed services like RDS, Aurora, Azure SQL and Atlas.

Common starting points are slow queries, a database running out of headroom, or backups nobody has tested. We profile the workload, fix the worst offenders first and write down what to watch.

We also handle migrations between engines and versions, with replication-based cut-overs that keep downtime to minutes.

What you get out of it

The results clients typically see. We agree the measures that matter to you during discovery.

  • 01

    Slow queries made 10× faster

    Indexing, query rewrites and schema changes aimed at the queries that matter most.

  • 02

    Backups you have actually restored

    Point-in-time recovery configured and a restore drill completed and timed.

  • 03

    Headroom for growth

    Capacity plan showing when you will need to scale and how.

How the engagement runs

A typical database management engagement, start to finish. You see working results every week.

Stack we use most often

  • PostgreSQL
  • SQL Server
  • MySQL
  • MongoDB
  • Redis
  • AWS RDS
  • Aurora
  • Azure SQL
  • pgBouncer

We fit in with what your team already runs.

  1. 1

    Audit

    1 week

    Profile workload, configuration, backups and access.

  2. 2

    Fix

    1–3 weeks

    Tune queries and configuration, implement backup and HA changes.

  3. 3

    Monitor

    Ongoing

    Dashboards and alerts, with optional monthly reviews.

Deliverables

What you receive, all in your own accounts.

  • Database health and performance audit
  • Query and index optimisation
  • Schema review and migration plan
  • Backup, point-in-time recovery and restore drill
  • Replication and failover setup
  • Access control and encryption review
  • Monitoring dashboards and alerts

FAQ

Common questions about database management

More in run infrastructure

All 17 services

Talk to an engineer about database management

A 30-minute call with a senior engineer. You leave with a rough plan, a timeline and a price range, whether or not we work together.