Gargee Bhattacharjee

Phone: 510-***-****

Email: abh5mr@r.postjobfree.com

Looking for a challenging position in IT with 10yrs of industry experience

in database systems (Oracle & Sql Server). Successfully led and managed

projects as DBA in various roles with expertise involving administration,

performance tuning and production support including ERP applications.

Skills

. Operating Systems Solaris, Redhat, Oracle

Linux

. Databases Oracle 7x, 8i, 9i, 10g, Sql Server 2005

. Veritas Products VCS, Veritas SFRAC

. Oracle Applications Oracle ERP 11i, OBIEE, SOA,

Discoverer,APEX

. Web/Applications Server Apache, Weblogic (Oracle Fusion

Middleware)

. SAN Storage 3PAR, EMC Clarion, Hitachi 9700

. Backup/Monitoring Tool TOAD, RMAN, OEM Grid, SwingBench

. Scripting Lang Unix Shells, Perl

. Programming Lang SQL, PL/SQL

Certifications

. OCP-DBA 9i

. Oracle DBA Classes 10gR2, 11i, R12,10g RAC

Professional Experience

Rosendin Electric, SJ, CA : Lead APPS DBA

2006- Current

Lead ERP & SQL Server DBA for the production applications.

. Responsible for production SQL Servers

. Responsible for the production ERP system supporting

Finance, Projects and Payroll/HR modules

. Responsible for periodic cloning EPR environments for

development and test purposes

. Responsible for applying Quarterly Payroll/HR patches and

lead through test cycles

. Implemented APEX ( Oracle Application Express ) as our IT

portal page

. Installed and configure OBIEE Dashboard

. Installed and SOA EDI ( Oracle Fusion Middleware)

. Configure Discoverer 5i for reporting tool

. Architect and implemented Oracle backup solution through

RMAN, AVAMAR and tape

. Configured monitoring and alert systems with OEM Grid

besides implementing custom scripts

. Setting up Concurrent Managers and monitoring active

Concurrent Requests

. Troubleshoot performance issues with reports

. Involved in hardware planning for future storage growth

. Configured and configured XML printing for PO and Invoices

. Have good knowledge about Optio software to facilitate Check

printing

. Administered upgrade project from 9i to 10g database for the

EBS

Symantec, MtView, CA : Sr DBA

2003 -2006

Lead database projects on several Oracle RAC integration UNIX platforms and

different architectures (x86, Itanium, Opteron) with Veritas SFRAC 4.1,

Veritas CFS 4.1, Veritas ODM 4.1, Veritas IPC 4.1.

. Installed,configured and created upgrade paths of SFRAC with 9i, 10g

Oracle RAC

environment with Veritas RAC

. Running different stress (I/O, IPC, CPU) on Oracle RAC environment with

SwingBench

. Worked directly with several customer (Charles Schwab, EBay) sites to

support different

Issues and gather real test scenarios with the Veritas RAC product

. Configured, zoned enabled and troubleshoot shared storage

through the HBA switch.

. Analyzed Statspack reports for performance bottlenecks.

. Worked with Oracle Ceritification group to certify the

Veritas RAC product with Oracle RAC

. Configure and analyzed Oracle ASM

. Configured Dataguard in test environment.

Epylon Corporation, San Francisco: Mid Level Apps DBA

2000 - 2003

Managed database projects and initiatives for several B2E government

clients.

. Experience with Oracle ERP and supported Finance module

. Knowledge of Oracle Workflow Event scheduling and monitoring

. Setup Notification Mailer for alerts

. Experience with creating application users and granting appropriate

responsibilities

. Experience with Oracle Portal, Discoverer4 and configured printer

. Setup Electronic Payments Inbound & Outbound with Oracle EDI Gateway for

the 3rd Party suppliers

. Provided architecture layout for customized database implementations.

Planned infrastructure for HA, Redundancy and optimized Response Time

. Supported 24x7 high volume OLTP database with >500 concurrent users (with

20% active)

. Performed extensive tuning of OLTP databases in areas of memory, file

storage, DB processes and DB objects

. Standardized Statspack data collection and reporting across all

platforms. Developed Perl modules to chart results on intranet

Sephora.com, San Francisco: Jr Level Apps DBA

1998 - 2000

DBA responsible for production ERP application ( Finance & HR) .

1. Responsible for production capacity planning and administrative needs

2. Maintained the Finance and HR modules

3. Installing ERP with RapidInstall in the Test, Development environment

and deploy it to the production

4. Adding Client users and responsibilities from the Oracle Application

5. Monitoring and scheduled Workflow Events from the all Application with

the OAM tool

6. Automated Apps Health Check, space management.

7. Supported 24x7 high volume OLTP database and handled typical issues with

locking, hanging, CPU load

8. Tuned bulk data load operations using export/import

9. Created cloned databases for release practices

10. Provided extensive SGA tuning and analysis

11. Configured Advance Queuing

12. Configured OEM 2.1. and developed scripts for auto alarming and

statistical reports

13. Implemented backups using RMAN solutions

14. Automated development code release from development to QA databases in

Perl/Ksh

15. Applying patches to the Oracle Apps server

Acterna, Bradenton, FL: DBA

1997 - 1998

DBA worked on network management system databases on Oracle 7x, 8x for

cable industry giants.

16. Installed and configured Oracle 7x, 8x on Solaris and NT 4.0, used RAID

0+1.

17. Provided upgrade analysis paths for minimum downtime.

18. Monitored backup and resources contentions to make the production

available 24*7

19. Provided metadata repository design, architected ETL processes, and

integrated web enabled user access with Perl.

20. Configured and tuned SGA, memory usage, MTS uga footprints and

developed benchmarking tests.

21. Developed periodic tuning goals and worked with Oracle

support/metalink research.

India Market Research Bureau(IMRB), Calcutta India

1995 - 1997

Worked on DSS system, business application development and payroll

software's as trainee.

22. Worked on Programming basics, Software engineering concepts, Operating

System internals

23. Worked on RDMS concepts, SQL using Oracle

24. Supervised computer labs of more than 15 PCs running, Windows/Unix

25. Coordinated and presented software training programs. Designed

curriculum and courses

26. Maintained and tuned DSS instances

27. Performed hot/cold backups

28. Worked on ODBC setups, application connectivity issues

29. Performed benchmarking and optimization of batch data processing

programs

30. Tuned application SQL queries for better performance

Education:

B.Sc. (Economics/Statistical Sciences), Calcutta University, India

OCP (9i)

Personal:

US Citizen .

References available on request

Contact this candidate