BENNY MICHAEL

*** ******* **,

Grand Prairie acsgsr@r.postjobfree.com

TX 75051 Mobile:214-***-****

SUMMARY OF QUALIFICATIONS

Over 6+ years of professional experience as Oracle Database Administration having good experience in database administration, database installation, upgradation, migration, installing patches, performance tuning, RAC installation and maintenance, setting up and configuring Dataguard, performing all kinds of backups and recoveries, cloning databases, replications using golden gate, auditing and product support.

Hands on experience on Oracle (9i/10g/11gR1/11gR2), installed and configured on different platforms like Windows, UNIX (RHEL 4, RHEL 5).

Experience in configuring high availability (HA) systems like Real Application Clusters (RAC) and Data Guard.

Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and up-gradations.

Experience in installation of Oracle RAC with ASM and manage RAC instance using CRSCTL and SVRCTL utility.

Experience in managing and monitoring ASM for standalone database and RAC database.

Experience in configuring, managing and monitoring database using Data Guard.

Configured and replicated databases using Oracle Golden Gate.

Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid).

Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Experience in Performance Tuning for better performance.

Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports.

Experience in SQL tuning using Explain Plans and Hints.

Expertise in Upgrading Oracle database and applying Oracle PSU and CPU patches.

Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN).

Experience in planning and scheduling the Physical (Hot/Cold) backups and Logical backups.

Created clone databases for development and test environments using RMAN as well as User managed cloning.

Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Good knowledge on Oracle support process for technical requests using Metalink and other support features.

Good written and verbal communication skills, self-motivated team player and good analytical thinking.

TECHNICAL SKILLS

Languages : SQL,PL/SQL,VB,JAVA

Packages : MS Office

RDBMS : MS Access, SQL Server, Oracle 9i,10g,11g

Platforms : MS-DOS, Windows NT/2000/XP/2003 and Red Hat Enterprise Linux RHEL : 4.x,5.x

PROFESSIONAL EXPERIENCE

Employer : Prudent Technologies Pvt.Ltd, Cochin, India

Client : Indian Oil Corporation Limited.

Role : Oracle Database Administrator from Jan 17th 2011 to 31st Jan 2015.

Responsibilities:

Planned and Implemented Disaster Recovery (DR) and HA using RAC, Golden gate and Data Guard.

Created Catalog database for monitoring backup information of backups using RMAN.

Installed and configured RAC (2 node) and RAC (3 node) using cluster ware and ASM.

Installed Golden gate for replication of database on 11gR2-Redhat-linux.

Configured parameters for replication, DDL support.

Migrated NON ASM database to ASM database.

Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.

Performed daily monitoring OEM, Managing and maintaining the host and its targets, clearing outstanding alerts, creating blackouts’ and turnover tickets to front line support (FLS)

Involved in migrating HP-Unix databases from 9i, 10g, and 11gR1 to 11gR2 Red hat-Linux

Implemented data transfer using Data Pumps and Export/Import utilities.

Performed up-gradation databases from 9i, 10g to 11g on Linux.

Configured listener and TNS names using NETCA.

Performed hot backup/cold backups for creating shadow image of the database for testing purpose on 11gR2 RAC.

Created a Clone database using RMAN on remote server and used Srvctl commands for RAC databases.

Involved in scheduling like incremental, cumulative and full backups according to retention policy using RMAN.

Involved in regular activities like creating table space, monitoring table space sizes and clearing OEM alerts.

Tuned the performance of the SQL’s using TKPROF and AWR reports.

Involved in optimizing SQL statements using Indexes and Hints.

Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

Involved in configuring Data-guard for 6 databases on 11gR1 ASM.

Being Migration project Involved in strategy plan to move data movement from production environment on 10g, 11gR1 HP-Unix to 11gR2 Red hat-Linux.

Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases.

Environment: Oracle 10g, 11g, 11gR2, HP-Unix, Linux/5, OEM, RMAN, Golden gate, Grid, RAC, ASM, Dataguard, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Employer : Technopark Chennai, India

Client : Flatparty Inc. Floral Park, NY

Role : Oracle Database Administrator from Oct 2008 to Dec 2010.

Responsibilities:

Installation and Configuration of Oracle 9i, 10g databases.

Provided 24x7 production database administration supports

Performed export imports using exp/imp, Data Pump.

Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.

Creation and resizing of database Table spaces (Space / Schema management).

Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers

Created different types of Indexes (B tree, reverse key, IOT and function based etc).

Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.

Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.

Configured Oracle Dataguard for Oracle Disaster recovery

Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.

Implemented Oracle database backup & recovery solutions using RMAN.

Restoration and Recovery of databases at the times of occurrence of critical failures

Provided partitioning of the large tables to reduce the access time.

Detecting and diagnosing production system performance by analyzing oracle trace, log files, analyzing SQL statement, measuring system and database activity.

Performed automated backups and scheduling using scripting

Written SQL, PL/SQL functions, procedures, packages and triggers.

Performed large batch jobs and tuning of SQL queries and database systems..

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.

Configured and implemented Oracle streams (Advanced Replication) for high availability.

Also migrated data from Oracle to SQL server for testing, reporting and analysis requirements.

Generated Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Involved in gathering requirements from end users.

Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: PL/SQL, Oracle 9i, 10g, SQL PLUS, PL/SQL Developer, Windows 2000.

EDUCATIONAL QUALIFICATIONS

Master of Computer Applications (MCA) from Anna University Chennai, India.

Oracle 9i and 11g Certification (OCP).

VISA STATUS

Green Card Holder.

Contact this candidate