Databases

Database Administration

We look after the databases your business runs on: SQL Server on-premises and in VMs, Azure SQL, Oracle and MySQL. Work starts with a fixed-scope health check and can continue as monthly care, a migration or a time-boxed performance investigation.

Ways to engage

How we can help.

Database health check

A fixed-scope review of one environment, with a written report.

  • Backup and restore verification against your stated recovery objectives
  • Performance, index and query review
  • Security, logins and permissions review
  • Patching, version and support-lifecycle status
  • Capacity and growth
  • A written report with prioritised fixes

Fixed price, quoted after a short call.

Ongoing database care

A monthly arrangement that keeps the basics checked and current.

  • Monitoring and alert review
  • Scheduled backup and restore checks
  • Patching in agreed maintenance windows
  • A quarterly health report
  • A set number of hours each month for changes

Migrations and upgrades

Moving or upgrading a database with a tested plan to fall back on.

  • Version upgrades
  • On-premises to Azure SQL
  • Cutover planning with rollback

Performance troubleshooting

When something is slow and nobody is sure why.

  • Time-boxed investigations
  • Written findings and recommended fixes

Outcomes you should expect

What good looks like.

  • Backups proven against your recovery objectives

    Restores are tested against the recovery point and recovery time you have agreed, and the results are written down.

  • A clear view of performance, security and lifecycle

    Indexes, queries, logins, permissions, patch level and support lifecycle reviewed, with fixes in priority order.

  • Planned changes, not surprises

    Patching and changes happen in agreed maintenance windows, and upgrades and migrations have a rollback plan.

Capabilities

Where we go deep.

  • SQL Server on-premises and in VMs
  • Azure SQL
  • Oracle and MySQL
  • Backup, restore and recovery testing
  • Performance, index and query tuning
  • Version upgrades and migrations to Azure SQL

Frequently asked questions

  • Can you work alongside our existing IT provider?

    Yes. We can take on the database work alongside your current IT provider, inside their tools and standards. See how we work with IT partners.

  • Do you need admin access?

    Only the access the work requires. We use named, least-privilege accounts, and remove them when the engagement ends.

  • What happens out of hours?

    Planned work such as patching, upgrades and cutovers happens in maintenance windows agreed with you. Support and responses are during business hours, Sydney time.