Oracle Apps DBA
Orapundits Consulting Services
Total years of experience :1 years, 8 Months
Client: Orapundits Consulting Services, Hyderabad, India May 2012 - Till date
Designation: Oracle Apps DBA
Environment: Oracle 10g RAC, Data Guard, Red Hat Enterprise Linux 4.8, OEM Grid Control 11g, ASM, AWR/ADDM, Shell Scripting, RMAN, TOAD, Oracle SQL Developer, PL/SQL Developer, VNC Server, Putty
Responsibilities: ✓ Installed and configured EBS R12 and its Oracle Database Installation and Configuration.
✓ Part of team that Upgraded Oracle EBS instance from version 11i to R12
✓ Oracle Database release upgrade from 9.2.0.4 to 10.2.0.1 and 10.2.0.4 to 11.2.0
✓ Oracle Database Point Upgrade from 10.2.0.1 to 10.2.0.4
✓ Cloning/refresh of EBS R12/11i Instance and Oracle Database using cloning technology.
✓ Patching of EBS R12/11i Instance and Oracle Database Instance. (Rollup, CPU, Merged Patch, RDBMS Opatch etc)
✓ Extensively worked with AD Utilities like. (ad* for AutoConfig, Patching, Admin, Cloning, Ctrl etc)
✓ Trouble-shooter for any performance issue and bugs, able to work with Oracle Support and eager to resolve issue with priority.
✓ Part of the team that implemented and configured RAC 10g on OEL 4.8.
✓ Part of the team that implemented and configured ASM to ASM Cloning
✓ Oracle Database administration and monitoring having RAC, Data Guard, ASM Instance, backup strategy using RMAN on Database machine and other high end servers.
✓ Monitoring considering database growth, space, load and optimal performance for large user base.
✓ Oracle Database Advance option of tuning and administering like Recovery Advisor, ADDM, AWR, Tuning and Diagnostic Pack etc.
Client: Orapundits Consulting Services, Hyderabad, India (September 2011 to April 2012) Designation: Oracle DBA
Environment: Oracle 10g RAC, Data Guard, Red Hat Enterprise Linux 4.8, OEM Grid Control 11g, ASM, AWR/ADDM, Shell Scripting, RMAN, TOAD, Oracle SQL Developer, PL/SQL Developer, VNC Server, Putty
Responsibilities: ✓ Installing and configuring of Oracle 10g, 11g databases on Linux 4.8.
✓ Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges
✓ Configured Recovery Manager (RMAN) and Performed Hot and Cold backups for production databases using RMAN.
✓ Involved in taking logical backup using Data pump Expdp and Impdp Utility.
✓ Involved in checking the status of listener and restarting listener.
✓ Grant and Revoked user privileges and roles as per requirement and killed blocking session.
✓ Performed auditing on user activities on request and per organization policies.
✓ Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.
✓ Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
✓ Created DB Links and indexes as per user requirement.
✓ Cloning of Production database to test and development environment using RMAN and User Managed Backup.
✓ B.Tech (Bachelor of Technology): Electronics and Communication Engineering, Awarded First Division By JNT University, Hyderabad, India in July 2012.
Awarded First Division By Board of Intermediate Education, Govt of AP, India in March 2008.
✓ Higher Secondary Education (Matriculation): Awarded First Division By Indian Certificate of Secondary Education (I.C.S.E), Govt of India in April 2006.