Sql Server Oracle

SHASHIPAL RAVU

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

512-***-****

Oracle Database Administrator

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

SUMMARY:

> Around 8 years of experience as an Oracle Database Administrator.

> Excellent experience in 24x7 production database administration,

support, installation, configuration, upgrades,database migrations,

patches, performance tuning, backup and recovery, cloning, space

management, database security & auditing.

> Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.

> Experience in OLTP/DSS database systems, managing large Oracle

databases.

> Proven experience with database performance and tuning techniques to

enhance database optimization plans.

> Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK,

AWR, ADDM.

> Experience with Oracle 11g RAC R1&R2/10gRAC R1&R2/9i/8i in Installation,

Administration, Monitoring, Database Backup and Recovery.

> Installed, configured,administered SQL Server 2005/2008.

> Migrated databases from SQL Server 2008 to Oracle 10g.

> Installed and configured ASM 11g R1&R2.

> Extensive knowledge on ASM Cluster File System.

> Installed and configured OCFS2.

> Involved in the installation of the Golden Gate.

> Replicated the data using Golden Gate.

> Achieved business continuity and high availability using Golden Gate.

> Handled Decision Support Systems using Golden Gate.

> Synchronized data changes that occur on the Source database near real

time to the target database using Golden Gate.

> Handled both Standard edition and Enterprise edition database servers.

> Proactive database monitoring using 10g Grid Control.

> Knowledge of SQL analysis tools and database internal debuggers

including ORADEBUG.

> Proficient with Database Cloning, Migration, Standby Database (Data

Guard)

> Experience in Oracle Cluster Ware environment.

> Experience in VERITAS Cluster Service (VCS).

> Involved in different scenarios of OLTP as well as DSS (Data warehouse)

databases.

> Have implemented ORACLE STREAMS and GoldenGate

> Extensive Experience with RMAN Backups, Cold Backups, Hot Backups and

Logical Backups.

> Experience in Oracle Data warehouse DBA skills relating to

administration and management of VLDB environments, Oracle OLTP.

> Experienced in using RMAN, Data pump Flash-Back Recovery and ASM.

> Knowledge of Database Recovery Techniques and implementation of those

recovery techniques to ensure business

continuity.

> Expertise in maintaining Database Security using auditing.

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

> Experience on working with Oracle E-business suite environment.

> Experience in Data Migrations.

> Experience in doing upgrades including maintenance & monitoring

implementation.

> Implemented various database solutions such as 11g RAC, 10g RAC, 9i,

Data Guard, Oracle Grid, Oracle Streams, GoldenGate.

> Experience in UNIX shell scripting, CRON jobs.

> SQL- Query optimization expertise, including data integrity analysis for

application customization testing, and creating analytical metrics.

> Possesses strong analytical and problem solving skills coupled with very

good communication and interpersonal skills.

> Extensive experience in Data Warehousing, ETL (Extraction,

Transformation, Loading)

> Excellent experience in Oracle Support processes for technical requests

through Metalink.

> Dealing with database security and auditing.

> Experience in SOX Controls, compliance reporting and audit validation.

TECHNICAL SKILLS

Operating Systems HP-UX 10.x, 11.x, VMS, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX

5.1, 5.2,6.1

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

95/98/ME/NT/2000/XP.

RDBMS Oracle 11g RAC, 10g RAC/9i/8i, MS SQL Server 2000/2005/2008,

MySQL,Sybase

Languages SQL, PL/SQL, Delphi, VC++, UNIX Shell Scripting, Perl

Tools/Utilities RMAN, OEM, SQL Plus, SQL Developer,SQL*Loader, ASM, EXP, IMP,

DataPump(expdp, impdp), TOAD, Golden Gate, ERWIN, VMware,

Informatica, Putty.

Tuning TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools

Database Erwin 4.0, Rational rose, Toad Data Modeller, ER/studio

Modeling

Other EMC, NetApp, VERITAS, NetBackup, TSM, HP Data Protector

Web Tools HTML, XML.

EDUCATION

> Bachelor of Technology from Jawaharlal Nehru Technological University.

Contact this candidate