Rss

Karunakar S

Database Administrator - 14 Years of Experience

Occupation:

Database Administrator

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

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.

Right_template4_bottom

CollapseWork 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
Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom