Description
SUMMARY: * 9+ years of experience with the 32bit, 64-bit environments as Microsoft SQL SERVER DBA in Production, Development and Testing in Clustered and Stand alone Server Environment. * Experience in installing MS SQL SERVER 2016, 2014 2012, 2008R2, 2008, 2005, 2000 updating with hot fix and service packs. * Good knowledge and handful of experience on implementing Always on High availability feature. * Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines. * Extensively worked on Active-Active and Active-Passive Clustering. * Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases. * 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 comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics. * Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans. * Expert in analyzing the execution plan and index management for better Query Optimization. * Handful of experience in PowerShell Scripting. * Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005/2008 to 2012. * Expert in Data Integrity, Performance Tuning, Query Optimization * Expert level skills in Objects creation such as Tables, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing. * Expert in creating Views. * Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc. for finding out long running queries. * Explicitly used third party tools like Lite Speed, Fog light and Red gate. * Auditing of database for users transaction, login and database action and removing orphan users. * Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects. * Strong experience in mentoring with team members, documentation and 24/7 on call production support. * Expert in developing T-SQL (DDL, DML, DCL) statements. * Expertise in Data Modeling Concepts. * Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE). * Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources. * Experience in logical and physical data modeling of the database in ERWIN and MS VISIO. * 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 handling the Change Data Capture (CDC) with different retention time. * Experience in SQL Upgrades SQL 2005 to 2008 and Building SQL Clustering. * Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values. * Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis. * Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival. * Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. * Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines. * Experience with Microsoft SQL Server Integration Services or any comparable ETL tool and Reporting tool with SQL Server Reporting Services using Business Intelligence Development Studio (BIDS) * Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer. * 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 Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard. * Expert in creating SQL Server Reports using SSRS 2005 and 2008. * Expert in using Version Control Software like Visual SourceSafe (VSS). * Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, Drilldown reports in multiple formats using multi - dimensional objects. * Strong ability in Scheduling and deploying reports on Report manger. * Experience working with change control process * Expert in using Ms Office suite 2007 including Ms Access. * Knowledge in JAVA, VB.net, C#. * Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
Work Experience
| COMPANY | POSITION HELD | DATES WORKED |
|---|---|---|
| (Confidential) | Sql Server Dba | 12/2014 - Present |
| First Data Corporation | Sql Server Dba | 1/2014 - 11/2014 |
| Georgia Department Of Transportation | Sql Server Dba | 2/2013 - 12/2013 |
| The Coca Cola Company | Sql Server Dba | 6/2011 - 1/2013 |
| Capital One | Sql Server Dba Manager | 1/2010 - 5/2011 |
Accomplishments
Highlights:
Job Skills
Keywords

