Services / Database administration

Database administration

A database that was fine at launch can quietly become the slowest part of your application as data grows. We handle the ongoing DBA work: indexing, query tuning, replication and backups, so performance problems get caught in a review, not from a customer complaint.

What's included

  • PostgreSQL and MySQL installation and configuration
  • Replication and high-availability setup
  • Index and query performance tuning
  • Scheduled backups with tested, verified restores
  • Access control and connection security
RATES
$115–$150 / hour

Standard remote and on-site support in Calgary. Fixed-scope project quotes available on request.

Request a Quote

Frequently asked questions

PostgreSQL or MySQL, which do you recommend?

It depends on your application and existing tooling; we don't push a default. Both are supported end to end, setup through tuning through backups.

Our queries have gotten slow as data has grown, can you fix that?

Yes, this is a common request. We start with an indexing and query review to find what's actually slow, rather than guessing at fixes.

How do you verify backups actually work?

By restoring them on a schedule, not just running the backup job and assuming it's fine.

FROM THE BLOG

Related reading

PostgreSQL vs MySQL: What Actually Matters for Your Application

Both databases are good enough for almost everything. Here's what should actually drive the decision instead of habit or hearsay.

OTHER SERVICES

Often paired with this

Linux server administration

Provisioning, patching, hardening and day-to-day care for Debian, Ubuntu, RHEL and CentOS systems.

Virtualization with KVM & Proxmox

KVM and Proxmox VE virtual machines for isolating workloads and getting more out of the hardware you already own.

Web hosting & server setup

Nginx/Apache stacks, SSL, deploy pipelines and staging environments configured and kept running.

Ready to talk about database administration?

Get a Quote