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
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.

---

Year 2010: Permanent Employees No Longer Required

Jack Welch joined a conference that was held in Duke Fuquay Business School where he was invited to promote his new book called "Winning". He told audience... Read More

Tales from the Corporate Frontlines: Training is in the Eye of the Beholder

This article relates to the Training competency, commonly evaluated in employee surveys. It comments on the value of training to both the company and its workforce. The... Read More

Customer Focus - Just 5 SimpleThings You Need to Think About

You can boil down the difference between successful businesses and the rest in how they work with their customers, in just five areas.So, what does this mean?... Read More

Partnering for Performance

"The difference between a boss and a leader: a boss says, 'Go!' ? a leader says, 'Let's go!'" -E. M. Kelly* Are you a boss or a... Read More

Delegation: When to Delegate, Who to Delegate to

There are some very simple guides for delegation.Most people delegate based on not wanting to do something. They simply walk out to their secretary or the closest... Read More

Setting Clearer Performance Expectations

The annual performance review.Stating this phrase guarantees some reaction for anyone who has ever had one, or had to give one as a supervisor or manager. In... Read More

Hidden Consultants Within Your Organization

You've all heard the old joke about a consultant being someone who uses your watch to tell you the time, and then steals your watch. There's some... Read More

Recruitment - What Youre Really, Really Looking For

Imagine that you're a sports coach and you need a new player on the team. Would you walk up to someone in the street and say -... Read More

The Seven Cs: Partnership Danger Signs - The 6th C: Changing Vision

A series of articles exploring the seven critical areas that can indicate a partnership is in trouble.The 6th C: Changing VisionIn order for a business to be... Read More

Are You Using the Right Form of Energy?

As we near the end of summer, here is a question I have for you, "Are you using the right form of energy to grow your business?"... Read More

MANAGING CRISIS; when you?re too good at it

When you are acclaimed for excellence during times of crisis you may not feel so good in a non-crisis environment. You may not shine so bright, perform... Read More

Check Your Communication Skills

Use this check list to assess your communication skills.Focus* Do you pay complete attention to others when they are speaking? (A wandering focus discourages open communication.)* Do... Read More

Importance of Just-In-Time Inventory System

In today's competitive world shorter product life cycles, customers rapid demands and quickly changing business environment is putting lot of pressures on manufacturers for quicker response and... Read More

How To Write Commercial Collections Letters

It is sometimes valuable to bring the sales manager into this step of the collection process. Information concerning the delinquency can often be obtained from the sales... Read More

The Ten Keys to Maximizing Employee Performance

1. Let people know what you expect. If people know what's expected of them, that's what they'll do--if they don't know what's expected, they'll do something else.... Read More

5 Creative Evolutionary Leadership Niche Strategies!

I have a short story to share with you about an important skill many leaders need to develop, use and perfect.Life is a journey. The signposts along... Read More

How to Hire the Right People

One of the biggest challenges any business owner or manager has is hiring the right people. I've recently discovered a simple, inexpensive yet very effective way which... Read More

Weaknesses of Wishing

When you're starting a business, you might wish for a lot of things, like having more than enough customers or not having to do marketing. But wishing... Read More

Just The Facts

Attitudes are more important than facts. Dr. Karl Menninger Attitudes are intangible and highly personal. They're based on your experience, but more importantly, on your interpretation... Read More

Delegate, Dont Abdicate

One of the key skills for the leaders of growing businesses is to 'get' the distinction between delegation and abdication.Many managers and business leaders fall into one... Read More

Smart Staffing Practices: Don?t Confuse Activity with Results

Does your hiring process consist of proven practices or just a hodgepodge of activities that get into gear when someone says, "I need more people" or "Sally... Read More

Managers Who Spend PR $$ Wisely

If you are a department, division or subsidiary manager, your budget is a precious possession whether you work for a business, a non-profit or an association. So... Read More

Biometrics and ?Return On Investment?

At this time of tight budgets, the mantra of business is "Return On Investment!" With few exceptions, expenditures are measured against the bottom line. Outlays for capital... Read More

Improving Your Inter-Company Communications At No Cost

It's all very well having a flashy (and expensive) advertising campaign, backed up by a wealth of positive PR, but if your staff are not all pulling... Read More

Marketing Miracle: Outsource Your Creative Services

The current economy is causing most companies to tighten their belts. With limited staffing and a restricted budget, how do you continue to promote your business? The... Read More

Employers - Protect Yourself from Custody Battles that Hold Your Company Hostage

Child custody? How'd that get to be an employer's concern?When an employee faces child custody litigation, it will effect their ability to do their job. And it... Read More