37 replies
by todd parker
What about us SQL Server DBA's? Are we in less of a demand? Does SQL Server have less downtime, thereby not needing fulltime gurus? I'm just curious why this article is focused on Oracle DBA's and doesn't include SQL Server DBA's, and what does thismean for those DBA's?
-Parker
by dpdeleon
I've been a Sybase and SQL Server DBA for years and all I hear is Oracle, Oracle, Oracle. There's a reason. It's the safe bet for management's consideration. Oracle for SQL Servers is what IBM was years ago for PC's and hardware. Management is finally seeing the lower cost solutions but it takes time.
Face it, Oracle has market share and a great marketing machine. As I'm trying to venture to Oracle somewhat (I do get moved by the market) I can tell you that on the face of it Oracle is a management beast compared to the others. That is why an Oracle DBA is so expensive and the software is expensive to manage. All things considered Oracle is as good or better (depending upon your needs) than any other SQL Server - it's just more expensive to own and operate.
by jtantonio
by suwatniabloy
by pbn2au
Sorry about the spelling. The internet runs Databases. The Databases hold products and services for sale. Those sales keep you eating, housed and comfortable. If the database crashes, you have no money. How much is having this money worth? Do you know how to maintain the database? I might be able to find the time to help you. However since I have several other people that I am already helping, I will need money from you to bump one of them.
Understand.... or why does the football player get 25 million to play exclusively for a certain club?
MCDBA here I come.
by tsarver
Notice that DBA's have moved from development to largely operations. At one time, the database was at the center of the development effort. Now developers can generally do their own ERD's, and only bring in a specialized DBA's to solve database performance problems.
Since DBA's are generally not part of the development team, having a remote DBA only impacts the operations. Since databases have been designed to be managed and maintained remotely, it doesn't matter to operations if the DBA is in the same building or not.
I think that remote DBA's is simply on the migration path toward outsourced operations, Web hosting, and eventually development.
by todd parker
tsarver said: "I think that remote DBA's is simply on the migration path toward outsourced operations, Web hosting, and eventually development."
I could agree more concerning the movement of the DBA, or at least that it is the case presently. But, please don't ever even whisper words like "..eventually development." That's when I quit to become a bartender. I hope it's not true.
;)
-Parker
by dpdeleon
It sounds like a viable solution to cost-cutting but it sort of reminds me of the way the ASP market.
I would like to argue with a couple of points that were made.
Many people may have a masters degree but its not necessary for most - if not all - dba tasks. The article gives me the impression that a masters degree is a prerequisite.
Dba's are prima-donnas? I don't know about that. Most work long hours and are on a 24x7 clock. That doesn't sound like coddling to me.
by golfnutt8
by kwlinc
Although I am biased toward MS SQL Server - here's the difference between the 2.
ORACLE:
-- Has market share
-- Aimed toward the large corporations.
-- Head-Start in RDBMS over MS.
-- Very Powerful
MS SQL SERVER:
-- GUI, Oracle is text-based. This is a MAJOR PLUS for MS. It allows for a lot lower administrative costs!
-- Is gaining market-share, is #2 behind Oracle.
-- Dominates the small to mid-size organizations.
OTHER RDBMS:
-- Forget about them!
-- Used by out-dated behemoth organizations or for extremely small &/or personal use.
by ninja stu
How do people classify DBA's anyway. With RDBMS's like MSQL you dont exactly need to be a rocket scientist (until things go wrong!). In smaller companys its usually just a small part of a much bigger job either doing server support or more general development.
What do people classify as DBA skills?
by dpdeleon
by mmcmanus
I have been working with MSSQL, Sybase and Oracle for over 6 years, and here are the differences as I see them...
MSSQL and Sybase are fine for those whose database will not get larger than 1 gigabyte,of course, this is assuming that the databasewas well designed in the first place.
With MSSQL versions 7 and 2000 the ease of use (creating databases, inserting data, backup and restore,security) makes it very tempting for many companies to try to get by without a 'real' dba. With MSSQL, you could even have a poorly designed database and the users would probably not notice unless the volume of data got very large.
Oracle is much more complex, and requires a real knowledge of data modeling and SQL coding to build a robust database...
by benjy
by soto
by todd parker
I'm going to laugh all the way to the store and buy it myself!
;)
-Parker
by jbm
by kol
by shanghai sam
by todd parker
Shortly afterwards... Oracle walked on water...
Groovy.
-Parker
by dpdeleon
by dksj
by whoiskevin
A DBA is someone that can design a robust scalable database architecture for your business. No it doesn't take a rocket scientist to install and get a database working but it takes years of experience and practice to design and maintain a real database.
I haven't seen a well designed and maintained database from a non-DBA yet. I have had to fix some ugly ones :-)
Also important roles for a DBA are.
Keeping the database running for the users and making sure that the required Backup and recovery procedure works.
Zero downtime during work!
Watching the databases enviroment and giving adequate warning for anychanges that are needed eg. DISC SPACE
again because as a DBA we work towards Zero downtime during work.
I also like to tune the databases I am responsible for so that the users get the fastest reponse possible.
Also important roles for a DBA are.
Keeping the database running for the users and making sure that the required Backup and recovery procedure works.
Zero downtime during work!
Watching the databases enviroment and giving adequate warning for anychanges that are needed eg. DISC SPACE
again because as a DBA we work towards Zero downtime during work.
I also like to tune the databases I am responsible for so that the users get the fastest responce possible.
by kol
by benjy
i could write a massive response to why u need a DBA for sql server even though it isnt rocket science but
I guess if u just check out the SQL SERVER DBA SURVIVAL GUIDE u will find tons of information .. dont be fooled into thinking its a simple system ..oh yes, because of its nice interface untrained people like to screw around with it with disastrous consequences.
by khassan
Well,
I agree with Kol. I have also came across so called new breed of DBA's who (in most cases) has taken few course and call themselves DBA. But personally I think a person must know/learn a lot before qualified to be DBA. Experience is one ofthe many key element in becoming a DBA. I don't think you can just take a course and claim to be DBA. In my opinion a DBA is usually evolves from a development environment with lots of experience in development and system design life cycle with indepth knowledge of system design and methodology etc.
I usually summarize it like "DBA are like specialist in a medical field but also have basic education/degree in medicine"... just an attempt to make a piont.....
Last point, there are two major aspect to DBA job
a) Database Design & Development (Data Modelling)
b) Database Administration
A full DBA must be able to handle both tasks.
Kamal Hassan
by benjy
Most good organisations delineate the role of a Database Administrator from the role of the Dataabase Architect and Database Developer. A DBA is not required to be able to architecturally design the system but should know optimisation of the server,the code etc .. yes of course knowing table design , normalisation etc is essential but the scope of the Architects work is wider and requires different skills .
check out
http://www.intelligententerprise.com/010130/feat3.shtml
by whoiskevin
I guess Larry has convinced you that 8.1.7 is simply an "upgrade" and not a bug fix.
No software is perfect. My big compliant with Oracle is that they will never call bad code a bug. They simple release an 'upgrade'.
by clasota
"DBAs have always been prima donnas". Really? Well, I guess Mr. Burelson would know. Looking at his bio he is Editor-in-Chief of Oracle Internals and a former adjust professor of Information systems. Are there any bigger prima donnas then editors and professors? Mr. Burelson is both - all the cockiness of an editor and all the arrogance of a professor.
I guess everybody who has an office is a prima donna. That would certainly include Mr. B. Or is he slumming it with the unwashed masses in acubicle?
Go back to your books Mr. B and stop clogging the internet with even more worthless information.
by mlierman
The second definition of "prima donna" in Webster's New World College Dictionary: "(Informal) A temperamental, vain, or arrogant person."
Dba's are prima donnas? I think if you look up the def of a prima donna that it applies to an individual not a group of people. I am a SQL Server DBA with experience and an Oracle novice. I am not coddled. I admit that I am treated well along with the other 3,000 employees in my company. However, in return, I work extremely hard as well as do the other 8Oracle/SQL DBa's in my company.
I think the article should have started on the benefits of outsourcing. The prima donna statment made the author sound like a whiny child desperate to get rid of a 'personal problem.'
A person will be a prima donna whether they a DBA or a Programmer. It's the person,not the job. What type of slam shoud we expect next? That we dress funny?
A non-DBA colleague of mine made this statement in regard to this article.
* Like physicans, DBA's that put in the long hours, hard time, and great effort to become the experts that they are. They have earned the respect and compensation they recieve. If you hire a fair to moderate DBA and pay them as a super star, you get what you deserve. Not only now, but in the future when you find all the little "gotchas".
A person will be a prima donna whether they a DBA or a Programmer. It's the person,not the job. What type of slam shoud we expect next? That we dress funny?
by kol
by todd parker
I didn't realize he was the Editor in Chief of Oracle Internals. That finally sheds the light on why this article was so focused on Oracle DBA's.
Now I feel like a used toilet tissue.
Ack!
-Parker
by pnmiller
A true DBA:
1.Installs and upgrades the DB software
2.Monitors the db server and tunes it if needed
3.analyzes storage needs; determines changes
4.responsible for backup and recovery
5.manage/reviews db users and security
6.works with developers
7.establishes and enforces the db standards
8.manages transferring data
9.manages replicating data
10.schedules the events of the db software
11.provides 24 hour access to db
12.contantly learning to keep up with new versions
13.works with the SA and NA to assure new software works 'plays well' with db software
While companies have other areas do some of these functions - the responsibility still falls on the DBA. For example, it would be hard for the DBA to recover/restore a database if they find out that the other department hasn't been backing it up!
I know that Microsoft and others teach that many small companies don't need a DBA unless the S**T hits the fan... but if you have a good DBA then the S**T should never reach the fan!
by skrm
I am a Senior PowerBuilder/Sybase Programmer in a major brokerage in NY area. Have been coding in PowerBuilder for the last 8 years. I am tired of Programming and would like to do something new and am considering becoming a DBA after getting
a certification.
I am not able to decide between ORACLE and SQL Server. Even though Oracle is currently the market leader, looks like it is slowly losing market share to SQL Server and DB2.
Thanks for your help and input.
SK
by penguinsrule
It is a well known established fact that Oracle bought RDB for many good reasons and quickly integrated many of RDB's strong features into Oracle, making it a significantly stronger product. They inherited a great deal of intellectual capital from buying RDB, and they not only have been able to maintain RDB and the strong user base with RDB, but they've been able to incorporate nearly all the positive features of RDB into ORACLE. Actually the current versions of Oracle are more RDB like
thanthe earlier ones were - and reliability is a sign of this as well. I'm sure if needed that you can get contacts who can verify this. In other words the RDB purchase was a good one.
This discussion is closed to new replies.
Trending IT Employment posts
Sort by Trending