Database Engineering
The deepest part of our practice.
A decade of production database work across core banking, humanitarian operations and revenue administration. This is where our experience is longest and where the fastest wins usually are — tuning a query is almost always cheaper than buying more hardware.
What we do
- Logical & physical data modellingConceptual through physical models, normalisation and deliberate denormalisation, dimensional and Data Vault approaches where they fit.
- Database design & developmentSchema design, constraints and referential integrity, stored procedures and packages, across Oracle, PostgreSQL, MySQL and SQL Server.
- Performance tuningExecution plan analysis, index strategy, statistics management, partitioning and query rewrites.
- High availability & recoveryReplication topology, failover design, backup strategy and tested recovery procedures with real recovery time objectives.
- Migration & upgradeVersion upgrades and cross-platform migration with parallel validation and reconciliation before cutover.
- Oracle Data Integrator developmentODI mappings, packages, load plans and knowledge module customisation, including remediation of inherited estates.
Technologies
Oracle 19c & 23aiPostgreSQLMySQLSQL ServerMongoDBRedisOracle Data IntegratorData Vault
Who usually owns the budget
CTO, VP Engineering, or a Head of Platform whose database has become the bottleneck.
What triggers the purchase
- Queries that used to take seconds now take minutes
- An unsupported database version is becoming an audit finding
- Nobody has tested whether the backups actually restore
Is this the piece you need?
Twenty minutes on a call is usually enough to know whether this is the right starting point.