Discussion Locked

Remote DBA offers an attractive outsourcing option

0 helpful
37 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

I believe being a DBA is not just a title. It entails a big responsibility that might make or break the company. That's where we get the premium. We work hard, stay late, be available 24x7, and works under pressure all the time. It takes dedication to do all of these things. That's why I always tell my wife whenever she asked why I do this, it's the love of the job, like being a doctor and anybody, anytime somebody might page/call you to treat a sick person. Same thing on being a DBA, anytime you can be called to fix a problem on the DB, you can't pick your own time, you have to fix it right away. It's a calling.

by suwatniabloy

so, what is really the job details of a dba (sql svr, sybase, or oracle). i mean the complete details on what you are doing. i mean all of them. please email me to suwatniabloy@hotmail.com. i mean please.

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 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

That was very well said. Underneath it all we shouldn't forget that the more market share a product has the more it's perceived as the superior product by management. And, management spends the money on the safe bet. Hopefully, technical people see through the hype - especially if you've worked with more than one SQL Server.

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

Hi , I like SQL Server best myself , but saying Oracle is text based is wide off the mark mate ... please see the brilliant interfaces and admin tools in 8.1.6 upwards and in 9i ... they give SQL a run for its money .. and hey DB2 is a classy systemtoo though it can be unwieldy at times ...

by soto

According to chart in the article Oracle only fails because of hardware or human failure! Wowee! No bugs! I'm rushing to buy it!

by jbm

I love Oracle, and after 5 Years Oracle's experience I can say. This Software is really a masterpiece. I use to work with Informix, the database itself is very performant, but .... The tools are very misrable. Suppose you backup your Database but there is no way to recover the database with the well done backup !!! This is not possible with Oracle. Yes Oracle is great

by kol

My company began implementing SAP on Oracle in 1996. To date, I have seen 1 Oracle instance crash AND we had not gone live yet! It's an impressive record. We have had up to 11 instances running on almost as many servers. Our two largest productiondatabases are each over 600 GB with nearly 1 terabyte allocated for each. My theory is that Oracle's reliability improved tremendously when Oracle purchased DEC's Rdb and all the Rdb developers around 1995.

by shanghai sam

Compared to MS SQL, the Oracle database engine provides much higher concurrency (ie., support for far more users) while also, perhaps counter-intuitively, providing much more reliability and read-consistency as well. Mind you, this comes at a cost (not only in licen$ing but also in complexity). Many people tend to throw up their hands when trying to figure out all the myriad options and capabilities of the Oracle RDBMS. And, to an extent, they are justified. Consider the fact that the entire set of Oracle Server documentation weighs in at over 20,000 pages! Nevertheless, this is the product of a superior, and quite ingenious, architecture which is time-tested and true.

by dksj

Companies risk losing "$10,000 per minute" but have a hard time justifying paying thier skilled DBA $80,000 per year? It is a supply and demand market, and if there are less qualified DBAs out there than there are senior vice presidents then the DBAshould earn more. Managers seem to hate to pay techies the going rate, but dont seem to mind giving themselves big salaries. Its not like they're going to get a Nike shoe contract.

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 :-)

by andrewburbidge

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.

by andrewburbidge

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

I have to say that in my 20 years of developing and maintaining high volume transaction processing applications, I've seen many more qualified database developers than DBAs. Too many junior IT analysts take a few Oracle classes and consider themselves DBAs. I prefer to have a seasoned developer design my database. If only maintenance is left for the DBAs, then outsourcing is a viable option.

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

To me, a DBA prima donna believes his skills are more valuable than everyone else's. He does not like to perform non-DBA tasks. He acts as if he is the only person who works 24X7. He cannot believe a company can outsource HIS job because HE is too important! Believe it or not, there are a lot of these types in the Oracle DBA market. I don't see this attitude as concentrated in other IT areas. I've always wondered why. Does Oracle include attitude training in one of their courses?

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.