Written T-sql Procedures, functions, cursors. Optimization and indexing for queries and database. Extracting and transforming data from different sources into database tables. Making backup, Mirroring and Log Shipping strategies. Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.  Responsible to Monitor and troubleshooting Log Shipping.  Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).  Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008. Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.  Development of SSIS Packages and finally development of reports using SSRS.