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
Network Health 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,NJ Jan 2011 – Oct 2011
SQL SERVER DBA/ BI Developer
Sony 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, Sony 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,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,Tennessee Jan ’08 – May ‘09
SQL Server DBA

Confidential,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 Bridgestone 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 Bridgestone 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