Get Down With OCP: Evaluating DBA Job Applicants in an OCP World



Learn Management Articles on management-info.biz. Get Down With OCP: Evaluating DBA Job Applicants in an OCP World article will help answer your questions on Management Articles.We at management-info.biz specialize in Management Articles. Management Articles at management-info.biz provides the most up to date news and articles. If you have questions please do not hesitate to contact us.

Not long ago, weeding through DBA applicants with a tech interview was a straightforward process. You'd ask candidates 200 or so technical questions. If they got 100 correct answers, you knew they'd been around the block; 150 or more and you knew you were on to superior talent. But once the Oracle Certification Program (OCP) became popular in the late 90s, the traditional tech interview lost its effectiveness. These days, candidates can answer 180 questions correctly and you still won't know whether they're talking from experience or simply regurgitating what they memorized at OCP a few weeks earlier. Although it has become increasingly difficult to determine whether you've found a seasoned, highly qualified DBA or a newly minted OCP Graduate, there are ways.

First, start by throwing out the questions. Any candidate who has been through OCP knows the answers—all of them. That list that helped you find superstar employees in the past is unfortunately useless now. Second, if you are a manager without solid database experience, enlist the help of an experienced DBA to help you prepare that critical interview. IT Managers have varied backgrounds and here it's important to pull from the right background, be it yours or someone else's.

You also need to analyze your needs. If you're looking to hire a junior person and mentor them, the OCP program ensures that the candidate has been exposed to most areas of the Oracle RDBMS. You can assume you'll have an employee who knows the commands and has a general concept of how a database works. But if you select an inexperienced OCP candidate thinking you're getting a skilled veteran, you'll be in for countless unpleasant surprises. Typical horror stories sound like: A DBA restores the backup for the first time in a real-life situation, finds out the backup strategy was flawed and loses the whole database. S/he probably also forgot to make a backup of the database before attempting the recovery, therefore rendering Oracle support intervention nearly impossible.

A DBA recommends technical implementation decisions based on limited experience with a single user database that has 10 tables of 100 rows each. Of course, the system hangs a few hours after the launch—as soon as 10,000 users start pounding on a 500GB database.

The most damaging aspect of newer DBAs is that they don't know when they are in over their heads, or how to plan properly. Senior IT professionals, no matter their field of expertise, have a gut feeling when it's happening. They know they have to step away, talk things over with a peer, roll everything back, and try another day. Inexperienced IT professionals are fearless and can therefore be dangerous, especially if they're expected to run the show.

So how do you find truly qualified DBAs in an OCP World? Put them to work—in the interview, that is. Create real world situations where candidates are allowed full use of any familiar online resources, and see what they can do. Some examples:

Want to check out their data modeling skills? Give candidates a hypothetical business that everyone understands, like a video rental store, and a basic set of business requirements. Put them in front of a white board and let them create a model that meets the stated requirements. You play the role of a subject-matter expert who is decidedly non-technical, and have them walk you through the results.

Wondering how they handle troubleshooting? Set up a database with various performance anomalies such as poorly written queries, missing indexes, and internal resource contention. Have applicants deal with the issues and walk you through their methodology. They can't use automated tools. The Oracle Data Dictionary and OS basic facilities must suffice.

Want to see if they know how to minimize downtime? Pretend you're a client who wants to upgrade a 500GB database from version X to version X+1. It's a 24/7 environment and each hour of downtime costs $10,000. There will be downtime regardless, but the DBA should be able to generate scenarios to keep it at a minimum.

Whatever skills you're looking to assess, make sure you test candidates in situations they can't prepare for and can't fake. The new interview process isn't quite as easy as those trusty old 200 questions. It requires more up-front planning and often more time in the interview room. But if it saves you from having to fire incapable employees who wreaked havoc on your database, it's probably worth it. A little advance preparation can save a whole lot of time, money, and hassle down the road. And isn't that all we're looking for in this crazy, mixed-up OCP world?



Worldwide House Sitting Directory. - Home owners search Free our extensive Worldwide database of housesitters. House sitters make yourself available.
The Way To Trade. - A breakthrough approach to trading in any market (world beating affiliate program)


Article Index: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81


More Articles:


1. Improvements In A Large Public Electric Utility In South America By Jose Sanchez
The company decided to develop and implement an improvement program. The main thrust was to propose strategies and alternatives for the implementation of a quality program.Later on, the company declared the "Year of Quality", which kicked off the beginning of an improvement program focusing on providing better service and paying more attention to the customers. That same year, after several internal attempts on the part of the company to carry out such a program, executive management requested…
Property Management Indianapolis

2. Use Noncompete Agreements To Protect Your Business By Tim Knox
Q: One of my former employees has launched an online business very similar to mine and is contacting my clients and trying to steal their business from me. Do I have any legal recourse against him? -- Brad J.A: I hate to break this to you, Brad, but unless this former employee signed a noncompete agreement while on your payroll, there is probably very little you can do to stop him from wooing your customers. You should discuss the situation with your attorney, but unless this person is al…

3. Planning Your Recruiting Efforts Can Help You Find Great Employees By William Von Achen
Today, companies have an ever-expanding list of options available to them when it comes to sourcing new employees, from advertising in newspapers and trade journals to powerful, cost-effective recruiting options available through the Internet. Unfortunately, the growth in the number of recruiting options available has made the competition for top candidates even more fierce.So how do you break out of the pack to find the people that you need? Like most other business activities, a successful…

4. Take Action with PMS - Productivity Management SystemTM
“Success is about deciding what’s important versus what’s irrelevant in your life; it’s about self-motivation, self-discovery, self-confidence and enjoying the rewards of achieving your goals.” Heidi Richards This is part three in the PMS - Productivity Management System™. This is your to-do list of processes and steps you must take in order to fully realize your goals. Once you have crystallized exactly what it is you wish to accomplish, it is important to know which steps you must take and in…