There are two roles in oracle database field.
- Oracle database developer
- Oracle database Administrator (Oracle DBA)
Skills Required :
For Developer: sound knowledge of Sql, PL/Sql & any programming language preferable.
For DBA : knowledge of Sql, PL/Sql , Database architecture, OS, some basic concepts of networking and the DB monitoring/management tools provided/supported by the oracle.
We are going to discuss about the skills required for Oracle DBA. The topics are given below on which we are about to discuss one by one.
- About Sql and PL/Sql
- Operating systems (OS) concept.
- Oracle Database architecture
- Oracle installation and DB creation
- User management
- Tablespace management
- ASM
- RAC
- Backup & recovery
- RMN
- Utility used for the activities
- Performance tuning
- Neccessary activities (for maintenance & Management purpose)
- Data guard
- Replication tool
- Upgrade & Patching
- DB Migration
- OEM
- Security issue dealing
- Incident management
- Errors handling as a DBA.
- Database decommission request.
- Etc.
No comments:
Post a Comment