Oracle Sql

BHARGAVA

abhofw@r.postjobfree.com

512-***-****

Oracle Database

Administration

Note: Available Immediately *** ONLY FOR A CONTRACT POSITION ***

Professional Summary:

. Over 7+ years of experience in Oracle Database Administration, Systems

Analysis, Design

Development, Implementation and Testing of Relational Database Management

systems for Business solutions and experience in Application, database

development and 24x7 production system support.

. Dealing with large databases using Oracle 11g RAC, 10g RAC, 9i, 8i, 7.x

on various platforms and which includes UNIX (HP-UX, Sun Solaris, IBM

AIX)/LINUX and Windows environments.

. Installed/configured Oracle 11g/10g Real Application Clusters (RAC).

. Upgraded databases from Oracle 8i, 9i to 10g and Oracle 10g to 11g.

. Expertise in configuration and administration of Data Guard

(Physical/Logical standby Databases).

. Installed and administered OEM Grid.

. Excellent experience with conventional Hot/Cold Backups and Recovery.

. Cloning of databases using manual method and RMAN.

. Extensive performance monitoring and tuning experience using STATSPACK,

TKPROF, SQL Trace,

Explain Plan, AWR, ADDM (Memory Tuning, I/O Tuning, Tuning

Contentions).

. Exposure in using 10g features ASM, Data Pump, AWR, ADDM, Export/Import,

SQL*Loader,

OEM Grid Control, Flash Back Recovery and RMAN.

. Proactive monitoring, identifying areas that need to be improved in the

application and database.

. Management of schemas, objects and partitioning the tables & indexes.

. Experience with Data Modeling, Logical and Physical database design.

. Excellent experience in managing Very Large Databases (VLDB).

. Experience in replication using Materialized Views, Oracle Streams and

GoldenGate.

. Creation of database with the complete understanding of hardware

configuration to provide maximum performance and high availability.

. Extensive experience in designing, tuning and managing physical and

logical database design.

. Proficient in writing SQL, PL/SQL programs and Shell Scripting.

. Good working knowledge on RAC environment and Grid Computing.

. Good Exposure in translating business requirements into creation of

database objects: tables, indexes, constraints, packages, Triggers,

stored procedures and functions using Oracle tools.

. Strong analytical and problem solving skills with ability to work within

team environment and independently when needed.

. Knowledge in Oracle Support processes for technical requests with

Metalink.

. Ability to function successfully in a highly stressful, 24x7 mission

critical environment.

. Excellent client facing abilities, a great team player with good

leadership qualities.

. Possess excellent oral/written communication and interpersonal skills.

Educational Qualification

. Bachelor of Technology.

Technical Summary

Operating HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,

Systems 5.3, RHEL 3.x, 4.x, 5.x and Windows 95/98/ME/NT/2003/XP

RDBMS Oracle 11g/10g/9i/8i, Oracle 10g RAC/Oracle 11g RAC

Languages C, C++, SQL, PL/SQL, UNIX Shell Scripting,

Software RMAN, OEM, SQL*Loader, SQL Server, TOAD, Oracle Warehouse

Builder, OEM Grid Control, ASM, exp/imp, DataPump,

GoldenGate

Tuning Tools EXPLAIN PLAN, STATSPACK, SQL TRACE, TKPROF, AWR

Database Rational Rose, Erwin4.0, Smart draw, Power Designer

Modeling

Professional Experience:

Contact this candidate