RE: DBA not bottleneck
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Jun 2004 09:17:56 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, June 09, 2004 8:04 AM
To: oracle-l@xxxxxxxxxxxxx
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????
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
