Platforms
- SQL Server — schema design, indexing, stored procedures, SSIS, SSRS, Always On.
- 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.