SUMMARY:

• 8 +years of experience with the 32bit, 64-bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand-alone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2; updating with hot fix and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• 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.
• 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)
• Experienced in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Skilled in use of SQL Server 2008 new features such as Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experienced in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for instant analysis.
• 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.
• Performed BCP, BULK INSERT, imported and exported data from different data sources.
• 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 32 bit 2005 server
• Handled Memory configurations for SQL Server 2000 and 2005 on Windows 2003 server.
• Experienced 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 such index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor and Event viewer for performance analysis.
• Experienced in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experienced in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Extensively worked on Hot, Warm and Cold Backups; Security Management, Managing server and client Connections
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Skilled in 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.
• Experienced in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experienced in creating deployment utility to deploy SSIS packages over Production, QA and Local systems.
• Expert in creating SQL Server Reports using SSRS 2005 and 2008.
• Extensive experience in the development of Reports using SQL Server 2000/2005 Reporting Services (SSRS) and Microsoft Access; developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi – dimensional objects.
• Strong ability in Scheduling and deploying reports on Report manger.

TECHNICAL SKILLS:

SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages:

C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems:

Windows 95/2000/2003/2008/XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases:

MS-SQL Server 2008/2005/2000

ETL Tools :

Data Transformation Services, SQL Server Integration Services (SSIS), Informatica

Scripting:

Shell Scripting

Reporting Tools:

SSRS, SSAS, Crystal Reports,

DB Utilities:

SQL Server Management Utility, Query Analyzer

Application Software:

Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

DataModeling Tools:

Erwin, Red gate, Lite Speed

Bachelor of Engineering Technology.

PROFESSIONAL EXPERIENCE:

Confidential,California . March 2012-Dec 2012
The company was initially engaged in the development and production of specialty chemicals used in biochemical, pharmaceutical, and other life science research applications. Today, Bio-Rad manufactures and supplies life science research, healthcare, analytical chemistry, and other markets with products and systems used to separate complex chemical and biological materials and to identify, analyze, and purify their components. The company has been listed on the New York Stock Exchange since October 24, 2008.
ENVIRONMENT: SQLServer2000/2005/2008/2008R2, Windows2003/2005/2008/2008R2, MS SQL Server 2000/2005, Oracle,
Responsibilities

• Installed couple of SQL Server 2008 on cluster environment.
• Installed couple of SQL server installation’s
• Implemented the disaster recovery models like clustering, and transactional replication.
• Performed daily Developer/DBA tasks such as handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance jobs.
• Experienced in Database security and integrity planning.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Involved in the migration of SQL Server 2005 databases to SQL Server 2008.
• Installed, SQL Server 2005 Reporting Services
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Tuning slow-running queries using SQL Server Profiler.
• Expert in sizing Temp database.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Creating Logins and Roles with appropriate permissions.
• Creating Logins and Roles with appropriate permissions.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Hands on experience in troubleshooting database issues.
• Worked on call 24/7 within support environment on weekly basis.

Confidential,Kennesaw, GA Dec 2011-March 2012

Description: Automated Logic designs, manufactures and delivers innovative automation solutions primarily for heating, ventilating, air conditioning, lighting and energy management of buildings. Its systems are installed in commercial, educational, industrial, data center, healthcare, government, hospitality, entertainment and retail locations worldwide. Automated Logic is a subsidiary of Carrier Corp. A unit of United Technologies
Environment:
Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2/2008, Microsoft SQL Server 2005, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, XML.
Responsibilities:

• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Tuning slow-running queries using SQL Server Profiler.
• Resolving locking and blocking issues.
• Importing data across multiple instances using BULK INSERT and BCP Utility.
• Extracting, Transforming, and Loading data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Planning, analyzing and developing Reports using SQL Server Reporting Services (SSRS)
• Successfully migrating data between different heterogeneous sources such as flat file, Excel.
• Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Creating and managing database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Creating Clustered and Non-Clustered Indexes to improve the performance of database access.
• Using log shipping for synchronization of databases.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Working with TFS and MS Visual Source Safe as a Version Control System.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.

Confidential,Bentonville, AR APR-2011-Oct 2011
SQL SERVER DBA

Description: Wal-Mart Stores, Inc, Is a multinationalretail corporation that runs chains of large discount department and warehouse stores. The company is the world\'s 18th largest public corporation. It is also thebiggest private employerin the world with over 2 million employees, and is the largest retailer in the world

Environment:
Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 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.
• Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.
• Writing T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tuning slow-running queries using SQL Server Profiler.
• Importing data across multiple instances using BULK INSERT and BCP Utility.
• Extracting ing, Transform, and Loading data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Created and managed database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Created Clustered and Non-Clustered Indexes to improve the performance of database access.
• Created and managed 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.
• Used 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,CA SEP2009-APR-2011
MS SQL Server/DBA
Description:1-800LoanMart is the leading provider of non-traditional lending services since 2001. They provide loans directly to consumers, as well as through a network of business partners. 1-800LoanMart is a company with a diverse portfolio of financial products, including direct financing on auto title loans.

Environment:
MS SQL Server 2005/2008/2000, Windows 2000 Advanced server NT, IIS Server 5.0, SSIS, Reporting Services, XML.

Responsibilities:

• Created and maintained various databases for Production, Development and Testing Servers using MS SQL Server 2005/2008. Planned the location of data, indexes, and Transaction log files on the disk.
• Installed and configured SQL Server 2005 on the server and client machines; provided connections and managed databases.
• Used DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
• Resolved locking and blocking issues.
• Configured up to 32 GB of memory.
• Tuning the Production server to get the performance improvement.
• Running Index Tuning wizard for optimal query performance.
• Implemented Database Mirroring as part of disaster recovery plan.
• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Providing 24*7 support to SQL application developers in implementing the applications on production server.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases

Confidential,CT JUNE2008-AUG-2009
SQL Server 2008-2005 DBA/Developer

Description: Aetna helps people to achieve health and financial security by providing easy access to cost-effective, high-quality health care. As a DBA, I was involved on data migration from various data sources such as Access, Excel and Sybase to SQL Server database systems.

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed troubleshooting of Client connections, viewing error log and applications.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) , Data Partitioning, Snapshot Isolation
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Used Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2008/2005/2000, C#., VB, VBA, ASP, .NET, Windows 2003.

Confidential,St Louis, MO JAN-2007-MAY-2008 SQL Server Developer
Description: Charter is Missouri\'s largest provider of broadband cable, high-speed Internet and broadband phone services. As part of the database management services team, My duties included maintenance of all databases owned by Charter.
Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Wrote and executedcomplex T-SQL queries using enterprise manager for backend data validation testing.
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.), to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user-defined functions implemented by developer teams into the databases.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of online systems and multiple applications.

Confidential,Atlanta, GA AUG2005-DEC2006
Senior SQL Server DBA
Description: Siemens Energy and Automation helps customers in the industrial, manufacturing and construction sectors succeed by providing complete electrical, engineering and automation solutions. Through a commitment to innovative engineering that goes back more than 150 years, Siemens serves the world\'s largest and most respected companies through integrated solutions, software, hardware and services.

ENVIRONMENT: SQL Server 2005/2000, Windows 2003, MS SQL Server 2000/2005, Oracle, .net, VB and ASP, Lite Speed, MS Visio.
Responsibilities

• Installed couple of SQL Server 2005 on cluster environment.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Performed daily Developer/DBA tasks such as handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance jobs.
• Experienced in Database security and integrity planning.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Hands on experience in troubleshooting database issues.
• Worked on call 24/7 within support environment on weekly basis.

Computer Skills & Certifications

Certifications:
Microsoft SQL server 2008 Certification – Technology Specialist