Published on: Mar 3, 2016
Transcripts - Nagu_OracleDBA
Abbadasari Nageswara Rao Phone: +91 9676809574
To take up a challenging career with active interest in the field of Database Administration in a quality
certified organization, which gives me an opportunity to demonstrate my skills & in turn be a source of
growth for the organization.
3 years of experience in Oracle Database Administration for a Banking Customer including
administering very large mission Production/development databases. Have expertise in Oracle
Database (10g/11gR1 and 11gR2) Administration.
Proficiency in Upgrading databases through Manual, using DMA.
Patching database homes (PSU) using Opatch and DMA tool.
Implementing the backup and recovery strategy (Using EXPDP/EXP, RMAN & Cold Backup).
Exposure to Oracle 12c Enterprise Manager (12c OEM) and installation of 12c EMAgent.
Proficient use of Oracle Enterprise Manager (OEM) for managing and monitoring Oracle
Troubleshooting ORA errors encountered in the alert logs and Handle Incident Tickets, Service
Calls and L2 support.
Experience in providing Security User Management, Privileges, Roles, Quotas, Auditing,
Scheduling jobs using crontab.
Experience in data management tools like OEM, EXP, IMP, EXPDP and IMPDP.
Managing listeners using Oracle Net Manager, LSNRCTL utility and OEM.
Managing agent using EMCTL utility.
Good knowledge in multi-node Real Application Clusters (RAC).
Good experience in handling ASM disk-groups and instances.
Working as Oracle DBA in WIPRO Technologies, Hyderabad from June 2012 to till date.
Examination Board/University School/College
M.C.A. JNTU Kakinada, A.P. University college of Engineering,
Degree(B.Sc.) Andhra University, A.P
Board Of Intermediate
A.P.S.W.R. Jr College, Pedavegi. 2006 89.30
Board Of Secondary
A.P.S.W.R. High School, Pedavegi. 2004 88.33
Stood college 1st
in Degree first year.
Successfully completed Unified Competency Framework Oracle 1.1 and
Oracle 2.1 Certifications in WIPRO Technologies.
TECHNICAL SKILL SUMMARY:
Database Oracle 10g/11g
Operating Systems Redhat Linux 4, IBM AIX, Solaris, Windows
Dev Tools SQL*Plus, OEM, Import/Export
Performance Tools AWR, ADDM, ASH
Ticketing Tools Service Now
Connecting Tools puTTY, SQL developer, SSH Tectia
Client CITI BANK
Designation DATABASE Administration
Role Oracle Database Administrator for UNIX Platforms and windows platform
North America Information Technology now known as GCT-NA (CITI Bank
Database Oracle 10.2.0.x and 11.2.0.x
Operating System Solaris / IBM-AIX / Linux
Languages SQL / Knowledge on Unix Shell script.
It is online transactional processing system which constitutes various critical production systems, testing
and development servers.
Working on 24x7 production support.
Designed and implemented cold and hot backups using RMAN.
Managing backup and recovering the databases.
Performing routine checks of space utilization and Extended Table spaces by resizing/adding
data files when needed.
Work Experience on Oracle Grid Control (OEM).
Enhance database administration by automating administration tasks, for e.g. developing scripts
for database instance availability, listener availability, check alert log files for error messages,
Clean up old log files before log destination gets filled.
Applied quarterly patches regularly and bug fix patches when needed.
Involved in tuning of database using Explain Plan, SQL Trace etc.
Reorganizing the database at regular intervals to remove row migrations, fragmentation in the
database using export and import utilities.
Interacting with Oracle Corporation for technical support through Metalink.
Implementing Cron jobs.
Proficient use of Oracle Enterprise Manager (OEM) (Grid control) for managing and monitoring
Worked on 10g and 11g ORACLE ASM administration.
Administrating RAC databases using SRVCTL and CRS.
Database id creation, role & profile creation and granting privileges roles and users.
Action on inactive database id's. Database health checkups and monitoring.
All L1 DBA tasks (script execution, schema level export/import, action on table space alerts).
Environment: Oracle 10g/11g, Oracle 10/11g RAC, Oracle HAS, ASM, Data Guard, RMAN,
Import/Export, OEM, DBCA/DMA, Solaris, AIX, Linux, Windows.
Name : A.Nageswara Rao.
Date of Birth : 03-03-1988.
Languages known : English, Telugu.
Address (Present) : C/o R. Ramesh, H.No: 1-109/1/2, Masjid Banda, Kondapur, Hyderabad-84.
(Permanent) : S/o A. Janesu, H.No: 1-3, Thimmakkapalem(Village), Shingagudem(Post),
Lingapalem(Mandal), West Godavari Dt, PIN: 534462.
I here by declare that the above written particulars are true to best of my knowledge.
Date: 20-04-50002 (Nageswara Rao Abbadasari)