Oracle Project
Resume:
Biswadip
Datta
OCP
DBA (Oracle **g & *i ), PGDCA, B.Sc,
Oracle
10g RAC Certified Expert.
Oracle
10g on Linux Certified Expert.
Phone:
Email:
**************@*****.***
Experience
Summary
To
work as Oracle DBA, I have an overall IT experience of 5
years in ORACLE technology (domains
Retail, Banking, Telecom, Manufacturing, TMTS) and Oracle
DBA experience of 4 years which includes Oracle 10g R2 DBA
experience of 3 years and Oracle 10g R2 RAC admin.
experience of 7 months.
Professional
summary
Professional
Society / Certification
Member
Since / Date Certified
Oracle
Database 10g: RAC Certified Expert (1Z0-048).
Mar 28,
2009
Oracle
Database 10g: Managing Oracle on Linux Certified Expert
(1Z0-046).
Jan 17,
2009
Oracle10g
Database Administrator Certified Professional
May 13,
2006
Oracle9i
Database Administrator Certified Professional
July 26,
2005
Program
or Course
Coverage
Dates
SQL*
International Limited
Oracle9i
SQL & DBA
Dec
2004
SQL*
International Limited
Oracle
Developer 6i-Forms,Reports
Feb
2005
ITC
KDC in-house training
Red
Hat Linux Administration
Apr
2005
TCS
Oracle
10g,OWB 10g, Discoverer 10g
Oct
2005
Wipro
Technologies
Manugistics
Sept
2006
Wipro
Technologies
Oracle
10g ASM, Grid Control
Jan
2007
IBM
India Pvt Ltd
Managing
Standby Database
Feb
2008
Technical
Skills
Operating
Systems
HP UX 11i, Red
Hat Linux, Win2000/2003 Server.
Databases
Oracle 10g, 9i,
8i, 8 (Database Administration)
Standby database
managing experience (managing, switchover, failover)
Oracle 9i to Oracle
10g (Migration).
Oracle10g ASM, Grid
Control,OEM, Toad, SQL Developer, Patching, Logminer, VPD, FGA
Installation &
configuration of oracle 10g,9i on RHEL 4.
Debugging Oracle on
Linux using RDA (Remote Diagnostic Agent), OS Watcher.
DatabaseCreation,
RMAN Backup using RecoveryCatalog/Control file
User Managed backup, Archive
Log configuration, Multiplexing of Control file, Redo Log Files,
Import/Export,
SQL* Loader, Data Pump
Statspack, AWR,
Tkprof SQL Statement tuning (Cost -based/Rule-based),Tuning of SGA.
Creation of, Pfile
from Spfile viseversa, Tablespace (Localy managed/dictionary
managed), Oracle Net Manager (Tnsnames.ora, Sqlnet.ora,
Listener.ora), Oracle Flashback Query (Time /SCN based),Materialized
Views, Oracle Shared Server Configuration, etc.
Languages
SQL, PL/SQL (Trigger, Cursor, Procedure, Function, Package)
Front End
Oracle Developer 2000/ 6i / 10g (Forms, Reports)
Reporting
Oracle Discoverer 10g
ETL
Oracle Warehouse Builder 10g
Educations
PGDCA
from IGNOU in, Dec 2004.B.Sc
from Calcutta University (Asutosh College), Kolkata, in 1997.
Higher
Secondary Exam. From Cathedral Mission High School, Kolkata, in
1995 .
Madhyamik from
Cathedral Mission High School, Kolkata in 1993.
Professional
Project Experience
Your
Current employer s name
Cognizant Technology Solutions
(Kolkata).
Duration
1st
September 2008
till now
Technology
Oracle
10G, 9i, 8i database
Patching, Tablespace monitor,
SQL query tunning, alert log checking, partition maintenance,
database refreshing,Trace file analysis, Managing RAC databases.
Toad
HP
UX 11i, Linux
Project
Abstract
Staples
ITIS DBA ( Retail )
Role Oracle DBA
Previous
employer IBM
India Pvt. Ltd (Bangalore).
Duration
Feb
2008 June 2008
Technology
Oracle
10G, 9i, 8i database (650 GB to 1 TB data volume)
Patching, Tablespace monitor,
Backup, SQL query tunning, AWR & STATSPACK report analysis,
alert log checking,
Trace file analysis, partition
table creation
RMAN
SQL
Developer
HP
UX 11i
Project
Abstract
Capital
One UK ( Banking )
Role
Oracle
DBA
Previous
employer Wipro
Technologies .
Duration
July
2006 to Dec 2007
Technology
Oracle10g(
Production- 1 TB data volume), Oracle9i
(
Production- 110 GB data volume)
Oracle
10g ASM, Oracle 10g Grid control, AWR,
HP
UX 11i
SQL
Developer
Oracle
Warehouse Builder 10G
Oracle
Discoverer 10G
Project
Abstract
CONTINENTAL
( MANUFACTURING vertical ), LEXMARK ( TMTS vertical )
Role
Oracle
DBA
Previous
employer AMI
Industries (India) Pvt Ltd and worked in TCS s
EDW project of British Telecom (BT).
Duration
Oct
2005 to March 2006
Technology
Oracle
10G database (1TB data volume)
(Implementation
of :- external table, oracle directory, AWR, Data Pump,
DBMS_SCHEDULER, DBMS_FGA, DBMS_MONITOR etc)
RMAN
Oracle
Warehouse Builder 10G
Oracle
Discoverer 10G
Toad
HP
UX 11i
Project
Abstract
TCS s
EDW
Enterprise Data Warehouse project of BT (
Telecom )
Role
Oracle
DBA
Previous
employer SQUAREM
Tech.Systems (P) Ltd and worked in ITC
Kolkata Datacentre.
Duration
June
2004 to June 2005
Technology
Win 2000, Oracle 8i,
Toad, OEM, Red Hat Linux
Performance
tunning
Execute
statspack.snap
Generate
statspack report
Deletion
of old snap id by using spurge.sql
SQL
tunning.
Using
of tkprof
Monitoring
table space size.
Finding
and recompiling invalid objects.
Taking
hot backup (User-Managed) of soya database.
Running
export & import.
Coalesce of
tablespace.
Generation
of Soya summary report (database health report).etc
RMAN
Log
Miner
Project
Abstract
ITC
Kolkata Datacentre production database maintainence. ( Retail )
Role
Oracle
DBA
Previous
employer SQUAREM
SoftServices .
Duration
April
2003 to May2004
Technology
Oracle
8,9i SQL, PL/SQL, Developer 2000,Win 2000
Project
Abstract
Inventory
Management System
The system is able
to keep & manage systematic stock maintain reorder level and
restrict over ordering of product. Along with this the system
maintains the vendor payment status based on the purchase order
and generates several types of management and accounts reports and
registers.
Fixed Assets
Management System
The main theme of
the system is to valuate fixed assets of the organisations.The
purchase,sales and lease transation entry can be done through the
system.The system is smart enough to the management because they
can monitor total scenario regarding the asset position.
Student
Processing System
This
project contains Student, Training Center, Course, Refund,
Course/student Statistics(Pie chart) etc modules. Validations are
given in both front end (forms), backend(database) for better
security. LOV, Combo box, Calender, Alert, Visual Attribute,
Stacked Canvas are used where required.
Role
Programmer
PASSPORT
DETAILS:
Name as on passport
Relationship
Passport Number
Date of Issue
Expiry Date
Place of Issue
Biswadip Datta
Self
F 5032035
05-OCT-2005
04-OCT-2015
Kolkata
PERSONAL
PROFILE :
Date
Of Birth 25th November 1976
Marital
Status Married
Languages
Known English, Bengali, Hindi
Interests
Photography.
Address
3/10
R.K. Chatterjee Road,
P.O. Kasba,
Kolkata 700042.
(BISWADIP
DATTA)
Contact this candidate