Role Summary:

The Data Architect owns data modeling, schema governance, multi-tenant data routing and isolation, and the ETL migration toolkit for ~250 customer SQL Server databases. The role designs both the PostgreSQL 16 platform database (workflow state, form schemas, audit logs, report configurations) and the SQL Server customer-database schemas, manages schema consistency across the installed base, and architects the reporting and future SQL Server → PostgreSQL migration path.

Key Responsibilities
Design the platform PostgreSQL 16 schema: workflow state, form-schema JSON storage (JSON Schema draft-07), report configurations, audit logs
•Govern the customer SQL Server schema (200–400+ tables per tenant across ~250 customers) including schema-drift detection and the golden schema manifest
Design the multi-tenant data-routing model: Hibernate Filters for tenant_id injection, request-scoped TenantContext propagation, and DB-level enforcement guarantees
Architect the SIMS Migration Toolkit: schema validator, chunked JDBC data extractor with checksums,



reconciliation validator (row counts, FK integrity, spot-check sampling), rollback manager with atomic snapshot and restore-on-failure, dry-run pipeline
Design the 4-layer Reporting Engine data architecture (Typed Data Access API → Report Definition Engine → React Presentation Layer → future AI Query Layer)
Drive schema-consistency analysis across all customer databases before any production migration script is written
Define the future SQL Server → PostgreSQL migration architecture so that portability is designed in from day one (zero rework when the migration is triggered)
Establish encryption-at-rest, TLS 1.3 encryption-in-transit, and AWS Secrets Manager integration for database credentials
Apply AI-augmented data-engineering practices: AI-driven schema-drift detection across the installed base, AI-generated ETL reconciliation reports, AI-assisted query generation and performance-tuning recommendations, and AI-au

📌 Data Architect (Chennai)
🏢 Galent
📍 Chennai