Description
Summary: * Over 8 years of experience working with Microsoft SQL Server in Production, Development and Testing in Clustered Environments. * Experienced in installing MS SQL Server 2005/ 2008/ 2008R2/2012/2014 and updating with hot fix and service packs. * Extensive experience in implementing high availability solutions on physical and virtual machines. * Implemented Migration and in-place Upgrade of MS SQL Server 2005/2008/ 2008R2/2012/2014. * Experience with Backup and restore of databases manually and by scheduling the jobs and Maintenance Plans. * Expert in Data Integrity, Performance Tuning and Query Optimization. * Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements. * Performed BCP, imported and exported data from different Data Sources. * Handling Memory configurations for SQL Server 2005/ 2008 on Windows 2003/2008/2012 Servers. * Experience in analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects. * Extensively used the native tools like index, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis. * Worked on setting up the SMTP Server for Database Mail setup and received alerts for the Threshold values. * Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN. * Worked on logins, user permissions and security on SQL servers. * Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases. * Expert in analyzing the execution plan and index management for better Query Optimization. * Strong ability in Scheduling and deploying reports on Report manager. * Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements. * Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard. * Created SSIS packages to validate, extract, transform and load data from Oracle into SQL Server database. * Converting DTS packages to SSIS packages. * A good team player with great interpersonal and communication skills.