Oracle Data

Sree Infotech LLC

*****@************.***

972-***-**** Extn 114 DEEPAK

Professional Summary

Eight years of experience in the Information Technology field as Oracle Database Administrator having

hands on experience in database administration, development, production support, installation,

configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management,

database security on various environment like Sun Solaris, RHEL, HP-UX, AIX, LINUX and Windows.

• Extensive knowledge on database administration for Oracle 11g RAC/10g RAC/9i/8i.

• Experience in Configuring Single Instance, Oracle Real Application Clusters( RAC) and

Automatic Storage Management(ASM).

• Expert in backup/recovery, installation, configuration, apply patches, troubleshooting,

performance monitoring, cloning, upgrading and migration of oracle software and tools.

• Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g RAC /9i.

• Solid experience in Oracle Recovery Manager ( RMAN), and standby database using Data

Guard.

• Expertise in the database infrastructure design which also include Real Applications Clusters

(RAC), Standby Databases (Data Guard).

• Data transferring with export/import utilities and Data Pump and SQL* Loader.

• Good experience in SQL, PL/SQL Programming (Functions, procedures, packages and

triggers).

• Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed

problems and implement corrective actions.

• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL*Net.

• Experience working with Oracle Data Integrator (ODI).

• Maintained large production as well as development/test/stage databases which involve Data

warehousing and OLTP applications.

• Hands on experience in build and Design of Databases for Oracle 10g and 11g.

• Installation of various SOA features like Encryption, SSO, Secure Socket Layer, Data

Integration.

• Proficient with OEM, Erwin, SQL Developer, RMAN and Toad.

• Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export, Auditing, RMAN

• Experience in implementing Oracle Streams and in installation and administration of

GoldenGate.

• Experience in Capacity Planning and Bench Marking.

• Experience in all facets of the systems development lifecycle, from requirement development,

architecture design, testing, and post implementation revisions.

• Experience in working with Big Data Appliance with Oracle Exadata Machines.

• Capable of working under pressure and stiff deadlines with 24/7 Database support.

• Experience in analyzing, translating business requirements to technical requirements and

architecture.

• Experienced in performance tuning of various aspects of the database by using oracle utilities like

TKPROF, EXPLAIN PLAN, STATS PACK, SQL_TRACE, TOAD and Automatic Database

Diagnostic Monitor (ADDM).

TECHNICAL SKILLS

Databases : Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i, 7.x, Server 2012/2008/2005, IBM

DB2.

Operating Systems : HP-UX, Sun Solaris, AIX, Linux and Windows.

Languages : SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools : RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB

Artisan.

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM Grid Control

ETL Tools : Informatica 5.1, Data pump.

Other : EMC, Net App, VERITAS

EDUCATION

Bachelor of Engineering, OU, Hyderabad

Contact this candidate