T‑SQL Database Developer (7+ Years)

T‑SQL Database Developer (7–9 Years)\n\nRole Summary\nWe’re looking for a seasoned T‑SQL Database Developer with 7–9 years of hands‑on experience designing, building, and optimizing data solutions on high‑volume transactional systems. The ideal hire brings deep SQL performance‑tuning expertise , strong data‑modelling skills, and practical exposure to banking and/or insurance —covering areas such as payments, core banking, policy administration, claims, risk, or regulatory reporting. Knowledge of Sybase ASE will be an added advantage.\n\nKey Responsibilities\nDesign & Development: Build robust database objects (stored procedures, functions, views, triggers) and performant SQL for OLTP/operational analytics workloads.\nPerformance & Scalability: Diagnose and tune complex queries, indexing strategies, partitioning, and concurrency; analyse execution plans and remediate hot spots.\nData Modelling & Standards: Create logical/physical models, enforce referential integrity, and apply naming/versioning and code‑quality standards.\nBatch & Automation: Author and maintain deployment and batch scripts (e.g., PowerShell/Bash) and schedule/monitor jobs (e.g., Control‑M/Autosys or native SQL Agent).\nIntegration & ETL: Build and optimize ETL/ELT flows (e.g., SSIS/Azure Data Factory or equivalent) feeding downstream apps, reports, and regulatory packs.\nReliability & Security: Implement backup/restore, DR patterns, role‑based access, and data‑protection controls for PII/financial data; assist with audits.\nSDLC & DevOps: Use Git/SVN; participate in code reviews, CI/CD pipelines, and controlled releases across environments.\nCollaboration: Partner with application developers, BAs, testers, and platform/infra teams; provide L3 support for production incidents and root‑cause analysis.\nMentoring: Guide junior engineers on SQL craftsmanship, troubleshooting, and performance best practices.\nWays of Working: Deliver in Agile/Scrum—plan, estimate, and track work using sprint ceremonies and tooling (e.g., Jira/Azure Boards).\n\nMust‑Have Qualifications\n7–9 years total experience as a database/T‑SQL developer in mission‑critical systems.\nExpert‑level T‑SQL in Microsoft SQL Server (query writing, set‑based design, window functions, error handling, transactions).\nAdvanced performance tuning: indexing/partitioning, parameter sniffing strategies, statistics management, memory/IO considerations.\nSolid data‑modelling: normalization/denormalization, constraints, keys, and concurrency patterns.\nScripting & Jobs: Windows/Linux scripting for build/deploy/ops automation; job scheduling and monitoring.\nVersion control: Git (preferred) or SVN; pull requests and code‑review discipline.\nBanking/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).\nStakeholder skills: crisp communication with business/tech partners; clear documentation