Database-backed investigations, migration lessons, production recovery, and practical AI-assisted engineering.
Trace a valid database rejection back to stale derived allocation counters, repair the data under row locks and version checks, and translate the error only after rollback is guaranteed.
Fix host-dependent Windows test failures by owning subprocess decoding and Git line-ending policy at the boundaries where test evidence and fixture state are created.
Diagnose primary-key collisions caused by sequence drift after an Oracle migration, align sequences forward during a verified write freeze, and prove recovery with complete transactions.
Trace an HTTP 200 empty response to an Oracle invalid-identifier error, replace legacy WM_CONCAT calls with deterministic LISTAGG, and verify source, build, artifact, and overflow boundaries.
Diagnose an IDE server that builds successfully but stops before deployment because its debugger cannot bind a Windows-excluded TCP port.
Connect Typora to Pandoc on Windows, then verify real DOCX and EPUB packages with Unicode text, tables, and embedded images.