Opening for SQL Server Developer in Mohali. The candidate must have 2 to 5 year experience. The candidate must possess B. Tech or higher degree, and one or more certifications on Microsoft SQL Server. The candidate should have minimum 4 years of development experience in Microsoft SQL Server, including recent version. Should have Strong knowledge of Transact-SQL, procedures, execution plans, functions , triggers and have Excellent query writing, performance optimization and trouble shooting skills. The candidate will be responsible to Create and maintain Entity Relationship (ER) Diagrams for existing and new databases . The candidate should be capable to Identify & avoid potential blocking and can optimize existing & new database code (functions, stored procedures, etc.) for performance and scalability. The candidate should be capable to maintain referential integrity, domain integrity and column integrity by the use of constraints and other available options. The salary offered is 6 to 9 lacs annually.