POOJA BHATTACHARJEE
Contact No: 1-720-***-****
Mail ID: *************.*******@*****.***
Address: Flat No –> O -301, 1100 East, 17th Avenue, Longmont, CO-80504
Gender: Female
Marital Status: Yes
VISA Status: H4 needs sponsorship for H1.
QUALIFICATION:
Level 1: SSC X-2002 ie, Xth
Level 2: H.S.C. XII-2004 Xiith
Level 3: Bachelor Of Technology (BTECH)-2008 in Computer Science And Engineering
Work Experience Details: I have been working as an Oracle product specialist and Senior DBA for 4 years
in Tata Consultancy Services Ltd., which includes both oracle product architecture designing and
administering skills. The products I have managed learning are Oracle Database Server(8i release 1 to
11g release 2), Oracle Application server(9i release 1 to 11g release 2 web logic server), Oracle IDS(6i to
11g release 2) and other supporting products required for creating High A vailability architectures with
these software’s. I am comfortable with different flavors of OS like, LINUX, UNIX, WINDOWS .
Contributions/Achievements: During my 4 years working tenure I have been rewarded and appreciated
many a times for my hard work and dedication both from my company and my clients. The Mention
worthy are: - Award for the best technical team,2010; Award for the best performance, 2011 as well as
TCS Gems Service and commitment award for 3 years of dedicated service, 2012.
Technical Skills:
ORACLE NON ORACLE
Product Tool Product Tool
1. Oracle Database RMAN, TKPROF, ADDM, 1. Windows 2000 to VMWARE, Virtual PC
8.1.7.4 to 11.2.0.3.2 AWR, IMPORT Windows 2008 R2 and Virtual software,
2. Oracle Application DUMP,EXPORT 2. LINUX flavors like Software Load
Server 9.1 to 11.1.1.6 DUMP,IMPORT Oracle Enterprise balancer, X-manager,
3. Oracle IDS 6i to EXPORT,ASM,ASSM,ORACLE Linux, Red Hat, SUSE, X-win, Cygwin,Winscp.
11.1.1.6 FAIL Fedora.
4. Oracle Golden Gate SAFE, RMAN, WEBUTIL, 3. UNIX flavors IBM
for 10g and 11g Sql/plus, pl/sql developer, AIX, HPUX, HPUX
5. Oracle Clusterware Forms and Reports builder, PARISC, SUN Solaris,
6. Oracle Grid Sql/plsql navigator,PUTTY Oracle Solaris. I have
7. Oracle Middleware etc. also configured
products like Weblogic network
Suite, Portal,SOA 4. OS cluster in,
Suite, Weblogic Server Windows and Linux
etc. environment.
8. Oracle Fail Safes 5. SSH configuration in
LINUX
CLIENTS SERVED:
Customer Name Service Provided Skillsets
SunAmerica Annuity and Life A]Oracle database migration 1. Oracle Database 11.2.0.3
Assurance Company (10.2.0.5 to 11.2.0.3),O- 2. Oracle O-patch 11.1.0.7.9 and
patching(11.2.0.3.2), trouble 11.2.0.3.2
shooting,performance 3. SQL server windows 2008 and
Tuning(using windows 2003
ADDM,AWR,TKPROF,ASSM).
B]Up-gradation of SQL server
from Windows 2003 to windows
2008 and day to day
maintenance of it.
C]Oracle Backup like RMAN
D] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
United Bank Of India A] Oracle database up-gradation 1. Oracle Database 11.2.0.2
11.1.0.6 to 11.2.0.2.2 2. Oracle O-patch 11.2.0.2.2
B] High availability
Architecture like Physical
standby database(active
dataguard) and Data guard
Broker.
C]24x7 DBA support as and when
required.
Eastern Railways Of India A] Oracle Database migration 1. Oracle Database versions 8.1.7
from 8.1.7 to 10.2.0.1,and it’s to 10.2.0.4.
up gradation to 10.2.0.4 2. Oracle Golden Gate 10g
B] Audit trail and Log miner
Configuration
C] Database health checkup
using stat pack generation and
customized scripts.
D] Same platform(LINUX)
unidirectional OGG 10g
configuration.
E] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
Damodar Valley Corporation A] Red Hat Linux 5.6 installation 1. Red Hat 5.6
B] Oracle Database 10.2.0.4 2. Oracle Database 10.2.0.4
installation and Physical standby 3. Oracle SOA Suite
database (active
dataguard)configuration
C] Oracle Application Server
10.1.3.2 installation along with
SOA suite configuration and
Application (java EAR)
deployment.
Ananda Bazar Patrika A] RHEL 5.6 installation and 1. RHEL 5.6 and LINUX clustering
cluster configuration for two 2. Oracle Database 10.2.0.5
nodes.
B] Oracle Database 10.2.0.5
installation and Active/Passive
configuration between two
nodes.
C] Physical standby database
(active dataguard) configuration
for this active passive
architecture.
Tata Medical Center A] Oracle database 10.2.0.5 1. Oracle Database 10.2.0.5
installation and Active/Passive
configuration on it.
B] RMAN configuration for
automatic & scheduled database
backup mechanism
Metro Railways A] Oracle Database 10.2.0.4 1. Oracle Database 10.2.0.4
installation and data migration 2. Oracle Golden Gate 10g
from 8.1.7 to 10.2.0.4 on HPUX 3. Oracle standalone Forms and
platform. Report Server 10.1.2.0.3
B] Virtual bidirectional data 4. Oracle IDS 10.1.2.0.3
replication configuration using
Oracle Golden Gate 10g.
C] Oracle standalone Forms and
Report Server 10.1.2.0.3
installation and configuration
D] Oracle IDS 10.1.2.0.3
configuration and Oracle forms
and reports migration from 6i to
10g.
E] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
United Commercial Bank A] Oracle Database up gradation 1. Oracle Database versions
from 9.2.0.1 to 9.2.0.8 and then 9.2.0.1 to 11.2.0.2
migrating it to 11.2.0.2,after its 2. Oracle Client versions 9.2.0.1
release. to 11.2.0.2
B] Oracle Client versions 3. Oracle failsafe version 3.3.2 to
installed and configured 9.2.0.1 3.4.2.0
and 11.2.0.2
C] Physical standby database
(active dataguard) configuration,
Switchover between the primary
and standby databases making
the standby primary and the
primary standby as and when
required and Snapshot database
configuration to check proper
functioning of the active
dataguard.
D]Oracle Fail Safe 9i
configuration.
E] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
State Bank Of India A] Oracle Database up gradation 1. Oracle Database versions
from 9.2.0.1 to 9.2.0.8 and then 9.2.0.1 to 10.2.0.4
migrating it to 10.2.0.4,after its 2. Oracle Client versions 9.2.0.1
release. to 10.2.0.4
B] Oracle Client versions 3. Oracle Audit Vault 10.2.3.2
installed and configured 9.2.0.1
and 10.2.0.1
C] Physical standby database
(active dataguard) configuration,
Switchover between the primary
and standby databases making
the standby primary and the
primary standby as and when
required
D] Database audit trail
configuration and audit vault
configuration for meeting their
data security policies.
E] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
West Bengal Commercial Taxes A] Oracle database 11.2.0.2 1. Oracle Database server
installation and data migration 11.2.0.2
from 9.2.0.1 to 11.2.0.2. 2. Oracle Web logic Server
B] Extended RAC along with Grid 10.3.6.0
configuration with database 3. Oracle Application Server
version 11.2.0.2 11.1.1.6
C] Hardware load balancing
D] Oracle 11g Web logic server
(10.3.6.0)and Application server
(11.1.1.6 pfrd) installation and
multiple forms and reports
server service configuration
along with software load
balancing at application server
level, in order to distribute the
user request through different
services.
E] Migration of forms and
reports in 6i to 11.1.1.6
Biecco Lawrie A] Oracle database server 1.Oracle Database server
10.2.0.4 installation and data 10.2.0.4
migration from 8.1.7 to 10.2.0.4
B] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
Orissa Modernizing Government A] Suse 10,linux clustering and 1. Oracle Cluster ware 10.2.0.4
Initiatives SSH,OCR,VOTING DISK and ASM 2. Oracle Database 10.2.0.4
configuration. configuration. 3. Oracle Application Server
B]Oracle cluster ware 10.2.0.1 10.1.2.0.2
installation and up gradation to
10.2.0.4 installation.
C]Oracle 3 instance RAC
configuration with database
version 10.2.0.4
D]Oracle Application server
10.1.2.0.2 installation along with
PORTAL configuration.
Orissa Secretariat A] Red Hat 5.2, linux clustering 1. Oracle Database 10.2.0.4
and SSH,OCR,VOTING DISK and 2. Oracle Cluster ware 10.2.0.4
ASM configuration. 3. Oracle Metadata Repository
configuration. Creation Assistant 10.1.2.
B]Oracle RAC configuration with
database version 10.2.0.4
C]Oracle Application server
10.1.2.0.2 installation along with
web cache configuration.
Kolkata Municipal Corporation A] Red Hat 5.4, linux clustering 1. Oracle Database 10.2.0.4
and SSH,OCR,VOTING DISK and 2. Oracle Cluster ware 10.2.0.4
ASM configuration.
configuration.
B] Oracle Cluster ware 10.2.0.4
installation and RAC
configuration with Oracle
Database version 10.2.0.4
Kolkata Police(Head Quarters) A] Red Hat 5.6, linux clustering 1. Oracle Grid and Database
and SSH,OCR,VOTING DISK and 11.2.0.2
ASM configuration. 2. Oracle standalone Forms and
B] Oracle Grid and RAC Reports server 10.1.2.3
configuration with Oracle 3. Oracle Developer suite
Database version 11.2.0.2 10.1.2.3
C] Oracle standalone forms and
reports server installation
10.1.2.3.
D]Oracle ids 10.1.2.3 installation
and migration of forms from 6i
to 10g
Customer Birla Tier A]Oracle database 10.2.0.5 1. Oracle Database 10.2.0.5
installation and Physical Standby 2. Oracle standalone Forms and
database configuration(Active Reports server 10.1.2.3
Data guard)
B] RMAN Configuration for
Automatic backup &
maintenance.
C] Oracle standalone forms and
reports server installation
10.1.2.3.
D] 24X7 DBA support for all
Oracle Products including
performance tuning,
troubleshooting or maintenance
activity.
Geological survey of India A] Oracle Cluster ware 10.2.0.4 1. Oracle Database 10.2.0.5
installation and RAC 2. Oracle Application Server
configuration with Oracle 10.1.3
Database version 10.2.0.4.
B] Active Data guard
configuration on the RAC
structure.
C] Oracle single instance ASM
database configuration with
version 10.2.0.5
D] Oracle Application Server
10.1.3 configuration along with
web cache