SUMMARY

• An astute Oracle DBA with 8 plus years of IT experience in Oracle technologies.
• Worked as Technical Lead, Team Lead, Onsite / Offshore co - coordinator and as per the client need.
• Strong expertise in end to end Oracle E-Business Suite upgrades, and Database upgrades.
• Administered different versions of Oracle Applications like 11i, R12.
• Good experience in Administrating Oracle RAC and Non RAC databases.
• Good Experience in performance Tuning Using SQL Tuning Advisor, memory Advisor, undo Advisor, Explain Plan, Gathering statistics information by Automatic Workload Repository (AWR & ADDM), collect the statistics for database/database objects, SQLT installed to get the report for slow running sql statements, enabling session level tracing, TKPROF, EXPLAIN PLAN, Tuning of SGA, creating indexes, changing execution profiles, creating the performance base lines and creating SR with oracle support.
• Sound knowledge on cloning of oracle applications and database using Rapid clone & manual clone.
• Good experience in Installation, Configuration, up gradation, migration, applying patch, Backup & Recovery using RMAN and EXPDP/IMPDP cloning the databases using RMAN, Data guard Configuration, Switchover/Failover, DR exercise and implementing TDE etc
• Good experience on 12c OEM, performance monitoring/administrating database using 12c OEM, agent push, promoting the targets into 12c OEM, database blackouts and setting the tablesapces thresholds for creating the alerts.
• Experience in PCP, workflow configurations
• Having a good exposure to UNIX environment, Linux, AIX and Solaris
• Exposure in working at Client/Customer locations, high level of confidence in customer management and can handle pressure situations.
• Confident at troubleshooting and problem solving.

TECHNICAL SKILLS

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i.

Operating Systems: Unix, Sun Solaris, AIX, Linux and Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: RMAN, SQL*Loader, EXP, IMP, Expdp/Impdp

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM, SQLTRPT and SQLT

ETL Tools: TOAD, BMC Remedy, Putty, Win SCP, VNC Viewer, Exceed.

PROFESSIONAL EXPERIENCE

Confidential

Lead DBA

Responsibilities:

• Upgrading Database from 10G to 11gR2.
• Performed all aspects of database administration including Installation, Configuration, Patches
• Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading and migration of oracle software and tools.
• Sound Knowledge on RAC Administration and Load Balancing.
• Upgrading E-Business suite application instances from 11.5.10.2 to 12.1.3
• Cloning of Oracle Application through Rapid Clone and manual cloning.
• PCP Configuration and Administration, JDK, JRE upgrade Shared Techs tack implementation
• Integrating and administering discoverer and Workflow administration.
• Mark view Integration and web logic administration.
• Applied RDBMS patches, maintenance packs, mini packs.
• RAC node Addition and deletion Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g RAC.
• Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed problems and implement corrective actions.
• Backups and Recovery Using RMAN and Data pump
• Trouble shooting various issues during migration.
• Provided 24/7 support to various phases SIT, UAT and go live.
• Worked on AIX, Unix and Windows Platforms
• Maintaining Application Security and Database Security
• Managing Users, Responsibilities and Profile options.
• Gathering Statistics for tables & schemas using DBMS STATS and manually.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Create and Follow up Service Requests with Oracle Support for Technical Support

Environment: RDBMS 10g and 11G, Oracle Applications 11i, R12.1& R12.2

Confidential

Responsibilities:

• Actively involved in planning and preparation of the go live project. Played a Key role in go - live and made a successful deployment.
• Involved in customer meetings and responsible for taking decisions required for the project.
• Transitioned offshore team on the upgrade activities and helped them to understand the internal and external dependencies.
• Conducted weekly meetings with both internal and external clients and provided the status updates
• Played a key role in post go live support and worked as a single point of contact for client and third party vendors for resolving the post go live issues.
• Installing and Administrating E-Business Suite 11i and R12.1.3
• Upgrading E-Business suite application instances from 11.0.3 to 11.5.10.2
• Upgraded E-Business suite application instances from 11.5.10.2 to R12
• Upgrading Database from 8i to 11gR2.
• Applied RDBMS patches, maintenance packs, mini packs.
• Hands on experience in Cloning of Oracle Application through Rapid Clone and manual cloning.
• Oracle Applications table spaces are migrated from old architecture to OATM
• JDK upgrade from 1.4 to 1.6
• Starting and stopping of weblogic admin and managed servers.
• Administering weblogic managed servers.
• Have worked on OID integration with 11g databases
• Implemented SSO Integration with R12.1.3
• Upgraded JRE from J-initiator.
• Changing and adding database parameters according to upgrade requirement.
• Configured secured socket layer (SSL) in oracle applications 11i.
• Applying CPU patches to fix the security issues.
• Managing Redo log and Archive log files.
• Oracle Database space management.
• User security management & administration.
• Implementing custom tops as for customer business perspective.
• Troubleshooting issues during the up gradation.
• Managing Imports & Exports using EXPDP & IMPDP for schema and full database refresh.
• Performing backups using manual methods (both hot & cold) and RMAN for database close and DR testing.
• Gathering Statistics for tables & schemas using DBMS STATS and manually.
• Involved in applications performance tuning and database performance tuning.
• Using of AWR report, ADDM, ASH, memory adviser, undo adviser and sqltrpt to find the performance issues and get recommended solution to improve the Performance.

Environment: RDBMS 8i, 9i and 11G, Oracle Applications 11i, R12

Confidential

Apps Database Administration

Responsibilities:

• Administrating E-Business Suite 11i and R12,
• Experience in Application Patching using ad patch and strong analytical and problem solving skills in Patch Management.
• Applied RDBMS patches, maintenance packs, mini packs.
• Proficient in using auto config for Oracle application system maintenance.
• Knowledge on AD Utilities like ad admin, adrelink, adctrl etc
• Knowledge on Cloning of Oracle Application through Rapid Clone.
• Managing the tablespaces and reorganized the Fragmented Tables.
• Added redolog files and maintained redolog groups.
• Purging unwanted request output and log files using purge concurrent programs.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers.
• User account management - creating users, disabling users, responsibility management.
• Sysadmin tasks like creating user, assigning responsibilities, registering forms, Concurrent programs, creating responsibilities and menus.
• Managing Redo log and Archive log files. Conversion of Database in Archive Log / No Archive Log Modes.
• Interact with end users to understand their technical queries related to database And provide assistance in resolving them.
• Performing health checks periodically and maintaining consistency.
• Starting and stopping the web logic services
• Troubleshooting startup issue of concurrent manager server and other servers.
• Troubleshooting discoverer server issues.
• Performing Patch Analysis, preparing final action plan for execution.
• Performing Pre Config Analysis(Application and database changes)
• Performing Pre State Analysis(data fixes)
• Changing parameter values in application configuration file
• Patch Application in Single and Multi node servers.
• Applying RDBMS patch using Opatch
• Trouble shooting issues after patch application.

Environment: RDBMS 9i, 10g and 11G, Oracle Applications 11i, R12.