ROLE OF A DBA

My #1 priority is to automate myself out of a job (of course, AFTER answering questions on dbasupport.com). The more automated the operation of my databases are, the more valuable I am to the organization. Sure, there are some shortsighted organizations that measure your productivity by how much time you spend doing the same "busy" work every day, but my organization measures your performance by how much $$$ you can save for backoffice operations.

For example, I just spent 2 weeks developing a system that will automate tablespace storage management. If one of my datafiles starts growing and approaching it's maxsize, a process will automatically add another datafile to the tablespace. I've basically automated 1/2 of a Jr. DBA. I can then take that Jr. DBA and expand his knowlege so he can grow and concentrate on other things critical to the business.

well u all are very great people.

Gayatri sorry for being harsh with u !!!

-----------------------------------------

I was looking into comment put by subha in this forum
i was trying to figure out how the dba could solve the problem.
did u guys read her posting ? 4 page.

she says that export backup was the only backup method the guy was knowing.
the system gets crashed.
with the import backup it didnot work, nor it worked when the database was created at fresh.
then they found that export backup was corrupt.
and finally the guy extracted the data ,

so i just wanted to know what did that guy do ? how he brought the database up and running ?
any thoughts /ideas ?

--pravin

looks like almost all acitve participants are in this thread...
so letme too join in....

!!!! Long live DBA !!!.

Jr.

Hi,

As sharma said "The DBA role differs from site to site" I manage 15 Databases in my site. I work 12 to 14 hrs a day, most of the weekends too. I am not sure what you are trying to imply on the DBA role.

Thanks

And besides anything else miss gayatri,
post questions like these in another forum(i'll let the moderators decide on that). probably ocp.
Here it'll be interesting if you'd post questions regarding db administration./problems/issues.
ASSUMING that you have some.......;)

Quote:

---

I think the role of DBA is very small part in a system life cycle. But to many this is a bread and butter. And this role may be interesting to one when he/she is of young age.

---

I am inclined to agree with tamilselvan. Just a DBA, well, at some point this may become boring. Once a database is tuned and stable, there is really not much to do with it for 8 hours a day. I personally enjoy programming with PL/SQL, Forms and Reports. Some business programming with PL/SQL could be more challenging that the DBA tasks.

But, again, depends on your shop.
I do not think that a DBA that "has" a few hundreds instances or just a single one, but mission critical, ( in finance/banking, for instance) could become "bored"... :D

Quote:

---

Originally posted by ovidius
But, again, depends on your shop.
I do not think that a DBA that "has" a few hundreds instances or just a single one, but mission critical, ( in finance/banking, for instance) could become "bored"... :D

---

Right. It's true what you are saying. Have in mind however that there are people and people....

Hi Gayatri ,

I agree to most of view but to achive the state mention in Ideal situation but to get into this ideal situation one certainly requies DBA Services in place.

Also We should not forget Chaos Theory where any inpredictable thing can occure in System and System could fail.

The realy importance of DBA felt in crash conditions where a small error can cause cost of Millions

To avoid all these DBAs are required becaz they monitor the system so monitoring can never be "Just Monitoring"


regards
viraj
[email protected]

Quote:

---

The realy importance of DBA felt in crash conditions where a small error can cause cost of Millions

To avoid all these DBAs are required becaz they monitor the system so monitoring can never be "Just Monitoring"

---

This is very well said and true.