Built a robust synchronization layer between Pentec’s internal system and AlayaCare. Leveraged database triggers and Amazon SQS to publish change events and keep data consistent across systems.
Stack
.NET CoreC#SQL ServerAWS SQSDatabase Triggers
Highlights
Event-driven sync with database triggers
Amazon SQS for reliable, decoupled messaging
SQL Server-first approach; observability and retries
Results
Near real-time data parity between systems
Reduced manual reconciliation and support tickets
Hardened sync with idempotency and poison-queue handling