Oracle Supply Chain
Resume:
Pooja Anand Bhat
Home: ***** ********* ****** #***, *****, Florida 33647, USA Cell phone:
813-***-**** Email: ***********@*****.***
[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