Jr. DBA needs Senior DBA's Advice..!!
The_RockJan 18 2008 — edited Jan 18 2008Dear all Senior DBA’s
I need you advice/suggestions.
I m Oracle9i DBA OCP Certified, Currently working as Assistant DBA. I m working in Oracle10g based Environment; it’s been around four months now, I m writing below my duties as DBA:
1. There is checklist that I need to submit to IT Manager that shows the status of Oracle Services, Listeners, Archived Redo Log Numbers, Hot Backup & Export of Primary, Standby and Test Databases.
2. I used to take the export of live user before updating the live database with Queries, Procedures, and Functions, forwarded by Software Engineering Department.
3. I take the export of live database user and update the test database user with the latest dumps.
Other things I have learned:
4. I learned how to configure Stand By database. It was test project for me, NOT a live project, but I learned a lot.
I have written all the steps in my blog:
http://rakeshocp.blogspot.com/2007/12/creating-stand-by-database-steps.html
5. I was 9i Certified, and it is good learning for me to use 10g Database at Live environment.
6. I have studied RAC, and waiting for Blade Servers, and green signal from Management, then I will learn Live RAC Project.
Now Confusion here is:
Once I check the CheckList, I wait for the work, but hardly get any kinda database related work, only I do execute scripts, and exports/imports. Is that the overall role of DBA besides implementing above mentioned projects?
I need your advice, I m willing to learn, but I don’t think I will be learning in the above DBA duties.
I want be a good/expert DBA.
Could you please advice/guide what should I do?
Rakesh Soni
http://rakeshocp.blogspot.com/