Highly experienced Information Systems Specialist with cross-functional
expertise
 in database administration and project management of ORACLE, Oracle Financials,
DB2 and Sql Server 

SUMMARY OF QUALIFICATIONS
	Over 10 years’ experience as an Information Systems Professional
specializing in Database Administration, Database Design, Project Management,
Software Implementation and Systems Architecture.
	Expert knowledge of ORACLE database (versions 7, 8i, 9i, 10G), DB2 UDB
7,8 and SQL SERVER 7.  Extensive expertise designing, installing, customizing and
supporting RDBMS under UNIX (HP, AIX, Solaris, Linux) and Windows NT platforms 
	Expertise with distributed database techniques i.e. Real Application
Cluster (RAC), Multi master Replication, Standby database and database cloning
	Experience in using Erwin, DBArtisan, Shareplex, Spotlight, BMC Patrol,
DBA studio, OEM tools, ETL
	Ability to handle basic systems administration tasks for UNIX Operating
system
	Well oriented in Networking (LANs, WANs), SQL * Net8

RDBMS:	Oracle 10G, 9i, 8i, 7.x, 6.0, DB2 UDB 8.1, SQL SERVER 7
ERP:	Oracle Financials 11i
GUI: 	Developer 2000 (Forms 4.5, Reports 2.5)
LANGUAGES:      	PL/SQL, SQL*Plus, C, Shell, Java, JSP, VB, ASP, and .NET
AS:	IBM Websphere 3.5
OS:	IBM AIX (4.3 / 4.2), HP/UX 9 – 11, Sun Solaris 5.9, 5.8, 5.7, Red Hat Linux
AS/ES 3 -4, Windows NT (4.0) and Windows 95/98/2000, Windows NT Workstation  
TOOLS:           	DBArtisan, OEM, Quest Spotlight, Shareplex for Oracle, Patrol
(BMC), DBA Studio, ARC Server, Erwin3.5/4, SQL Navigator 3, ETL, Rational
Clearcase

PROFESSIONAL EXPERIENCE

Senior Consultant, DBA							May 05 – Present

Working for multiple clients and supporting them as remote DBA. Main role is to
provide on call support and implement new projects


Supporting a major investment bank in US and responsible for remotely supporting
Oracle databases as well as implementing new projects using latest oracle
technology

	Member of team providing 24 X 7 support for production databases.
	Writing, Implementing and testing of backup procedures for the
development, testing and production environment using Recovery Manager (RMAN) for
8i , 9i and 10g
	Configured 10g Data Guard and implemented Data Guard Broker.
	Migrated from Oracle 8i to 9i, Oracle 9i to 10G. 
	Used new features of 10G viz., data pump, flashback, Incremental merge
in RMAN etc.
	Applying latest CPU patches and also various bug patches
	Intensive use of   Log Miner, Oracle Streams and Advance Queuing 
	Setup multi-master replication and troubleshoot any issues relating to
replication or materialized views
	Database performance tuning using AWR and ADDM reports. Used SQL Tuning
advisor and Segment advisor
	Assisted in the prioritization of all bugs and change requests ensuring
that they fit within the overall technical architecture of the project or change
	Install, configure and manage all Oracle instances on mid-tier (Unix
and Windows)







Government Services, Canada							Jun 04 – Apr 05
Senior Consultant, DBA

Member of the team providing technical support for over 180 production servers
and numerous services within four data centers with an inventory exceeding 300
servers in various stages of build. As a Database Administrator, support customer
applications within the Government of Ontario through the creation of physical
data base designs and administering the Data Base Management System (DBMS)
including the optimization of the databases, performance tuning, backup and
recovery. 

	Accountable for overseeing all technical aspects of database systems
changes and problem management. 
	Primary liaison between Infrastructure, Server Support, Team Leads,
Business Analysts and the Solutions Integration Teams with reference to Oracle,
DB2 and SQL databases
	Assisted in the prioritization of all bugs and change requests ensuring
that they fit within the overall technical architecture of the project or change
	Install, configure and manage all Oracle instances on mid-tier (Unix
and Windows)
	Configured and maintained Oracle 9i RAC on Red Hat Enterprise Linux
AS/ES 4.
	Configured Oracle 9i backup through RMAN on Solaris 5.9 and Veritas Net
Backup 4.5
	Planning, configuring and maintaining DB2 Shared services for the
entire OPS (Ontario Public Service).
	Maintaining SQL Shared services for the entire OPS.
	Migrated WebDB 2.2 to Oracle Application Server 9i
	Writing, Implementing and testing of backup procedures for the
development, testing and production environment using hot back-up strategy and
Oracle provided tool Recovery Manager (RMAN) for 8i and 9i.


IBM / Empire Blue Cross Blue Shield , US                           					May 01–
Jun 04
Senior Oracle DBA

Responsible for all the production databases and led in the optimization,
maintenance and enhancement of ORACLE environment. Beside Oracle databases,
additional responsibilities of DB2 and SQL server were also performed on as and
when required basis.

	Writing, Implementing and testing of backup procedures for the
development, testing and production environment using hot back-up strategy and
Oracle provided tool Recovery Manager (RMAN) for 8i and 9i on Solaris 5.7,5.8 and
AIX 4.3,5
	Configured, implemented and maintained the Oracle Standby database for
high availability environment on Windows NT and AIX, Implemented transparent
application fail over (TAF) on Windows NT/2000 Server. 
	Plan, manage, expand and upgrade technical infrastructure, consisting
of 5 locations and up to 300 users.
	Configured and maintained Oracle 9i RAC on AIX cluster. Configured and
maintained Oracle Fail safe on Windows 2000. Installed replication with shareplex
from Quest Software on HP/UX.
	Research and implement new data warehousing solutions and experience in
using Oracle ETL tools
	Install, configure and manage all DB2 instances on mid-tier. Installed
and maintained DB2 connect on AIX.
	Evaluate and optimize ORACLE applications, consisting of ORACLE
Financials 11i, e-business, data warehousing, legal system and help desk. 
	Install, Analyze and upgrade ORACLE Financial systems.
	Design e-business database solutions for Websphere-based applications.
	Installed DB2 UDB on AIX/NT/2000 and Install SQL SERVER 7 on NT/2000
	Migrated SQL Server data into Oracle
	Assisting application developers in SQL query performance tuning using
Oracle supplied utility tkprof, explain plan to check the disk I/O and access
path of query of SQL query, DML statement
	Performance tuning of variable initialization parameter, disk I/O, CPU
utilization, paging rate, buffer, data dictionary and library cache, miss ratios
calculations.
	Design and implement back-up/recovery strategy for new ORACLE
environment.
	Direct day-to-day administration and maintenance of ORACLE RDBMS,
including creation of tables, space allocation, stored procedures and triggers.
	Implement Capacity Planning processes and procedures.
	Monitoring the activity of 70 instances using the BMC Patrol monitoring
tool.
	Automated database backup using shell script programming and export
utility of oracle on UNIX platform.


American International Management						Oct 00 – May 01
Database Administrator -Consultant
Consultant DBA accountable for successfully planning, managing, expanding and
upgrading company’s technical infrastructure.  

	Installation and Administration of an Oracle 8i (8.1.5) database on
various platforms
	Installation and Administration of Windows NT (4.0) and SQL server 7
	Full Oracle8 Database Administration services in support of PeopleSoft
Financials, Supply Chain, and Distribution applications. 
	Responsible for all aspects of PeopleSoft security administration.
Responsible for all aspects of project migration and patch application. 
	Developed and administered multiple PeopleSoft Process Schedulers.
Participated in the full life cycle deployment of the PeopleSoft implementation
then provided both on-site and remote support services. 
	Database design and creation estimate size for table spaces, tables,
redo log files, indexes, rollback segments and managing objects
	Involved in the preparation of ER diagrams and Data Flow Diagrams
	Database tuning, application tuning, rebuilding indexes, performance
monitoring, changing initialization parameters, disk I/O, memory tuning to
improve the performance of online database
	Implemented Multi-master (sync mode) replication setup for this portal
site over the local area network using Oracle Enterprise Manager across different
O/S i.e. NT and IBM-AIX
	Performance tuning of variable parameter, disk I/O, CPU utilization,
paging rate, buffer, data dictionary and library cache, miss ratios
calculations.
	Installation and configuration of Developer 2000 at client side
	Implemented database security using roles, profiles and privileges 


Manipal Consultancy Services, India 			 Sept 97 to April 00
Database Administrator

MCS is an in-house consulting for Manipal Group. Manipal Group is conglomeration
of more than 50 educational institutes, Hospitals, Financial Institutions etc.
MCS was involved in providing consulting on Software, Hardware and Finance to
Manipal Group.

	Installation and Administration of Oracle 7.x/ 8.x database
	Space management such as disk space uses; swap space availability,
objects reaching max extents, amount of free space in table space and capacity
planning.
	Implementing and maintaining database security (create and maintain
user, roles, and assign privilege)
	Appraise the technical director and MIS director of the problems which
exist in the project and recognize the infrastructure for the coming years
	Data control relocation of data files, online redo logs files, and
database control files
	Handling backup and recovery of database, applied partial recovery due
to loss of data file
	Implemented Updated Snapshot replication setup for a schema using
scheduled database link over the local area network and configured the setup
using Oracle Replication Manager
	Application tuning, user creation, relocation of data files,
performance monitoring using the explain plan tool.
	Installation and configuration of Developer 2000 at client side
	Written a UNIX shell script to perform the export utility to for
logical backup of the database.
	Automated the backup activity by putting the above script in crontab
job.










MEMG. Nepal  		              	July 96 to August 97
Junior Consultant

MEMG is an Educational Group based in NEPAL offering education in Medical and
Engineering streams. As an junior consultant was responsible for Oracle
installation and maintenance

	Installation and Administration of an Oracle 7.3.2 database
	Installation and Administration of RISC based operating system such as
SMOS (8.28)
	Database design, estimate size for table spaces, tables, redo log files
and indexes and managing objects
	Database tuning, application tuning, rebuilding indexes, performance
monitoring, changing initialization parameters, disk I/O, memory tuning to
improve the performance of online database
	Troubleshooting problems in the existing database, interacting with end
system users, developers regarding the problem which occur
	Involved in writing and troubleshooting stored procedures and
triggers.
	Involved in the backup and recovery policies and procedures

Environment:   SCO UNIX (3.2R4.2)/ (5.0), UnixWare (2.01), SVR4, XENIX
(2.3.2/4), Oracle 6.0, Windows 95.

EDUCATION/PROFESSIONAL TRAINING
Oracle 8i DBA Certification (Database Administration and architecture, Backup
and Recovery)
IBM DB2 Certification
Oracle 8I, 2000, India
Oracle 8, 1998, India
Certificate Course in Oracle Financials, 1998, India
Unix and C, 1997, India
MCom ,1996, India
Diploma in Computerised Accounting Applications, 1994
BCom, 1993, India