Management Information |
Get Down With OCP: Evaluating DBA Job Applicants in an OCP World
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? Robert Hamel Rob graduated from the University of Ottawa in 1987 and has been working with information systems ever since.
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Five Steps to Better Employee Management Hiring employees is a huge responsibility. Before hiring anyone, be sure to carefully analyze your needs in terms of extra assistance. How to Create a Positive Work Atmosphere Positive versus Negative WorkplacesWe have all worked in places where we grew to dread getting up in the morning, and a few of us have had the pleasure of working for a boss who makes us feel like we can do anything. Let's take a look at the differences between a positive and a negative work environment. 6 Simple Steps to Dealing with Difficult Managers The challenge of managing difficult managers can be rather daunting, especially when you inherit them! If they are your own born and bred, then hopefully they would have evolved into great managers!Experience shows that difficult managers are difficult because they are angry and frustrated about something or somebody (even themselves - especially where they are, or have become, a square peg in a round hole of a job), so the steps to take are these:-Always a first is to build great relationships with your people. This involves protected one-to-one time, where they feel valued. A Checklist for Organized Executives I could begin this article by providing a checklist of organizing techniques for you to incorporate into your daily work routine. The goal would be to become and remain organized, improve your time management and reduce your stress while increasing your productivity. Nine Vital Lessons For Avoiding Training Fads That Waste Time, Money and Enthusiasm Unfortunately, at least two thirds of much of the training and development effort undertaken by organisations to develop their people is wasted.This is such as shame isn't it? Waste of money is bad enough but even more serious is the waste of human energy and enthusiasm. The Truth About Performance Reviews Now that it is January, many of you are putting together, or have just finished putting together your annual Performance Appraisals for your staff. Feedback on performance is certainly one of the most critical aspects of personnel development and one that deserves to be taken very seriously. Five Ways to Turn Resistance into Opportunity Resistance. It isn't something people cherish or enjoy encountering. People Are Our Most Important Asset! How many times have you heard or uttered this phrase in the last 5 years or so. As a "reformed accountant" this phrase makes me cringe more than any other business euphemism being espoused today. Out of Control? There are papers on the floor, across the desk and resting on the keyboard. Piles of files are all around. Understanding How Change Has Changed There seems to be an assumption that change is a single traumatic event that is thrust upon us and over which we have no control.In the recent past this was definitely true, in industry there would come a sudden realisation at the end of the financial year that unless we did something radical we were going to the wall. Tales from the Corporate Frontlines: A New Managers Tale This article relates to the Manager/Supervisor competency, commonly evaluated in employee satisfaction surveys. This competency evaluates an employee's feelings regarding their direct manager or supervisor. Project Management - Are You Done Yet What happens when a Project Manager asks one of his team members "Are you done yet"?If you're a seasoned project manager, then the following scenario will sound very familiar. If you're new at this game, take my word for it: This will happen to you!------------------------------------------------------Starring in this article: R. Solving the Problem Solving Problem The meeting started like a hundred others before. There were five people sitting around the conference table, like they always did, trying to solve a problem that had popped up in the last few weeks. Ringing Doorbells Without Howitzers Many operations leaders have been there, done that with re-engineering. And they report, in effect, that the process is like ringing a doorbell with a howitzer shell. Setting a Pitiful Example: Twenty-six Warnings to Heed * TO: All Parents [and Employers and Managers]From: Your Child and/or EmployeeDate: The present timeRe: Don't Spoil me; Teach Me1. Don't spoil me. Innovation Management - Innovation or Profit? Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.There are other useful definitions in this field, for example, creativity can be defined as consisting of a number of ideas, a number of diverse ideas and a number of novel ideas. ISO 9001 Okay Now You Have It How Do You Market It? Marketing ISO 9001 2000.Lately we've been seeing a lot of press releases from wineries and suppliers touting their ISO certifications. Can Your Corporate Policy Pass the Monkeys, Bananas, and Water-spray Experiment? Five monkeys were placed in a cage. A banana was hung on a string and a ladder was placed below it. Hows Your HUB? Marketing gurus are always coming up with new lingo but oftentimes they are restating the old tried and true concepts in new terms. Marketing students from the 70's and 80's will be familiar with the acronym USP. Measure for Measure Can you imagine playing hockey without a goal? Basketball without hoops and nets? Football without a goal line? Golfing without holes or greens?There may be leagues where it doesn't matter whether anyone is keeping score, but not the big leagues. Champions of the Super Bowl, the Stanley Cup, the Masters can only be determined when there is someone keeping score. |
home | site map | contact us |