Oracle Certified DBA with over 11 years IT experience, including over 6 years as DBA administrating Oracle 8.i/7.x/6.x.
oracle Certified DBA with proven ability to manage complex database systems with over 11 years IT experience, including over 6 years as DBA, administrating oracle 8.i/7.x/6.x. Extensive hands-on experience in performance tuning, backup/recovery and space management for large databases in Production and Development environments. Experienced in supporting oracle applications and Peoplesoft. Proficient in Unix administration and shell scripting, SQL, PL/SQL, SQL*Loader and other oracle utilities. Well-versed with logical and physical database design, data modeling concepts and techniques. Application experience includes Finance, Telecommunication, Manufacturing and Management Information Systems. Excellent team player with good communication skills.
Institution Degree Areas of study
Thapar Institute of Engg. and Tech., India MCA Computer Application
Punjab University, Chandigarh, India BS Physics, Chemistry and Mathematics
oracle Corporation Certificate course oracle 8i
Awards, Certifications, Memberships:
Member of the International oracle User Group America
Member of the oracle Developer Program
Hardware HP Servers(N540,V2250,T500,K570/580,D370), Sun Enterprise 100 Server, Sun Sparc/20, VAX VMS, IBM-RS 6000, IBM 370/155 mainframe, Intel based PCs
Operating Systems HP UX 9.x/10.20/11.0, Sun Solaris OS 2.3/2.51, AIX 4.1, VMS 4.5, UnixWare 2.01, SCO Unix , XENIX, Windows NT 4.0,Windows 95 /3.X , Novell NetWare 4.0
RDBMS oracle 6.0/7.X/8.x, DB2, Unify, Sybase SQL Anywhere, Dbase/FoxBASE, Jet Engine
Modeling Tools ERWIN, oracle Developer 2000, Designer 2000, C, Powerbuilder 5.0/ 6.x, Visual Basic 5.0, Reports 1.0, SQL, PL/SQL, SQR, HTML, Unix Borne/K Shell Script
Database Experience Installation & Configuration of WEBDB, oracle Application Server, oracle Database Administration with oracle Parallel Server and Parallel Query Option, oracle Distributed Database Option, oracle Installation and Configuration, Database Server Tuning and sizing, Application SQL Tuning, User -Space management, Backup/recovery techniques, SQL*Net configuration, SQL Loader and Application Developer Liaison.
Products OEM (oracle Enterprise Manager), Bradmark DBGeneral DBA Tool, BMC PATROL Database and Application Tool, Revealnet Tool, Platinum SQL Station & Analyzer, SQL Lab, Precise DBA tools, Platinum Tsreorg, Platinum Desktop DBA.
Job Responsibility Summary
Senior oracle DBA Purdue Pharma LP, Stamford, CT Apr 00 - Present
Environment oracle 8i/7.x running under HP-UX11.0/10.20, SQL* Loader, Designer 2000, OEM, Platinum SQL Station, Platinum Tsreorg , Platinum Desktop DBA.
Hardware HP Servers(N540,V2250,T500,K570/580,D370), EMC DISK, Clients running Windows NT/95 on IBM Compatible desktops.
Purdue Pharma L. P. is a research oriented pharmaceutical company which seeks to provide a benefit to patients by providing new and improved treatments for diseases and their symptoms. Purdue seeks to continually develop and sell new, high quality, innovative, pharmaceutical preparations, which together with clinical data and medical education create new value for patients and the health care system.
Key member in a 5 members DBA team which is providing 24x7 support to 40 Production/Development Instances with Peoplesoft ,oracle Financials.
Planned and implemented migration of a high availability Production database of 90 GB from 7.3.4 to 8.0.6 using oracle Migration utility. Migrated another database from 8.0.5 to 8i
As a Backup/Recover expert DBA, Design and Successfully implemented Backup/Recovery Strategies for two 24x7 critical systems Databases using Hot Backups and Standby databases.
Successfully implemented oracle Names Setup.
Participated in study of Single logon security protocols.
Implemented Read Only Snapshot Replication
Successfully Migrated an Access Database to oracle 8.0.6
Senior oracle DBA ITDS, A Amdocs Division, Stamford, CT June 98 ? Mar 00
Environment oracle 8i/7.x running under HP-UX11.0/10.20, SQL* Loader, ERWIN, OEM, DB General, Platinum SQL Station, Precise, BMC Patrol.
Hardware HP Servers(N540,V2250,T500,K570/580,D370), Clients running Windows NT/95 on IBM Compatible desktops.
ITDS, the second largest cellular billing solutions provider in the world, provides its customers with the totally integrated billing software called XCEDE to its clients. ITDS also provides various miscellaneous products such as Fraud Protection S/w for cellular phones. The client list includes MCI-Worldcom, CELLCOM, Unitel. Xcede has all capability for downloading data from any data source to billing and analyzing the credits to the customers, etc.
Team member in a 9 members DBA team which is providing 24x7 support to 3 production Instances of 100GB plus with 500 concurrent users and 35 development/testing/demo instances.
Installation of oracle 8i/8.x/7.x and other oracle tools. Participated in testing the compatibility and portability of Application on oracle 8.05 by migrating whole application and database from 7.3.2 to 8.05.
Leading Backup and Recovery Group (consist of 3 DBAs) responsible for Disaster recovery and Standby Database.
Actively worked on SQL and Physical database tuning resolving fragmentation and disk contention. Use Partitioning feature of oracle 8 to improve performance.
As a member of Change Control Board, responsible for maintaining Application schema and Schema versions.
Setup and Tune a Testing Server with RAID technology on HP Server running HP 11.0/oracle 7.3.3. Tested load of 1000 concurrent users. For Load testing used Mercury Tool Load Runner.
Database sizing for various deployments to clients.
Actively participated in Application Tuning which includes SQL Tuning, Database design tuning and tuning at Instance level.
Written and troubleshoot database triggers/Stored Procedures using PL/SQL.
Have written shell scripts for automation of various database-monitoring activities.
Principal oracle DBA Boscov?s Group, Reading, PA Jan `98 to May ?98
Worked at Boscov?s, Reading on People Soft Application using People Tools and Crystal Reports 5.0. Assisted in Database Performance Tuning and Sizing for an existing Financial Application on 100GB database with up to 200 concurrent users with oracle at backend. This include customization and Implementation after evaluating their configuration and data requirement & setting the optimal parameters for best performance. Providing Online support for various oracle problems for these. I was also available for User & Schema Management and Backup & Recovery.
Principal oracle DBA NIC, Govt of India, INDIA May `93 to Dec. 97
Installed and implemented oracle Server, Applications and Tools(Workgroup Server, Enterprise Server, Designer 2K, Developer 2K, SQLNET 2.X Programmer tools, OLE Objects) at client sites.
Supported 14 databases on different applications running on 6 Servers. Largest one was 60GB database running oracle 22.214.171.124 under Distributed database environment for 32 District Courts of States of Punjab, Haryana & Chandigarh.
Provided extensive database redesign and tuning expertise on several 3rd party packages with oracle backend.
Implemented oracle Multithreaded Server(MTS) in order to handle large number of concurrent connections.
Implement oracle Parallel Query Option in order to utilize 4 CPUs on database server.
Designed the physical layout for several oracle databases and implemented same that include Sizing and maintaining large database whose growth is very fast by optimizing it for large data loads and also for query performance in Online environment.
Physical database tuning resolving fragmentation and disk contention.
Planned migration of this 20GB database initialy from Xbase to oracle 6.0 then to oracle 7.2
Implemented Enterprise Manager on Windows NT/95 for Centralized Database Administration.
Implemented distributed databases with two-tasking, database links, two phase commits, snapshots using SQL*NET.
Database Security and User administration via roles, profile, privilege, synonyms and auditing.
Served as Technical liaison between oracle team and System Administration team.
Developed and implement a number of utilities to automate several oracle DBA works. These include dynamic hot and cold backup, Tuning, Import, Export, Recovery and analyzing the performance.
As Database Team Leader, supervise 6 Junior level DBAs providing them ubstantial oracle Technical guidance.
Provided Technical screening and interview of several prospective DBA and Developer candidates.
Supported application development and production environments for Financial Accounting, Hotel Management, Transport and other MIS applications running Powerbuilder, Developer 2000, SQL*Forms, Report Writer and Pro*C as front end.
Project Leader Cum Principal Designer NIC, Govt of India,INDIA May `91 to Apr. `93
Lead a team of 12 Computer Professionals including Systems Analyst, Programmer and Junior Programmers.
Providing Consultancy to 6 different Govt departments which includes selection of hardware, software manpower.
System Administration of 2 Unix Server, one NT server and 30 Windows 95/3.X clients
I was maintaining a nationwide Satellite network called NICNET for Chandigarh State of India.
Initial feasibility study for Hotel Management Application which includes Interviewing and Interacting Customers.
Estimated costs and schedules and Quote final bid to customer and was able to get the contract in a tough competition.
Detailed System Analysis and Design of this Application.
Allocate functions to various system elements
Conducted Seminars/Workshops/Training for user departments on UNIX, RDBMS & Programming Languages.
Also lead the team in implementation of Financial Accounting and HR Applications on all 6 departments
Analyst cum Programmer NIC, Govt of India, INDIA Jun. `89 to Apr. `91
Worked in a team of 6 members on a project titled ?Motor Vehicle and Licensing Information System?. The project includes Registration of vehicle and Driving Licence. I have done analysis and design part of the system. Also participated in coding. The tools used were oracle 6.0, Sql Forms 3.0, Reports 1.1 and PL/SQL under UNIX. This software is being used by Estate Office Chandigarh Administartion.
As Programmer and Analyst with National Informatics Centre, worked in a team of 6 members on a project titled Inventory Management System. I was involved in coding Sale and Purchase Order Modules of the system. Extensive use of oracle Triggers in PL/SQL was done in the system. The tools used were oracle 6.0, Sql Forms 3.0, Reports 1.1 and PL/SQL under UNIX.
Library Information System. I was involved in coding of Issue/Receipt, Catalogue and Purchase Order Modules of the system. Extensive use of oracle Triggers in PL/SQL was done in the system. The tools used were oracle 6.0, SQL Forms 3.0, Reports 1.1 and PL/SQL under UNIX.
As a As Programmer worked in a team of 6 members on a project titled Inventory Management System. I was involved in coding Sale and Purchase Order Modules of the system. Extensive use of oracle Triggers in PL/SQL was done in the system During this period I worked on various other small projects and training to various departments in Computers. Tools used during this period are oracle 6.0 SQL Forms 3.0, Reports 1.1 and Xbase under UNIX.