Backend Engineering

Founded a new reporting service that separates heavy analytical reads from the transactional database, resolving indicator timeouts, framing the OLTP-vs-OLAP trade-off, critically reviewing the architecture decision, and building the walking skeleton and its data layer.

Corrected tens of thousands of corrupted production records (~33k in one case) with no maintenance window, using reusable CLI commands with dry-run, rollback files, batch auditing and event re-publishing, a "correction command" pattern the team then reused.

Delivered search and fast navigation over very large asset trees end to end, with recursive SQL on the backend and a search UX with in-memory caching and progressive background prefetch on the frontend, eliminating the repeated loading that made the most-used flow slow.

Turned container and dependency hardening into a standing quarterly practice across two backend services over four quarters, covering non-root runtimes, 135 CVEs flagged and all 7 rated critical remediated in the first pass, then a base-image and dependency overhaul that took the audit from 69 findings to 16, unfixable OS CVEs from 160 to 0, and the final image from 1.64 GB to 463 MB, with exploitability-based accepted risk documented rather than version numbers chased, and one self-inflicted rollout regression root-caused and fixed the same day.

Made an edit to an organizational node in the asset hierarchy propagate consistently across denormalized copies in seven tables and two services, via a single atomic transaction with post-commit events, the work that made me the team's reference for cross-service synchronization.