Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??
Most of the Perl programmers I know are reasonably competent with database work on platforms such as MySQL and Oracle.

Over half of them are quite well-versed in database work and have built both the data and code for at least one reasonably sized application from scratch. About a third of them are triple threats: They could build a reasonably sized application from scratch including all of the required systems design and administration.

It sounds like the person you're looking for may be someone who can do just that: Take a set of requirements and do everything except perhaps the system administration. They may be working in somewhat of a vaccuum if there are no other DBAs on staff.

In this case, I would highly recommend focusing not just on whether a candidate has built data-centric applications using a database similar to the one you would propose to use, but on whether they have designed a data solution (e.g., everything from the table structure including constraints to indexes to triggers and stored procedures if necessary). Ask them to sketch an ERD for a schema they've designed on a whiteboard during the interview to make sure their skills live up to their claims.

Being able to pull information out of a database is a whole different beast from designing a schema which is reasonably efficient, scalable, and extensible.

I also second Ryszard's comment. With some projects you are best off hiring a bright but inexperienced (and inexpensive) coder. However, when you hiring someone to be a one-person band, you get what you pay for. If you are looking for someone to single-handedly take the project from requirements gathering to initial release or beyond, you will save yourself time, money, and heartache by paying more for someone with more experience.

Hope this helps :-)


In reply to Re: Hire a Perl programmer and get a database guru free? by Starky
in thread Hire a Perl programmer and get a database guru free? by wil

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others meditating upon the Monastery: (11)
    As of 2014-12-29 17:13 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      Is guessing a good strategy for surviving in the IT business?





      Results (194 votes), past polls