Job Summary
Must-Have Qualifications
· 5–7 years total experience as a database/T-SQL developer in mission-critical systems.
· Expert-level T-SQL in Microsoft SQL Server (query writing, set-based design, window functions, error handling, transactions).
· Advanced performance tuning: indexing/partitioning, parameter sniffing strategies, statistics management, memory/IO considerations.
· Solid data-modelling: normalization/denormalization, constraints, keys, and concurrency patterns.
· Scripting & Jobs: Windows/Linux scripting for build/deploy/ops automation; job scheduling and monitoring.
· Version control: Git (preferred) or SVN; pull requests and code-review discipline.
· Banking/Insurance exposure: real-world experience with at least one area—payments, cards, core banking, lending, policy/claims, underwriting, risk, or compliance/reporting (e.g., AML/KYC, IFRS/IRDAI reporting).
· Stakeholder skills: crisp communication with business/tech partners; clear documentation
Key Responsibilities
Solid data-modelling: normalization/denormalization, constraints, keys, and concurrency patterns.