PROFESSIONAL SUMMARY

• Seven plus years of IT experience in MS SQL Server 2008/2005/2000, 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.
• Experience in SQL, T-SQL, 4GL, Application by Forms (ABF), Ingres Report writer, Visual Tools, Shell Scripting, Stored Procedures
• Design and documented logical and physical models using various tools like ERWIN and VISIO.
• Experience in object creations such as Tables, Views, Functions, User Defined Data Types, Indexes, Stored Procedures, Cursors and DML/DDL triggers.
• Creating and maintenance of Databases, creating logins, Roles, Users and managing user permissions.
• Extensive experience in migration of various databases including Ingres II to Oracle 10g and Oracle 9i to SQL Server 2005
• Experience in design and execution of Capacity Planning, Performance Tuning, Disaster Recovery, backup and restore.
• Expertise in installing, upgrading and configuring MS SQL Server Active/Active and Active/Passive Clusters.
• 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 migration of Data from Excel, Flat files, Ingres, Sybase, Oracle to SQL Server by using BCP, BULK INSERT and DTS/SSIS utility. Extracting, Transforming and loading (ETL) of data using SQL Server DTS/SSIS.
• 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 as part-time 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
MCTS

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 2008/2005/2000, Ingres II, Open Road, DB2,
Informix, Oracle 9i/10g, 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
Confidential, 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:

• Responsible for configuring and Tuning of MS SQL Server.
• Involved in the Migration of Ingres II to SQL Server 2005
• Involved in monitoring and managing all the Databases
• Implemented Backup/Restore Strategy using maintenance plans to avoid any loss of data.
• Involved in implementing standards and security for all the databases
• Implemented various automated scripts to monitor disk space, fragmentation, and some daily server activities and configured job.
• Involved in Performance Tuning, optimization, backup and recovery of the databases
• Utilized various system tables, dynamic management views (DMV), Catalog View and DBCC Commands to check stability and performance of the databases.
• Involved in striping and mirrored backup
• Involved in providing fail-over for database mirroring
• Involved in replication, performance monitoring and dead-lock monitoring using third party tools
• Involved in Storage, health checks, etc
• Involved in 24x7 Support for the databases

Environment: T-SQL, SQL Server 2008/2005/2000, Windows Server 2003, ERWIN, VISIO, DTS/SSIS, SSRS, SSAS, Ingres II, 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
• 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, St. Louis, MO 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 partial migration of Ingres II to Oracle 10g
• 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 has been exclusively developed for National Thermal Project Corporation as per the management requirements. It 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

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 developed by XL Softech Systems Ltd and 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