RAGHAV
*******.***@*****.***
Oracle DBA
Note: Available Immediately *** ONLY FOR A CONTRACT POSITION
***
SUMMARY:
. Over 8 years of experience as an Oracle Database Administrator having
hands on experience in database administration, production support,
installation, configuration, upgrades, patches, performance tuning,
backup and recovery, cloning, space management, database security,
auditing, troubleshooting, database design, TAR support, Unix shell
scripting and documentation
. Experience in OLTP/DW database systems, managing large Oracle databases
VLDB.
. Worked as a team member to provide 24x7on-call production database
support.
. Oracle Database Administration experience in variety of different
environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
. Skilled in Oracle Data ware House Tool CDC(Change Data Capture)
. Worked with Oracle Databases (10g/9i/8i,8,7) on Unix/Linux/Windows
platforms.
. Planned and implemented DR & high availability solutions using Oracle 11g
RAC & 10g RAC, Standby Database (Oracle Data Guard).
. Knowledge of database recovery techniques and implementation of those
recovery techniques to ensure business continuity.
. Experienced in using Automatic Workload Repository (AWR).
. Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of
databases using RMAN and manual methods
. Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid
Monitoring, Recycle Bin
. Good experience in Oracle Streams, Golden Gate.
. Extensive performance tuning experience, specializing in Operating System
Tuning, SQL Tuning, Database/Instance Tuning
. Delivering Oracle Database performance-tuning services for customers with
EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM Grid Monitoring
custom scripts troubleshooting oracle databases using sqltrace utilities.
. Experience in Upgrading databases, applying patches.
. Knowledge on Oracle Support processes for technical requests through
Metalink and other Support Procedures
. Experience is Capacity Planning and Benchmarking.
. Proactive Monitoring, identifying areas that need to be improved in the
application and database using Statspack, AWR, ADDM and OEM Grid
Monitoring
. Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data
modeling, OLAP, Logical and Physical Database Design, Backup and Recovery
procedures.
. Experience in basic and advanced replication using Oracle Streams and
experience in using OEM, TOAD, Data Migrations using export/import,
benchmarking using load testing tools
. Expertise in maintaining Database Security using security compliance
auditing, expertise in loading data from flat files using external
tables, SQL*LOADER.
. Proven ability to adapt to demanding schedules and changing priorities
and ability to function successfully in a highly stressful and critical
environment.
. Strong analytical and problem solving skills with ability to work within
team environment and independently when needed.
TECHNICAL SKILLS:
. RDBMS :Oracle 11g /10g RAC/9i
. Operating Systems :HP-UX, Sun Solaris, IBM AIX, Linux and Windows
. Languages :SQL, PL/SQL, Java, C, UNIX Shell Scripting,.NET
Technologies
. Tools :OEM, RMAN, SQL*Loader, EXP, IMP, Data Pump, Erwin,
TOAD
. Tuning :TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
. ETL :Informatica 5.1, External Tables
. Other : Oracle Streams, Golden Gate, EMC, NetApp, Veritas
NetBackup, TSM, HP OmniBack, Data ware House.
EDUCATION:
Bachelor of Technology in Electrical and Electronics Engineering
EXPERIENCE: