Khaja Arifuddin

Background

About Khaja Arifuddin

Have over 8 years of SQL Server database Development, performance tuning & Administration experience. Extensive experience and knowledge in T-SQL–DML, DDL, DCL, Transactions, Stored Procedures, Triggers and Functions. Experience in installation, configuration and migrating of Data in MS SQL Server 2005, 2008, 2008R2 and 2012 versions. Hands on experience in troubleshooting database issues, debugging SQL Server stored procedure/triggers and documenting issues/resolutions of SQL Server Applications.Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. Worked in OLTP & OLAP environment Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency. Hands-on working experience with analyzing query plans, Code Reviews, managing indexes and locks, troubleshooting deadlocks.Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries. Extensive knowledge in Tuning SQL queries, T/SQL queries & improving the performance of the Database.Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data. Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures Good knowledge of System Development Life Cycle (SDLC). Hands on Experience in using Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance