Oracle Data Warehouse

manohar damaraju

Tel 347-***-**** (M). E-mail: **********@*****.***

1

Technically sophisticated and business-savvy Senior Oracle Database

Administration Consultant with more than 10 years of career experience

reflecting strong leadership qualifications coupled with hands-on

expertise. Maintains focus on achieving bottom-line results while

formulating advanced technology and business solutions to meet a diversity

of needs. Good team player with excellent interpersonal communication

skills.

TECHNICAL SKILLS

. Profound knowledge of Oracle server concepts and got excellent

troubleshooting skills.

. Experience in high availability solutions like Oracle RAC, Data Guard

etc and knowledge of Oracle Streams.

. Strong SQL and PL/SQL skills and possess knowledge of Shell scripting.

. Working experience with both Development DBA and Production DBA roles.

. Worked on many flavors of UNIX like Redhat Linux, IBM AIX, HP-UX,

Solaris etc as well as on Microsoft Windows environments, and possess

good knowledge of CPU, Memory and IO management and hardware and SAN

concepts.

. Oracle Certified Professional (OCP) and worked on Oracle 11g, 10g, 9i,

8i,8 and 7.3.4 versions.

. More than 10 years of experience as Oracle DBA and Developer at

various levels.

o Sound knowledge and experience in installation procedures,

migrations, patching and cloning.

o Setting up level 0 and incremental RMAN backups and BCT, knowledge

of Media management layers like HP Omniback and Legato. Worked on

different recovery scenarios.

o Extensive experience with 10g grid control, OEM and other tools like

TOAD, SQL Developer etc. Also, got experience with Quest tools TOAD,

Foglite and Spotlite.

o Good understanding and experience in working with Dataguard

databases.

o Sound knowledge of database and sql performance tuning. Worked on

tkprof, AWR, statspack and OEM tuning pack. Always try to update

myself with industry best practices.

o Setup Oracle RAC with ASM at different projects in Lunix and

Solaris. Got good understanding of setup, tuning and troubleshooting

of RAC environments.

o Good understanding of Oracle security patches, Oracle SOX

compliance, general database security setup, Fine grained access

control and knowledge of setting up database audit.

o Worked on highly concurrent OLTP databases, online index reorg and

online table redefinition.

o Knowledge of managing data warehouse databases, different methods of

partitioning, local and global indexes, bitmap indexes, data and

index segment compression, parallel query and parallel DML.

o Knowledge of star schema and dimension tables and experience with

supporting OLAP applications and ETL tools like Datastage,

Informatica.

o Understanding of multimaster replication, refresh methods,

materialized views, MV Logs and query rewrite.

o Worked with utilities export, import, data pump, SQL Loader, Log

miner etc.

o Extensively worked on PL/SQL programming. Implemented stored

procedures, triggers and was involved in application design and

development. Got working experience on PL/SQL collections, bulk

collect, autonomous transactions etc. Worked on several Oracle

supplied packages.

o Got good understanding of advanced sql features like analytic SQL,

cube and rollup operations etc.

o Basic understanding of Oracle HTML DB.

. Knowledge in basics of Oracle Apps database administration.

. Good knowledge of Data Modeling and got working experience with Erwin.

. Got working experience with tools like Remedy, Autosys, Jobtrac, PVCS

etc.

. Exposure to Perl and shell scripting using Bourne Shell and Korn shell

(KSH).

PROFESSIONAL EXPERIENCE

Active Health Mgmt. Data Warehouse Implementation and Maintenance, New

York, NY. Sep 2008 - Till date.

Role: Senior DBA

ActiveHealth Management, a wholly owner subsidiary of Aetna Inc., is a

leading provider of health management services, including disease

management, clinical decision support and personal health records. The

project involves enhancements, maintenance and production support of their

Data Warehouse database.

. Work on all aspects of their data warehouse database running on 4 node

Linux RAC.

. Provide oncall support to all the Oracle databases and applications.

. Colloborate with the development team in understanding the Informatica

transformations and worked on performance tuning the same.

. Perform application performance tuning like setting up for parallelism

where ever possible, parallel DML and evaluating right index

strategies, bitmap indexes etc.

. Discussed with development team, the advantages of Analytic SQL and

implemented the same extensively in their reporting modules.

. Involved in setup of snapshot replication for a couple of modules and

maintain our replication environment.

. Troubleshoot long running queries and reports.

Amazon.com, Forecast and Merchandising Systems project, Seattle.

Oct 2006 - Aug 2008.

Role: Senior Database Administrator

Amazon.com, a Fortune 500 company based in Seattle, Washington, is the

global leader in e-commerce. Project involves creating, maintaining and

monitoring every aspect of their retail and forecast system databases.

There are at least 50 production databases most of which are OLTP and a few

DSS systems all running on RedHat Linux.

. Work involved maintaining, monitoring and performance tuning of large

scale massively concurrent OLTP databases. The databases were

primarily running on 10g with a few databases upgraded to 11g.

. Ability to quickly respond to and act on complex database scenarios.

. Worked with development teams in design and development of new

modules, worked with Erwin to maintain data models, work with change

management tools etc.

. Coded extensions to our generic partition maintenance program in

pl/sql to handle multi column partition keys, subpartitions, data

segment compression etc.

. Implemented streams replication to replicate data from procurement

module to the data warehouse. Setup change data capture, setup rules

and made transformations and applied to the data warehouse database.

Worked on automating the administration and monitoring of the same.

. Developed and maintained scripts and standards for our group of

approximately 50 production databases.

. Configuring databases for high availability and massive horizontal

scaling. The architecture enables us to build and seamlessly deploy

new databases and perform migrations with quick turnaround time and

minimal down time. We have setup DataGuard and MultiMaster Replication

for different databases based on the requirements of the applications.

. Worked on 4 node Linux RAC with ASM for our pricing database. Worked

configuration, setting up monitoring scripts, RMAN backups,

troubleshooting and performance tuning.

. Worked on setting up connection time load balancing and transparent

application failover. Setup services for instance affinity and manage

load on the database instances.

. Worked on troubleshooting issues with interconnect, monitoring

performance bottlenecks, RAC wait events etc.

. Tested backup efficiency and implemented Block change tracking (BCT)

in some databases.

. Providing on call support for our databases and applications.

Woolworths Limited, Architecture and Competency Group, Sydney, Australia.

May 2003 - Jan 2006.

Role: Senior Oracle DBA and Module Leader

. Member of a team of 8, maintaining and monitoring more than 150 Oracle

databases running on HP-UX and Microsoft Windows.

. Maintaining both OLTP and DSS databases and on UNIX (HP-UX 11,11i) and

Windows platforms.

. Conducted Performance, Scalability and Reliability (PSR) tests on some

products to ensure that the applications would scale to the required

volumes in stipulated batch processing times.

. Worked on HP Omniback Media management software with Oracle RMAN for

database backups.

. Working on Disaster Recovery project to setup databases in EMC SRDF

replication and usage of BCVs for quick and reliable backups.

. Experience in capacity planning, system and database resource

estimates.

. Received many appreciation letters from clients for my works in PSR

testing.

GE Power Systems, Parts ERP project, Atlanta, GA.

Apr 2001 - Mar 2003.

Role: Apps Developer

. Developed PL/SQL code to transfer data from GEPS Parts ERP database to

their Data Warehouse. The majority of work involved extraction and

transformation of source data using PL/SQL and then send feeds or load

it to the data warehouse database. Worked on Solaris and Wondows

environments.

. Worked in the project from design, testing to production maintenance

phases of the project.

. Worked on Erwin to create logical and physical models and create

entity relationship diagrams.

. My work mainly involved Order Management, Warehouse and Shipping

modules of Oracle Apps version 10.2. Developed a good understanding

of these modules, schema and Oracle Apps tech stack.

. Followed Quality procedures and worked on Technical documentation for

my modules.

. Worked with PVCS version control software and Kintana Object migrator

for Oracle Apps.

. Lead a team of 5 people at offshore and facilitated coordination

between offshore and onsite in Atlanta.

Oracle Consultancy Group.

Sep 1999 - Jan 2001.

Role: Oracle Technical Support Consultant

. TCS is a reseller of Oracle products in India. My work involved

supporting our customers with installations, migrations,

troubleshooting and performance tuning.

. Performed installations of many different Oracle products and

developed good understanding of Oracle products and Oracle database

lifecycle on most unix platforms including IBM-AIX and SGI-Irix.

. Configured many high availability solutions like Oracle Parallel

server and Oracle Standby database.

. Gained knowledge on PL/SQL and shell scripting.

. Successfully performed media recovery for some of our customers.

EDUCATION : Bachelor of Science - Computer Science and Systems Engineering

Oracle Certified Professional [pic]

Contact this candidate