Resume

Sign in

Manager Oracle

Location:
Hyderabad, Telangana, India
Salary:
3lac/A
Posted:
October 26, 2016

Contact this candidate

K SRAVAN KUMAR

Mobile No: +** 868*******, 738*******

E-mail: acw8o7@r.postjobfree.com

Professional Profile:

Oracle Professional with 2 Years of experience in Oracle DBA with proficiency in, Golden gate, Non-RAC,RAC,RMAN and Dataguard.

Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transitive and Very large databases (VLDB).

Experience in configuring and managing Oracle Real Application Cluster databases with ASM technology.

Installed and Configured the Golden Gate software and created manager, extract, replicate trail files and tested the data is flowing from source to target database.

Technical expertise in Oracle DB implementations, maintenance, trouble shooting and administration.

Experience upgrading Oracle databases from 9iR2 to 10gR2, 9iR2 to 11gR2 and 10gR2 to 11gR2

[11.2.0.2.2] on RHEL, AIX and Solaris 10 SPARC 64-bit systems

Implementation and Administration of Oracle Dataguard.

Configuring and Administering Oracle 10g Automatic Storage Management (ASM).

Working knowledge in Oracle GRID controls (Oracle Enterprise Manager).

Experience in applying Oracle PS, CPU Patches on 9i, 10G and 11G.

Experience in Patching Grid Infrastructure home.

Experience in Installing, Configure and maintained 2 Node 11g RAC/Non-RAC with ASM development databases.

Experience in monitoring table spaces, indexes, extents and performance tuning.

Exposure of working on OEM and Strong in Database Backups using RMAN, Export/Import, and Data pump, SQL Loader, etc..

Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle11g features in these utilities.

Hands on experience managing SAP database using SAP tools.

Strong Experience in Cloning of databases using RMAN, VERITAS Net Backup.

Excellent Knowledge on Oracle Support processes for technical requests with Metalink.

Good working Knowledge of SQL and PL/SQL

Technical Skills:

Operating Systems

RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10, HP-UX Itanium, IBM AIX, Windows XP.

RDBMS

Oracle 11g/10g/9i, Oracle 10g Real Application Cluster (RAC), ASM,Microsoft SQL Server 2005,2008.

Oracle Products

OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, Import and Export (EXPdp/IMPdp), ASM, TKPROF, SRVCTL,DBCA,DBUA

Languages

C,C++, SQL,T-SQL,PL/SQL, Java, UNIX/NT Shell Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Other Tools

TOAD, Putty, SQL Developer, Blade logic BMC Database

automation tool, Data Modelling Tools, Erwin,Fog light Monitoring System, Net-backup

Management system, GRD Ticketing System, Nexus ticketing System.

Professional Experience

Yasmeen Educational Society, Warangal Aug 2013 – Present

Oracle - Database Administrator

Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g

Installed, Configure and maintained 2 Node 11g RAC/Non-RAC with ASM development databases.

Upgrading Oracle Database from 11.2.0.2.0 to 11.2.0.3.0.

Ensuring SLA timings by taking and restoring backups from PROD to TEST.

Partitioning of large tables for fine performance tuning.

Implemented Data Guard on oracle 11g R2 on Linux.

Scheduling RMAN Database backups on Linux Server.

Upgraded development databases from 10.2.0.5 to 11.2.0.3.

Scheduling RMAN backup jobs from Oracle Enterprise Manager.

Had played the supervisory role to the offshore team for a brief period of time.

Configured and maintained replication using Oracle Golden Gate.

Performed a zero downtime cross platform database upgrade using Oracle Golden Gate.

Monitoring Goldengate process and working on issues.

Performing Failover operations/Disaster Recovery in Data Guard Environment.

Used OEM extensively and set up Rules for alert notification and schedule RMAN backups with failure notification.

Wrote shell scripts for purging trace files, alert log and network log files in Sun Solaris boxes which is used as standard script across all the databases.

Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.

Environment: Oracle 9i, 10g/11g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Fog light tool, OEM.

Education:

Bachelors of Engineering from JNTU



Contact this candidate