Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2006
    Posts
    3

    Unanswered: Developer, Designer & Dba?

    Hello All

    I am sorry i am not sure if its the right section to ask this question or not.

    My question is that what are the job functions of:

    Oracle Designer.
    Oracle Developer
    Oracle DBA Administrator.

    Thanks.
    F.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    DBA owns the database - he's a janitor and takes care about the database. Nurses it, cures when it is ill, performs regular backups etc. After setting it up, DBA gives the database into designer's and developer's hands, gives each of them required privileges (but not always all that they would probably want to have).

    Designer designs an application from scratch - there's an empty schema which should be populated with Oracle objects - tables, views, stored procedures, database triggers, packages, ... - designer's job is to combine all of them in order to enable applying business rules to the IT solution. He will have to carefully design primary keys, enforce referential integrity, etc.

    Developer may, but doesn't have to know business rules (of course, it would be better if he does). However, developer must know tools he uses - SQL, PL/SQL on the lower level, Forms and Reports Builders, Designer, maybe even one of the GUI tools (SQL Developer or TOAD, for example) which would help him develop all the designer designed and make it usable by an end user.

    Hm, now it sounds as if it was a Cynicderella story.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Littlefoot, you forgot the bit about the Designer being responsible for not listening to the end-user, the Developer being responsible for not developing what the Designer asked for (not that the end-user wanted it anyway), and the DBA being responsible for not allowing the end-user to access what he didn't want in the first place
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Huh, right ... but this comes with several years of experience

  5. #5
    Join Date
    Sep 2006
    Posts
    3

    Smile Thanks littlefoot

    for explaining the roles of 3D's.

    Regards
    F.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •