Job Title : SQL Lead Job Summary : Architect for SQL Development
Experience : 10 to 14yrs.
Required Skills :
Technical Skills : MS SQL Server ,TSQL ,Query Tuning
Domain Skills : Provider
Roles & Responsibilities :
Good experience in MS SQL Server Good knowledge and experience in : Primary Key, Foreign Key, Unique Concepts
- Joins Query writing, DML, TCL, Subquery
- Experience in T-SQL programming and exception handling
- Triggers Cursors Functions Stored procedure Views/ materialized views Query Analysis Performance Analysis Optimization
- Query Tuning Index Evaluating various query optimization metrics parameters like * Generate and analyse Query Execution Plan along with Execution time * IO Statistics etc
- Implement performance improvements Experience with SQL Server Service Broker
- Should be an independent contributor and assist the team as needed both from technical and co-ordination standpoint
- Collaborate well with various stake holders in delivering E2E solution
- Nice to have exp in Java (not mandatory)
- Nice to have exp in Camel (not mandatory)