Re: Multiple DBs - Balancing Act

2003-08-14 Thread Thomas Day
Our basic distinction is between production and development. Production DBAs carry pagers, are on call 24/7, and get the big bucks. They also specialize in recovery and (some) tuning. Development DBAs are kinda split three ways --- physical database development (create new development, training

Re: Multiple DBs - Balancing Act

2003-08-14 Thread Stephen Andert
(trying again with "bad" word modified ) Mike, We rated our databases based on factors such as vocal customers, database size (larger database might require special handling), development stage (new, rapidly developed apps tend to cause more work) and daily troubleshooting (anything with a pipel

Re: Multiple DBs - Balancing Act

2003-08-14 Thread Tanel Poder
Hi! I would put it that way: 1) you got a bunch of databases 2) these databases need work done on them 3) therefore you got a bunch of DBAs And the dimension ranges are: 1) a database can be unimportant .. very important easy to maintain .. hard to maintain need little skills .. need muc

RE: Multiple DBs - Balancing Act

2003-08-14 Thread Stephen Lee
At WorldCom, the manager tried to make as good of an assessment as he could make about how much time supporting each of the databases would require and divided the databases up as evenly as he could. Each DBA was the primary for a certain number of databases; and just about everyone could be cons