MS SQL Developer

Job Description:

• Experience in SQL Server 2008\2012 is mandatory. Should be able to write complex stored procedures and functions.
• Optimize long running queries using tuning advisor and Execution plan. Experience with SQL Server Analysis Services, Performance Tuning etc.,
• Use DDL (Data Definition Language) and DML (Data Manipulation Language) to build and deploy Database objects, including tables, views, user defined functions, and stored procedures.
• Utilizes database security regulations, policies, and guidelines.
• Build reporting deliverables, to include DDL/DML SQL Scripts.
• Participates in analysis and development of tasks related to business report requirements.
• Utilizes best practices, checklists and defined processes.
• Participates in data analysis for required database objects.
• Should possess strong architectural and design skills, implemented various design patterns and frameworks.
• Should possess Strong Debugging skills and able to identify and fix the issues/bugs identified in the Stored Procedure.
• Should know about Error Handling.
• Work experience in agile projects.