GST Suvidha Provider
A robust data platform for enterprise taxation & analytics.
Client: GST filing platform serving accountants at 800+ large corporations, including 300+ BSE-listed companies
The Problem
The client was building a GST (Goods & Services Tax) filing system to help accountants file GST for their companies. It had to be secure (highly confidential financial data), performant (3,000+ concurrent users), scalable (sudden influx of requests on the last day of filing), safe and available (audits and compliance), flexible (SaaS and on-premise), and absolutely accurate in financial calculations.
Challenges
- 3,000+ concurrent users with last-day filing surges
- Highly confidential financial data demanding strict security
- Support for both SaaS and on-premise installations
- Audit and compliance readiness with sub-3-second response times
Solution Design & Implementation
SaaS Model with Tenant Databases
A master database managing dynamic connection strings for tenant-specific databases — built for scalability, security and portability across client environments.
Performance & Load Balancing
Database requests routed via the master database for load distribution, with transactional log replication separating transactional and reporting workloads.
Robust Security Framework
Role-based access control across deployment, testing, operations and support — with client-specific logins and granular permissions, all monitored.
Comprehensive Monitoring
DMVs, logs, extended events and Windows Performance Monitor tracking database growth, deadlocks, query performance, tempdb contention and wait stats.
Resilient Infrastructure
A 6-server setup (3 primary + 3 replication) managing 1,200+ databases across 2 geographical regions for disaster recovery.
Architecture
Sources
Accountants
3,000+ Concurrent Users
Client Portals
GST Filing Requests
GSTN
Govt. Portal Integration
Ingestion & Integration
Master Database — Dynamic Routing
SaaS Multi-Tenant Data Platform
SQL Server — 6-Server Setup
Transformations
Tenant-Specific Databases
Transactional Log Replication
RBAC Security Layer
Data Zones
Additional Stores
Monitoring
Extended Events & Wait Stats
Consumption
<3s Response
Filing & Audit Dashboards
Orchestration & Monitoring
Windows Performance Monitor
Deadlock & Growth Alerts
Results
99.99%
Uptime throughout the year — zero server issues during filing
30%
Productivity gain for accountants filing GST
0
Security incidents to date
1,200+
Databases operationally online
<3s
Hot data request response time
800+
Large corporations served