 Over 16+ years of Overall IT experience, with 13+ years in SQL Database Developer, T-SQL, Query Optimization, Performance Tuning, SSIS, SSRS, Database Design & Development Expertise in Transact-SQL (DDL and DML) and in Design and Normalization of the database tables. Experience in implementing business logic using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers. Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. Managed indexes, statistics and optimized queries by using execution plan for tuning the database. Good experience in normalizations and relational integrity constraints in OLTP database design. Experience in Performance Tuning, Client/Server Connectivity, and Database Consistency Checks. Experience in Index Management, Tuning Tools (SQL profiler) and Data Partitioning, Query Audits, Activity Monitor and better understanding of execution plans for faster execution of databases. Ability to Optimize Query and Performance Tuning Experience of Large and Critical Database Migration from many type of data formats with SSIS Packages Provided guidance and solution to technical problems and issues occurring during development of applications to teams and their members. A self-starter with a positive attitude, keen to learn new concepts and take up challenges. Ability to work with a team and independently. Quick learner with the ability to grasp new technologies. Writing the Complex Queries Using Joins, Sub-Queries, CTE, Pivot and Cursors. 6 Months experience in Schemas (Star schema, Snow flake and etc.) Index Management (Rebuild/Reorganize/Update statistics). Involved in setting up SQL Jobs with SQL Agent for regular maintenance, Jobs and Alerts.