Experience:

Experience required- 7+ years
Candidate should have 7+ years of Experience with SSRS 2008/2012 & SQL Server.
Experienced in Database design, Coding, unit testing and Implementation.
Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
Knowledgeable in designing XML documents using DTD, XML Schemas, XSLT and XPath queries for its integration in database.
Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
Good knowledge in developing and designing reports through SSRS and Excel
Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
Involved in UAT and Integration testing with QA team.

Responsibilities:-

Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Applications.
Developed Physical data models and created DML scripts to create database schema and database objects
Employed Server Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.
Performed Debugging on the Stored procedures for the requirement to handle the errors
Development of custom scripts and stored procedures for data import and manipulation
Developed various operational Drill-through and Drill-down reports using SSRS.
Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
Used cascaded parameters to generate a report from two different Data Sets.
Involved with Query Optimization to increase the performance of the Report.
Developed Reports for business end users using Report Builder with updating Statistics.
Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning adviser.
Interacting with QA and Developers in identifying the requirements and designing and implementing the Database Schema.
Should have knowledge of JIRA

Desired Candidate Profile:

Should have worked with USA / UK Clients.
Strong problem solving/trouble shooting skills.
Strong communication skills to interact with the client.
Should be a good team player.