PRATHAPANENI PREMA

adjeud@r.postjobfree.com

+91-970*******

Synopsis

2years of experience as an Oracle database administrator and 6 Months of experience in NON-IT, providing 24X7 production and development, supporting 12c.

Proficient in database administration, production support, installation, configuration, backup and recovery, cloning, space management, database security, basic performance tuning and troubleshooting.

Co-ordinated and participated on bridge calls on various occasions.

Creating users, assigning privileges, roles, quotas, profiles to users and good experience in tablespace Management.

Performing logical backups using Export/Import and Expdp/Impdp utilities.

Experience on database backup and recovery using RMAN.

Experience with ASM (Automatic Storage Management) for standalone and RAC databases

Expertise in RDBMS Tools like Import/Export, Data Pump, RMAN and OEM Grid Control.

Co-ordinate with UNIX administrators and storage admins for space management and TSM related issues.

Communicated and interfaced with Oracle support via My Oracle Support (previously Metalink) to troubleshoot some critical issues.

A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

Core Competencies

Technical

Operating System : Unix.

Oracle DBA Skills : Oracle 12c

Oracle Utilities : RMAN, Dataguard.

Oracle Tools : Putty

Process : Change management, Incident management, Problem

management.

Work Experience

Company : CTS (from July 2018)

Job profile : DBA Prod Support

Project : Kaiser Permanente (US Healthcare Company)

RESPONSIBILITIES:

Supporting project using Service now tool, handling Incident, Problem and Change Management process, Documenting, reviewing and approvals of the database change at various levels. .

Performed regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles, and Roles.

Monitoring of blockings in databases and taken appropriate action by coordinating with Application team.

Monitoring and managing the listeners and creating environment.

Managing the Datafile, Control file, Redolog file, Table spaces and so on.

Good in implementation of Creating Database links for Testing and Development team.

Attending tablespace, file system, backup and archive alerts.

Set up database users, manage database permissions and setup database roles, and enable database auditing for database security.

Database migrations/cloning from one server to another server.

Resolving the GAP issues in dataguard physical standby database.

Performed planned physical data guard switchover.

Experience in monitoring databases using Oracle enterprise management (OEM) tool and grid control

Killing blocking sessions upon application team confirmation.

Developing and implementing database backup and recovery plans, maintaining space in File Systems and Tablespaces, Maintaining Undo and temp tablespaces. Monitoring alert log, memory usage, disk I/O, CPU, database network connectivity etc.

Having knowledge on Restored tables to point-in-time using RMAN and EXP

Registering and unregistering databases in catalog database.

Supporting Unix team during OS LEVEL maintenance activity.

Configured ASM disk groups and added disks to existing diskgroups and rebalancing disks.

experience with OEM. Adding targets in OEM and monitoring performance in OEM.

Deploying application codes on test and development databases subsequently in Production database.

Troubleshoot Oracle connectivity problems.

Academia

Course

Institution

Board/

University

Year of Completion

Percentage B.SC.,

Statistics

SreeVidyanikethan Degree College, Tirupathi.

S.V.University

2015-18

85

Intermediate

(MEC)

Master Minds College, Tirupathi.

Board of Intermediate Education

2013-15

87

SSC

SreeVidyanikethan EM High School,Tirupathi

Board of Secondary Education

2013

9.5

(GPA)

Personal Dossier

Languages Known : English,Telugu

Address : #8-307/B, Satya Narayana Puram,Jeevakona,Tirupathi-517501

Andhra Pradesh

Hobbies : Playing Shuttle.

Declaration

I, Prathapaneniprema do hereby confirm that the information given above is true to the best of my knowledge.

Date:

Place:

(P. PREMA)

Contact this candidate