Pooja Anand Bhat

Home: ***** ********* ****** #***, *****, Florida 33647, USA Cell phone:

813-***-**** Email: acdxtd@r.postjobfree.com

[pic]

Looking for a position in Oracle Database administration, management and

development.

AN OVERVIEW

[pic]

Database Administrator with over 6 years of experience in database

development, creation and maintenance of database objects in Supply Chain

and Finance domains. Possess a very strong work ethic and high ownership of

responsibilities.

Multi database skill set in Oracle Database 10g/ 11g, Microsoft SQL Server

2005/ 2008 and IBM DB2 V9.x. Actively involved in database activities such

as database creation, maintenance, upgrades, patching, migrations across

databases as well as writing stored procedures, SQL tuning and writing

shell scripts to meet various functional requirements of the product. Also

possess basic knowledge in Informatica administration.

PROFESSIONAL SUMMARY

[pic]

< 6+ years of experience in Database Administration

< Responsible for providing Production (Including On-Call) and Development

support for Oracle, Sybase, DB2 and SQL Server databases

< Strong experience in installation, upgrades, Critical Patch application

and migration of various versions of databases on different platforms

< Good understanding and experience in implementation of RMAN backup and

recovery strategies

< Experience in monitoring the performance of database using performance

tools such as AWR, ADDM and advisors

< Experience in installation and configuration of Oracle 10g/11g Data

Guard, switchover and failover

< Experience in Oracle GoldenGate Replication

< Oracle 11g RAC and Grid Infrastructure Administration

< Experience in Oracle Exadata Administration

< Knowledge of and experience using tools like OEM 12c, OEM 11g grid

console, DBArtisan, Control-M

SKILL SET

[pic]

Operating System : Windows, Unix (AIX, HP-UX, Red Hat Linux,

Solaris)

Database : DB2 8.2/9.x, Oracle 9i/10g/ 11g, MS SQL

Server 2005/2008

Domain : Supply Chain Management, Finance

DB Management : OEM, DBArtisan, Ignite

Config. Mgmt. Tools : ClearCase, ClearQuest, SVN

Tools : Oracle SQL Developer, Toad, Rapid

SQL, Control-M, Informatica PowerCenter

Languages : Oracle PL/SQL, UNIX shell

scripting

Fluent in : English, Hindi, Marathi,

Konkani

EXPERIENCE [pic]

Fidelity Investments, Bangalore, India 03/2011 - 02/2014

Senior Database Administrator

Responsibilities:

. Implemented RMAN backup strategy for all databases (Incremental and

cumulative)

. Implemented Active Data Guard on Oracle 11g instances with DGMGRL

configuration

. Handled a major migration project to move databases from MS SQL Server

2008 to Oracle 11g using Microsoft Visual Studio 2008 SSIS package and

Oracle SQL Loader

. Performed cross platform migration of Oracle 11g database from AIX to

Exadata-Linux using transportable tablespaces

. Oracle RAC and Grid Infrastructure installation and administration

. Managed DB security & prepared audit documentation for compliance

. Managed data file objects including tablespaces and datafiles, object

sizing, and monitored database usage and growth

. Managed user profiles, indexes, and storage parameters

. Responsible for creating user logons and managing user accounts

. Suggested tuning solutions for SQL queries and database performance

. Upgraded all oracle databases from 10g to 11g

. Applied database security patches - CPU and PSU

. Handled communications with Oracle Corporation for technical support

. Batch job monitoring & responding to incidents

. Developed Unix shell scripts for automation and process enhancements

. Worked with a team of Oracle, Sybase, SQL Server & DB2 DBAs for

supporting critical applications for the Fidelity Pricing & Cash

Management Systems (FPCMS) unit

Manhattan Associates, Bangalore, India 09/2009 - 02/2011

Database Administrator

Responsibilities:

. Worked as DBA for the WM09-SCPP project (Warehouse Management System)

. Schema maintenance and stored procedure development

. Query tuning, development of automated scripts for DB refresh

. Evaluated impact of database patches on application

. Internal client interaction with application developers, QA, performance

engineers and business analysts

. Involved in writing white papers and present technical content to the

project team

Manhattan Associates, Bangalore, India 07/2007 - 04/2009

Database Administrator

Responsibilities:

. Worked as DBA for the WM09-SCPP project (Warehouse Management System)

. Schema maintenance and stored procedure development

. Query tuning, development of automated scripts for DB refresh

. Evaluated impact of database patches on application

. Internal client interaction with application developers, QA, performance

engineers and business analysts

. Involved in writing white papers and present technical content to the

project team

AWARDS [pic]

. "Star of the Iteration" Awards (3) at Manhattan Associates for

commendable contribution in a product development iteration

. "You Have Earned It" Awards (2) at Fidelity Investments for exemplary

performance

. "Eureka! - Kaizen" Awards (2) at Fidelity Investments for suggestion and

implementation of ideas for process improvement

CERTIFICATIONS

[pic]

. IBM 730 examination certified DB2 DBA in December 2008.

TRAININGS

[pic]

. Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Ed 3

(5 days at Oracle University, Bangalore)

. Oracle Database 12c: New Features For Administrators Ed 1 PRV (3 Days at

Oracle University, Bangalore)

. Golden Gate trainings (Internal at Fidelity Investments)

ACADEMICS

[pic]

. Bachelor of Engineering in Electronics and Telecommunication - Graduated

with Distinction from Goa College of Engineering, Goa, India in 2007

ACADEMIC PROJECTS

[pic]

Tata Consultancy Services, Goa, India 07/2006 - 06/2007

Intern

Implementation of a WiMAX (Worldwide Interoperability for Microwave Access)

base band subsystem using FPGA (Field Programmable Gate Arrays)

. Tools used: Altera's Quartus II software, Model Sim

. Language used: VHDL

PERSONAL DETAILS

[pic]

Date of Birth: 17-Aug-1986

Marital Status: Married

Contact this candidate