Hi friends, This is abdul raffeek working as a Sr.Oracle DBA in an Indian Based MNC, I would like to share something about Oracle DBA Work nature, day to day activities and advance concepts.
DBA Work Nature:
As an Oracle DBA, you can expect to be involved in the following tasks:
DBA Work Nature:
As an Oracle DBA, you can expect to be involved in the following tasks:
-
Installing Oracle software
-
Creating Oracle databases
-
Performing upgrades of the database and software to new release levels
-
Starting up and shutting down the database
-
Managing the database's storage structures
-
Managing users and security
-
Managing schema objects, such as tables, indexes, and views
-
Making database backups and performing recovery when necessary
-
Proactively monitoring the database's health and taking preventive or corrective action as required
-
Monitoring and tuning performance
Daily Activities:
In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.
Advance Concepts:
Datagurad, ASM and RAC
