Wednesday 9 January 2013

Career in Oracle Application:


Today’s market for the professionals who have the domain knowledge of any business stream like finance, supply chain, manufacturing and they know the functionality and application of Oracle e-Business suite( also called as e-Biz) has a huge demand in the market and is ever increasing.

Today Oracle application is world leader in ERP(Enterprise Resource Planning) market which has in the near past acquired many established ERPs like JD-Edwards, Peoplesoft, Seibel to name a few.
Currently Oracle e-Biz is having couple of versions in the market which has still not been upgraded. The versions are E-biz 11i, E-biz R12 and Fusion. Fusion is the latest version in the portfolio of Oracle applications.
There are three different tracks in which you can get experts to get a good job in the ERP market they are:
  • Functional Consultant
  • Technical Expert
  • Apps DBA  
Functional Consultant: Functional Consultants are people who have done there basic studies in the relevant domain area (domain area can be Finance, Supply Chain, procurement, etc,) and have atleast two to three years of working experience in the specific domain area. For example if one wants to be a Functional Consultant (functional) then he needs to be a post graduate in commerce or Maters in business administration with two years of experience (or a graduate in commerce with 3+ years of experience) and should have under gone Oracle Functional consultant training.

Technical Expert is one who has the basic education like Degree in Engineering (BE) or B.Sc.(computer science) and has undergone additional training on the technology used in Oracle Applications. The technological skills to be possessed by a technical expert are as below:
  • SQL/ PL SQL
  • Developer 2000 (D2k)
  • Reports
  • Forms
  • Knowledge of unix
  • Java 
 DBA (Data base administrators): Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.
A database administrator's responsibilities can include the following tasks:
  • Installing and upgrading the Oracle server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Creating primary database storage structures (tablespaces) after application developers have designed an application
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with your Oracle license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data on tape
  • Backing up and restoring the database
  • Contacting Oracle Corporation for technical support

No comments:

Post a Comment