Summary & Expertise:

• 7+ Years of extensive experience in SQL Server database, out of which 6+ years as a SQL Server DBA in Development, Test and ProductionEnvironments.
• 24 X 7 Production Database On Call Support.
• Extensive Experience in Database Design, Administration, Implementation and Application Development.
• Extensive experience in Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008.
• Expertise in Performance tuning and Optimization, Data integrity and statistics.
• Expertise in database Backup, Recovery and Disaster Recovery solutions.
• Expertise Migration of Data into SQL Server from variable data source using BCP, Bulk load, Data Transformation Services (DTS) and SSIS.
• Experience in Software Development Life Cycle (SDLC) and configuring Alerts using SQL Mail, DB mail and CDO.
• Implemented high availability solutions using Microsoft Failover Clustering, Replication and SQL Server Log Shipping in OLAP & OLTP environments.
• Expertise in implementing and maintaining Snapshot, Transactional and Merge replication in SQL Server 2000 and SQL server 2005.
• Installed, configured and administered Clustered instances in Active/Active, Active/Passive environments.
• Experience in Configuring database Mirroring and Database Snapshots.
• Experience in Designing, Establishing a strategy to manage data across servers using linked servers.
• Experience in Creating, Managing, Maintaining Database objects and Security Audit issues.
• Excellent knowledge with SQL Server Storage Structures and security Architecture residing databases on SAN storage.
• Extensive experience in controlling the user privileges, monitoring the security and audit issues.
• Extensive Experience in upgrading and migrating SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations.
• Experience with SQL Server 2005 DDL/DML Triggers.
• Good knowledge in Data warehousing concepts.
• Documented Disaster recovery plans and participated in Disaster recovery drills.
• Experience in Business intelligence development environment using Microsoft DTS, SSIS, SSRS, and SSAS.
• Expertise in maintaining Change control and Release management process.
• Experience in allocating system storage and Capacity planningfor future storage requirements for the database system.
• Extensive experience in using SQL profiler, System monitor, Query analyzer, Net monitor and Process explorer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code.
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of data.
• Installed, configured and administered Microsoft SharePoint servers.
• Have strong analytical, problem solving skills, Good communication skills and ability to work independently.

EDUCATIONAL QUALIFICATION:

• Master of Computer Applications (M.C.A.)

Summary of Tools and Technologies

Databases

MS SQL Server 2008/2005/2000, ORACLE 10g/9i, My SQL

Operating Systems

Windows 2000/2003/NT, UNIX

Languages

T-SQL, PL-SQL, HTML, DHTML

ETL Tools

SSIS 2008/2005, DTS, BCP

Reporting Tools

SQL Server Reporting Services 2008/2005, Crystal Reports

.Net Technologies

ASP.NET, VB.NET, C#.NET

Performance Tuning Tools

SQL Profiler, DTA (Data Tuning Advisor)

Tools

TOAD, IIS 6.0,MS-Office 2003/2007

Professional EXPERIENCE:

Confidential, Lyndhurst, NJ Nov 2007 - Present

SQL Server DBA .
IncentOne has provided integrated incentive solutions to clients ranging from small businesses to the FORTUNE 500, including half of the FORTUNE 50. Clients have included Washington Mutual, Blue Cross Blue Shield and the United States Postal Service. Incentone's technology-based solutions provide the tools to drive employee performance and productivity improvements, increase sales, faster customer loyalty and retention and reduce health care costs.

• Responsible to provide 24x7 DBA & Production support
• Ensured the integrity and security of production-level SQL servers
• Provided Database Administration and Support for on Windows2000 and Windows2003. Responsibilities include assisting Microsoft SQL Server customers with Configuration, Administration, implementation and troubleshoot SQL Servers for all in house and Vendor applications
• Installed different versions of SQL Server in a Clustered (Active/Active and Active/Passive clusters onSAN technology) and Non Clustered Environment
• Responsible for Setup and maintaining Log shipping,Replication for DW and Reporting use
• Monitored SQL server performance on regular basis, and gather data for trending analysis
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries
• Used SQL profiler, System monitor, Query analyzer, Net monitor and Process explorer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production environment
• Developed automated daily, weekly and monthly system maintenance tasks such as database backups, database integrity verification and indexing
• Participated in efforts to provide 24/7 global DBA support to software developers
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Working with SQL Server 2008 in non-production environment.
• Reviewed T-SQL code written by developers to follow better standards, procedures to optimize for better performance before QA deployment
• Managed capacity planning and implement database security for multiple instances of development, QA, Integration and Production SQL Server databases
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005
• Experience in securing databases using Sox compliance methodologies
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers
• Configured and Monitored database Mirroring

Environment: SQL Server 2000/2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), Windows 2000/2003, Visual Studio .NET, BMC Patrol,Microsoft SharePoint, Litespeed.

Confidential, Jersey city, NJ Dec 2006 - Oct 2007
MS SQL Server DBA
Confidential, a world leader in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer.

• Provided Database Administration and Support for on Windows2000 and Windows2003. Responsibilities include assisting Microsoft SQL Server customers with Configuration, Administration, implementation and troubleshot SQL Servers for all in house and Vendor applications
• Upgraded\\Migrate SQL Server 2000 to 2005 , executed MBSA tool to implemented suggestions in Cluster
• Involved in Physical , Logical design and Schemas for databases of new application
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging
• Remote Monitoring of SQL Server 2000/2005
• Performed Physical and LogicalData Modeling for databases of varied sizes including VLDBs
• Designed and implemented capacity planning module to make future projections in terms of system resources
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones
• Designed and configured Active/Active, Active/passive Clusters for high availability
• Involved in migrating servers using in place and side by side upgrade
• Configured Log shipping, Replication, Mirroring and database Snapshots
• Coding efficient SQLServer Stored Procedures and User Defined Functions using TSQL and using appropriate Index hints, Join hints, Lock hints and suitable Transaction Isolation level
• Monitored and tuned both server and databases using DBCC, Server configurations options (sp_configure) and Database options (sp_dboption). Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
• Configured and wrote SQL scripts for ESP Jobs
• Installed, configured and administered Microsoft SharePoint (2.0) servers
• Installed and Configured SSRS using Local, Scale-out, Scale-up mechanisms and deployed the reports using these mechanisms

Environment: SQL Server 2000 and 2005, Oracle 9i/10g, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) , Windows 2000/2003, Visual Studio.NET , Tivoli, BMC Patrol, VERITAS Net backup , LiteSpeed, TOAD.

Confidential, Atlanta, GA. Oct 2005 - Nov 2006
SQL Server DBA
Confidential, is the world's largest home improvement retailer and the second largest retailer in the U.S. US Expense retail project is to create the expense reports for all the stores. New tables are created and Hyperion and MSRS reports are generated. Credit customer Analytics project sends the data to Citi bank and Dunnhumby for the research purpose.
Involved in Design, Analysis, Implementation & Administration of MSSQL databases in Multiple Environments (Design, Development, User Test & Production) handling requests and requirements for multiple users for the Home Depot.

• Successfully upgraded from SQL Server 2000 to SQL Server 2005 in all environments using in place and side by side upgrades.
• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005.
• Responsible to provide 24x7 DBA and Production support
• Installed and configured Transactional and Snapshot Replication for production servers to another production server available in remote locations.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Secondary Server to support Disaster Recovery Solution.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler and using monitoring tool.
• Created Logins, Users and Roles with appropriate permissions.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Managing Backup & Maintenance Plans.
• Providing support for the Production, Development and QA Servers for SQL Server 2000/2005.
• Providing support to Server DBA's in Performance Tuning and Query Designing
• Created maintenance plans in Native and LiteSpeed modules

Environment: SQL Server 2000/ 2005 , Windows 2000/2003, Visual Basic 6.0, Oracle 8i/9i , SAP, ASP.Net ,ESP, BMC Patrol, Litespeed and Crystal Reports.

Confidential, Hyderabad, India June 2004 - Sep 2005
Jr. SQL Server DBA
The application was developed to computerize the operations of a Banking Organization. It can handle Savings account, Current account and Recurring deposit account. Special emphasis was given to the Generation of Reports based on dates. Extensive search can be made based on Account Number and Account holder\'s Name. Files were integrated for smooth flow of Transactions.
Responsibilities:

• Involved in system study and database designing
• Managing Backup & Maintenance Plans.
• Created Logins, Users and Roles with appropriate permissions.
• Installation of SQL Server 2000 in Windows 2000
• Apply Service Packs for SQL Server
• Designed different kinds of transactions for the application
• Involved in Performance tuning, optimization of stored procedures and queries.
• Developing ( data transformation services ) DTS packages.
• Writing stored procedures and triggers according to the requirement
• Created views consisting of computed columns to facilitate easy user interface
• Wrote Stored Procedures and DTS packages for maintenance tasks in Production environment.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler.
• Involved in implementation of Disaster Recovery of SQL Servers.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and System Performance
• DBA support for a development team customizing and testing new releases of Client Server applications
• Providing support to Server DBA's in Performance Tuning and Query Designing

Environment: SQL Server 2000, T-SQL,Enterprise Manager, Query analyzer,Windows2000 Server.

Confidential, Hyderabad, India. May 2003 - May 2004
SQL Server Developer /DBA
Confidential, is a leading global consulting and IT services company. It has excellent domain competencies in verticals such as Automotive, Banking & Financial Service, Insurance & Healthcare, Manufacturing, and Telecom-Infrastructure-Media-Entertainment-Semiconductors (TIMES). As a diverse end-to-end IT solutions provider, Satyam offers a range of expertise aimed at helping customers re-engineer and re-invent their businesses to compete successfully in an ever-changing marketplace.
Responsibilities:

• Involved in system study and database designing
• Managing Backup & Maintenance Plans.
• Created Logins, Users and Roles with appropriate permissions.
• Installation of SQL Server 2000 in Windows 2000
• Designed different kinds of transactions for the application .Involved in Performance tuning, optimization of stored procedures and queries.
• Developing DTS packages
• Writing stored procedures and triggers according to the requirement
• Created views consisting of computed columns to facilitate easy user interface
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database
• Disk space management, memory management and user connections.
• Created Stored Procedures, cursors for complex queries
• Built SQL Queries to retrieve and manipulate data
• Responsible for backend programming such as creating tables, views
• Providing support to Server DBA's in Performance Tuning and Query Designing

Environment: SQL Server 2000, T-SQL, Enterprise Manager, Query analyzer, Advanced Windows 2000 Server.

Confidential, Mumbai, India Nov 2002 - Apr 2003
Client: Confidential
SQL Server developer

• Description: Apollo Health Street is an end-to-end healthcare focused Services Company, with impeccable credentials; proven track record and unwavering commitment aimed at delivering value added services to its clients. It is backed by the renowned Apollo hospitals group, headquartered in India, whose integrated healthcare network involves 35 hospitals, 40 clinics and 100 plus pharmacy outlets, a workforce of 16000 including 4000 physicians.

• Involved in User Requirement Gathering and TechnicalSpecification Documentation
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer the SQL Server 2000
• Worked on Query Optimization through query Analysis and Index Optimization.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL
• Back end Experience in MS SQL Server development, writing T-SQL storedprocedures, triggers, cursors, UDF's
• Created DTS Packages to transferring the data to and from the database using IMPORT and EXPORT wizard
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing
• Worked on running DTS packages, troubleshooting the packages and logging the errors for error handling
• Involved in Source Control Explorers like Visual Source Safe (VSS 6.0) and for maintaining different versions on Scripts and DTS packages
• Created Partition Metadata for OLAP partition and Fact Table
• Created the run time command files, automation code for all the scripts
• Also I run many batch scripts for copying, deleting and renaming files in different folders using Execute Process Tasks
• Involved on Testing on the column mapping from source to target tables, calculate the values according to business requirement