SUMMARY:

• Over 19+ years of experience in the IT industry as an expert Lead Oracle E - Business DBA, Oracle Fusion Applications DBA & HR Analytics admin having sound exposure in real time system support, production and development database administration, performance tuning, backup and recovery, space management, environment tuning, installation, maintenance and trouble shoot of instances.
• Delivered responsibilities as Lead Oracle E-Business DBA, HR Analytics, Oracle core DBA, MySQL
• Rock solid experience in administration & support of Oracle E-business Suite (R12.x/11.x), Oracle Databases (11g, 10g, 9i/8i), GRC suite, HR Analytics (OBIEE) admin, APEX, UPK, Vertex, Retek, Agile, ClearOrbit, Perforce, Tomcat, WebLogic, SplashBI admin and various programming tools and utilities including PL/SQL, UNIX Shell Scripts, RAC, RMAN, TOAD, Grid Control, Datadomain.
• Experience in design architecture and development of client server applications in 2-tier & 3-tier architecture using Developer 6i, Oracle database and legacy systems using COBOL.
• Installation (R12.2.6 & 12.1.x), Upgradation, Migration, staging and Administration of Oracle database & E-Business application, Oracle Fusion application 9, HR Analytics (OBIEE) in various functional domains on AIX 6.1 /HP-UX/Linux/Solaris/NT.
• Work experience on multi-node and RAC with ASM environments.
• Work experience of DMZ and E-Business mobile configuration.
• Planning and designing databases, applications including designing local structures and forecasting further expansions (CAPACITY PLANNING).
• Monitoring & Tuning database performance using AWR, sqltxplain and OEM/TOAD for optimization of resource utilization on server.
• Expert in database activity like managing tablespaces, rollback segments, redo logs export, import.
• Hands on experience in backup data including RMAN and Standby/dataguard.
• Expert in all ad utility like adadmin, adpatch, adop & Sysadmin.
• User management and work as part of a team and provide 24 x 7 production support of type on-call operations.
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges.
• Install Oracle Client software and troubleshoot connectivity issues.
• Good Co-ordination with Unix System Administrators and Network Administrators to achieve zero down time and better server performance.
• Good in Unix Shell script for application and database batch jobs to schedule through cronjob.
• Concurrent Managers tuning
• Worked with Oracle Support through Priority service request (TAR) to resolve issues
• Good Communication skills and experience in handling clients around the globe
• Good working knowledge of Logical database design.

STRENGTH/SOFT SKILLS:

• Abel to think ahead in order to establish an efficient and appropriate course of action for self & others. Prioritizes plans activities taking into account all the relevant issue and factors such as deadlines, resources.
• Able to get one’s message understood clearly by adopting a range of styles, tools and techniques appropriate to the audience and the nature of the information.
• Able to build and maintain effective working relationship with a range of people. Works co-operatively with others to be part of a team, as opposed to working separately or competitively.
• Manages personal effectiveness by managing emotions in the face of pressure, set backs or when dealing with provocative situations. Demonstrates an approach to work that is characterized by commitment, motivation and energy.
• Adapts & works effectively with a variety of situations as an individual or groups. Able to understand & appreciate different thoughts and opposing perspectives on an issue, to adapt an approach as the requirements of a situation changes, and to change or easily accept changes in one’s own organization or job requirements.
• Lead process improvement initiatives. Provided situational leadership on teams charged with broader, or cross-functional, problem resolution.

PROFESSIONAL EXPERIENCE SUMMARY:

Lead Oracle E-Business DBA & HR Analytics admin

Confidential, Reading, PA

Responsibilities:

• Installation, upgrade, maintenance of Oracle E-Business suite, HR Analytics instances.
• Configuration of DataGuard for E-business suite & core database.
• E-Business custom application deployment to production instance.
• E-Business upgrade from 12.1.3 to 12.2.6.
• Support of core database for Savvion, Tiriga, Support Central.
• Support of RMAN, DataDomain backups.
• Maintenance, monitoring, patching, trouble shooting for entire E-Business suite, HR Analytics.
• Instance cloning, Data scrambling for development and QA.
• MySql database creation and maintenance.
• WebLogic server with Discoverer, SplashBI admin.
• Maintenance of DMZ with E-Business mobile.
• Database & Oracle E-Business security.

Sr. Oracle Applications DBA

Confidential, Columbus, OHIO

Responsibilities:

• Installation of GRID control 11g.
• Configuration of DataGuard for E-business suite and core database.
• Worked in OS Migration team for E-business migration from Windows to RH Linux 6.1
• E-business upgrade from 12.0.4 to 12.1.2.
• Support of core database for Market Manager.
• Support of RMAN, CommVault backups.
• Maintenance, monitoring, patching, trouble shooting for the client’s entire E-Business suite.
• Worked on Oracle SRs
• Instance cloning for development.
• Data masking through GRID control.

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Installation of E-business suite (12.1.1) in RFGen.
• Migration of E-business from Solaris (SPARC) to RH Linux 5.7 in Telmar NT
• E-business upgrade from 12.0.4 to 12.0.6 in Telmar NT as a primary DBA.
• Support of core database in Telmar NT
• Support of RMAN, ClearOrbit, Perforce, Optics in Telmar NT
• Support of Agile PLM in Semtech Tech.
• Support of ClearOrbit (supply chain management), Perforce, Optics in Telmar NT
• Maintenance, monitoring, patching, trouble shooting for the client’s entire E-Business suite.

Confidential, Rockville, MD

Sr. Oracle Core with Applications DBA

Responsibilities:

• Migration of E-business from Windows 2000 Server to RH Linux 5.5
• Installation, Configuration of 11.5.10.2 binary under Linux.
• Upgrade the Java.
• Upgrade the apps tech stack.
• Installation and configuration of standalone discoverer under Linux.

Environment: E-Business 11.5.10.2 with database 10gR2, SAN, Grid Control, Shell Scripts, Linux 5.4

Confidential, Seal Beach, CA

Sr. Oracle Core with Applications DBA

Responsibilities:

• Installation, Configuration of R12.0.4 E-Business instance and oracle core database.
• Cloning of oracle database & E-business from CRP instance using rapid clone.
• Patch tree analysis & patching using adpatch, opatch, mergpatch
• Sysadmin jobs with user management & ad utility
• Concurrent manager/requests maintenance, custom concurrent manager creation.
• Database and SGA tuning using STATPACT, AWR report.
• Taking ownership of issue and trouble shoot of different application and SR(TAR) management
• Preparation of technical documents, writing shell, sql scripts for E-business.
• Providing Capacity Planning management process with DBA guidance for best practices.
• Backup management by RMAN using Grid control.
• Configuration of GRID control for E-Business and Oracle database.
• Monitoring GRID control alert for E-Business and database activity.

Environment: E-Business 12.0.4 with database 10gR2. Oracle core database 11gR1, Grid Control, Shell Scripts, AIX 6.1L

Confidential, Tustin, CA

Sr. Oracle Applications DBA

Responsibilities:

• Installation, Configuration of R12.0.4 E-Business instance.(SSL with Load balanced & shared APPL TOP)
• Upgrade of EBS R12 from 12.0.4 to 12.0.6 with 10gR2 database and from 12.0.6 to 12.1.1 with11g database.
• Cloning of oracle database & E-business from CRP instance using rapid clone.
• Patch tree analysis & patching using adpatch, opatch, mergpatch
• Sysadmin jobs with user management & ad utility
• Concurrent manager/requests maintenance, custom concurrent manager creation.
• Database and SGA tuning using STATPACT, AWR report.
• Preparation of technical documents (TA090), writing shell, sql scripts for E-business.
• Providing Capacity Planning management process with DBA guidance for best practices.
• Backup management by RMAN and Grid control using TSM backup system.
• Working with IBM and Confidential Functional team for providing technical support of Oracle Financials, HR
• Installation and configuration of OBIEE with Informatica under IBM - AIX and Linux redhat.
• Installation and configuration of GRC suite (AACG, TCG, CCG, PCG, PEA) under Linux redhat & GRC manager, Stellent under windows.
• Configuration of HRMS on EBS (Applied Human Resources Suite Family pack, DataInstall, HRglobal patches(hrglobal.drv), configure the quantum(payvendor), Configure Vertex Q series application for Payroll, Apply US HR 2009 Annual Statutory patches)
• Installation and configuration of APEX
• Fusion Middleware installation and implementation, integration with Oracle ADF Architecture.
• Installation of UPK database under AIX and UPK server, publisher under Windows.
• Configuration of GRID control for E-Business and Oracle database.
• Monitoring GRID control alert for E-Business and database activity.
• Configuration of SSO, OID with E-Business.
• AACG patching for upgrade from 8.0 to 8.1.1
• Upgradation of CCG of GRC suite.

Environment: E-Business 12.0.6 with database 10gR2 & 12.1.1 with 11g database, RMAN, TOAD, GRID Control, APEX, GRC suite, OBIEE, UPK, Vertex, SSO, OID, Shell Scripts, Ecologic SAN in fiber channel, Linux RH.

Confidential, Avon, MA

Sr. Oracle Applications DBA

Responsibilities:

• Installation, Configuration, Testing of instance, DMZ instance for the application.
• Upgrade from 11i (11.5.10.2) to R12 (12.0.4).
• Cloning of oracle database and application from production to final UAT, uat, dev and instance.
• Patch tree analysis & patching using adpatch, opatch, mergpatch
• Sysadmin jobs with user management & ad utility
• Concurrent manager/requests maintenance, custom concurrent manager creation & tuning, troubleshoot
• Writing and Tuning of SQL, PL/SQL using PL/SQL developer, texplain and dbms profiler.
• Database and SGA tuning using STATPACT, AWR report.
• Taken ownership of issues and trouble shoot of different application and SR(TAR) management
• Preparation of technical documents, writing shell, sql scripts for Apps.
• Handling Production Database issue, space issue and ERP issues and database changes/fix
• Apache, JVM, Jserv tuning
• Providing Capacity Planning management process with DBA guidance for best practices.
• Backup management by RMAN using Omni backup system.
• Network and OS tuning using top, sar, netstat
• Working with Functional team(Protégé) for providing technical support of Oracle Financials.

Environment: Oracle Application 11.5.10.2 with database 10.2.0.3, RMAN, TOAD, OEM, Linux, SQLPLUS, SQL Loader, FNDLOAD, UNIX Shell Scripts.

Confidential, Irvine, CA

Sr. Consultant / Oracle Applications DBA

Responsibilities:

• Installation and configuration of financial and ascp, testing of database and 11i and R12.0.4 instance.
• Cloning of oracle database and application from production & quality.
• Database upgrade as per the update calendar from 8.1.7 and 9.R2 to 10.2.0.4 and 11g
• Managing the RAC and ASM instances of 10g
• Patch tree analysis & patching using adpatch, opatch, mergpatch
• Sysadmin jobs with user management, ad utility
• Concurrent manager/requests maintenance & tuning, troubleshoot
• Writing and Tuning of SQL, PL/SQL using PL/SQL developer, texplain and dbms profiler.
• Database and SGA tuning using STATSPACT, AWR report.
• Taking ownership of trouble shooting through Remedy ticketing system, SR(TAR) management
• Preparation of technical documents, writing shell, sql scripts for Apps and Core DBA activities.
• Administration and configuration of core Database on 10g RAC.
• Handling Production Database, space issue and ERP issues and database changes/fix
• Apache, JVM, Jserv tuning
• Providing Capacity Planning management process with DBA guidance for best practices.
• Backup management by RMAN using Omni and EMC backup system.
• Configure Oracle Single Sign-On (SSO) on oracle application server.
• Executing DDL (tables, views, code movement) and DML (data movement) in production.

Environment: Oracle Application 11.5.9 and 11.5.10, Oracle Database 8i/9i/10g/11g, 10g RAC, RMAN, TOAD, OEM, Windows NT/2000, HP-UX, HP-Itanium, SQL Loader, FNDLOAD, Shell Scripts, Remedy.

Confidential, VA

Oracle Application DBA

Responsibilities:

• Cloning of oracle database and E-business
• Database upgrade & application upgrade
• Database and SGA tuning using STATSPACK
• Patching using adpatch, opatch, mergpatch, Sysadmin jobs, ad utility
• Installation and configuration of database and 11i
• Concurrent manager/requests maintenance & tuning
• All production and development issue resolve from Confidential Support Central case.
• Preparation of technical documents, writing shell, sql scripts for Apps and Core DBA activities.
• Managing Core Database and upgrade from 8.1.7 and 9.R2 to 10.2.0.2
• SQL tuning using explain plan and PL/SQL tuning using dbms profiler.
• Handling Production issues and database changes/fix, Space management issue resolve with unix team.
• Apache, JVM, Jserv tuning
• Preparation of document as per Genworth standard.
• Load balancing using multiple JVM, forms metric server.

Environment: Oracle Application 11.5.9 with two node installation under Solaris, RMAN, TOAD, OEM, SQLPLUS, FNDLOAD, UNIX Shell Scripts, Confidential Support Central, Unix Administration

Confidential

Consultant / Oracle Applications DBA

Responsibilities:

• Installation and configuration of database and 11i financial module
• Cloning of oracle database and application
• Database upgrade & application upgrade
• Database tuning using STATSPACK
• Patching of application and database using adpatch, opatch, mergpatch
• All sysadmin jobs and ad utility
• Concurrent manager/requests maintenance & tuning,
• Confidential Support Central ticket resolving
• Preparation of technical documents, writing shell, sql scripts for Apps and Core DBA activities.
• Handling Production Database and ERP issues and database changes/fix/ code movement

Environment: Oracle Application 11.5.9 with two node installation under Solaris, RMAN, TOAD, OEM, SQLPLUS, FNDLOAD, UNIX Shell Scripts, Confidential Support Central, DataGuard.

Confidential

Consultant/Oracle Applications DBA

Responsibilities:

• Installation and configuration of database and 11i
• Cloning of oracle database and application
• Database upgrade & application upgrade
• Patching to shared appl top using adpatch.
• Sysadmin jobs like user maintenance, responsibility maintenance, ad utility
• Code, object movement from SIT to PROD through KINTANA
• Concurrent manager/requests maintenance, trouble shoot & tuning,
• Apache and JVM tuning and PL/SQL and SQL tuning.
• Configure Oracle Single Sign-On (SSO) on Oracle Apps.
• Confidential Support Central ticket resolving
• Preparation of technical documents for tuning proposal, enhancement in database and application process.
• Managing Core Database and upgrade from 8.1.7 and 9.R2 to 10.2.0.2
• Handling Production Database and ERP issues and database changes/fix/code movement
• Preparation of document templates as per Confidential TSG standard.

Environment: Oracle Application 11.5.7 & 11.5.9 with two node installation under IBM-AIX(DB) and Linux Suse(Web), RMAN, TOAD, OEM, Shell Scripts, Confidential Support Central, Kintana, RAC with RAW devices, Markview 170 system.