Re: what sort of dba can you get for 100K nowdays

and none of them did.

Yup. I myself have gone fairly backwards in my transition into the DBA
realm - I had been an infrastructure/network guy for years, and made
the switch to DBA cold. Went into the environment, and got busy
learning SQL DDL. I knew nothing about anything - tablespace? Not a
clue. Segment? Never heard of it. Basically, I was 'home-grown' in an
operational environment. And, I have learned. Over the past year and a
half, I feel I've gotten pretty reasonable at what I'm doing - and yet
I am not as familiar with the lower-level configuration principles as I
_should_ be - simply because I have not done it as many times as some
have, and because the time I have for academia is pretty lean.

I think that while spending time in mainly development environments
would benefit a DBA by forcing them to understand block sizes and file
system options like the back of their hand, there is a cost -
development environments don't see the same kind of _problems_ as
operational environments will see. In my case, I have been pretty light
on much of the low-level config stuff, but I have seen my share of
fires pop up - I recently had a situation where a developer using a
read-only account caused the entire Production SGA to clog up with
PL-SQL that had been generated by TOAD after running an Explain Plan on
a crap SQL statement. The entire Prod database dropped after an ORA-600
was thrown. Thankfully, it was at 4pm on a Friday. As a result, I am
teaching myself about standby databases for reporting.

As a potential employer, I am curious - if you had to choose, which
would you value more? Someone who knew the theory of planning and
deploying the physical and logical database inside and out, or someone
who had seen enough problems to be able to handle himself
intelligently, and with a cool head, when something goes sideways in
Prod and he's suddenly put on the spot?

BD

.

Relevant Pages

  • Re: Please Help
    ... RDBMS developers hang themselves. ... update-type query cannot violate the RI defined in the database. ... There is often not such a thing as a DBA in the Pick world and when we ...
    (comp.databases.pick)
  • Re: need access to read to SQL db and Access frontend
    ... I succeeded in getting to the actual .mde file on the network and linking to ... valuable since I can now see what tables are being used in SQL. ... tool tip with the path to the source database or DSN for the ODBC ... separate module/entity from dbA and doesn't need to be related but I ...
    (microsoft.public.access.tablesdbdesign)
  • Interview Questions(Oracle9i DBA), help me
    ... The DBA is attempting to back up the Oracle database control file. ... The request queue is common, and the response queue is different ...
    (comp.databases.oracle.server)
  • Re: need access to read to SQL db and Access frontend
    ... Does the documenter product a report and you just can't print it or is the ... tool tip with the path to the source database or DSN for the ODBC ... If the tables are linked to a SQL Server database or even another Access ... separate module/entity from dbA and doesn't need to be related but I ...
    (microsoft.public.access.tablesdbdesign)
  • Re: need access to read to SQL db and Access frontend
    ... Now I cannot print anything in the documentor. ... tool tip with the path to the source database or DSN for the ODBC ... If the tables are linked to a SQL Server database or even another Access ... separate module/entity from dbA and doesn't need to be related but I ...
    (microsoft.public.access.tablesdbdesign)