BALAJI KARUMANCHI

abhylr@r.postjobfree.com

512-***-****

Senior Oracle DBA

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

PROFESSIONAL SUMMARY:

Over 8 years of IT experience as Senior Oracle Database Administration

(Oracle 11g RAC, 10g RAC, 9i,8i) on a variety of UNIX (Solaris, HP-UX,

AIX), LINUX, Windows NT 4.0/2000/2003

. Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT,

LINUX and migration of oracle server from 7.3.4,8 to 8i, 8i to 9i and 9i

to 10g, 9i to 11g, 10g to 11g applied oracle patches.

. Installation, maintenance and tuning of Oracle 10g RAC, Oracle 11g RAC

Applications. Used rapid install and other Oracle Application maintenance

utilities like OEM.

. Created development, testing, staging, production, RAC and standby

databases for OLTP, DSS and Data Warehousing using customized shell

scripts and stepwise.

. 24*7 production database support with Support to developers & end-users.

. Have implemented ORACLE STREAMS, and two type of standby databases

supported by DATAGUARD, logical standby and physical standby databases

. Having hands on experience in Hot/Cold Backup, Recovery and Cloning of

databases using RMAN.

. Logical and physical modeling using Erwin.

. Implemented RMAN backup (Full, incremental and cumulative) and recovery,

Incomplete recovery and disaster recovery using Standby database (Data

Guard).

. Implemented automated backup strategy using the UNIX shell script CRON

UTILITY

. Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts &

implemented by Using CRONJOB for Day - to - Day activities.)

. Performance tuning of the database - SQL Tuning, Used Tuning utilities

like STATSPACK, SQL Trace, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of

SGA, Distribution of disk I/O, Sizing of tables and indexes.

. Performance Tuning i.e. tuning applications, shared pool, I/O

distribution, rollback segments, buffer cache, redo mechanisms

. Installation and Configuration of Oracle Grid Control.

. Strong knowledge of Data Warehousing methodologies and concepts,

including star schemas, snowflakes, ETL processes, dimensional modeling

and reporting tools.

. Extensive experience with designing and implementing Oracle databases,

data warehouse design, implementation and tuning.

. Capacity planning and bench marking

. Data loading using SQL*LOADER, External Tables, Logical backups using

DATAPUMP.

. Database replication using snapshots, materialized views and advanced

replication methods.

. Worked on different types of storage structures (SAN/NAS).

. Good co-ordination and communication with system administrators, business

data analysts and development teams.

. Proven ability to work effectively in a team environment and capable of

learning new technology and adapt to a new environment quickly.

. Strong analytical, problem solving & Communication Skills

EDUCATION

. Master's in Computer science

. B. Tech (IT)

TECHNICAL ENVIRONMENT:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, IBM AIX 5.1,

5.2,5.3, Red Hat Linux RHEL 3.x, 4.x, 5.x and Windows

95/98/NT/2000/XP.

RDBMS: Oracle 11g RAC/10g RAC/9i/8.x/7.x, SQLServer2005

LANGUAGES: SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting.

SOFTWARE Recovery Manager (RMAN), Real Applications Cluster (RAC),

APPLICATIONS/ TOOLS: STATSPACK, AWR, ADDM, ERWIN, Teradata, Clusters, Veritas

Backup, Developer 2000, SQL*Loader, exp/imp, Datapump,

TOAD, Oracle Enterprise Manager/Grid Control, Goldengate

WEB TOOLS HTML, XML

PROFESSIONAL EXPERIENCE:

[pic][pic]

Contact this candidate