Oracle Technical Support

BhadriNarayana K

Mob:+91-733*******

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

Professional Summary

Around 4.3 years of IT experience as an Oracle DBA with RAC.

Having very good experience in Oracle databases from version 9i to 11gR2 and various platforms like Solaris, Linux on RAC and non-RAC environments.

Physical and Logical Standby Databases (Data Guard)

Upgradation of Oracle db from 9i to 10g, 10g to 11g .

Given 24/7 support to project and resolving the user issue as per severity

Experienced in Multi-node to single node cloning on Linux and Solaris with RAC.

Experience in backup and recovery using RMAN with hot and cold backup.

Experience in Oracle Database patching using opatch.

Involved in oracle technical support process through Metalink and other procedures.

Good Experience on Oracle Enterprise Manager (OEM) 12C good knowledge on R12.

Experience in Creating ASM Databases and Managing DG’s in RAC environment.

Successfully provided 24*7 supports for production, development, and test database.

Educational Qualification

Bachelor in Computer Sciences (BSC) in G.Pullareddy Degree and PG College(2010), Hyderabad.

Work Experience

Working in KMAXIT in Hyderabad as Oracle DBA Consultant from AUG 2012 to till date.

Technical Skills

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

Oracle Tools Utilities : RMAN, RAC,ASM,DG,EXPDP/IMPDP,Puttty,Toad.

Operating System : Solaris, Linux (RHEL & OEL), Windows.

Project Experience

Project #2

Client : RBS

Technical Environment : Oracle Database 10g,11g&12c

Role : Oracle DBA Consultant

Job Responsibilities:

Involved in the RAC meetings and implementing solutions to fix the problems permanently.

Maintaining RAC databases by using SRVCTL, CRSCTL resources.

Backing up OCR and VOTING DISKS

Interacting with oracle support for technical assistance requests.

Good experience in monitoring the RAC and ASM instance.

Experienced in Cloning Production instance to DEV, TEST and UAT.

Manual check for AWR and TKPROF

Having good experience in adding space in ASM Disk groups.

Apply different types of Patches and Patch sets.

Upgraded the database from 9i to 10g & 10g to 11g.

Managing monitoring the Database space requirements and system performance using control.

Perform Daily Monitoring all Oracle Instances using Oracle grid Control and monitor users, Table space, memory structures, logs, and alerts

Good experience in handling and monitoring alerts on 11g &12c.

Monitoring the database backups and resolving the issues.

Day-to-day business database support and management of the production databases.

Good at performing patching activity on RAC Databases.

Implemented Oracle Data guard (Physical) standby databases With Data guard Modes Maximum (Performance/Availability/Protection).

Project #1

Client : PMSI( Primary Medical Staffing Inc.)

Technical Environment : Oracle Database 10g.

Role : Software Engineer.

Job Responsibilities:

Having good knowledge on Oracle Architecture.

Good knowledge on the concept of Oracle Managed files (OMF).

Good knowledge on Undo Segment Management

Refreshing instances as per as refresh schedule

Interacting with customers to understand their technical quires and resolved them.

Good experience on documenting the bugs and their resolutions.

Interacting with oracle support for technical assistance requests.

Good experience on Created Technical Notes and Documentation.

Experienced in Database Cloning.

Created users & privileges with appropriate roles and levels of security.

Designing of tablespaces/datafiles, rollback-segments.

24/7 Incident Response to database alerts from production monitoring tools and Operations.

Managing Tablespaces, Data files, Control files, Online Redo Log files.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and AUTOTRACE

Transferring logical data using Export/Import and Expdp/Impdp utilities.

Experience in configuring and troubleshooting network files such as Listener.ora and Tnsnames.ora.

Planning the frequency of backup, type of backup, weather to run the database in archive log mode.

Backup database using RMAN. Implementing BACKUP (Hot Backups / Online Backups)and RECOVERY strategies for Offline and Online Backups.

Contact this candidate