Oracle Manager

Pattan Althaf

Oracle DBA

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

609-***-****

Professional Summary:

3+ years of involvement in Oracle Database Administration, having selective involvement in database administration, installation, configuration and upgrades with Oracle Software 12C/11G/10G on Sun Solaris, Red Hat Linux, AIX, and Windows Platform.

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Exposure to Real Application Cluster (RAC) environment with Grid Infrastructure and Auto Storage Management (ASM) on Oracle 10g/11g.

Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup

Good knowledge on GoldenGate.

Basic knowledge on Exadata.

Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.

Good exposure in Oracle Enterprise Manager (OEM), Grid Control.

Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on RHEL.

Skilled in day-to-day DBA activities including schema management, user management, space management (table space, rollback segment), scheduling jobs, UNIX Shell Scripting.

Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases

Education:

Masters of Science – Electrical and Electronics Engineering

Fairleigh Dickinson University

2015-2017

Teaneck, NJ

Bachelors of Science – Electrical and Electronics Engineering

P.V.P. Siddhartha Institute of Technology

2010-2014

Vijayawada, India

Technical Skills:

Databases

Oracle 9i/10g/11g/12c

DB Management Tools

Oracle Enterprise Manager, RAC, Data Guard, RMAN, Export/Import, Data Pump, SQL*Loader, Statspack, ADDM, Oracle Scheduler, OAM, Shell Script, AWR, ASH, Toad, Cron jobs

Operating System

MS DOS, Windows 98/NT/2000, Red Hat Enterprise Linux, Sun Solaris, IBM AIX, UNIX

Languages

C, C++, Core Java, SQL, PL/SQL, UNIX Shell Scripting

Experience:

System Administrator

F.D.U

Aug’15-April’16

NJ, U.S.A

Worked on new 12C release and all other releases 10g and 11g.

Involved in the installation of 11g-r2 RAC on LINUX environment

Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

Build/Repair Standby databases/Data Guard using RMAN restore and duplicate command.

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Perform Oracle performance tuning and monitoring using Oracle OEM/AWR/Quest tools.

Trained in using GoldenGate and Exadata.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Created and managed users, roles, privileges, profiles, schemas using OEM

Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

Ensuring physical backups are complete on a regularly scheduled basis and performing recovery of the database as required.

Environment: Oracle 12C,11g-R2,10g, Exadata, GoldenGate, OEM, TOAD, HP -UX 11.23, Linux 4.0, Streams, ASM, Business Objects

Software Developer

Agile Technologies

May’14-Jan’15

Hyderabad, India

Installed/Configured 10g/11gR2 RAC and ASM on Linux and migrated Oracle databases into RAC environment.

Migrated Oracle 10gR2 (10.2.0.3 and 10.2.0.5) databases running on Red Hat Enterprise Linux 5 to Oracle 11gR2 (11.2.0.3) running on Red Hat Enterprise Linux6.

Installed Oracle 10g and 11g RAC database on Sun Solaris and utilized ASM as shared storage

Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Experience in maintaining Oracle Data Guard & Standby Database and providing critical Solution with strategic disaster recovery plans with different recovery procedures and methods.

Setup Oracle Enterprise Monitor (OEM), applying templates for thresholds, working on alerts and clearing them.

SQL and PL/SQL Performance Tuning: Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER) and Auto trace.

Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup

Environment: ORACLE 10g,11g OEM, RMAN, RAC, Streams, ASM, PL/SQL, RHEL, Solaris, Windows, SQL *PLUS, TOAD.

Junior Database Administrator

P.V.P. Siddhartha Institute of Technology

May’13-April’14

Vijayawada, India

Worked as Junior Database Administrator.

Installed Oracle 10g and 11g RAC database on Sun Solaris and utilized ASM as shared storage.

Refreshed schema level and full level production to non-production databases using both RMAN and EXP/IMP and Datapump.

Tuning the database by generating STATSPACK report, and improving the query performance by using EXPLAIN PLAN, SQL TRACE and TKPROF.

Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog and implemented Oracle database backup and recovery strategies using RMAN.

Cloned database and schemas using Data pump for 10g and 11g versions.

Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.

Created tablespaces, tables, and users for custom applications. Worked on Table Partitioning.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer.

Contact this candidate