Platforms

  • SQL Server - Schema design, indexing, stored procedures, SSIS, SSRS, Always On High Availability.
  • MySQL / MariaDB - Schema design, replication, backup strategy, query tuning.
  • PostgreSQL - Schema design, partitioning, PL/pgSQL, logical replication, extensions.

What we do

  • Architecture & modelling - Normalised OLTP schemas, star/snowflake for reporting.
  • Performance tuning - Index reviews, query plan analysis, slow query hunts.
  • Migrations & upgrades - Cross-engine moves (e.g. SQL Server → PostgreSQL), zero-downtime cutovers.
  • Backups, DR & monitoring - Point-in-time recovery, automated backups, uptime alerting.
  • Reporting & views - Clean reporting layers so the business can self-serve.