SUMMARY:

• 9 years of experience with the 32bit, 64-bit Microsoft SQL SERVER in Production, Development ,Testing and certification in Clustered and Stand alone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2,2012, updating with hot fix and service packs
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability solutions like different Always ON Replication models Snapshot and Transactional , Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Always ON , Active-Active and Active-Passive 2 way and 4 way Clustering.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.
• 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 Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at 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 PROCS, 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 .
• Expert in creating Views.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in EMBARCADERO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large VLDB and Complex Databases.
• 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 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.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• 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.
• 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, and EMBARCADERO.
• Auditing of database for users transaction, login and database action and removing orphan users
• 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 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.
• Strong ability in Scheduling and deploying reports on Report manger.
• Expert in using Ms Office suite 2007 including Ms Access.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

M T offers a wide array of financial solutions for our personal, business and commercial banking needs, designed to accommodate the way we bank today, while helping us build financial security for the future. I was involved in the SQL server administrative activities for their migration project of Web Banking Platform from SQL Server 2000 to 2008R2 and also support their various existing Production Platforms.

Environment:

Microsoft SQL Server 2012 , Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2012 Server ,Windows 2008R2 Server, Windows 2008 Server, Windows 2007 Server, Windows 2003 Server .

Responsibilities:

• Installation and Maintenance of SQL Server2012, 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services SSIS Packages.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Confidential

SQL Server DBA

Medica strives to meet the customers' needs for health plan products and services. In doing so, Medica work with its members and providers to make health care accessible, affordable and a means by which the members improve their health. I was involved in the SQL server administrative activities for the project designed for their Claims and Provider operations department for enrollment of health care benefits provided by the company

Environment:

SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2005.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles
• Performed Database backups with tools like litespeed.
• Used SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Setting MAX DOP Max degree of parallelism to 8 for 28 GB memory.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Confidential

Sr. SQL Server DBA

The Georgia Department of Community Health DCH was created in 1999 to serve as the lead agency for health care planning and purchasing issues in Georgia. The General Assembly created DCH by consolidating four agencies involved in purchasing, planning and regulating health care. The department is designated as the single state agency for Medicaid. In 2009, Healthcare Facility Regulation was created at DCH from sections transferred from the former Department of Human Resources Office of Regulatory Services. At that same time, the Divisions of Public Health and Emergency Preparedness and Response transitioned to the department.

Environment:

SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order increase the performance with no cost effective.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Confidential

SQL Developer

Description: Bharti Airtel Limited is one of Asia's leading integrated telecom services providers with operations in India, Sri Lanka and Bangladesh. Bharti Airtel since its inception has been at the forefront of technology and has pioneered several innovations in the telecom sector. The company is structured into four strategic business units - Mobile, Telemedia, Enterprise and Digital TV.

Environment:

SQL Server 2000, Windows NT server, SQL Profiler.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee's requirement and generating.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.