SQL & Enterprise Databases

Architect a production-grade 3NF multi-tenant relational schema for orders, inventory, and payments with row-level security and automated stock decrement triggers.

Build an immutable, append-only double-entry financial ledger guaranteeing mathematical debit/credit balance equality and cryptographic hash chain verification.

Design a high-throughput queue dispatcher and telemetry analytics warehouse handling 100,000+ daily robot execution logs with sub-second reporting queries.

Build advanced analytical SQL queries implementing Recency-Frequency-Monetary (RFM) customer segmentation and recursive CTE graph traversal for referral hierarchies.

Implement a medical clinic appointment booking engine utilizing PostgreSQL range types and exclusion constraints to guarantee zero overlapping bookings.

Model a worldwide supply chain logistics system tracking containers across vessels, customs ports, and delivery hubs with real-time ETA calculation and lag detection.

Develop a production Python FastMCP server exposing relational database capabilities to Claude and autonomous agents with JSON schema validation and zero-injection protections.

Design an automated CI/CD schema migration pipeline using Flyway / Liquibase principles with backward-compatible expand/contract patterns and automated rollback scripts.