An awesome job with good management and advancement.
Pros: Free lunches
Cons: health care, vacation
Early in the morning at work,I check if databases are running (by using a shell scripts that check all instances )
check if users can connect to instances
In THE morning WHEN I get to work, I look at the incidentce logs(alert logs,batch jobs) and authomated jobs using shell scripts in unix/linux scheduled using the crontab and the schedular
batch jobs which usually contains companies order entries
backups (rman datapump and os backup to taoe or to cloud
change management /change request documented for auditing purposes
s the day advances monitor ( WITH shell scripts, alert log and oem)the databases attend meetings if any
do patching if it is the month for patching
Verify DBSNMP is running
Log on to each managed machine to check for the 'dbsnmp' process.
For Unix: at the command line, type ps –ef | grep dbsnmp. There should be two dbsnmp processes running. If not, restart DBSNMP.
I manage 5 databases using the Oracle Enterprise Manager(OEM) and Grid control.
I learn about possible failures most of the days
I cooperate and understand with my co-workers
The hardest part of the job is to resolve an ORA 600 that will require me to open a ticket with oracle cooperation.
The most enjoyable part of the job is when the data is secure, running optimally and monitoring well with no user complaining about long running queries.