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
DBA Team Lead
Rob has served as the applications architect for one of the largest government databases in the world, as well as a primary architect on a database with one of the world's highest record of transactions per second. Before joining The Pythian Group in 2000, he worked for numerous corporations and government agencies, including Human Resources and Development Canada and Elections Canada. An acknowledged expert in the field, Rob excels in application architecture and application performance tuning.
Rob graduated from the University of Ottawa in 1987 and has been working with information systems ever since.
Have you ever tried to drive somewhere without proper directions?... Read More
Check Out Your E-HabitsAnother week has ended. And, despite moving... Read More
The overriding goal of ISO-14000. (History 1995)As ISO-9000 becomes a... Read More
Several decades ago, a passenger jet approached a Florida airport... Read More
Implementing an ISO 9001 system represents a major effort. However,... Read More
"We have to be careful it's like a minefield out... Read More
How content and satisfied are American employees? Not very!According to... Read More
Although this performance discussion is an opportunity for you to... Read More
Although there are real, external reasons for managerial difficulty ?... Read More
The industrial age is over. Organizations still stuck in the... Read More
Creativity can be defined as problem identification and idea generation... Read More
This article relates to the Manager/Supervisor competency, commonly evaluated in... Read More
Facilitating good communication can make the difference between a well... Read More
Creativity can be defined as problem identification and idea generation... Read More
One of the greatest time wasters of all are unnecessary... Read More
Modern business faces complex problems; management often calls upon highly-specialized... Read More
The end of the television season in May included the... Read More
Creativity can be defined as problem identification and idea generation... Read More
INTRODUCTIONThe typical approach executive teams use to cascade, or roll... Read More
Human communication is always three-dimensional. No spoken or written message... Read More
Question: ERPs seem like a good idea, so why is... Read More
When you have to deal with one of your team... Read More
It is becoming more common for employers to require employees... Read More
The title of this article sounds like simple advice, but... Read More
We had a problem with handling materials in a production... Read More
TEAM DECISION MAKING: Managers who invite participation believe that people... Read More
My background is in retail management - yes, running stores,... Read More
As an experienced manager, I can announce without a doubt... Read More
INTERNAL PUBLIC RELATIONS: Never overlook an opportunity to do internal... Read More
WHAT MAKES A GOOD APPRAISAL INTERVIEW?Here is a tip for... Read More
Lack of Operations Manuals stunting your growth?CONTENTS:1. Do you lack... Read More
There's a common phrase used by Organizational Development and Human... Read More
These factors where determined by interviews with and books from... Read More
The Fundamentals of Strategic Marketing, Some Key Traits for Greater... Read More
Here is a true story. My dentist did a "clinical"... Read More
In any organisation, progress is frequently impaired by the time... Read More
How can you get more attention for your conference and... Read More
You had better care! Because what people think usually leads... Read More
Creativity can be defined as problem identification and idea generation... Read More
Surveys of executives reveal that many companies fall short of... Read More
Stop hiring new administrative support staff. And learn how to... Read More
In September 2004, President Bush signed the $146 billion tax... Read More
I'm always fascinated by the people who lift huge weights,... Read More
Okay, be honest!Are you guilty of sticking in a few... Read More
Even in today's still uncertain economic times, there are companies... Read More
Ok, you say, I know I need a budget, but... Read More
Modern business faces complex problems; management often calls upon highly-specialized... Read More
Yet there is a place for those external 'raft-build's', 'away... Read More
"We have to be careful it's like a minefield out... Read More
Effective communication in business is not about creating the perfect... Read More
Great Groups! - Getting a Group to Think Like a... Read More
Your people are invaluable to you. They are the lifeblood... Read More
Sometimes when I conduct my workshop on Effective Meetings, one... Read More
It is 9:00 am on a Monday morning. Do you... Read More
Recruiting and hiring are often done in haste, leaving the... Read More
Creativity can be defined as problem identification and idea generation... Read More
With deference to Dr. Covey and his very popular Seven... Read More
Succession Planning provides many valuable assets to your business. Yet... Read More
What you say to other people can make or break... Read More
Email, when used properly, can generate additional direct sales and... Read More
Working virtually adds a whole new dimension to the phrase... Read More
WHAT MAKES A GOOD APPRAISAL INTERVIEW?Here is a tip for... Read More
If you search on Google for "virtual assistant", you'll find... Read More
We go to meetings to share information, to report on... Read More
What principles should a company keep in mind when developing... Read More
"It is not the strongest species that survives, nor the... Read More
Business Management |