Need DB Redesign advice

  • Great points indeed. I mean no disrespect to DBAs. I'm just used to having to wear many hats and am not knowing of all tasks for someone who only works with the database portion.

    My boss said very clearly no to hiring an employee, but yes to periodic consulting. That's a start I suppose.

  • allbymyself (3/24/2011)


    Great points indeed. I mean no disrespect to DBAs. I'm just used to having to wear many hats and am not knowing of all tasks for someone who only works with the database portion.

    My boss said very clearly no to hiring an employee, but yes to periodic consulting. That's a start I suppose.

    None would be taken. You can either master one slope or you can ski the mountain, to turn a really bad metaphor. Good DBAs don't necessarily know a lot about the other portions of IT and they don't usually spend a lot of time researching them, either.

    From what you've mentioned, what you really need is an architect and/or developer, not necessarily an administrator. I would recommend getting one in for a week to allow them to do an evaluation. From your description, my guess is it would take them about 2-3 weeks to rough out a high level correction to your design, 2 to 3 months to create it at the detailed level and implement most of it, but noone would commit to any timelines without being allowed some research time.

    As long as you sit in with him while he works you should be able to improve your skillset tremendously while they're there, as well, so have your boss think of the ROI in two parts, if you can convince him. Half corrections to the existing system, and half training of the guy he wants to keep around. 🙂


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • I'll second what Craig wrote.

    Get someone in on a short-term contract to look over the architecture. You'll get the most out of that. Even if you don't keep them for the fix, if they give you a good plan for it, you might be able to implement it yourself.

    There's no real telling how long it'll take, even for a seasoned pro, but a couple of weeks for a good analysis, and proceed from there, sounds about right.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply