RE: OT - Opinions on workload
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'wbfergus@xxxxxxxxx'" <wbfergus@xxxxxxxxx>, 'Oracle-L List' <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Sep 2011 08:22:15 -0500
I would probably argue for training one of the existing office members in the
use of ARC and the GIS front-end and work with an Oracle dba on a short-term
contract to setup the Oracle database objects & security.
Then, you could pay that dba consultant as an "on needed" basis to provide
support etc and work with the ARC application developer on new modifications
etc.
Just my $0.02
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bill Ferguson
Sent: Thursday, September 01, 2011 8:13 AM
To: Oracle-L List
Subject: OT - Opinions on workload
Hi all -
I have a generic question that hopefully some of you have experience at.
What do you think the IT requirements would be for a project that wants to take
an existing Oracle 11 database (roughly 40 data tables) and add a GIS front-end
to it with ARC (probably the Enterprise version, for multi-user, multi-editor).
This is all still in the planning stages (for another month), so I'd like to be
able to provide some facts for the person proposing the project. So far, it
sounds like they are only planning on one part-time IT person.
This person would be responsible for everything Oracle and ARC-GIS related,
including installing, configuring and maintaining an ARC-server installation,
the main Oracle database, probably a dummy Oracle database in-between (to avoid
giving ARC DBA rights in the real database), all of the programming, user
support (for the ARC and Oracle parts), maintaining a 5 person office with it's
LAN and associated hardware, etc. There are several schemas within the database
for other projects, but (so far) only one of the schemas will be GISable
Is it realistic for one person to actually accomplish all of this with only a
40 hour work week, or would more folks be required, in your own professional
opinions? Keep in mind that 250 hours (a little over 6
weeks) of the work year is wasted on security documentation, plus roughly 2
months each year for Annual Leave, sick time, training, maintaining the other
schemas and their associated programming, etc.
So, this only leaves about 38 weeks each year (maximum) that could be spent
working on and maintaining the above, along with training new users, developing
new code for added functionality, etc.
Things are still in the planning stage on this, and I think the workload
estimate is way to low, and the person stuck with this will burn out extremely
quickly, but I would like to have some case examples before the person
proposing the project finishes up. I'm only an IT person, not a scientist, so
obviously I have no idea what I'm talking about when it comes to these
gosh-darn technical issues, so some actual case examples from those of you who
have either done it or seen it done, and how it worked (or failed) and why
would be useful. I really don't have much hope of this project actually
requesting (and
recieving) any extra IT support, and just the Oracle end of it has been keeping
me busy, around 80 hour weeks without additional compensation. I just really
don't see how this can be successful based upon my own experience and
knowledge, but perhaps I am missing something?
Thanks for any and all input.
--
-- Bill Ferguson
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
