Health check & tuning
Find out why it is slow and fix the worst offenders.
- Workload analysis
- Index & query fixes
- Config review
- Written report
02 services / database administration
I look after SQL Server, PostgreSQL and MySQL estates for teams that cannot afford slow queries or lost data. Performance tuning, migrations, high availability, backups you have actually restored from, and monitoring that tells you before your users do.
// what you get
// typical engagements
Starting points, not rigid packages. Every project gets a written scope and a fixed or weekly price before work begins.
Find out why it is slow and fix the worst offenders.
Move engines, versions or clouds without losing a row or a weekend.
An experienced DBA on call, without the full-time salary.
// process
Capture the current workload, wait stats and slow queries so improvements are measurable.
Separate the real bottlenecks from the noise. Usually a handful of queries cause most of the pain.
Changes are tested on a copy, scripted, reviewed and rolled out in a window you choose.
Same measurements again, side by side with the baseline.
Monitoring, runbooks and a maintenance plan so the gains stick.
// related work
Moved a logistics company's 400 GB SQL Server estate to PostgreSQL with a rehearsed dual-write cutover, cutting licence costs and unblocking a move to Linux containers.
A three-week performance engagement that took the checkout's slowest query from 2.4 seconds to 180 milliseconds at the 95th percentile, without new hardware.
Designed and built a two-site SQL Server Always On setup with verified backups, tested restore drills and the runbooks to go with them, for a company that had never restored a backup.
// tools
// faq
Microsoft SQL Server, PostgreSQL and MySQL/MariaDB, on-premises or in Azure and AWS. I also work with Redis as a caching layer.
Yes, over VPN or bastion access with least-privilege accounts. Every change is scripted, reviewed and reversible.
It is common and fixable. A restore drill is part of every engagement; a backup you have not restored is a hope, not a plan.
Yes, through a monthly retainer with monitoring, monthly reviews and priority response for incidents.
A health check can usually begin within a week. Migrations are planned around your release calendar.
Tell me what you are building, what is slow, or what you are raising. I reply to every message personally.