Resume

Sign in

Management Oracle

Location:
Hyderabad, Telangana, India
Posted:
May 18, 2018

Contact this candidate

Resume:

Mobile: +91-996*******

SEELAM LAVANYA Email: ac5h75@r.postjobfree.com

Oracle Database Administrator having 1.6 years of experience in Production, Non production and Development databases.

Objective:

In quest of challenging position in a reputed Organization where I can utilize my skills and leverage every opportunity that comes to my way to meet the desired targets and deadlines in a highly committed and dedicated environment. PROFESSIONAL SUMMARY

Experience in managing databases under various environments.

Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).

Backup & Recovery: Configuring the database archiving mode, taking hot, cold or logical backups, incomplete or complete recovery using user managed backups (RMAN, imp/exp, and data pump utilities).

Up-gradation of database from one version to another version.

Excellent knowledge of oracle10g and 11g architecture and administration, good understanding of new features.

Basic analysis on AWR reports for performance issues.

Experience in Applying patches on databases (Prod and Non Prod).

Monitoring space, wait events, locks and long operations running on the database WORK EXPERIENCE:

Working as an Oracle DBA in IBM India Pvt. Ltd. Hyderabad Sept-16 – Till Date. TECHNICAL SKILLS:

Database : Oracle (12c, 11g, 10g, 9i)

Tools : Putty, winscp

Languages : SQL, C, JAVA, HTML

Operating System : Linux, Windows

Oracle Utilities : Export & Import, RMAN, Expdp & Impdp. EDUCATIONAL QUALIFICATIONS:

BTech (CSE) from JNTU HYD in 2016 with an aggregate of 75%. PROJECT SUMMARY:

Title : Oracle Database Administrator.

Client : State Street Corporation

Environment : Linux, Windows, Oracle 11g.

Duration : Sept'16 to Till Date

ROLES AND RESPONSIBILITIES:

Currently providing 24/7 support to Production database.

Installation Oracle on Linux /Unix OS Server, Database creation.

Monitored the all Databases Production/Development/Test and troubleshoot the alerts like Archive error, Space Management, Backup failures, Job Failures, ORA errors, etc.

Maintain the User management and table space management

Monitoring the alert log file.

Bouncing database activities and listener configuration.

Verifying scheduled user managed & rman backups.

Managing logical and physical structures i.e. Table spaces and data files growth.

Proactively Monitoring file system growth, Alert Log and Archive Destination

Export and import to creating test environment.

Proactively worked on DR activities on weekends.

Execution of Scripts on Quality and production database.

Working on day to day performance issues with analysis of AWR, ADDM, ASH reports.

Reorganizing the database objects by archiving the data and moving the tables within the Table space, rebuilding the indexes.

Created table space using Locally Managed Table Spaces with segment space Management auto and using various block size in order to avoid row chaining.

Locking and Unlocking the schema as per the user requirements. Declaration:

I hereby affirm that the above mentioned information is true and correct to the best of my knowledge. S Lavanya.



Contact this candidate