About the role

We are modernizing Cascade, a large, business-critical auction and asset-management platform, and are in the business testing and data migration phase. The legacy system holds years of seller configuration, workflow, fee and rules data. Much of its business logic lives in stored procedures, lookup tables and application code rather than in documentation.

We need a hands-on Database SME who can quickly understand a complex legacy SQL Server estate, produce accurate data extracts for business teams, find and fix data-quality problems, and support migration to the modernized platform. The timeline is short. We're looking for someone who uses LLM-based tools (Claude, Copilot, ChatGPT and similar) as a normal part of their daily work to read unfamiliar code, write and review complex queries, and move faster than a traditional approach allows, while staying rigorous about accuracy.

What you'll do

• Reverse-engineer legacy business logic. Trace how screens get their data, through ASP.NET pages, C# data-access layers (LINQ to SQL / Entity Framework), stored procedures,



functions and lookup tables. Turn that into explicit, reliable SQL.

• Build data extracts for business users, such as Finance and Product. The extracts must match what the application shows, including its defaults, hidden fields, versioning rules and quirks, and must be easy for non-technical readers to use in Excel.

• Write complex, read-only production queries safely. Use window functions, version resolution ("current effective record"), rewriting procedure logic as plain queries where execute rights aren't available, and set-based work across large tables, without blocking or disturbing production.

• Find and quantify data-quality issues. Look for duplicates, orphaned records, stale versions and inconsistent lookup codes. Document them and propose cleanup scripts for review and approval.

• Support data migration. Map legacy schemas to the modernized data model, write and check migration

📌 DBA (Bengaluru)
🏢 Kadel Labs
📍 Bengaluru