8+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005/200 in Production, QA and
8+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005/200 in Production, QA and Development Environments.
Strong experience with T-SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
Ability to work in all stages of System Development Life Cycle (SDLC).
Experience in Error handling and debugging coding issues and troubleshoot production problems.
Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.