Manager Oracle

Title:Technician / System Administrator

*******@*****.***

Document

Source below

NAME: SUJAN MITRA

ADDRESS: ***** *** **

CITY: FREMONT

STATE/PROVINCE: CA

ZIP/POSTAL CODE: 94539

COUNTRY: USA

EMAIL: *******@*****.***

PHONE: 510-***-****

CANDIDATE ID: 97317

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 6

WILL RELOCATE: Yes

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

HOTSKILLS: ORACLE =5+ yrs, ORACLE DBA =5+ yrs, ORACLE APPS DBA =2+ yrs, PL-SQL =5+ yrs, PERL =1+ yrs, INFORMATICA =6+ mths

ESUME

Sujan Mitra

7 years of experience in analysis, design, development and implementation of Applications

as an Oracle Applications Database Administration (24/7). Extensive hands on experience

with Oracle Application 11.5/10.7 on SUN Solaris and Windows platforms. Strong knowledge

of installation, configuration, implementation, performance tuning and troubleshooting,

backup/recovery, Application and database tuning. Extensive experience in Shell Scripting,

PL/SQL, Designer 2000, Erwin 3.x, Developer 2000, OEM, VERITAS Netbackup, VERITAS Volume

Manager and VERITAS Clustering. Strong conceptual knowledge of Powermart 4.7

(Informatica).

SKILLS PROFILE:

Hardware: RS-6000, SUN Ultra HP 9000, Pentium PCs

Operating System: SUN Solaris 2.x, HP- UNIX 11.0, AIX- UNIX 4.x, Windows 95/98/NT

Languages: C, PL/SQL, Shell Scripting, PERL, Pro * C

Special Software: VERITAS Netbackup, VERITAS Volume Manager, VERITAS Cluster Server, OEM,

SQL*Plus, Export/Import, RMAN, Designer 2000, Performance Pack, Server Manager, Network

Manager, Apache Web Server, Oracle Web Application Server, Informatica, Developer

2000(Forms 5.0/4.5, Reports 3.0/2.5)

ERP: Oracle Financials 10.7/11.5(AOL, Sys Admin)/VANTIVE

Network Protocols: TCP/IP

RDBMS: Oracle 8i/8.x/7.x, Oracle Application 11.5/10.7

PROJECT DETAILS:

Dec, 2000

to May, 2001

Oracle Application Database Administration

Client: Agilent Technologies, Rocklin, CA

Role: Sr. Oracle Applications DBA

Worked as an Oracle Application DBA to support the transition of Oracle Applications.

My responsibilities included:

Complete planning, project scoping of migration of Oracle Applicationn 10.7 to 11.03

and 11i

Installation, Configuration and Administration of an Oracle Application 10.7 Smart

Client on HP-UX platform.

Migrating Oracle Application from 10.7 to 11.5 (11i)

Migration of backend Oracle 7.x database to 8i

Applying patches for applications through adpatch utility, cloning of test and

development instance using adclone utility

Creating users, responsibilities, assigning responsibilities to users

Creating new concurrent manager and managing concurrent managers

Implemented comprehensive Backup/Restore mechanism using VERITAS Netbackup Utility,

VERITAS Volume Manager, VERITAS Cluster Server

Installation and Configuration of Oracle 8i

Defining Platform and Tools Requirements

Conducting Sizing/Capacity Planning efforts for the Oracle Database and Applications.

Designing a high availability 24*7 hours databases and hardware infrastructure.

Working closely with the Application development team for the Bug Fixes and Escalation

Extensively Involved in loading data into Oracle 8i tables using SQL* Loader

Worked on Informatica (ETL Tool) to message access data, message data/transformation

form legacy data source into Oracle applications.

Tuned Applications using tkprof, usage of bind variables in all user programs and using

data dictionary tables to tune database.

Documentation

Hardware: HP-9000, HP workstations, Pentium PCs

RDBMS: ORACLE 8I

Operating System: UNIX (HP-UX), Windows NT, SUN Solaris 2.6

ERP: Oracle Financials 11.5/10.7

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, VERITAS Netbackup/Volume

Manager/Cluster Server, Erwin 3.5, SQL* Loader, Apache server

Apr, 2000

to Dec, 2000Oracle Database Administration

Client: Exodus Communications, Santa Clara, CA

Role: Oracle DBA

While on this project, my responsibilities included:

Involved in tuning and development of Oracle 8i. Involved in WebDB Migration. Multiple

refreshes for Report Server using Snapshot. Involved in Replication of Database Analysis

study for Call-Center.

Development and implementation of PROMON-1 Server Checking and PROMON-2 DB Checking.

Oracle installation and set up on Siebel development server. Involved in capacity

planning study for Genesys Report Server.

Involved in defining platform and tool requirements. Involved in loading data into

Oracle 8i tables using SQL* Loader.

Implemented comprehensive Backup/Restore mechanism using VERITAS Netbackup.

Involved in installation and configured Oracle Enterprise Manager (OEM) and Performance

Pack monitoring tool. Involved in extensive tuning of concurrent managers, database

servers, o0perating system and 3rd party tools.

Provided user support documentation.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 8i/7.X

Operating System: Windows NT, SUN Solaris 2.6

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5, Sybase Power Designer 7.0

Jan, 2000 to Apr, 2000

Oracle Database Administration

Client: California Independent System Operator, Alhambra, CA

Role: Oracle DBA

While on this project, my responsibilities included:

Involved in installation, configuration, tuning and development of Oracle 8i. Performed

data modeling.

Involved in PL/SQL code reviews and coding, tuning of the application.

Defined platform and tools requirements.

Extensively involved in loading data into Oracle 8i tables using SQL* Loader.

Implemented comprehensive Backup/Restore mechanism

Installed and configured OEM and Performance Pack Monitoring tool. Provided user

support documentation.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 8i/7.X

Operating System: Windows NT, SUN Solaris 2.6

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5

Nov, 1999 to Jan, 2000

Oracle Database Administration

Client: 3Com, Santa Clara, CA

Role: Oracle DBA

Involved in installation, configuration, tuning and development of Oracle 8i as well as

defining platform and tools requirements.

I was responsible for conducting sizing/capacity-planning efforts for the Oracle

database and applications.

Designed high availability 24x7 databases and hardware infrastructure. Extensively

involved in loading data into Oracle 8i tables using SQL* Loader. Implemented

comprehensive Backup/Restore mechanism using OmniBack Utility.

I installed and configured OEM and Performance Pack Monitoring tool. iDisk layouts for

physical and logical database using raw partitioning, Quick I/O considering RAID striping

and mirroring.

Documentation.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 8i/7.X

Operating System: Windows NT, SUN Solaris 2.6

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5, Sybase Power Designer 7.0

Jan, 1999

to Sep, 1999

Client: SBE, San Ramon, CA

Role: Oracle Applications DBA /Oracle DBA

While on this project, I was responsible for:

Involved in installation, Configuration, Administration and Migration of Oracle

Applications 10.7SC - 11.0.

Involved in installation, configuration, tuning and development of Oracle 8i. Conducted

Sizing/Capacity Planning efforts for Oracle Database and Applications.

Designed high availability 24x7 databases and hardware infrastructure.

Worked closely with the application development team for the Bug Fixes and Escalation.

Extensively involved in loading data into Oracle 8i tables using SQL* Loader.

Implemented comprehensive Backup/Restore mechanism using OmniBack Utility.

Documentation.

Hardware: SUN Ultra, Pentium PCs, HP 9000

RDBMS: Oracle 8i/7.X

ERP: Oracle Financials 11.03/10.7

Operating System: HP- UX 10.10,Windows NT, SUN Solaris 2.6

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5, Sybase Power Designer 7.0

Apr, 1998

to Jan, 1999

Oracle Database Administration

Datascan Technologies, Atlanta, GA

Role: Oracle DBA

While on this project, my responsibilities included:

Responsible for installation, upgrades and application of patches for Oracle. Involved

in planning database logical storage and physical structure.

Developed instance startup and shutdown scripts.

Different parameter file were selected according to the different type of load on the

system.

Proper distribution of rollback segments according to the transaction type to be

dealtby database was considered.

Backup policy was decided on the basis of availability of the database.

Involved in tuning SQL statements to reduce response time and application tuning.

Involved in collecting and analyzing database performance information and other related

database administration activities.

Also involved in helping the analysts in data modeling of the various modules. Involved

in data modeling. Developed PL/SQL packages and designed database tables to be used for

reporting.

Wrote PL/SQL programs for rollup tables and de-normalization of tables for reporting

purposes.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 8/7.X

Operating System: Windows NT, SUN Solaris 2.6, HP UX 10.1

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5

Jan, 1996

to Feb, 1998Oracle Database Administration

Client: Iris Software Ltd

., India

Role: Oracle DBA

While on this project, I was responsible for:

I was responsible for database administration.

Was responsible for backup plans, execution and recovery of database. Involved in

implementing security and resource management.

Created users, roles, privileges, indexes, data files, redo-logs, control files and

table spaces. Involved in the design and creation of the schemas, creating the database,

modifying database structures, monitoring and tuning database, managing database storage

and security.

Developed database stored procedures for all processes, triggers for business rules and

views for complex queries.

Involved in performance tuning SQL statements and application tuning. Involved in

collecting and analyzing database performance information.

Formulated Backup and Recovery strategies for clients and recover the databases in case

of a crash.

Resolved connectivity issues on SQL*Net through TCP/IP, SPX/IPX. Performed post

installation troubleshooting.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 7.X

Operating System: Windows NT, SUN Solaris 2.5

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Apache Web Server, OEM, SQL* Loader,

Erwin 3.5

May, 1995

to Jan, 1996

Oracle Database Administration

Nestle India Limited, India

Role: Oracle DBA

While on this project, my responsibilities included:

Created test database and used it as model for appropriate change to production

database to have minimum resource usage and high performance.

Created table spaces at the production database, allocating one for indexes and the

other for remaining database objects.

Created users and granted privileges and roles.

Created various synonyms and views as the system required access to objects owned by

other users.

Tuned the production database to ensure that Redo Logs and Rollback Segments have no-

wait sizing of Rollback to reduce wraps and extends (and shrinks). Reduced I/O contention

amongst various data files.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 7.X

Operating System: Windows NT, SUN Solaris 2.5

Tools: PL/SQL, SQL*Plus, SQL*Loader, Developer 2000

May, 1994

to May, 1995Oracle Database Administration

Client: DCM Financial Services Ltd

., India

Role: Oracle DBA

While on this project, my responsibilities included:

Created database Triggers, Procedures, Functions and Packages as per Business

requirements of the system.

Backup and recovery of the database.

User Support.

Tuned applications using SQL Trace and Explain Plan. Developed screens for enquiry and

configuration management.

Documentation.

Hardware: SUN Ultra, Pentium PCs

RDBMS: Oracle 6.X

Language: UNIX Shell Scripting

Operating System: Windows NT, SUN Solaris 2.6

Tools: PL/SQL, SQL*Plus, SQL*Loader, Forms 3.0

EDUCATION:

1991

- Bachelors in Science, Major: Physics, Andrews College, India

1994

- Graduate Diploma in Systems Management, NIIT, India

Contact this candidate