SUMMARY

I have around 8+ years of experience in SQL Server Database Administration. I am looking for Middle level Assignments in Database Administration with a growth oriented organization. My MS SQL Server experience covers the following:

PROFESSIONAL SYNOPSIS

• Installing the MS SQL server on server and nodes
• Installing MS SQL Server on cluster environment (active/ passive , active / active)
• Upgrading sql server on cluster environment.
• Installing Reporting services and configuring it with IIS for report generation.
• Installing analysis Services, applying patch
• Configuring and managing replication as per the application requirement
• Configuring Logshipping for reporting services and DR issue
• Working experience on ticketing tool like Remedy and Peregrine
• Working Experience on monitoring tool like MOM
• Creating users and manage privileges
• Using litespeed for taking backup and Creating maintenance plan
• Using TSM taking backup and managing backup
• Closely working on performance issue on DB and working with application team to resolve performance issue.
• Migrating SQL Server to higher version
• Applying security policy to the data base
• Plan and implement the backup and recovery of data base
• Scheduling the regular backups for the databases
• Maintaining the user profiles of Sql server
• Creating users as per the requests and granting them roles to access the database
• Coordinating with the development team, resolving issues with database connectivity, fine tuning application code.
• Setup and maintain documents and standards
• Tracking the updates for Sql server(like patches for MS SQL SERVER )
• Working knowledge of Tectia SFTP and connect direct NDM

ORGANIZATIONAL EXPERIENCE

PROJECTS

Confidential
Duration( Feb 2009 till Date)

Confidential, is a major American financial services company based in New York, NY. Citigroup was formed from one of the world\'s largest mergers in history by combining the banking giant Citicorp and financial conglomerate Travelers Group on April 7, 1998.
Citigroup Inc. has the world\'s largest financial services network, spanning 140 countries with approximately 16,000 offices worldwide. The company employs approximately 322,000 staff around the world, and holds over 200 million customer accounts in more than 140 countries. It is the world\'s largest bank by total customers & worldwide branch network as of 2009. It is a primary dealer in US Treasury securities

Role: DBA (Recon & Frontier)

Responsibility:

• Provide on-call support and prioritized tickets based on severity
• Performance monitoring and tuning for Dev/UAT/Production Database.
• Creation of Database and DB files, Users, Indexes and disk space maintenance.
• Ensuring regular and timely Backup of databases on SQL Server (both native backups and SQL lite speed backups).
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Installing MS SQL server
• Installing MS SQL in cluster environment
• Installing Reporting services and configuring it with IIS for report generation.
• Implementing all the changes required by development teams as well to resolve production data issues.
• Configuring and Troubleshooting Log shipping, Replication issues
• Complying with Audit process.
• Databases Migration from Sql Server 2000 to 2005 and 2005 to 2008
• Provide support for Tectia SFTP for inbound feeds
• Provide support for connect direct NDM for inbound and out bound support.

Confidential
Duration (Jun 2008 till Jan 2009)

Confidential, is world\'s largest maker of construction and mining equipment, diesel and natural gas engines, and industrial gas turbines. Caterpillar is been associated to Satyam computers from last 20 years.
Scope of the project includes: primary SQL Server DBA Support, round the clock 24/7 support to the Production, Development and Test environment.

Role: DBA

Responsibility:

• Installing MS SQL server
• Installing MS SQL in cluster environment
• Installing Reporting services and configuring it with IIS for report generation
• Installing analysis Services, applying patch
• Configuring and managing replication as per the application requirement
• Configuring Logshipping for reporting services and DR issue
• Working on ticket tool Peregrine
• Tickets handling based upon the Priority (Like 1,2,3,4,5)
• Resolving the Problem tickets of different severity levels during on-call support
• Users call Handling
• Database Creation
• Creating users and manage privileges
• Applying security policy to the data base
• Backup and restore using TSM
• Scheduling the regular backups for the databases
• Maintaining the user profiles of SQL server
• Creating users as per the requests and granting them roles to access the database
• Taking initiative to solve developer's issues in accessing the database.
• Setup and maintain documents and standards
• Maintaining import/export copies of the database

Confidential
Duration (Feb 2008 till May 2008)

BP is a platinum client of Satyam Computer Services Ltd. We are providing 24x7 Production Support to Petroplus Systems and Applications, Petroplus now being a part of BP. In addition we also make modifications or develop new Applications as per the request of the Client
Scope of the project includes: primary SQL Server DBA Support, round the clock 24/7 support to the Production, Development and Test environment.

Role: DBA

Responsibility:

• Installing MS SQL server on server and nodes
• Installing MS SQL in cluster environment
• Tickets handling based upon the Priority (Like urgent, High, Medium, Low)
• Resolving the Problem tickets of different severity levels during on-call support
• Users call Handling
• Database Creation
• Creating users and manage privileges
• Applying security policy to the data base
• Backup and restore using native backup, SQL Light speed Backup
• Scheduling the regular backups for the databases
• Maintaining the user profiles of Sql server
• Creating users as per the requests and granting them roles to access the database
• Taking initiative to solve developer's issues in accessing the database.
• Setup and maintain documents and standards
• Maintaining import/export copies of the database

Confidential
Duration (Mar 2007 till Jan 2008)

Standard Bank is a South African-based financial services company with a global presence. Standard Bank operates from 17 African countries and 21 countries on other continents, including the key financial centers of Europe, the Americas and Asia. Standard Bank outsourced their Information Technologies to Satyam Computer Services Lt., which supports all their Databases (UDB, Sybase, Ms-SQL Oracle) 24*7.

Role: DBA

Responsibility:

• Installing MS SQL server on server and nodes
• Installing MS SQL in cluster environment
• Tickets handling based upon the Priority (Like urgent, High, Medium, Low)
• Resolving the Problem tickets of different severity levels during on-call support
• Users call Handling
• Database Creation
• Creating users and manage privileges
• Applying security policy to the data base
• Backup and restore using native backup, SQL Light speed Backup
• Scheduling the regular backups for the databases
• Maintaining the user profiles of Sql server
• Creating users as per the requests and granting them roles to access the database
• Taking initiative to solve developer's issues in accessing the database.
• Setup and maintain documents and standards
• Maintaining import/export copies of the database
• Tracking the updates for Sql server(like patches for MS SQL SERVER )

Database: MS SQL Server

Confidential
Duration (Feb 2006 till Jan 2007)

PACS Partner a PACS (Picture Archive and communication system) and (Radiology Information System) product of Medical Standard INC (USA). PACS Partner is a tele-radiology software design to archive the medical image of any modality like CT, MR, Ultrasound and distributing the images on the internet through a login facility in the software. This software takes the image directly from the modality in DICOM (digital Imaging and communication in medicine) format and store in the database for distributing the image on internet for users and it also permits the user to make the medical manipulations on the image and store it in central server database. It also has reporting module that provides to the doctors a facility of remote Reporting for the image and store it in Central server.

Role: DBA

Responsibility:

• Installing the MS SQL server on server and nodes
• Applying clean up rules for the images in data base
• Managing the images to keep them offline or make them available on web
• Creating users and manage privileges
• Applying security policy to the data base
• Plan and implement the backup and recovery of data base
• Scheduling the regular backups for the databases
• Maintaining the user profiles of Sql server
• Creating users as per the requests and granting them roles to access the database
• Taking initiative to solve developer's issues in accessing the database.
• Setup and maintain documents and standards
• Maintaining import/export copies of the database
• Tracking the updates for Sql server(like patches for MS SQL SERVER )
• Database: MS SQL Server

Confidential
Duration (Jan 2005 till Dec 2005)

iPACS is a PACS (Picture Archive and communication system) product of RealTimeImage (Israel). iPACS is a tele radiology software design to archive the medical image of any modality like CT, MR, Ultrasound and distributing the images on the internet through a login facility in the software. This software takes the image directly from the modality in DICOM (digital Imaging and communication in medicine) format and store in the database for distributing the image on internet for users and it also permits the user to make the medical manipulations on the image and store it in central server database. It also has reporting module that provides to the doctors a facility of remote Reporting for the image and store it in Central server.

Role: DBA

Responsibility:

• Installing the MS SQL server on server and nodes
• Applying clean up rules for the images in data base
• Managing the images to keep them offline or make them available on web
• Creating users and manage privileges
• Applying security policy to the data base
• Plan and implement the backup and recovery of data base
• Scheduling the regular backups for the databases
• Maintaining the user profiles of Sql server
• Creating users as per the requests and granting them roles to access the database
• Taking initiative to solve developer's issues in accessing the database.
• Setup and maintain documents and standards
• Maintaining import/export copies of the database
• Tracking the updates for Sql server(like patches for MS SQL SERVER )

Database: MS SQL Server

Confidential
Duration (Sep 2003 till Dec 2004)

This project was developed in order to create a transparent office environment to meet SMART governance objectives. Solution simulates existing Data and Messaging systems in the forest department. This project had two parts -

• Offline application which resides on client machines (C.F. and D.F.O.'s) is for data entry and local reporting
• Web enable application where an authorized user can view the report's of its circle or other's.

This Project is a Client - Server based and has 3-tier architecture. There is one Middle layer for uploading and downloading data from the web server which is developed on .Net. Software helps in Processing & Monitoring of all the official forms.

Role: Junior DBA , Application Support

F-end/B-end: ASP Dot Net (Web Matrix), VB Dot Net and MS SQL Server 2000
Client: Confidential

Confidential
Duration (Sep 2003 till Dec 2004)

This application was also based on 3 tier client-server architecture .The department deals with trading & collection of TENDU Leaves. This application was designed and developed in such a manner that all District offices enter data in the application and head office would simulate that data for reporting and other MIS work. There is one Middle layer for uploading and downloading data from the web server, and same was developed using Dot Net Framework. The Modules are: - Master Entry, Godown Planning, Payment Receipt, Dispatch Leaves, Leaves collection and Reports.

Role: Junior DBA , Application Support

F-end/B-end: ASP Dot Net (Web Matrix), VB Dot Net and MS SQL Server 2000
Client: Govt of M.P., Minor Forest Dept.

EDUCATION

• Master of Computer Application [MCA]
• Bachelor of Business Administration (BBA) (marketing)