Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA not bottleneck

RE: DBA not bottleneck

Date: Wed, 9 Jun 2004 09:17:56 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00789@EXCHMN3>


   Welcome to the wonderful world of the split-personality DBA. On one hand you were hired primarily because of your technical skills. Then you are put in charge of a project that primarily uses your people skills. Ron has provided some excellent tips. You might check on Google for terms like "data cleansing" and "data warehouse". The DW people must deal with this all the time, so they have some pretty good tips for running a project like this. The magazines that deal with DW often have articles also.

Dennis Williams
Lifetouch, Inc.
-----Original Message-----

[]On Behalf Of
Sent: Wednesday, June 09, 2004 8:04 AM
Subject: RE:DBA not bottleneck


I am heading up a data cleansing effort.

The process goes like this:

-analysis done on current data
-users define business requirements for data transformation if necessary
-I ask questions because they often leave things out and this is what a good
DBA would do
-I write the process to clean-up data then ask users to test before we do in
-We do in production

I have been leading the meetings each day (30 min) and documenting resolutions, next actions, responsible parties, yadayada.

However, the user has come up with a number of business rules after going back and doing some analysis and saying "Well, I guess we didn't do that right the first time - and as much as I could I have been learning all the business rules and asking lots of pertinent questions" - all good everybody happy.

However, managers say "Hey, this should be done by now - not realizing the detailed analysis and testing this requires and multiple people" - so

I want to provide something back like how long it might take me to do - however, to be frank much of what I find when coding is more issues that need to be answered with a business rule that I cannot make up!!!!! So I do go the extra mile - not just fix the one thing - but also bring up pertinent and relevant issues and keep this train on track.

If they do good analysis and it takes them X number of hours to do that it doesn't take me long to turn around the fix.

If they miss something or in fixing that one thing I uncover yet something else on the system or need clarification it takes longer.

So, what do I say to these managers???? I am more help on this in all areas but since once the issues are identified (which I am one of the persons who finds and is able to generalize into a more concrete problem and find patterns across the database ), analysis is done (which I often help with), business requirements specified (which I often ask pertinent questions for to get clarification), I am the last guy holding the bag writing the clean-up process - which is actually done speedy quick - but since it is the last thing in the overall process it looks like I have had lots of time to do this.

Very frustrating. How do I help managers to understand this????

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at
FAQ is at

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:
put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Wed Jun 09 2004 - 09:18:00 CDT

Original text of this message