SUMMARY

• Installed, configured and administered Oracle Application 11i/12.1/12.2 in Single/Multi - tier Architecture under operating systems like Solaris, Linux, AIX HP-UX and Microsoft Windows on VMware, Physical and customer cloud.
• E-Business Suite upgrade from 11.5.10.2 to 12.1.3 and 12.2.
• Installation/configuration of GoldenGate.
• Installing and Managing Oracle Financial Services Revenue Management and Billing (ORMB).
• Managing large databases for Data Warehousing and running ETL tools.
• Installing and Managing Golden Gate for data replication between ORMB and ORMBA databases.
• Proficient in Weblogic administration.
• Lift and shift E-Business Suite 12.2 from On-premises to Oracle Cloud.
• Install and configuring RAC environments.
• Hands on knowledge on managing Databases and E-Business Suite on AWS platform.
• Cloning of Oracle Applications using Rapid Clone and manual clone process for EBS (12.2,12.1,11i) and databases 9i,10g,11g,12c,19c).
• Well versed in Rapid Install, AD utilities for Oracle Applications.
• OATM migrations and upgrade of databases from 9i to 10g, 11g, 12c and 19c.
• Securing data with Transparent Data Encryption (TDE)
• Proficient in AD utilities (adadmin, adconfig, adpatch, adlicmgr, adsplice, adident, adctrl, adsplice).
• Shared Appl Top configuration and Load balancing across the middle tiers.
• Configured PCP (Parallel Concurrent Processing) for multi-node environments.
• Applying various types of Patches with patching utility adpatch, adop and opatch.
• Create and maintain custom responsibilities, menus for functional setups.
• Space Management, Memory Tuning, Application Tuning and managing schema objects like tables, Indexes, Views.
• Well experienced in administering Oracle Applications and Databases on different flavors of UNIX platforms ( Oracle Enterprise linux, Red Hat Linux, Sun Solaris, IBM AIX) and Windows.
• Exposure to OEM (Oracle Enterprise Manager) Grid 10g/11g/12c and OAM(Oracle Application Manager)
• Configured and used RMAN for taking the backup of Oracle 9i/10g/11g/12c/19c Databases.
• Proficient in Oracle backup and recovery principles.
• Proficient in configuring Concurrent Managers for Applications
• Users Administration (Roles and Profiles).
• Experience in raising Severity TARs/SR and conduct OWC sessions with Oracle support to overcome loss of service to the production instance.
• Very good knowledge in Oracle Application SYSADMIN activities like Printer configuration, custom tops creation, etc.
• Implementation and administration of Middleware products like OBIEE/OBIA & UPK(User Productivity Kit).
• Having good experience on providing architect design solutions for any new product implementations as per the client business requirement.
• Strong Troubleshooting Skills to handle any kind of production issues.
• Deployed Oracle products in Virtual infrastructure to avoid the cost implications of physical Infrastructure.
• Always adhere the strict policies of SLA and SOX audition of the client.
• Experienced in SOA gateway and Webservice deployment with Oracle Applications.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Sun Solaris, AIX, HP-UX and Windows.

Oracle ERPs: Oracle Applications 11i, R12.1 and R12.2

Oracle Middleware: Oracle WebLogic, UPK, OBIEE & ODI (Oracle Data Integrator)

Scripting: SQL Plus, shell and python scripting (like awk,sed,perl).

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

Tools: VNC, Putty, FTP, WinSCP, Toad, Sqlplus Loader and Vmware.

Cloud Services: AWS (Amazon Web Services) and Fujitsu Cloud services (K5)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Upgraded database from 12.1.0.2 to 19c.
• Oracle E-business suite applications from 12.2.4 to 12.2.9.

Confidential

Sr. Oracle Apps DBA

Responsibilities:

• Administering and supporting the Oracle E Business application and database for development, UA and Production.
• Upgrading Oracle database and Oracle E-business suite applications from 12.1.3 to 12.2.6 and database 11.2.0.4 to 19c.
• Managing offshore and onshore DBA team of size 12.
• Customer facing lead DBA for project deliverables.
• Installing and Managing Oracle Financial Services Revenue Management and Billing (ORMB)
• Installing and Managing Golden Gate for data replication between ORMB and ORMBA databases.
• Responsible for Production Oracle Financial systems available 24x7 business transactions.
• Maintaining 20+ different Oracle instances-patching, cloning, backup, monitoring, custom-code, migrations etc.
• Managing Oracle databases for different Oracle middleware products and third party applications.
• Working with Business Users, Development and Functional teams for daily DBA support.
• Encrypting business data and securing financial transactions using TDE (Transparent Data Encryption).
• Creating DB and administrating Exadata Machine.
• Managing integrations with OAM/OID with Oracle E-business Suite and synchronizing user data between Active directory and Oracle E-Business Suite.
• Administrating WebLogic for different Domains.
• Working with SQL statements.
• Working with Shell and Python scripting.
• Coordinating the monthly and quarterly release, pre and post release activities.
• Identifying the issues in Production and providing solutions.

Confidential, Portland, OR

Sr. Oracle Apps DBA

Responsibilities:

• Oracle Apps DBA and Sysadmin activities for EBS Release 12.2.
• Patch analysis and apply Oracle applications patches using adpatch and opatch on databases and application technology homes.
• Working with Functional and Technical teams in respect of code migrations, compilation of forms, objects using ad utilities.
• Working with Oracle support for any complex issues.
• Troubleshooting technical issues and provide fixes.
• Maintaining documentation for all technical changes.