A Reader writes:
What’s the value of a professional DBA?
I’m the Sr. DBA for a software development firm that deploys ERP applications on Oracle databases for companies across the country. Even though I’ve only been here a couple of years, I’ve been working with Oracle databases for over 12 years, and I’m dismayed that my company is using cheap foreigners who don’t even understands English, much less the fundamentals of good Oracle database management.
How do I convince my management that we’re sliding down a slippery slope by using cheap DBA and that it won’t be too long until we get frantic calls from people with systems down due to poor maintenance? Management doesn’t understand the complexities of database administration and I feel like my years of experience and knowledge are discounted by them requesting me to manage a team of semi-literate offshore DBA’s.
For the past year, I’ve been raising the issue and begging for them to hire qualified DBAs or contract with a reputable DBA support firm such as yours with very little success.
You wouldn’t buy a Formula One race car and let anyone work on it, but these companies think that any shade tree mechanic would do. If you have any advice at all or resources I could use to promote them hiring or having a qualified DBA available, I would love to hear it.
And we answered:
In these recessionary times, it’s tempting to cut corners and replace well-trained (and well compensated) DBA’s with cheap foreign pretenders. It’s penny-wise and pound-foolish behavior, sure to cause issues in the future. You are also correct that Oracle customers are not aware of the inherent complexities of Oracle that make it the world’s most robust and flexible data platform.
Penny wise and pound foolish:
You get what you pay for. If you want a DBA with an MBA and good technical experience, it can easily cost over $100,000 per year. Read these notes on the complex infrastructure required for corporate database management.
In the hands of a competent expert, Oracle gives a level of control over that data that is unprecedented, and a good DBA can control every aspect of their mission-critical database. In the hands of an inept of reckless beginner, Oracle’s powerful features become a weapon of destruction.
Untrained and inexperienced Oracle DBA’s are the bane of corporate America. Oracle Corporation white papers suggest that more than 75% of all Oracle database outages are attributable to human error. By hiring the services of recognized Oracle Remote DBA experts, you can avoid the potential downtime associated with human error.
Is my DBA staff good enough?
So how can you tell if a company has a qualified DBA staff? Guidelines for Oracle DBA best practices include many factors, both organizational and financial:
DBA Budget – Businesses that spend less than 15% of net income on Information Systems activities is likely undercapitalized. During tough times, the last place to cut-corners is on the manager of your mission-critical data. Many companies revenue streams are tied directly to the availability of their data.
DBA Quality – The DBA is the chief proprietor of the corporate information, a mission-critical job that is often at the same level as a vice president. The primary DBA often has a graduate degree in business administration and computer science, an essential melding of diverse skills that ensures that the DBA can work with all business functional areas on their data needs. See my notes on the qualities of a competent DBA.
At the end of the day, the amount spent on Information Technology activities is directly proportional to the value of the data. If the data is worth protecting, then the cost of the DBA is a small price to pay.
The perception of the quality of a DBA is also related to the changing economics in the market. In the early 1980’s the $40,000 DBA salary was a very tiny part of a ten million dollar mainframe budget. In the early 21st century, the $100,000 DBA salary is a much larger chunk of a two million dollar system. As the costs of hardware falls, the relative costs of human resources appear larger, and make a tempting target for the reckless manager, bent on saving money at the expense of putting their company data at-risk.
Are you willing to accept this risk?
When you use an unqualified DBA you not only put the quality and availability of your data at-risk, but you face even larger exposures:
Data Disclosure – I’ve fixed databases where a dishonest DBA placed a daemon to extract the Oracle data each day and e-mail it to China! A cheap DBA can cost you more than your data, it can put you out of business.
Data Losses – A simple disk crash could cost you thousands of dollars in lost data and reduce morale. I’ve been in shops where a botched recovery made an entire department do-over an entire weeks work!
Unplanned downtime – Some companies measure their downtime costs in hundreds of thousands of dollars per minute, and an inexperienced DBA can cause millions of dollars in downtime.
Corruption – As systems become more complex, an inept DBA can easily introduce data corruption into the database, causing permanent and irreversible data mangling.
Many companies will cease existence without their database, and the cost of data loss factors directly into the decision to use well-qualified DBA professionals.
Unfortunately, it’s only after a major catastrophe that miserly companies recognize the importance of having a properly-qualified DBA staff.
When choosing a DBA, experience trumps all else, but it’s the nature of the experience that matters most:
Real-world experience – The path to true Oracle expertise is paved with working on real-world, mission-critical Oracle databases. No amount of at-home experimentation can compare with the learning from working on a real production database. Many aspiring Oracle experts will work for free for non-profit charities in order to get this experience.
Quality experience – There is a wide variation in the quality of experience in the Oracle workplace. Not all experience is created equal, and a challenging high-performance database job will provide far more expertise exposure than baby-sitting a stable database.
Broad experience – A broad base with many different types of Oracle database is essential for developing expert status. I’ve been in shops with over 20 DBA’s, where job duties are highly segmented and Oracle professionals are relegated to “niche” work, like security administration, or full-time patch application. On the other hand, a single DBA is more likely to get a broader range of experience. The best place to get experience is as an Oracle consultant where you are exposed to dozens of novel databases each year. A well-rounded Oracle DBA will have experience in many areas including OLTP, OLAP and batch databases.
Their remain a two-tiered market for Oracle professionals, the traditional DBA role of data proprietor, and a secondary market for Oracle “baby-sitters”, neophytes with only a modicum of training and experience.
Ensuring that your data is secure can put your whole company out of business, and if they are lucky they will find-out the need for qualified experts before a data loss puts then pout of business.
Oracle Tips by Burleson Consulting
March 25, 2009