«
»

Oracle Applications Job Roles

Most beginners that want to jump in the oracle applications bandwagon are quite confused on what role they should choose.

IMHO, there are 3 main types of job roles in Oracle Applications :

1. Applications DBA (Database Administrator) : The job title speaks for itself, normally the main duties of Applications DBA are :

  • Installing Oracle Applications (could be under unix/windows/linux/etc)
  • Regular Database Maintenance (Disk Space monitoring, performance monitoring, backup and recovery,database tuning,main contact/support for database issues etc)
  • Regular Applications Maintenance (creation of new users, new responsibility, monitoring concurrent managers etc)
  • Applying Patches/doing upgrades.
  • Act as production controller to move new application setups , new customizations objects/programs etc.
  • Application Cloning, normally DBA will refresh development instance or test instance regularly with backup from live/production instance.
  • etc

2. Oracle Applications Developer : The job titles may vary (such as Technical Consultants, E-business technical specialist, Software Engineer, Oracle Programmer Analyst and so on), but main duties basically is the same  :

  • Responsible for Development of New or Customizations of Reports, Forms, PL/SQL programs, Workflows, Custom PLLs, Form Personalizations, OA Framework Pages, unix scripts, alerts, SQL*Loader and many more.
  • Creating technical documentations and installation documents for the customizations they made.
  • Act as second level of support for Oracle Applications troubleshooting, such as interfaces problems, reports problems etc.
  • Custom applications tuning for performance problem.
  • Thinking of technical solutions for requirements given by the users or functional analysts.
  • etc

3. Functional Analysts : As the job title says, the main duties are the following :

  • Application Setups (depends on which modules they support/implemented)
  • Act as first level of support for Oracle Applications troubleshooting with users.
  • Gather . define and analyze the detailed functional requirements his/her respective modules.
  • Creating Functional Requirements Document (MD-50 document in Oracle AIM) which will be read by Applications Developer
  • Create/develop test scripts (with testing software) or testing documents.
  • Develop user manuals/documentation for the respective modules.
  • Develop and/or conduct trainings to business users.
  • Etc

From these 3 job roles , there are “hybrid” job roles which combine multiple job roles such as :

Oracle Technical Consultant : Some technical consultants in consulting group that I know can do both dba tasks as well as developer tasks.

Techno-Functional Analyst : For this role the respective person should be able to act as functional analyst as well as developers, so he/she should have deep knowledge on the functional flows of the respective modules he/she supports as well as equipped with the developer skills.

 

Above lists are not a complete lists of the job duties, but these served only as a global overview for those who wants to start a career in Oracle Applications sector. Based on your qualifications, experience and interest you can choose the best role that suits you. Good luck.

This entry was posted on August 18, 2007 at 2:25 pm and is filed under General Information. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “Oracle Applications Job Roles”

  1. Manish Gupta Says:
    December 7, 2007 at 8:12 am | Reply

    Hello,

    With reference to the above explanation, I need to know the job role of a Oracle Functional Consultant in SCM – Logistics/Warehousing & Distribution

    Also, please let me know does Oracle offers any courses for the functional Consultants for the above mentioned area. As I am based in Singapore, therefore, appreciate if you please let me know from where I can find the more information on it.

    Looking forward for your early reply.

  2. dgood76 Says:
    December 7, 2007 at 12:36 pm | Reply

    Hi Manish,

    The job role is most probably as above, with specializations in Oracle Order Management, Procurement, Inventory , MRP/DRP and/or ASCP (Advanced Supply Chain Planning).
    So you could try to look for Oracle Classes offering those above courses,
    try to look at this link for the courses needed :
    http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=84&group_id=9

    Check here for Oracle University offers in Singapore, click on the course schedule to find out what and when the courses are scheduled. Alternatively you could change the country to neighbouring countries like Malaysia which could offer cheaper price.

    Oracle Applications Job Roles

    Or alternatively you could phone Oracle Sales Representatives in Singapore to ask, sometimes they are waiting for minimum number of people to start a course.

    Hope that helps,

  3. Manish Gupta Says:
    December 27, 2007 at 10:10 am | Reply

    hi,

    Thanks for the useful information. I checked this website but I am not sure where from where to start. I have 7 years of experience in Development and now I working in a MNC Manufacturing company.

    Being an end user, I am pretty comfortable on Inbound & Outbound Logistics / Order Organizer / Req.Mgmt / OHQ / MM etc in Oracle 11i but I want to go into functional implementation.

    So as to start into the implementation not sure which Oracle certification module I should go for and you will agree the courses are very costly.

    Appreciate if you please guide me on this front. Once again thank you very much for your help.

  4. Manish Gupta Says:
    December 28, 2007 at 2:27 am | Reply

    In line to my latest message, I was involved in Testing of my Concurrent Reports during the Oracle 11i Implementation in my company.

Leave a comment