· Hands-on experience in installing, configuring, managing, monitoring, troubleshooting, upgrading, and migrating SQL Server 2012, 2008, 2005, and 2000 in clustered and standby environments. · Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In-Place upgrade process as well as side-by-side upgrade process, documenting the Upgrade process, and also being an expert in migrating DTS packages to SSIS Packages · Experience in implementing and monitoring replication, log shipping, and configuring database mirroring in cluster environments in production, QA, and dev environments. · Configured the servers in 32-bit and 64-bit clustered and standalone server environments. · Expertise in Database Backup and Recovery Procedures by using Native and LiteSpeed to/from Disk/Legato Server (Tape). · Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. · Experience in using Performance Monitor/Profiler to resolve dead locks or long running queries. And also good experience in data (table) partitioning. · Expertise in writing stored procedures, functions, and triggers using T-SQL and also in tuning complex queries. · Knowledge on physical storage configuration and optimization of SAN/NAS/DASD with different RAID Monitoring Event Viewers, SQL Error Logs, and Log File Viewers for software and hardware-related errors. · Created linked servers between SQL Server and Oracle 9i, 10g and 11g, and Teradata and DB2. · Knowledge of Business Intelligence Tools to Create SSRS Reports, SSIS Packages, and SSAS with OLAP. · Expertise in implementation of security models; Database authentication modes, and the creation of users Configuring permissions and assigning roles to users. · Expertise in performing data transformations between servers using BCP, DTS, SSIS, and bulk insert.