MS SQL Server Developer

Job Title:MS SQL DeveloperWork Location: HyderabadExperience:4 to 8 YearsPackage:As per Market StandardsNotice Period:Immediate JoinersIts a Full Time Opportunity with Our ClientMandatory Skills:MS SQL Server Developer,T-SQL,Performance tuning,SSIS,DTS Migration & ETL Data FlowsRoles & Responsibilities:--Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server in Production, Testing and Development.--Experience in installation, configuration of MS SQL Server--Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005 /2008 using SQL --Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.--Knowledge of Relational Database Management systems.--Experience in Database Backup, Recovery and Disaster Recovery procedures.--Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.--Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables. --Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. --Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimisation. --Install and Configure SQL Server on Virtual Machines.--Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data --Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. --Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.