I specialize in diagnosing, repairing, and optimizing PostgreSQL databases — including legacy systems that have accumulated years of technical debt, silent bugs, and undocumented logic.
What I offer:
- Deep forensic audit of existing PostgreSQL databases (schemas, functions, triggers, sequences)
- Detection and repair of silent failures — broken stored procedures, wrong search paths, out-of-sync sequences, stale reservations
- Performance tuning and query optimization
- Trigger design and plpgsql function rewriting for correctness and maintainability
- Database health reports with prioritized fix recommendations
- Ongoing retainer-based database maintenance and monitoring
I have successfully rescued a 20-year-old production PostgreSQL database for a logistics client, identifying and fixing critical bugs across 125+ stored functions, correcting sequence drift, repairing broken stock management logic, and resolving stuck production orders — all without downtime.
If your database has unexplained behavior, data inconsistencies, or you simply don't trust what's running in production, I can audit it and give you clarity.
Technologies: PostgreSQL, plpgsql, SQL, pgAdmin, DB Browser