Technical Lead (IN)
HCLTech
HCLTech
Seeking an experienced Technical Lead with a strong background in database development and T-SQL. This role involves working with mission-critical systems and requires advanced skills in performance tuning and data modeling. Ideal candidates will have exposure to the banking or insurance sectors and possess excellent stakeholder communication abilities.
This is a full-time, onsite position requiring 5-7 years of dedicated experience in database development.
Develop and maintain expert-level T-SQL for Microsoft SQL Server, focusing on query optimization, set-based design, and robust error handling.
Implement advanced performance tuning strategies, including indexing, partitioning, parameter sniffing, and memory/IO considerations.
Apply solid data modeling principles, ensuring normalization/denormalization, appropriate constraints, keys, and concurrency patterns.
Automate build, deployment, and operational tasks through scripting and job scheduling on Windows/Linux platforms. Monitor job execution effectively.
A minimum of 5 years of total experience as a database/T-SQL developer is essential, with at least 7 years being ideal for candidates with exceptional skills.
Expertise in T-SQL within Microsoft SQL Server, encompassing query writing, set-based design, window functions, error handling, and transaction management.
Proficiency in advanced performance tuning techniques, including indexing, partitioning, parameter sniffing, statistics management, and memory/IO optimization.
Solid understanding of data modeling concepts like normalization/denormalization, constraints, keys, and concurrency patterns.
Experience with scripting (Windows/Linux) for automation and managing job scheduling and monitoring.
Familiarity with version control systems, preferably Git, including pull requests and code review processes.
Demonstrable experience in banking or insurance domains, covering areas such as payments, cards, core banking, lending, policy/claims, underwriting, risk, or compliance/reporting (e.g., AML/KYC, IFRS/IRDAI).
Strong stakeholder management skills with clear communication to business and technical partners, supported by concise documentation.
HCLTech
IT Consulting