Summary

Senior SQL Server DBA with 12 years of experience in IT industry and 10 years in SQL Server 2008/2005/2000 Database Administration, Database Troubleshooting, Performance Tuning, Database Design. In the previous projects worked at Microsoft Corporation on Datawarehousing and Database administration for SQL server database servers for various Microsoft internal as well as external Customers. I have added knowledge in MySql, Oracle, and Sybase DB administration. Worked on financial, media and manufacturing applications and has fare functional knowledge in the same.

Technical Skills

DBMS MS SQL Server: 2008/2005/2000, MySql, Oracle
Tool/Languages: DTS, SSIS, SSRS, ASP, VB,VBScript, XML,IIS, COM, MTS, SQL, TSQL, Actuate, Erwin, PHP

Professional Experience:

Client: Confidential, Radnor PA Jan 2010 to present
Senior SQL server DBA
Comcast is leading provider of entertainment products and services points.Comcast supports a number of devices in your home, including stand-alone routers and a combined modem and router commonly called a Gateway.
It has multi platform and database Systems like Oracle, SQL Server, Mysql. on LINUX and Windows Servers.
The role in project as Primary MS SQL Server DBA for Comcast Converged Products group at Radnor, PA.
Worked on different features of SQL server such as SQL server 2008 clusters, SQL server Transactional and golden gate Replication, Log shipping, mirroring, performance tuning. Also worked Mysql, Oracle database administration.

Technology/Software: SQL Server 2008R2/2008/2005/2000, , SSIS, SSRS, TSQL, OS Windows's server 2008/2003, Idera SQL Diagnostic Tool, Oracle 11g, Goldengate, Mysql

• Database Administration Activities as a on call Production Support DBA for Sql Server databases for Comcast Converged Products group.
• Involved in SQL Server database installation, maintenance and follow guidelines for security as per Microsoft standards.
• Setup SQL 2005\\2008 Clustering in active\\active and active\\passive mode
• Involved in SQL server 2005\\2008 synchronous\\asynchronous mirroring
• Setup backup and recovery strategies for SQL server databases.
• Perform capacity planning and disk configurations for new hardware infrastructure
• Performance Tuning of SQL server databases.
• Implemented table partitioning to improve performance and data management
• Setup Goldengate replication for SQL servers
• Logshipping and transactional peer - peer replication setup and troubleshooting
• Develop SSIS tools to upload data into SQL server databases
• Develop parameterized reports in SSRS and administration of report server.
• Alert notification setup and Monitoring SQL servers using Idera monitoring tool
• Installation, configuration and upgrade of MYSQL databases to latest version 5.5.8.
• Set up master - master and master - slave replication in Mysql 5.5.8
• Installation of RAC and Dataguard in Oracle 11g
• Goldengate replication in Oracle 11g

Client: Confidential, Mountain View CA Jan 2009 to Dec 2010
Senior SQL server DBA
Intuit is an American software company that develops financial and tax preparation software and related services for small businesses, accountants and individuals. It is incorporated in Delaware and headquartered in Mountain View, California
It is having a giant environment in terms of online applications and Databases. It has Database Systems like Oracle, SQL Server, Mysql. All applications are spread across multiple Database Instances on different versions of Oracle/ MS SQL and on multiple UNIX, LINUX, SUN, AIX, Mainframe and Windows Servers.

Technology/Software: SQL Server 2008/2005/2000, MYSQL, PHP, SSIS/DTS, TSQL, OS Windows's server 2008/2003, Idera SQL Diagnostic Tool,

• Database Administration Activities as a oncall Production Support DBA for Sql Server databases for EASM supported applications like Estore.
• Datacenter move for servers from Houston datacenter to Omaha datacenter using different methods like forklifting, P2P or P2V migrations
• Involved in setting up database Backups to NAS device
• Installation and Maintenance of SQL server 2008 on standalone and cluster environment
• Installation, Report server Configuration and Report development of SQL server reporting Services
• Involved in Capacity Planning and Disk Configuration for new hardware infrastructure
• Performance Analysis using NetIQ performance tool
• Performance Tuning and optimization of databases
• Involved in SQL server 2005\\2008 synchronous\\asynchronous mirroring
• Setup backup and recovery strategies for SQL server databases.
• Perform capacity planning and disk configurations for new hardware infrastructure
• Logshipping and transactional replication setup and troubleshooting
• Installation and Maintenance of SQL server 2008 on standalone and cluster environment
• Installation, Report server Configuration and Report development of SQL server reporting Services
• Involved in Capacity Planning and SAN storage , RAID level Disk Configuration for new hardware infrastructure

Client: Confidential, Redmond, WA Sept 2008 to Jan 2009
Production Database Support
SQL SERVER: - 2008, 2005, 2000 DBA
Microsoft Corporation is a giant American multinational computer technology corporation. It develops, manufactures, licenses, and supports a wide range of software products for computing devices all over the world. The products and applications are based on SQL server RDBMS. Extensively worked in SQL 2008 upgrade projects and setup mirroring, replication and log shipping on production severs. Worked as a part of Microsoft Management Services (MMS) DBA team for Microsoft SharePoint group which provide services to various Microsoft customers like Nokia, Cocacola etc.

Technology/Software: SQL Servers 2008/2005/2000, SSIS/DTS, TSQL, OS Windows server 2008/2003, Litespeed 2005, Visual Source Safe, Microsoft Office SharePoint 2007, MOM operator console

Responsibilities:

• Database Administration Activities as a oncall Production Support DBA for Sql Server and part of MMS DBA account managers team supporting SharePoint servers.
• Extensively involved in installing SQL server 2005 and 2008 single instance and multi instance Clusters with active/active or active/passive configuration. Built 2 node, 3 nodes and 4 nodes clusters.
• Upgrade from SQL server 2000 and 2005 to SQL Server 2008
• Involved in SQL server 2005 and 2008 synchronous/asynchronous mirroring from scratch. As per the Microsoft MMS standards all the production databases should mirrored to mirror node as a part of disaster recovery.
• On boarding new servers from different BUITS as per the MMS standard including disk offset for better I/O
• Configuring production servers as per Microsoft standards to improve performance.
• Deployment of Microsoft standard maintenance job suite for optimization of databases like reindexing, index defrags, updates statistics and partitioning large tables.
• Perform capacity planning and disk configurations for new hardware infrastructure
• Handling SQL 2008/2005/2000 Installations (Cluster & Standalone) and latest service pack and hotfix upgrade.
• Troubleshooting and Diagnosis of SQL server alerts
• Performance Tuning and optimization(rebuild index/index defrag/update stastics) of large databases up to 4 Terabytes
• Setting up Mirroring, Replication and Log shipping for SQL Server 2005
• Disaster Recovery Planning, Backup, Restoration and Recovery in different scenarios
• Development of DTS and SSIS packages
• Creation of Database Schemas, managing User Creations, assigning Roles to SQL Databases
• Maintaining database documentation at team site
• Part of tier3 problem management team and account manager for tier1 offshore team (MACSMON)

Client: Confidential, Redmond, WA Nov 2007 to Aug 2008
Datawarehousing development and Database Administration
SQL SERVER: - 2008, 2005, 2000 DBA
Microsoft Corporation is a multinational computer technology corporation. It develops, manufactures, licenses, and supports a wide range of software products for computing devices all over the world. The products and applications are based on SQL server RDBMS. Worked as a part of Remote IT services (RITS) DBA team for maintaining Datawarehouse in SQL server and production support for around 600 SQL servers across various product groups and systems like HR and Finance in Microsoft.

Technology/Software: SQL Servers 2008/2005/2000, SSIS/DTS, TSQL, XML, VBscript, OS Windows server 2008/2003, Litespeed, IIS

Responsibilities:

• Business Intelligence and Data Warehousing in SQL Server 2005
• Development and support for Data warehousing in SQL server database system, data modeling and ETL processes.
• Designing fact and dimension tables for Datawarehouse database
• Creating SSIS packages to load data from OLTP database into Datawarehouse database.
• Database Administration Activities as a oncall Production Support DBA for Sql Server and part of RITS DBA account managers team.
• Handling SQL 2008/2005/2000 Installations (Cluster & Standalone)
• Involved in installing SQL server single instance and multi instance Clusters with active/active or active/passive configuration.
• Migration from SQL 2000/2005 to SQL 2008
• Backup, Restoration and Recovery in different scenarios
• SQL server Optimization Job Scheduling and Maintenance
• Partitioning for large tables in SQL server databases.
• Maintaining database documentation at team site
• Part of tier3 team and account manager for tier1 offshore team (PSITOPS)

Client: Confidential, Universal City, CA Dec 2004 to Nov 2007
Confidential
SQL SERVER: - 2005, 2000 DBA

NBC Universal is one of the biggest Broadcasting Companies in USA. It is owned by General Electric (GE). It is having a giant environment in terms of online applications and Databases. It has all kind of Databases like Oracle, Sybase, SQL Servers, MYSql, and IDMS Mainframe. All applications are spread across multiple Database Instances on different versions of Oracle/Sybase/MS SQL and on multiple UNIX, LINUX, SUN, AIX, Mainframe and Windows Servers. NBC Universal is having all kind of applications, using small databases of several hundreds MBs to Very large Databases / Data Warehouses of TB size, organized either as single instance or 2 Nodes/3 Nodes RACs with fail over OS Level clusters or Data Guards on DR side. NBC Universal/CNBC is one of the prestigious clients of Patni Computer Systems and this Project is to support all Databases and development and administration Activities (Production, Application and Architect) at client location in California, to be performed on day-to-day basis on the requirements of different applications online/on-air in NBC Universal/CNBC. Creation and management of MS SQL Server Databases, Active\\Passive, and Active\\Active Clusters for important events/projects of the year happenings in NBC Universal/CNBC like Presidential Election-2004, Olympics-2004 in Greece. Actively involved in Database merger/migration activities after merger of two big companies NBC and UNIVERSAL STUDIOS and right now active part of NBC Universal/CNBC 24X7 Support On calls Database team.

Technology/Software: SQL Servers 2005/2000/7/6.5, SSIS/DTS, SQL, TSQL, ERWIN, MySql 5.0, Oracle 10g

Responsibilities:

• Database development activities as a Onsite Production Database DBA Support for Sql Server 2005/2000
• Create Stored Procedures, Triggers, views , functions
• Writing complex queries to create reports.
• Creating Performance tests using SQL profiler(client side and server side traces)
• SQL server 2005 installation (including integration and analysis services)
• Database Design: Forward and Reverse engineering of ERD and Schema
• Handling Installation and creation of new Sql server databases.
• Logshipping (SQL 2000)
• Sql server cluster shared environment (Active\\Active, Active\\Passive)
• Backup, Restoration and Recovery in different scenario
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers
• Managing User Creations, assigning Roles to SQL Databases
• Requirement analysis and Capacity Planning for database Designing, maintenance, update application schema structure / data models /ERDs and relations between objects as per requirement analysis using Erwin
• Installation of SQL server 2000\\2005, applying service packs and hot fixes
• Development of DTS and SSIS packages, Migration from DTS (SQL 2000) to SSIS(SQL 2005).
• Administrator for Hyperion Essbase application.
• Developing reports using Hyperion Essbase

Client: Confidential, Memphis, TN Jan 2003 to Oct 2004
Confidential
SQL SERVER - 2000 DBA
Confidential, is Storage USA\'s facility management system. This system is used by property managers, call center personnel, revenue managers, marketing personnel, and the back office administrators. PropertyMax consists of a number of modules to allow user to rent a unit for a vendor. A unit is a type of warehouse where vendor can store his/her goods. PropertyMax includes Property Search - Find the closest property to a customer and/or find a property with certain features such as climate control.
Reservations - Define your customers' needs and make appointments and reservations, schedule a follow-up, place the customer on a waitlist, or record lost demand.
Customer Care - Manage a customer's contact information, accept payments, move customers in and out, and view their customer history.
Products & Services - Sell, return, and reverse inventory, as well as enter other income into the system.Letters - Print a letter to an individual or group of customers.
Revenue Management - Recommend new rates and discounts and learn about the pricing logic.

Technology/Software: SQL server 2000, ERWIN, DTS, SQL, TSQL, Windows

Responsibilities:

• SQL Server 2000 oncall DBA support & Troubleshooting SQL server alerts
• Installation of SQL Server Binaries, Service Packs and hot fixes.
• Maintaining DTS packages, SQL server agent jobs, Performance Tuning
• Backup, Restoration and Recovery in different scenario
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers
• Managing User Creations, assigning Roles to SQL Databases
• Server side and Client side DB trace to monitor the activities on the Database Server.
• Capacity Planning for new servers

Client: Confidential, USA Sep 2002 to Dec 2002
Confidential
SQL Server DBA

Confidential, is the task tracking tool for for different accounts of GE (corpoate, card services,Jeffa etc.). It helps to see the status of each opened as well as closed task of each project under specific GE accounts that are using this tool. It also generates different types of reports and graphs to see the progress of the project.

Technology/Software: SQL Server 2000, ASP, VB, COM, MTS, Windows

Responsibilities:

• Writing Stored procedures in SQL Server Using TSQL
• Performance Tuning
• Database backup and restore
• SQL 2000 log shipping and replication
• Installation of components in MTS

Client: Confidential, General Electric, USA Jun 2002 to Aug 2002
Confidential
SQL Server 2000 - DBA

The digitized application will enable the SVP (Senior Vice President) of HR in GCF HQ, as well as GCF regional and country HRM\'s to have a better visibility of the efficiency and the effectiveness of the HR process, thus eliminating rework and increase productivity. This application will aid SVP, HRMs the ability to monitor a selection of Turnover and Diversity, Headcount, Recruitment categories on a monthly basis.

Technology/Software: SQL server 2000, SQL, TSQL, ERWIN, Lotus Notes R5, Windows

Responsibilities:

• Writing stored procedures in SQL 2000
• The procedures are referred by front-end applications to enter or display the data to the users.
• DBA related activities such as Database Creation, backup\\restore
• Creation of test data for test tools
• Creation\\Modification of ERWIN diagram for data modeling.
• Creation of Deployment Guide and master tables' scripts to run on client\'s server, which is presented to the user at the end of project.

Client: Confidential, USA May 2001 to May 2002
Accounts Payable
SQL Server DBA

Accounts Payable (AP) project deals with the generation of reports and maintenance of the accounts for GE CBSI. GE CBSI has 40 CBIs and the reports as well as the payments for all these CBIs is calculated by the AP.The need for Accounts Payable arises because of the time lag between the receipt of goods or service and the payment for the goods or service. The AP process involves purchasing of goods, verifying receipt, vendors and invoice, inputting and processing information to produce checks and reports, financial control activities.RAPID Application; This caters to data-entry and inquiry of purchase Order, Receiver and Invoice information. The data-entry screens facilitate the input of voucher information by the users. Basic validations are performed on the input data. They are reformatted as sequential files, in the format required by the mainframe application (IVIS). The extracts of IVIS application are transferred to RAPID to be used in Inquiries.

Technology/Software: SQL server 7.0, SQL, TSQL, Visual Basic 6.0, Active Server Pages, Power builder 5.0

Responsibilities:

• Delivering change requests send by client
• Modifying/Creating procedures at backend SQL server
• Maintenance of SQL database servers(Backup/Restore/Maintenance job execution
• Knowledge Transfer
• Knowledge Management Activities

Client: Confidential, UK, Great Britain Mar 2000 to Mar 2001
Confidential
SQL Server DBA

Confidential, is a company in UK which held exhibitions online as well as physically. This project is for online exhibitions. It is to develop exhibition web site which will allow users to create their own websites dynamically. The users were the exhibitors themselves.
Each user who has register with this site has to do payment by credit card. Third party tool is used for it. The users have choice of 5 different layouts which will define how the web page looks. User can upload his own images and text in the web site. There is a facility to send emails.
At some places html pages are created dynamically which can be send by emails. There is also a quiz option where user can select his answer. There are 2 categories for users 1. Exhibitor 2.Visitors. Visitors can only view the sites but can not make any change.

Technology/Software: SQL Server 2000/7.0, ASP, VB 6.0, COM, IIS, MTS

Responsibilities:

• Writing Stored Procedures in SQL server 2000/7.0
• registering COM components on MTS
• Using Flash for design of website.
• Modify COM components.
• Using visual source safe for version control

Education

Intec Institute of Software Exports
Advance Tech. Course in Database & Front end tools
Bachelor of Engineering (Industrial Electronics)
Six Sigma Green Belt Certified (GE - Patni)