PROFESSIONAL SUMMARY

SQL Server Database Administrator having 7 years of experience, well versed in all phases of System Development Life Cycle (SDLC) including analysis, design, programming, implementation and maintenance of stand-alone and web-based database applications with the following abilities:

• Total 7 years of IT experience and extensive experience in MS-SQL Server Development and Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning.
• Expert in data migration from MS SQL Server 2000 to 2005/2008, including Replication and clustered SQL Servers.
• Designing, testing and implementation of high availability solutions like Clustering, Database Mirroring, Log Shipping,andReplication of databases for large, medium and small customers to further increase scalability and stability of business critical systems.
• Experience in data migration from existing databases to remote data centers.
• Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Managed databases on multiple disks using Disk Mirroring and RAIDtechnology.
• Experience in writing complex queries using T-SQL, stored procedures, triggers, user defined functions, and views
• Expertise in developing drill-through, drilldown reports using SQL Server 2005 Reporting Services (SSRS)
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC, DTUTIL and BULKINSERT.
• Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.
• Experience in implementing different types of Replication Models.
• Has good knowledge in implementing Log Shipping Technique as a part of disaster recovery plan.
• Experience in writing and debugging Stored Procedures, Views and Triggers.
• Experience in performance tuning of very complex SQL statements and procedures using show plan.
• Proven ability in Performance Tuning andQuery Optimization.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
• Created clustered and non-clustered indexes for increasing the performance, also monitored the indexes by troubleshooting any corrupt indexes by removing fragmentation from indexes.
• Provided 24/7 database maintenance and support.
• Knowledge in Third party tools like TOAD, LiteSpeed, AutoSys and Foglight.
• Good Team Player, Strong Interpersonal, Analytical and Communication Skills combined with self-motivation.
• Self-motivated, creative team player with effective communication and Leadership qualities.

EDUCATIONAL QUALIFICATIONS

Bachelor of Engineering in Electronics and Communication

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C,C++,C#.

Database Application Software: SQL Server 7.0/2000/2005/2008, MS Access, Oracle

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSIS, SSAS.

ETL Tools: SSIS,DTS

Application Software: Microsoft Office, macros

Change Management Tool: Visual Source Safe (VSS), Team Foundation Server (TFS),BMC Remedy

Operating Systems: Windows Server 2000/2003, Windows NT 4.0
Windows XP/98/95, MS DOS, Linux.

Third Party Tools: Lite Speed, Performance Dashboard, TOAD, Foglight

PROFESSIONAL EXPERIENCE

Confidential, MN July '11 - Till Date
Sr.SQL SERVER DBA

Description:

Confidential, is the largest hair salon chain in the world, with over 11,000 salons (including both company-owned and franchises). Its namesake is Regis Hair Salons, and it also owns the chains Carlton Hair International in Southern California, Images Salon in Las Vegas, NV, Michael of the Carlyle in Colorado Springs, and Denver, CO City Looks, Famous Hair, Best Cuts, Saturday\'s, HCUK, Supercuts, Pro-Cuts, Hair Crafters, Magicuts, MasterCuts, Borics Hair, Hair by Stewarts, Trade Secret, PureBeauty, SmartStyle, Cost Cutters, TGF Hair Salon, Hair Masters, Style America, Holiday Hair, and Mia & Maxx Hair Studio mostly in the United States,

Responsibilities:

• InstalledSQL server 2008 R2 on windows 2008 R2 advanced servers, applied service packs andsecurity fixes.
• Imported Data from text files and excel spread sheet into SQL Server 2000 database using DTS package.
• Setup Cluster environment in SQL Server 2005.
• Configured transactional replication between primary Server and Read-Only servers with separate distributed servers.
• Created backup strategies and scheduled them for execution.
• As a part of Capacity planning made performance baseline for 2008 R2 servers using perfmon (Performance counters)
• Worked with the Application team to ensure upgrade doesn't affect any application.
• Upgraded about 30 servers from SQL Server 2000 to SQL server 2008 R2.
• Migrated SQL server 2000 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment.
• Worked on writing complex queries using T-SQL, stored procedures, triggers and views
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2008 R2.
• Extensively worked on SQL Server Integration Services (SSIS).
• As a part of migration worked on converting from DTS to SSIS packages.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Configured the database maintenance plans for database optimization.
• To provide actionable performance insight SQL Server 2008 ,Extensively used Data Collector and Management Data Warehouse
• Provided with a wide variety of options in managing the environment, created Policies and checked for compliance. Administering Servers by Using Policy-Based Management
• Experienced in performance tuning using windows performance monitor and SQL profilerof SQL server
• Creating the users, user groups and maintains the access permissions
• Configured Replication methods like snapshot, transactional replications.
• Worked on DTS packages and SSIS packages for transferring data from various data sources like DB2,Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers.
• Setting up database back up and recovery procedures for production, quality and development servers
• Developing triggers, stored procedures and enforcing business rules via checks and constraints
• Performance tuning and optimization of procedures and queries.
• Worked with SQL server profiler to generate traces

Environment:

Windows 2008 Advanced Server, MS SQL Server 2000/2005/2008R2,SQL Server Integration services(SSIS), MS Access, Excel.T-SQL.

Confidential, PA Dec'10 - June'11
Sr. SQL DBA

Description:

Confidential, is a diversified national insurer in United States. Coventry operates health plans, insurance companies, network rental and workers' compensation services companies. Coventry provides a full range of risk and fee-based managed care products and services to a broad cross section of individuals, employer and government-funded groups, government agencies, and other insurance carriers and administrators.

Responsibilities:

• Managed 120 SQL servers including Prod, Dev and QA.
• Worked with Terabytes of Data with over 3000 databases
• Installed, configured and managed MS SQL 2005 and 2008 fail over Clustering for production servers on 64 bit platforms to provide high availability.
• Worked on Active - Active and Active - Passive clustering environment.
• Post deployment Installations on SQL 2008 servers on Windows 2008 servers.
• Installed recommended service packs and security patches on production, test and development servers.
• Migrated Databases from SQL 2005 to SQL 2008.
• Thorough understanding of standard SOP's, SLA's and change control management process.
• Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
• Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest FogLight.
• Experience with third party tools like FogLight and Veritas Netbackup.
• Configured 43 Production servers using Foglight monitoring tool.
• Deployed the SSIS packages using manifest file in Production environment.
• Created Linked Servers between SQL server 2005/2008 and Oracle servers in the environment
• Created batch files for Veritas Netbackup and scheduled them with SQL Job for both system and User Databases.
• Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2008
• Used PerfMon and Profiler trace files to find the blocking issues which occur as a result of I/O and CPU bottle necks and memory leaks.
• Worked on 24 /7 Production support understanding the business SLA's.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Conversion of the legacy systems data into MS SQL server using SSIS packages.
• Designed databases for different projects and resolve database issues.
• Created SSIS / DTS packages to pull data from Oracle and Flat Files.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Generated different reports using MS SQL Reporting Services.
• Performed Database refreshes from Prod to UAT and Dev servers
• Reviewed and deployed the code provided by developers in Prod and QA servers.
• Involved in handling Work Orders and Documentation of the Change Process by creating Tasks using Service Center.
• Experience in using Citrix software application
• Manage security issues by analyzing permission structure and make the necessary adjustments to ensure people have the appropriate privilege.

Environment:

SQL Server 2000/2005/2008,T-SQL.Windows Enterprise Server 2003/2008, Microsoft Visio 2003, Microsoft Integration Services. T-SQL, Query Analyzer, SQL-Profiler, Foglight, Citrix application.

Confidential, NJ Jan '09 - Nov '10
Sr. SQL Server DBA

Description:

The project is to provide services in the area of Software Development and Maintenance, on site and Remote Database Administration, and Business Intelligence Solutions.

Responsibilities:

• Responsible for application configuration and migration between development, test, and production environments.
• Primary responsibilities include profiling, performance tuning & redesign, high availability server network and disaster recovery.
• Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• Extensively worked on SQL Server Integration Services (SSIS).
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Solving the Bugs Reflected by the Testing team
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible forDesign and Development of SSIS Packages to load the Data from various Databases and Files.
• Performed daily tasks includingbackup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handlingthrough TRY-CATCH statement, Common Table Expression (CTE).
• SQL 2000, 2005 - Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.

Environment:

SQL Server 2000/2005 Enterprise, T-SQL,Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2003, SFTP, Microsoft Integration Services.

Confidential, TX Nov '06 - Dec'08
Sr. SQL server DBA

Description:

Confidential, is the largest financial services group in the world, offering a diverse array of corporate and personal financial products and the greatest global distribution capacity of any financial firm.

Responsibilities:

• Installation, configuration of MS SQL Server 2000, 2005, 2008 for development and testing purpose.
• Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration.
• Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.
• Created and monitored database maintenance plans for checking database integrity
• Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server's logins (Windows and SQL Accounts).
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created DTS packages to export and import data from SQL SERVER to Access, text and EXCEL files.
• Responsible for database backups & restoration and scheduling backup strategies.
• Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Planning, implementing and troubleshooting Snapshot and Transaction Replication.
• Prepared Estimates for Database, table size growth.
• Worked with SQL Server Reporting Services (SSRS), implemented report builder to allow customers build their report.
• Generated reports using SQL server report manager and published as PDF formats.
• Created report models for Report Builder and managed reports using Report manager.
• Migrated report system from a custom Crystal Reports system to SQL server 2005 Report Services.
• Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.
• Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Involved in migration of SQL Server 2000 to 2005 Cluster.
• Monitoring the event logs and server error logs for troubleshooting.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Performance tuning, finding the CPU Bottlenecks, SQL Server Bottlenecks.

Environment:

T-SQL, Query Analyzer, SQL-Profiler, Windows 2000, SQL Navigator. SQL Server 2000/2005 Enterprise Edition, Windows 2000 advance server, Crystal Report 11.0 SQL Server Reporting services (SSRS) SQL Server Management Studio (SSMS).

Confidential, INDIA Jun '04 - Sep '06
SQL Developer/DBA

Description:

This module involves the systems integration, interfacing, installation, commissioning, software development, as well as education and training, on an ongoing basis, computerization of the finance department in the company and to integrate the existing modules like Sales Accounting, Marketing Management System, Purchase & Stores Accounting System and Production being developed .This software caters to the financial accounting needs of all the units of the company, which makes the maintenance of the accounts at IDT easier.

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment:

SQL Server7.0/2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP, Replication.