ORACLE DBA

Anna

Email: ****@************.*** ph: 972-***-****

SUMMARY:

Having 8+ years of experience as an Oracle Database Administrator and performed different tasks like

database administration, installation, configuration, upgrades, patches, performance tuning,

backup and recovery, production support, cloning, space management, database security.

• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of

operating systems including UNIX/LINUX, Solaris and Windows environment.

• Experience in Migration Projects. Hands on experience in-updating from Oracle 9i to 10g

(10.2.0), 10g to 11g and applied oracle patches.

• Experience in Data Warehouse environment.

• Migrated databases using Golden Gate, Transportable tablespace and Datapump from 9i, 10g to

11g.

• Extensive expreice in using Korn Shell scripts for Regular backup, instance start and shutdown

and for automation

• Installed Oracle 10g RAC software with ASM & OCFS2 File systems

• Oracle RAC Database Administration including Installation, configuration, Analysis,

Design, Backup and Recovery (RMAN).

• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and

Data Warehousing using customized shell scripts and stepwise.

• Co-ordinate with UNIX administrators for space managements on various servers.

• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net

Backup, IBM TSM & LEGATO Storage Manager.

• Proficiency in Disk management and problem resolving techniques with a good understanding

of Capacity planning and efficient usage of the disk space.

• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and

procedures, data migration, data clean-up, copy data archiving, etc.

• Monitoring and management of various database components (logical & physical) like table-

spaces, segments and data files.

• Experience on Data Replication using Snapshot, Materialized views, import/export.

• Extensive performance tuning activities like Operating System Tuning, SQL Tuning,

Database/Instance Tuning.

• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,

TKPROF, STATSPACK, AWR, SQL TRACE.

• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database

Design, Backup and Recovery procedures.

• Expertise in maintaining Database Security using security compliance auditing, expertise in

loading data from flat files using external tables, SQL*LOADER.

• Have implemented ORACLE STREAMS.

• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby

Databases and also to ensure disaster recovery using various data protection modes.

• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid

Controlling using OEM

• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS

TECHNICAL SKILLS:

Operating HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL

Systems 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS Oracle 11g/10g/9i/10gRAC.

Languages SQL, PL/SQL, C, C++, C#, VB.NET, JAVA, XML, UNIX Shell Scripting.

Tools/Utilities RMAN, OEM, Oracle Management Server, SQL*Loader, Export/Import, TOAD,

Data pump, MS Access, Data Guard, Golden Gate 10.4

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR

Hardware Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP

Platforms XP256 / XP512, IBM X series Server, and various PC desktop and servers.

Contact this candidate