Manager Data

M.Sreenivasa Raju

Email:*.************@*****.***

Phone: +91-929*******

Professional Summary

Around 3 years of professional experience in providing Oracle Database Administration support.

Technical Summary

Experience with supporting the Production 11g & 12c Standalone,RAC databases with complete lifecycle including Installations, Patching, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.

Having Experience on database creation using DBCA method and Manual method.

Experience in Configuring and managing backups through RMAN utility.

Scheduling and creating scripts for archive log gap and RMAN backups in crontab.

Creating and monitoring the table spaces, allocating table spaces for users.

Experience in decommissioning of the databases.

AppliedPSU patches and Bug patches using OPatch and OPatch Auto utilities.

Performed database upgradation from 11gR2 to 12c.

Having Experience in schema refresh and Database refresh using Logical backups. Preforms Table refreshes and schema refreshes using Datapump.

Generating AWR, ADDM & ASH Reports to monitor the performance of the database.

Experience on Automatic Storage Management (ASM) and knowledge on Migrating the database from

Non-ASM to ASM.

Experience in configuring high-availability using DATA GUARD with Physical Standby for both Standalone & RAC databases.

Implementation of backup methodologies and disaster recovery strategies for production databases, testing of multiple Switchover on test databases using DGMGRL and converting Physical standby to snapshot standby, Flashback Database during actual DR drills.

Troubleshooting the Standby database issues like archive log gap between primary & standby (Gap

Resolution), missing of data files at standby side, applied logs with delay.

Resolving database issues/alerts from Oracle Enterprise Manager (OEM) on daily basis and observation

regarding space management providing solutions to have database healthy and running.

Having good understanding of Oracle RAC Architecture.

Performed Cloning of NON-RAC to RAC using RCONFIG Utility.

Involved in Rolling Patch and Non-Rolling Patch (During Non-business hours) for 4-node RAC using Opatch and Opatch Auto.

Having an knowledge on Home Cloning.

Supported all kinds of SAN Storage Array Migrations Lift & Shift, Addition of storage on to the database servers.

Troubleshooting the cluster database using command line utilities CRSCTL and SRVCTL.

Knowledge on OCR (OLR) and VOTING (GPNP) disks.

Gathering stats for schema and table on regular basis.

Knowledge in Golden gate architecture.

Knowledge in AWS and EC2 databases.

Knowledge on Creating and Using Tables, Views, Inline Views, Synonyms, Sequences, Indexes, Materialized Views and writing SQL queries, Joins, Indexes, Views and Sub Queries

Provide support on 24x7 shift rotation basis and monitor trouble ticket queues to attend user and customer calls

Educational Qualifications

Master of Computer Application (MCA) from S.K University in the year 2017.

Technical Skills

Operating Systems : RHEL 6/7, Sun Solaris 9, 10.

RDBMS : Oracle10g, 11gR1/R2, 12c

Tuning Tools : TKPROF, EXPLAIN PLAN, AWR, ADDM

Oracle Tools & Utilities : RMAN, EXP/IMP, Data pump, OEM

MAA : RAC, ASM, Flashback, Dataguard

Professional Summary

Client : General Electric (Corporate & Health care).

Company : Genpact.

Duration : March 2018 –Till date.

Role : Oracle Database Administrator

Project summary

General Electric Company (GE) is an American multinational conglomerate incorporated in New York City and headquartered in Boston. As of 2018, the company operates through the following segments: aviation, healthcare, power, renewable energy, digital industry, additive manufacturing, venture capital and finance and lighting.

Responsibilities

Creation of database users by setting the default tablespaces, assigning quotas, roles,privileges and profiles.

Applied PSU patches every quarter recommended by Oracle on Standalone and RAC databases.

Refresh the database, Schema using EXPDP/IMPDP from production to development database for further testing purposes.

Troubleshooting database issues like Table space Utilization, Temp & Undo Table spaces.

Resolving archive log gap between Primary and Standby databases using RMAN incremental backup and Managing Media Recovery process, Network failures and Configuration issues.

Involved in OS Patching for performing the activities related to the Databases.

Implementation of Backup and Recovery Strategies using RMAN.

Troubleshoot and resolved log gap in Data Guard Configuration.

Monitoring the ASM disk groups by adding, removing the disks to the Disk groups.

Scheduling and creating scripts for archive log, RMAN backups using CRONTAB and OEM.

Raising SR to Oracle Support for various Internal ORA errors, bugs and issues.

Handling experience on checking the locks, inactive sessions and took appropriate actions to kill inactive sessions, long running jobs and high CPU utilization situations.

Scheduling housekeeping scripts for trace and archive log files.

Operational excellence check on daily basis.

Checking of Alert log and Trace files to monitor the database on a daily basis.

Configuring and maintaining tnsnames.ora, listener.ora and sqlnet.ora files.

Worked with Oracle Support during ORA-600 and ORA-7445 issues

Environment: RAC on Linux 6/7 & Oracle 11.2.0.4,12.1.0.2 Sun OS 5.9, EXPDP, IMPDP, RMAN, Dataguard, Flashback, ASM.

Contact this candidate