PROFESSIONAL SUMMARY

• Over five plus years of IT experience include four plus years of experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
• Extensive experience in installation and configuration of MS SQL Server 2005/2000/7.0/6.5 versions.
• Experience in working with Windows server 2003, Windows 2000 Advance Server and Windows NT Server Installation and Administration.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000/2005 databases.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging Stored Procedures and Triggers.
• Configure & Maintain TCP/IP on Windows Servers for security and high availability.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Exposure on MS SQL Server 2008.
• Upgrade DTS packages to SQL Server Integration Services (SSIS).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Experience in implementing business logic using Triggers, Views and Stored procedures.

TECHNICAL SKILLS

Operating Systems:
Windows Server 2000/2003, Windows NT 4.0
Windows XP/98/95, MS DOS, Linux, UNIX.

Languages:
C #, T-SQL, SQL plus, OSQL, VB
Scripts, ADO.Net

SQL Server Tools and Others:
RDBMS:
MS SQL Server 2005, 2000, and 7.0
Oracle, Microsoft Access

OLAP Tools:
MS OLAP Services Manager

Confidential, Wilmington, DE
Database Administrator August 2008 - September 2009

RESPONSIBILITIES:

• Installed and configured SQL Server 2008/2005 Instance on Window Servers.
• Migrate databases from SQL Server 2000 to SQL Server 2000/2005 & Oracle.
• Create and modify Jobs, Alerts, tables, maintenance plans, DTS and SSIS packages based on the requirements.
• Design and Implementation of database, backup and security standards.
• Give user risks to perform user activity based on the applications and requirements.
• Maintain, manage & monitoring SQL Server/Oracle Databases on Cluster environment.
• Maintain SQL Server Reporting Server.
• Manage and monitoring disk space for backup and restore.
• Responsible for providing and manage data on 24/7 applications.
• Provide On-call support of various business applications on local/remote side.
• Maintain Transactional and Merge Replication for high availability of the data.
• Maintain and create/modify SSIS and DTS packages for migrate the data from SQL Server to Oracle data warehouse.
• Performance tuning of database on production systems
• Maintain and manage database mirroring and replication.

Environment: MS SQL 2000/2005/2008, T-SQL, Windows 2000/2003, ADO.Net, Oracle 10g/11g, SQL Plus, SQL Loader, TOAD

Confidential, Ann Arbor, MI
Database Administrator December 2007 - July 2008

RESPONSIBILITIES:

• Migration of SQL Server 2000 DTS Packages in to SQL Server 2005 SSIS.
• Recompile SQL Query to pull out the data and make some changes.
• Create BCP scripts to load and unload SQL Tables.
• Documentation of SSIS Packages and Database Model.
• Performance Monitor with SQL Profiler and Windows Performance Monitor.
• Create SSIS Package to insert the data with SQL Queries on SQL Database to Oracle Data warehouse.
• Change the Physical model of SQL table based on the requirement and Data Warehouse.
• Create new user as per requirement and assign proper rights to the Developer User.
• Work with developers to re-write the code in Visual Studio & ADO.Net and deploy on test servers.
• Configuring Oracle ODBC driver for SQL Provider.
• Write MDX query with SELECT statement specifies a result set that contains a subset of multidimensional data that has been returned from a cube.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, ADO.Net, Visual Studio 6, Oracle
10g, SQL Plus.

Confidential, Brooklyn, NY
Database Administrator March 2007 - Nov. 2007

RESPONSIBILITIES:

• Performed Data Migration from SQL Server 2000 to 2005.
• Creating tables, views, indexes, stored procedures, triggers, cursors.
• Performance Tuning: Analyze, tuning and optimizing and using performance monitor.
• Migrating SQL Server 2000 DTS Packages to SQL Server 2005.
• Scheduled the backups and recover when needed.
• Configured SQL Server clients and support for test and development servers.
• Created User Database, tables and gives user rights.
• Imported data from text files and excel spread sheets into SQL Server 2005 databases using SSIS packages.
• Deploy web databases to test and production environments.
• Performed DBCC Utilities to checks and fixing data
• Enabling Service Broker with WMI Provider for Server Events.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, ADO.Net, ERWin Studio

Confidential, Ahmedabad, India
SQL Server DBA Jan. 2006 - Aug. 2007

RESPONSIBILITIES:

• Installation, configuration the MS SQL Server 6.5 and maintenance of servers in various environments.
• Performance and tuning of SQL servers and application issues related to migration.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so that the tasks are run with out user monitoring.
• Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000/2005, Query Analyzer, Windows 2000 Server, Import/Export Data

Confidential, Ahmedabad, India
SQL Server DBA/Analyst Feb. 2004 - Dec. 2005

RESPONSIBILITIES:

• Developing and implementing plan for Disaster Recovery.
• Requirement gathering and analyzing data sources
• Assisted in design and implementation of the Database
• Installation and configuration of SQL Server 7.0 and 2000
• Design and implementation of Backup policies and Recovery procedures
• Created stored procedures and triggers
• Used BCP for data transfer

Environment: SQL Server 2000, Windows 2000 & Windows NT 4.0

EDUCATIONAL QUALIFICATIONS