jeffTheItGuy/ZimGrid-Utility-Billing-on-SAP-HANA

A production-grade database operations platform for African power utilities, built on SAP HANA 2.0 with real-time DBA monitoring, disaster recovery architecture, and multi-currency billing. # ZimGrid — Utility Billing and Grid Operations on SAP HANA > **A production-grade database operations platform for power utilities, engineered for SAP HANA 2.0 with real-time monitoring, disaster recovery architecture, multi-currency billing, and a transparent dual-engine database layer.** > > **Built as a portfolio project to demonstrate SAP S/4 HANA Database Administration expertise for the ZESA Holdings Systems Engineer (SAP S/4 HANA DBA) role.** --- ## What This Is A full-stack utility billing system built for widthstanding unstable networks, dual-currency economies (USD/local), prepaid meter token vending, and grid asset tracking across vast geographic regions. The backend runs on **SAP HANA 2.0** (column-store, in-memory) with a **React operations dashboard** that gives database administrators real-time visibility into system health, replication status, and high-volume transaction tables. For local development and portfolio review, the project uses **PostgreSQL with a HANA-compatible schema** — all table structures, partitioning annotations, spatial indexes, and DBA runbooks are designed for **direct migration to SAP HANA 2.0**. The critical architectural addition is a **Database Adapter Layer** with an **SQL Dialect Translator**. The same API codebase — customers, meters, billing, payments, prepaid tokens — runs transparently against either PostgreSQL (dev) or SAP HANA (production) without changing a single line of route logic. Flip `USE_HANA=true` and the application switches engines at runtime. --- ## Why This Matters | What ZESA Needs | What This Project Proves | |---|---| | Administer SAP S/4 HANA databases | Multi-tenant HANA container setup, tenant DB management, memory tuning | | Ensure performance, availability, security | Live memory gauges, delta merge monitoring, analytic privileges, audit logging | | Database backups and disaster recovery | System replication (Primary → DR), automated backup catalog, point-in-time recovery runbook | | …