| |
| |
|
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:
Google News |
|
|
|
RELATED ARTICLES
Business Opportunity - Leverage Your Employees! As a business asset, they don't sit well on the P&L statement. They aren't valuable like a piece of machinery, or an office block. Creativity and Innovation Management: Specialisation or Generalisation? 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. Top 7 Methods to Empower Employees How many times have you asked someone to do something like "draw up a plan for such and such project"? Your employee completes the plan, but then you say, "That is not what I wanted" or "That is not how you do it". And so the employee thinks: you didn't tell me exactly how you wanted it done. Why Business Owners Need Security The main reason is to stop any potential lawsuits from happening! But do you know how many individuals I have talked to about this very thing? Many! Do you know what the majority have told me? They have locks and cameras, so they don't need anymore security than that!This is a mess waiting to happen, the reason is as follows. This attitude is the reason things happen in business establishments that prompt major lawsuits from those that get hurt in some way while on the premises or by someone on the premises. Delegation - The Basic Steps To Reducing Your Workload And Creating A Successful Team If you have a task greater than you can handle on your own, then you need to delegate. Not a choice many of us choose to make, but one we can all learn. 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 is weak willed, having no momentum behind it. Action Learning: Its More Than OJT For centuries companies have used on-the-job training (OJT). OJT works because it follows much of what we know about adult learning theory. Middle-Aged Managers, the Forgotten Digital Divide The digital divide is defined by the role computers play within widening social gaps in our society, as the condition of one group having an advantage over another group in regard to computers, technology skills and Internet access.This is usually thought of as being a divide between the white middle class and minority communities; but there is another often overlooked class of nonusers, the middle-aged corporate manager. Manage or Lead - Why the Difference Matters and What to Do About That Difference Many books have been written about managing people, and an equally large number have been written about leadership. Some use the words manage and lead interchangeably, and some talk about the differences between the words, building a distinction based on style or behaviors. Use Noncompete Agreements To Protect Your Business Q: One of my former employees has launched an online business very similar to mine and is contacting my clients and trying to steal their business from me. Do I have any legal recourse against him? -- Brad J. Overcoming the Document Tracking Challenge "Where did it go? It was here yesterday. Wait. Let the Professionals Help You Out - Outsource As your website grows in terms of attracting more footfalls, generating more business, and providing more content; it will demand more time and attention from you to continue performing. As a businessperson, it is advisable that you concentrate on your core competency, which is the reason why you created the website in the first place. What is Knowledge Management Anyway? When you think of all the things companies have, you do not always consider the knowledge they have. For instance, a company is only as good as its employees, its resources, and its knowledge. How Your Feelings and Those of Your Employees Can Make The Difference How we feel is really more important than what we know. This is because how we feel plays a bigger role in our behavior than knowing what we should or should not do. Business Innovation - Organizational Structure 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. Employee Turnover: Is It Eating Up Your Profits? Keeping the cost of doing business down, yet providing a quality product or service, is one of the most critical components of success for today's leader. What many fail to realize is that employee turnover can represent a very substantial price tag to a company's productivity and its bottom line. 6 Shared Factors of Successful Executives These factors where determined by interviews with and books from very successful people. Factors which eminently successful people considered essential were collected and classified. Creativity and Innovation Management - Motivation and Management Layers 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. Firing Someone Without Resentment Firing, sacking, letting go or terminating people is unpleasant. There are ways to minimise resentment, but why bother? Because most legal action and unpleasantness stems from dissatisfaction/resentment about the way things were handled - about how rather than what happened. 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.
|
| home | site map |
| © 2006 |
