PROFESSIONAL SUMMARY

• Seven plus years of IT experience in MS SQL Server Oracle , Ingres II, Database Administration, Analysis, Design, Development and Support in Production, Test, Development and Cluster Server Environment.
• Three plus years of extensive IT experience in Ingres II/9.2/Open Road 2006 Database Development and Administration in Production support Environment.
• Expertise in migrating databases from different versions of SQL Server and also from Oracle to SQL Server using SSMA.
• Design and documented logical and physical models using various tools like ERWIN and VISIO.
• Experience in design and execution of Capacity Planning,Performance Tuning, Disaster Recovery, backup and restore.
• Experience in SQL, T-SQL, 4GL, Application by Forms (ABF), Ingres Report writer, Visual Tools, Scripting, Stored Procedures
• Expertise in installing, upgrading and configuring MS SQL Server Active/Active and Active/Passive Clusters.
• Experience in object creations such as Tables, Views, Functions, User Defined Data Types, Indexes, Stored Procedures, Cursors and DML/DDL triggers.
• Experience in migration of Data from Excel, Flat files, Ingres, Sybase, Oracle to SQL Server by using BCP, BULK INSERT and DTS/SSIS utility.
• Creating and maintenance of Databases, creating logins, Roles, Users and managing user permissions.
• Experience in Query Optimization using SQL Server Profiler, Windows Performance Monitor for monitoring and tuning SQL Server performances.
• Excellent knowledge in system tables, stored procedures and DMV's using T-SQL.
• Expertise in implementing database consistency checks using DBCC utilities.
• Experience in implementing Database Mirroring and Log Shipping in SQL Server 2005.
• Experience in implementing and managing different types of replication models like Snapshot, Merge, Transactional and Peer to Peer.
• Experience in diagnosing and trouble shooting problems that arise in the production environment.
• Connecting remote SQL Servers as Linked Servers and Adhoc SQL functions like Openrowset, Opendatasource and Openquery.
• Experience working with third party tools like Idera's SQL Diagnostic Manager, SQL Litespeed and Microsoft Operating Manager (MOM-2005).
• Experience in implementing RAID 1-5 and 10 Technology.
• Experience in working with Windows 2003 Server, Windows 2000 Advanced Server and Windows NT Server.
• Experience in working as System Admin for Linux based applications
• Experience in managing and monitoring production and development/testing server
• Sound knowledge on Business Intelligence tools like SSAS, SSRS, SSIS
• Capable of working in teams as well as independently with excellent communication, Interpersonal, Analytical and Problem solving skills
• Capable of learning new technologies with a quest, zeal and undertaking challenging tasks.

CERTIFICATIONS
RHCE: Certificate Number:
MCTS: Certificate Number: rfdsyd5549

EDUCATION
Bachelor of Technology in Computer Science & Engineering

SKILL SET
Operating Systems : Sun-Solaris, AIX, Hp-Truce, Linux, windows 98/2000/XP,
Windows Server 2003/Advance 2000/NT, VAX

RDBMS : SQL Server Ingres II, Open Road, DB2,
Oracle 91/10g, Informix, Sybase 11.5, MS-Access
Version Control : Team Foundation Server (TFS), Visual Source Safe 6.0
Web Technologies : HTML, ASP.NET, XLS, HTML, DHTML
Web Servers : Apache, Squid proxy, IIS 5.0/6.0
Testing Tools : Win Runner 7.0, QTP, and Rational Rose
Ingres Tools : Knowledge Manager, Object Manager, FTP
Data Modeling Tools : Microsoft Visio, Erwin
Networking models : TCP/IP, SMTP, shared memory, named pipes
Directory Service : AD, LDAP, NDS
Business Intelligence : SSIS, SSAS, SSRS

EXPERIENCE

Confidential, Oct 2005- Present
Ambler, PA

Client - Confidential, Detroit, MI May 2008 - Sep 2009
Database Administrator
General Motors (GM) has got 21 Parts distributions centers (PDC), a warehouse which are located across US and many more around the globe. The current project, the Ware House Management System (WMS) deals with the maintenance of the database that handles all the raw materials/parts coming into the PDC and the finished products delivered out.
Responsibilities:

• Involved in data modeling by following standard database methodologies of creating conceptual data models, logical data models and physical data models using ERWIN tool
• Configured MS-SQL Server in Active/Active clustering environment using MSSQL-Cluster to congregate business requirement and implemented a base line security standard for the Oracle/SQL Server database
• Pro-actively monitoring all the databases to check that the database is online and is available before the user logs in
• Managing all the databases by actively trouble shooting logging, report/query, index, and other related issues arising in production environment
• Tuning the queries, reports, stored procedures, etc to increase the performance of database and assisting application programmers in writing a better database code
• Involved in VM-Ware Virtualization by migrating 1 TB data of SQL Server 2005 to SQL Server 2008
• Involved in migration of 300+ GB Oracle database to SQL Server 2005 using SQL Server Migration Assistant (SSMA)
• Involved in creation, testing and implementation of disaster recover planning accounting all the minor and major issues including hardware failures, power supply failures, etc
• Implemented Backup/Restore Strategy using maintenance plans to avoid any loss of data.
• Extracting, Transforming and loading (ETL) of data using SQL ServerDTS/SSIS.
• Implemented various automated scripts to monitor disk space, fragmentation, and some daily server activities and configured job using VB script.
• Utilized various system tables, dynamic management views (DMV), Catalog View and DBCC Commands to check stability and performance of the databases.
• Involved in extraction of data for reporting from oracle on Linux.
• Implemented transactional replication, performance monitoring and dead-lock monitoring using third party tools
• Involved in 24x7 Support for the databases

Environment: T-SQL, SQL Server Oracle, Windows Server 2003, Linux, DTS/SSIS, SSRS, SSAS, ERWIN, Informix, Sybase, Visual Source Safe 6.0

Client - Confidential, Detroit, MI Jan 2008 - Apr 2008
DBA /System Administrator
Dynamic Slotting System software is designed for the manufacturing firm. The objective of this software application is to help the distribution units in slotting and re-slotting of various parts. Dynamic Slotting System has been classified into two categories

• Dynamic Part Slotting (DPS)
• Build-out Diary (BOD)

Responsibilities:

• Provide On call Support for above mentioned applications
• Involved in System Administration activities to provide security for the application
• Involved in Installing patches and handling Web Proxy server, mail server etc
• Actively involved in managing active directory services like change directory, for SQL Server
• Involved in Maintenance and monitoring of the above mentioned applications
• Involved in Performance Tuning and backup of the databases
• Involved in log shipping and merge replication
• Involve in Change Request as per the client
• Involve in Minor Enhancement and coordinate in deploying the change code.

Environment: SQL, 4GL Procedures, SQL Server 2005, Ingres II, Shell Scripting, Windows Server 2003, Linux, Team Foundation Server, Open Road

Client - Confidential, Middletown, NJ Dec 2006 - Dec 2007
DBA /System Administrator
This objective of this Subscriber Application Processing System (SAPS) is to provide complete technical support to subscribers of AT & T. This Application involves automation of all functionalities to support subscription of all the products to the users.

PACKAGES SUPPORTED:FRIENDS AND FAMILY PACKAGE
MODULES SUPPORTING: ADSL, PSTN

Responsibilities:

• Involved in System Administration activities
• Involved in creating logins and restricting access to the machine, etc
• Involved in all DBA activities
• Involved in Bulk and Disk admin roles for the applications using SQL Server 2005
• Performed Health Checks for the all the databases
• Involved in Developing New Packages and Applications.
• Developing User interfaces using Ingres II.
• Maintaining active applications and done modification according to the user requirement.
• Extensive working knowledge in 4GL procedures, Application designs.
• Proficient in using VI Editor (UNIX) and ABF, Report writer.
• Porting of data to Ingres

Environment: Ingres II (ABF, 4GL, Report Writer), SQL Server 2005/2000, C, SQL, 4GL Procedures, Tru 64 UNIX, Red Hat Linux, Windows Server 2003

Client - Confidential, Oklahoma City, OK Dec 2005 - Nov 2006
DBA
The Integrated Online Contract Management System, Application is being developed to automation all Contract Management activities of the enterprise. This Application involves processing of operation right from Proposal creation to award of work with paperless effort. This project carries different Features like Master Module, System Administrator, Proposal Module, Tender Module, Work-Order Module, Bill Module and Deviation Module.
Responsibilities:

• Managing and Monitoring the databases
• Developing user interface using Ingres II.
• Study of system requirements.
• Drawing of process flow chart.
• Developing forms using ABF and reports using report writer.
• Database Performance and Tuning
• Creation of tables, indexes, views.
• Testing of forms and reports.
• Training to end users on all modules.

Environment: SQL, 4GL Procedures, Ingres II (ABF, 4GL, Report Writer), SQL Server 2000, Sun Solaris, Windows Server 2000, Testing Tools

Confidential, Jun 2002 - Sep 2005

Client - Confidential, Apr 2004 - Sep 2005
Application Support/DBA
The Integrated online Material Management System, Application has been designed to carry out all the functionalities in an enterprise right from Request of materials to delivery of goods. This Application involves timely change of user interfaces according to user requirement and changing and creation of local report s according to the management. This has been extensively used in many PSU including NTPC, KCP, ORIENTAL, etc. It carries different functionalities like Stores Management, Purchase Management, Directory Creation, Local reports, etc
Responsibilities:

• Maintain all User interfaces using Ingres II.
• Maintained all active applications and done modification according to the user requirement.
• Extensive working knowledge in 4GL procedures, Application designs.
• Proficient in using VI Editor (UNIX) and ABF, Report writer.
• Migration to Ingres.
• Porting of the Data in Ingres

Environment: SQL Server 2000,Ingres II (ABF, 4GL, report writer), Sun Solaris, Shell Scripting, Backup and Recovery

Client - Confidential, Jun 2003 - Feb 2004
DBA/ Application Support
The Online Integrated Finance Management System, Application involves the processing of Contract Bills, Fixed Assets. Various transactions related to Medical & Tour Claims, Loans & Advances, Tax deductions & Rebates, Contract bills, Sales & I. Tax for contracts, Bank Transactions & Reconciliation are all taken care of in this module. Report Builder (RBF) has been used for generating various on line reports as per the requirement of user and solving user problems.
Responsibilities:

• Involved in all DBA activities
• Involved in generation of frames, OSQ, Reports.
• Knowledge of Software development and SCO-Unix, Sun Solaris.
• Domain knowledge of project.
• Worked extensively on SQL.

Environment: Ingres II (ABF, 4GL, Report Writer), Tru 64 UNIX

Client - Confidential, Jul 2002 - May 2003
DBA
The Objective of this Payroll Management for Specific Employees is to automate all the financial and material transactions and facilitate effective decision making in inventory control, Finance and accounts functions. The major benefits of this product will be increased accuracy and timeliness that will result in substantial cost saving.
Responsibilities:

• Study of System requirements.
• Study of logical flow.
• Study of Database model.
• Underwent training in Coding of Financial Accounting System.

Environment: Ingres II

Reference : Will be providing on request
Relocation : Willing to relocate