Apps DBA Responsibilites

[anu_uma]

Hi All,

Can Anyone explain in detail about the Apps DBA Responsibilities and Functions a APPs DBA.....

What are the roles performed by the DBA......

What a DBA does?? What are the work to be taken care of a DBA????

Is there any way to do the activities of DBA as remote? What are the services can be offered by a remore DBA?


Thanks
Uma

[bang_dba]

Installation
Administration
Patching
Cloning
Performance tuning

and other general troubleshooting to ensure the smooth operation of the appliation

[anu_uma]

Hi,
Thanks for the reply,

by the by Administration means what sort of administration is it???

Regards,
Uma

[zeenat khan]

administrator installs and configures database software
for the development environment; creates the various databases
required during the development life-cycle (for example, the data
dictionary, unit testing, system testing, training); and maintains
database access controls. Additionally, this project role provides
consultation on performance; monitors growth and fragmentation of the
development database; and provides database backup and recovery.


The system administrator is responsible for administering a
development system. This project role?s responsibilities include
ensuring hardware is correctly configured; installing, configuring, and
maintaining operating and development software; and ensuring daily
backups of the system are performed. The system administrator
designs and maintains the system?s security; for example, establishing
system accounts.
The system administrator provides first-line support for development
system problems and makes sure faults are quickly rectified. This
project role may perform the set-up and initial maintenance of a
production system or advise the client?s operational staff on these tasks.
The system administrator works with the project team to optimize
system performance.


APPS DBA is mixture of above two

[anu_uma]

Hi Zeenat Khan,

Thanks and Thats Great...

I would like to know what kind of work can be done by a DBA when the project is Offshore Support in Apps.....

DBA Activities in OFFSHORE PROJECT......


Regards,
Uma

[ahmadbilal]

Check Log files on DB, Forms, Apache, Concurrent manger
Check work flow errors.
Release error activity from work flow
Check performance and space usage of the database
Work with application-maintenance to resolve issues
Work with system-maintenance to resolve issues
Participate in projects, or discuss requested changes.
Test and apply patches
Test and install new customizations
Tune concurrent manager
Tune Apache Server

[anu_uma]

Hi,
Thanks for your valuable inputs.