Description
Professional Summary: * 2+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments on SSMS tool. * Experience installing MS SQL SERVER 2005,2008,2008 R2,2012, 2014 updating with hot fix and service packs * Strong understanding of RDBMS concepts as well as Data Modeling Concepts. * Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines. * Extensively worked on Active-Active and Active-Passive Clustering. * Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non prod environments. * Configured Always-On with synchronous and asynchronous secondary replicas. * Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012 * Experience in developing T-SQL (DDL, DML, and DCL) statements. * Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard. * Experienced in Cloud Migration with AWS * Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE). * Experience in using the DMVS, DMFS, SP_PROC's, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis. * Expert in Data Integrity, Performance Tuning, Query Optimization * Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing. * Expert in creating Views. * Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases. * Configured the AWE and /3 GB switch for the SQL server 2005 on 32-bit boxes. * Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server. * Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering. * Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects. * Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis. * Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, Updating Statistics. * Expert in analyzing the execution plan and index management for better Query Optimization. * Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values. * Customizing and generating multiple TFS reports to serve company needs. * Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. * Experience in using DMV and DBCC commands for various performance issues. * Extensively used third party tools like Lite Speed, Fog light and Red gate. * Auditing of database for Users transactions, login and database action and removing orphan users * Worked with a team of business analysts, data architects, application developers, ETL developers and testers * Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server. * Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System. * Experience in creating SQL Server Reports using SSRS 2005 and 2008. * Experience working on Hyper-V and VMware environments * Experience working with Change control process/Change management * Loaded Data into Oracle Tables using SQL Loader * Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. * Strong experience in mentoring junior team members, documentation and 24/7 on call production support * 24 7 Production support experience
Accomplishments
Highlights:
Keywords
