1
Q
How does an Oracle DBA role differ from an Oracle Developer role? Are there any similarities?
A
Oracle developer mainly develops the backend application and does data modeling based on the business rules. They design the components and details but are not expected to administer it.
Oracle DBA’s mostly administer the database. They don’t normally develop code but still have a good knowledge of SQL and PL/SQL language. May be assigned development tasks or assist the developer.
2
Q
What would be the main responsibilities of an Oracle DBA in an organization?
A
- At the heart is keeping the Oracle DB up and running.
- Installing and configuring a DB from scratch.
- Starting up and shutting down the DB.
- Creating new users and managing the privileges.
- Taking regular backups and restoring those backups.
- Monitoring space usage.
- Enforcing security policies.
- Monitoring DB activities.
- Tuning the DB.
- Follow and apply the latest patches.
3
Q
What are the common DBA tasks?
A
- Installing Oracle Software
- Creating Oracle Databases
- Performing Upgrades of the DB and Software
- Monitoring the DB
- Monitoring and Tuning Performance
- Etc.
