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.
 Google News Updated : Wed, 08 Oct 2008 02:50:04 GMT Obama And McCain On Small Business - CBS News
CBS News - The fifth installment of the series examines where each candidate stands on helping small businesses. Supported the government bailout aimed at easing the credit crunch. Obama-McCain debate Question 5: What sacrifices Ad Wars: McCain Dishonorable and Obama Untrustworthy Publ.Date : Tue, 07 Oct 2008 23:28:47 GMT Obama, McCain stretch facts in debate - The Associated Press
The Associated Press - WASHINGTON (AP) - Democrat Barack Obama and Republican John McCain stretched facts, sometimes past the breaking point, as they addressed the financial crisis and more during their second presidential debate. McCain, Obama Laud Buffett When Asked About Treasury Candidates Obama-McCain debate Question 2: How will Publ.Date : Wed, 08 Oct 2008 02:01:16 GMT Ayers and Obama later worked on Chicago charitable boards together - CNN
CNN - By Drew Griffin and Kathleen Johnston CHICAGO, Illinois (CNN) -- More than 30 years ago, William Ayers was a fugitive leader of the Weather Underground, an antiwar terrorist group known for its bombings of police stations, the Pentagon and the US ... Connelly: My tea with a 'terrorist' What’s The Obama-Ayers Connection? Publ.Date : Wed, 08 Oct 2008 00:55:44 GMT Fed's new tool: Business loan bailout - CNNMoney.com
CNNMoney.com - By Chris Isidore, CNNMoney.com senior writer NEW YORK (CNNMoney.com) -- The Federal Reserve announced a new program to help the battered market for short-term business loans - taking its closest step yet to lending directly to businesses. Fed's Credit Tactic Has Small Effect Fed, in emergency move, will lend to companies Publ.Date : Wed, 08 Oct 2008 01:33:46 GMT Bloomberg’s Gift to the People: Moi - New York Times
New York Times - By CLYDE HABERMAN An e-mail pen pal of mine in Alaska (no, not her, someone else) wrote the other day mentioning Marshal Philippe Pétain. UPDATE 1-NYC lawmakers to weigh bill raising term limits Bill to end term limits introduced in City Council Publ.Date : Wed, 08 Oct 2008 01:08:24 GMT World markets mixed amid ongoing bank jitters - Forbes
Forbes - By PAN PYLAS 10.07.08, 5:55 PM ET World stock markets were mixed on Tuesday as banking stocks on both sides of the Atlantic took another pounding despite the US Federal Reserve's announcement that it will buy huge amounts of short-term debt in an ... TOPWRAP 15-Fed steps in but US stocks dive; UK to rescue banks Patrice Hill THE WASHINGTON TIMES Publ.Date : Tue, 07 Oct 2008 22:03:58 GMT Judge Orders 17 Guantánamo Detainees Freed - New York Times
New York Times - By WILLIAM GLABERSON WASHINGTON - A federal judge on Tuesday ordered the Bush administration to release 17 detainees at Guantánamo by the end of the week, the first such ruling in nearly seven years of legal disputes over the administration’s detention ... White House "Deeply Concerned" With Guantanamo Ruling US judge orders Guantanamo Uighurs freed Publ.Date : Wed, 08 Oct 2008 01:49:29 GMT Amazon RSS Feed Generator |
PARLOT::Ebooks, Scripts,
Websites, and more... Rejection hurts. No one likes to give it or to... Read More Implementing an ISO 9001 system represents a major effort. However,... Read More Do you announce a meeting and find either no one... Read More We all spend time on planning vacations. If it's not... Read More Standardizing Quality SystemsThe ISO, or International Organization for Standardization, was... Read More The point of a quality improvement program should not only... Read More Why do some new managers succeed while others fail? It... Read More Creativity can be defined as problem identification and idea generation... Read More When you are acclaimed for excellence during times of crisis... Read More Creativity can be defined as problem identification and idea generation... Read More Even in today's still uncertain economic times, there are companies... Read More There are some very simple guides for delegation.Most people delegate... Read More Life can sometimes be unexciting if not refreshed by the... Read More Many entrepreneurs and chief executive officers are unaware that there... Read More The methods in which you set up a conference call... Read More At one time or another, all of us have experienced... Read More Are you one of those bosses that people just love... Read More Last week I was confused and frustrated about a few... Read More The great majority of family businesses in North America are... Read More As a small business operator, personal checks may be one... Read More "Ha!" you say. "For someone to make a statement like... Read More One of my earliest childhood memories is watching Lew Alcindor... Read More In the bestseller, Good to Great, Jim Collins discovered that,... Read More Where there is people there is politics! Bullying is now... Read More Surveys of executives reveal that many companies fall short of... Read More
Adsense
websites
How to Say No
Steps to Build ISO 9001 Compliant Program
What Every Manager Should Know About How to Conduct Successful Meetings
Project Managment: Land the Plane Stop Doing and Start Succeeding
Quality Standards with ISO 9001
Quality Improvement is Free
Employee Orientation: The 90 Day Difference
Innovation Management ? some ideas are better than others
MANAGING CRISIS; when you?re too good at it
Creativity and Innovation Management: The Creative State
Satisfied Employees, A Powerful Marketing Strategy
Delegation: When to Delegate, Who to Delegate to
A Renewed View of the Modern Business Culture
Have You Always Thought That The Best Ideas Come From Research Or Management? Think Again
How to Set Up a Conference Call
Medical Collection. How Organized is Your Office?
Being a Great Boss
Riding the Waves to Success
Five Steps to Successful Business Succession
What to do When You receive a Bad Check
Leadership Skills Means Turnover is Not a Problem
Focus and Shoot
Truth or Consequences: How to Give Employee Feedback
Bullying and the Not for Profit Organisation
Managing Rebellious Employees
Affordable and Reliable Web Hosting Starting at $4.49/Month
Avoid These Seven Deadly Dangers Of Outsourcing
Here are seven dangers of outsourcing your software development. They... Read More
Organizational Capital in Politics, War, Sports and Business
Intangible Corporate Assets such as Organizational Capital, Blue Sky and... Read More
Steps in Using the Critical Incident Technique
STEPS IN USING THE CRITICAL INCIDENT TECHNIQUE:1) The incident. Read,... Read More
Seeking Help
Where does the time go? Billable time. As a consultant,... Read More
The Best Way to Keep Track of Meetings
How should you keep track of meetings?Have you ever wanted... Read More
How to Find the Right Virtual Assistant for You
If you search on Google for "virtual assistant", you'll find... Read More
Never Punish Yourself or Others for Failures
If you want to find success in various ramifications, be... Read More
Performance Expectations - 5 Tips and 5 Questions
People want to understand their role - they want to... Read More
Effective Meetings: Why Most Meetings are a Waste of Time
Whether your company holds one meeting a week or dozens... Read More
Success in Business Means Managing Negative Emotions
You may have the MBA but if an internal critic... Read More
What Makes A Good Media Story?
Media relations can be difficult, but also rewarding. And the... Read More
Hiring and Retaining Good Employees
Hiring good employees is not only important to business, it's... Read More
Parenting Your Employees to Better Performance
Have you ever worked for someone who was such a... Read More
Group Decision Making : Are the Decisions Really Made by the Group?
GROUP DECISION-MAKING: Many managers feel they are well-versed in areas... Read More
Innovation Management ? changing the world!
Creativity can be defined as problem identification and idea generation... Read More
Three Ways to Transmit Loud and Clear
The heart of a fool is in his mouth, but... Read More
10 Resolutions For The New Year!!
Each year many people create a list of resolutions designed... Read More
Partnering for Performance
"The difference between a boss and a leader: a boss... Read More
Outsourcing Problem Analysis
As an HR professional, you have responsibilities in several broad... Read More
The Diamond Cutter
Geshe Michael Roach is a Princeton graduate and a Buddhist... Read More
Invoice Factoring for Goverment Vendors
Assignment of Claims Act of 1986"....What does this mean for... Read More
Marketing Miracle: Outsource Your Creative Services
The current economy is causing most companies to tighten their... Read More
Time Management and Team Development - The Yes and No of It
Sometimes.In fact making some small changes to the circumstances when... Read More
Six Sigma Training 101 ? Better Management Basics
What is Six Sigma?Six Sigma is a quality management program... Read More
Five Ways to Influence Change in Others
Because of my work as a consultant, trainer and coach... Read More
Business Management |