| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA not bottleneck
Paula
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
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Paula_Stankus_at_doh.state.fl.us
Sent: Wednesday, June 09, 2004 8:04 AM
To: oracle-l_at_freelists.org
Subject: RE:DBA not bottleneck
Guys,
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
production
-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????
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |