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

Home
>
Business Management
>
Get Down With OCP: Evaluating DBA Job Applicants in an OCP World

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.

In The News:

Yahoo! News: Top Stories

Democrats criticize Obama's proposed tax cuts (AP)

AP - President-elect Barack Obama's proposed tax cuts ran into opposition Thursday from senators in his own party who said they wouldn't do much to stimulate the economy or create jobs. Senators from both parties agreed that Congress should do something to stimulate the economy. But Democratic senators emerging from a private meeting of the Senate Finance Committee criticized business and individual tax cuts in Obama's stimulus plan.

UN Security Council calls for immediate Gaza truce (AP)

AP - The U.N. Security Council called for an "immediate" and "durable" cease-fire in Gaza in a resolution Thursday night even as fighting between Israel and Hamas raged with early morning airstrikes killing seven Palestinians and pushing the death toll to about 760 in the near two-week conflict.

Mini Dynasty: Tebow leads Gators past Oklahoma (AP)

AP - The game defied expectations. Tim Tebow fulfilled them. He rescued No. 1 Florida, running through and throwing over No. 2 Oklahoma for a 24-14 victory Thursday night that gave the Gators their second BCS championship in three years.

Key panel recommends impeaching Ill. governor (AP)

AP - A key panel unanimously recommended impeachment for Gov. Rod Blagojevich on Thursday, setting up a vote that could make him the first governor to face such fate in Illinois' sordid political history. Blagojevich should lose his job for abusing power, mismanaging government and committing possible criminal acts, including federal allegations he tried to sell off a U.S. Senate seat, the special committee concluded.

Job losses stack up as recession deepens (AP)

AP - Trying to survive a deepening recession, employers are cutting their work forces to the bone, leaving more Americans unemployed and with dim prospects of finding a new job any time soon.

Oversight panel wants better answers from Treasury (AP)

AP - Less than a month after its first report, a congressional panel overseeing the Treasury Department's $700 billion financial bailout is demanding more answers.

Critics' final answer: `Slumdog' wins 5 awards (AP)

AP - The critics have spoken, and "Slumdog Millionaire" is their final answer.

Cheney: CIA did nothing illegal in interrogations (AP)

AP - Vice President Dick Cheney said Thursday that he sees no reason for President George W. Bush to pre-emptively pardon anyone at the CIA involved in harsh interrogations of suspected terrorists. "I don't have any reason to believe that anybody in the agency did anything illegal," he said.

Petraeus: Afghan, Pakistan problems are really one (AP)

AP - U.S. policy to win in Afghanistan must recognize the poor nation's limitations and its neighborhood, especially its intertwined relationship with U.S. terrorism-fighting ally Pakistan, the top U.S. military commander in the region said Thursday.

Prosecutors: Madoff was ready to send out $173M (AP)

AP - Prosecutors said Thursday that investigators found 100 signed checks worth $173 million in Bernard Madoff's office desk that he was ready to send out to his closest family and friends at the time of his arrest last month in what is alleged to be largest financial fraud in history.

U.N. calls for immediate Gaza truce (Reuters)

Reuters - Israel pushed ahead with its offensive in the Gaza Strip on Friday, ignoring a U.N. Security Council resolution calling for an immediate ceasefire to the 14-day-old conflict.

World waits on jobs data as recession weighs (Reuters)

Reuters - U.S. employers probably cut the most jobs in at least 34 years last month as the global economic crisis gathered pace and moves by policy makers took time to filter through to struggling companies.

Citi backs measure to help avoid foreclosures (Reuters)

Reuters - Financial giant Citigroup Inc will support a proposal in Congress to rewrite U.S. bankruptcy law to help troubled mortgage borrowers avoid foreclosure, Chief Executive Vikram Pandit said on Thursday.

Panel steps up criticism of Treasury: report (Reuters)

Reuters - A report being released on Friday alleges that the U.S. Treasury has failed to reveal its strategy for stabilizing the financial system, not answered questions asked by a government watchdog, and has done nothing to help struggling homeowners, the Wall Street Journal said.

Illinois panel recommends governor's impeachment (Reuters)

Reuters - A legislative committee on Thursday recommended the impeachment of Illinois Gov. Rod Blagojevich, citing widespread abuse of power including allegations he tried to sell the U.S. Senate seat vacated by President-elect Barack Obama.

Obama team amending financial rescue package: report (Reuters)

Reuters - President-elect Barack Obama's economic team is urgently overhauling the $700 billion financial rescue package to broaden its scope beyond Wall Street, The Washington Post reported on Friday.

Qaeda Pakistan leader believed dead: U.S. official (Reuters)

Reuters - Al Qaeda's operations chief in Pakistan and a top aide are believed to be dead, a U.S. counterterrorism official said on Thursday, in what appeared to be the latest results of a campaign targeting the militant group's leadership.

Accused swindler Madoff "warm and charming": report (Reuters)

Reuters - Some friends of accused swindler Bernard Madoff considered him a "warm and charming" man, and one of his alleged victims praised him just before his death in 2005, Fox Business Network reported on Thursday.

Gaza toll mounts as UN Security Council urges immediate truce (AFP)

AFP - Israel carried out new deadly air raids on the Gaza Strip on Friday as the UN Security Council called for an immediate ceasefire to end the two-week-old conflict in the Palestinian enclave.

Progress in resolving gas row as Russia agrees to monitors (AFP)

AFP - Hopes for a quick resumption of Russian gas supplies to Europe were rising Friday after Russia agreed on the terms for the deployment of monitors in Ukraine.

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

Business Management Business Management