SUMMARY

• Over 8+ Years of IT experience which includes System Analysis and Design, Development, Support & MS SQL Servers 2000/2005, 2008 and 2008R2.
• Configured the servers on 32 bit and 64 bitclustered and standalone server environments.
• Worked on huge number of Production and Test Servers.
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005, 2008 and 2008R2.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good knowledge about Client Server Architecture/Database Architecture/Server architecture and Administration Architecture.
• Worked on Extensive environment of VLDB of 1 Tera Byte.
• Worked extensively on Active-Passive Clustering of SQL 2005/2008/2008R2 and server consolidation. Troubleshooting production issues and raising high availability.
• Migrated VLDB around 1 Tera Byte from SQL 2005 to SQL 2008.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication and Log shipping for SQL Server High Availability.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, and SYSTEM VIEWS for the instant analysis.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Used Indexes for improving query performance, lower storage and maintenance cost.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
• Expert in analyzing the execution plan and index management.
• Experience in using FOGLIGHT, SPOTLIGHT tools for tuning and for optimal performances of SQL SERVER.
• Explicitly used third party tools like IDERA Diagnostic Manager, FOGLIGHT, Spotlight and Performance Analysis tool.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans and Explicitly used COMMVAULT tool for backup jobs.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles (Securable and Permissions).
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables.
• Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
• 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
• Involved in all phases of the SDLC (software development life cycle).
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEMcontrol flow tasks and data flow tasks SSIS.

TECHNICALSKILLS

Windows Vista/XP/2000/NT/2003/2003R2/2008/2008R2, Server 2003,Server 2008

Databases:

MS SQL Server 2008R2/2008/2005/2000, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS:

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools:

SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Data Modeling Tools:

IDERA Diagnostic Manager, Light speed, Foglight,Commvault.

Languages:

T-SQL, C/C++, Visual Studio2005/2003,XML,HTML, ASP.NET, VB.Net,IIS

Applications:

Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer,Sharepoint

Education:

• Bachelors

Certifications:
Microsoft SQL SERVER 2005 -Certified (ID: 8074617)

Professional Experience

Confidential, Medford, MA Nov 2011 – Till Date 
SQL Server DBA/DEVELOPER 
Confidential is a comprehensive health planto improve access to affordable health care in Massachusetts. It is one of five MMCOs contracted by the Commonwealth of Massachusetts to provide health care coverage for the state’s MassHealth population, one of five MMCOs serving the Commonwealth Care population, and the only MMCO serving the Medical Security Program Direct Coverage population.
Responsibilities:

• Installing, configuring, administering and securing production and non-production servers.
• SQL SERVER 2008R2/2008/2005/2000 Production Environment.
• Worked in Active passive cluster environment.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Migrated DTS packages to SSIS packages.
• Monitored and modified Performance using execution plans and Index tuning
• Created new tables, stored procedures and triggers in T-SQL.
• Refactored and Fine-tuned the queries and Stored procedures in T-Sql.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Migrated DTS packages to SSIS packages and Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Checking Database Health by using DBCC Commands and DMVS.
• Extensively involved in Query optimization using execution plans.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Extensively involved in Index Tuning, Query Tuning and Database Tuning.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Extensively worked on Transactional Replication.
• Expertise in SQL server Reporting Services(SSRS)
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on migration and maintenance of data using various utilities like EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Extensively used IDERA for performance monitoring tool.
• Applied Patches and Service packs to update different versions of MS SQL SERVER in Clustered and Standalone Environments.
• Worked on Resource Governor which is new feature on SQL 2008.
• Maintaining User account administration for Different domains.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• To set up SQL Server configuration settings.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS,VM ware, IDERA,EMBARCADERO, MS- Excel, SQL Mon, XML, ASP.NET, VB.Net, IIS

CONFIDENTIAL, Park Ridge, NJ Jan 2011 – Oct 2011
SQL SERVER DBA/ BI Developer
Confidential is committed to developing a wide range of innovative products and multimedia services that challenge the way consumer’s access and enjoy digital entertainment. By ensuring synergy between businesses within the organization, Confidential is constantly striving to create exciting new worlds of entertainment that can be experienced on a variety of different products. 
Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2005/2008 on Windows
• Migrated databases from SQL Server 2000 to SQL Server 2008 and documented the process with Pre-Migration and Post-Migration steps.
• Worked on Large databases around 1Tera Byte.
• Developed SSIS packages in importing data into slowly changing dimensions tables in the Data warehouse databases.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot Isolation, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Rendered Drill down, Static reports in Matrix form in SSRS.
• SQL Server 2005 and SQL Server 2008/2008R2 Failover Cluster Installation and Experience with Cluster Configuration in SAN environment.
• Applied Patches and Service packs to update different versions of MS SQL SERVER in Clustered and Standalone Environments.
• Fixed the failed PRINCIPALS (logins),user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2005.
• Scheduled regular BACKUP JOBS using COMMVAULT backup tool and kept track of DATABASE by receiving the emails on Alerts.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Snapshot, DMV’s, DMF’s.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used COMMVAULT backup tool with MS SQL SERVER 2005.
• Utilized the new features of 2008 like TCE, EKM, MERGE STATEMENT and Compressed Backups.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Utilized Foglight for monitoring the deadlocks, blockings and windows level performance also.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Implemented SSL certificates for network level encryption for database security.
• Creating logins and mapping the user to roles by assigning permissions.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Maintaining User account administration for Different domains.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL SERVER 2000/2005/2008,SSRS,SSIS, VISUAL STUDIO 2005 ,WINDOWS SERVER 2008/2003,IIS,Foglight.

Confidential,Edison, NJ Jun ’09 – Dec’10 SQL Server DBA/SSIS/SSRS

Confidential is the world\'s largest luxury goods company. LVHM is the parent of around 50 subsidiaries, that each manages a small number of prestigious brands. These subsidiaries are, to a large extent, run autonomously. The current business plan aims to tightly control the brands it manages in order to maintain and heighten the perception of luxury relating to their products. 
Responsibilities:

• SQL SERVER 2005/2000/2008 Production Environment.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005.
• Rendered Drill down, Static reports in Matrix form in SSRS.
• Used SSIS packages to move data from dev to QA and QA to Production.
• Deployed maintenance plans for regular DBA activities in SSIS.
• Scheduled night jobs for importing large amount of data using SSIS Packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILERand ACTIVITY MONITOR for performance analysis.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Checking Database Health 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 for the Disaster Recovery plan. Worked in Active passive cluster environment.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually.
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used Litespeed backup with MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS) and SharePoint
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7Support on weekly basis

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows 2003 64-bit, DTS, SSIS, SSRS, Profiler, LiteSpeed.

Confidential, Nashville, Tennessee Jan ’08 – May ‘09 
SQL Server DBA

The Confidential Group expanded its business to become largest tire manufacturer. In 1988, the company acquired The Firestone Tire & Rubber Company, a well-respected global corporation with a venerable history of its own. This transformed Confidential into one of the world\'s largest tire and rubber companies and created a global team dedicated to serving customers worldwide with the highest level of quality, service and technology. It provides people with a deeper understanding of the Confidential Group\'s strengths, as well as our future direction.

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• 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
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Using the Lite speed to take backups.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS
• Used Data Partitioning and Snapshot Isolation in SQL Server 2005/2008. Using log shipping for synchronization of database.
• Good experience in data modeling and metadata services.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, SSAS,VM ware, Litespeed, Spotlight, MS- Excel, SQL Mon

Confidential, Baltimore, MDApr ‘07 – Dec ‘08 
SQL ServerDBA 
CONFIDENTIAL deals with Medicaid and Medicare transactions to the Maryland state from various hospitals. Medicaid and Medicare bills are processed according to the HIPPA rules. CONFIDENTIAL Processes the various types of transactions related to claims and payments, which are mainly involved in recognizing how the claims should get paid.Third party liabilityis about thepatient having the insuranceother than the state providedMedicaid.This project is mainly related to Medicare claims processing of State of Maryland.
Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2008/2005 on windows 2003/2008 on clustered environment.
• Workedon32 bit,64 bitclusteredenvironments.
• Performed Node Injectionfor the enhancements of hardware in the Clustered environment.
• Installedandconfiguredandmaintained failover clusteringforSQL SERVER 2005.
• Migrationof databases fromSQL Server 2000/2005toSQL Server 2005, 2008.
• Monitored Log shippingas high availability solution.
• ConfiguredServer Memoryfor maximumPerformanceand effective utilization.
• Monitoring SQL server performance usingprofilerto find performance anddeadlocks.
• IntegratedPerformance monitorandSQL tracesto have better graphical analysis to find system bottlenecks.
• Administered and maintained windows 2003 server based network of 40 servers.
• Implemented RAID1 and RAID5 on mission critical servers.
• Proficient in working knowledge of Clustering and SAN.
• UsedDynamic Management Views (DMV)for monitoring the performance of the server.
• Worked withIP MonTool by setting upalertsfor the Monitors of various SQL Servers.
• PerformedDatabase Integrity Checks, updated Database Statistics and performedRe-indexing through Maintenance Planner.
• Maintaining the databaseconsistencywithDBCCat regular intervals.
• CreatingSQL Server Loginsand assigningRolesandAuthentication Modesas a part ofSecurity Policiesfor various categories ofUser Support.
• CreatedMaintenance Plansthat helped in effective disk utilization and index maintenance.
• Effectively managed disk space usingEMC toolfor Data base Backups.
• Created, Scheduled and monitoredSQL Server Jobs,making sure jobs run successfully every night.
• Extensively worked onProduction supportand involved in trouble shooting SQL servers in various levels.

Environment:Windows 2000/2003/2008, MS SQL Server 2000/2005/2008,Microsoft.NET, SSRS, SSIS, SSAS, MS Office Access 2003.

Confidential, Dallas-TX Feb ‘05– Mar ‘07
SQL Developer/DBA

Citi, the leading global financial services company, has some 200 million customer accounts and does business in more than 100 countries, providing consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, and wealth management.
Responsibilities:

• SQL Server 2005/2000 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
• Established Maintenance Plans for Regular Backups and Index rebuilding.
• Expertise in Tuning Slow running queries using Profiler and Statistics IO by using different approaches like evaluating joins, indexes, updating Statistics and code modifications.
• Configured more than 2 GB ram on 32 bit Environment.
• Migrated DTS packages to SSIS packages and successfully implemented the Capacity planning for different servers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Checked Database Health by using DBCC Commands and DMVS. Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Wrote scripts to extract data from database tables and write the data to textFiles.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity, procedures and functions for business & data transactions with error handling.
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Tuned stored procedures by adding the try catch blocks for error handling. Created the documentation for issue diagnostics reports.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance.

Environment: Windows 2003, MS SQL Server 2000/2005, Oracle, .Net, VB and ASP

Confidential, Bangalore, INDIAAug ‘03 – Dec ‘04 
SQL Server Developer 
Confidential is a global IT services and solutions provider provides the winning edge to our clients by leveraging our Business-to-IT Connect and deeply committed people. Clientsinclude industry leaders like Chevron, Hitachi, Sanyo and Lafarge, among others. They have Seven decades of a strong, customer-focused approach and the continuous quest for world-class quality has enabled it to attain and sustain leadership in all its major lines of business. Confidential has an international presence, with a global spread of offices. A thrust on international business has seen overseas earnings grow significantly.
Responsibilities:

• Installed and configured SQL Server 2000.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Dropped and recreated the indexes on tables for performance improvements.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Created indexes to speed the execution of data retrieval queries and stored procedures.
• Experience in applying Service Packs at database and OS Level.
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Worked on Fail over Clustering for SQL Server databases for mission critical applications.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.

Environment: SQL Server 2000, ASP, Windows 2000.