Having used Oracle for 25 years and SQL Server for over 15 years, I can say
that the DBA jobs are usually somewhat different.
- Oracle tends to be a more pure DBA role
- SQL Server tends to require a greater level of development work, usually in
the areas of T-SQL, SSIS (data integration) and SSRS (report writing)
Financially, Oracle tends to pay more, but that may just be a factor of my
skills in Oracle (and the fact I don't go for pure SQL Server-based clients).
In terms of managablility, there's a lot less to do in SQL Server - this is
both a strength and a weakness. Loads of DBA-stuff in SQL is so much easier to
do than Oracle. It's mainly because there are a lot fewer configurable
parameters and a much simpler architecture. If SQL Server is a graphic
equaliser on your home music kit, Oracle is a recording studio. In the right
hands, Oracle can do even more amazing things than SQL Server and is more
scalable with better HA and DR - but at a price with a level of technological
complexity that is mind boggling. I'd be happy scaling SQL Server over the
100TB range though (although I've never personally gone beyond 16TB on SQL)
SQL Server EE cost is peanuts in comparison to Oracle EE - especially now that
you don't even need to license Dev environments, but still significant compared
to MySQL/MariaDB/PostGres/etc
I could write essays on this but its late and one need to be careful to avoid
religious issues in relation to different RDBMS's. Pick the one that's
appropriate for your application and business need. They all have strengths -
don't store the favourites for your website in Oracle EE when MongoDB will do
very well for that, thanks.
regards
Neil Chandler (OCP/MCP/MCTS/stuff like that)
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of peter.sharman@xxxxxxxxxxxxxx <peter.sharman@xxxxxxxxxxxxxx>
Sent: 04 January 2017 21:15
To: dramirezr@xxxxxxxxx; orahawk@xxxxxxxxx
Cc: Oracle - L
Subject: Re: Oracle DBA to SQL Server DBA?
I agree, the move to Linux for SQL Server is (to me, anyway) a real game
changer for Microsoft. Over the past x number of years (pick your favourite
number for x!), Oracle has come out with more and more fantastic technology
that has been of use to less and less people. Don't get me wrong, I still
think Oracle has the best database technology on the planet. But honestly, how
many people use that really cool stuff? How many of you are using Oracle
functionality that wasn't there in Oracle 7? Probably quite a few, but in
today's cost restricted world, most people are going to find {insert your
favourite non-Oracle RDBMS here} is good enough. In the case of SQL Server,
its real killer was it was Windoze only. Now as it moves into the Linux space,
Oracle Corporation (the company, not the technology) will have to come up with
a real game changer in reply. And unfortunately, their answer so far (Can you
say "cloud"? There, I knew you could!) has not been good enough to take on
anyone.
Let the flames begin! :)
Pete
On 4 January 2017 at 05:01, Dragutin Jastrebic
<orahawk@xxxxxxxxx<mailto:orahawk@xxxxxxxxx>> wrote:
Hello List,
Since recently they were 2 similar discussions
https://www.freelists.org/post/oracle-l/Oracle-DBA-to-PostGreSQL-DBA
https://www.freelists.org/post/oracle-l/OT-Job-Posts,6
I would like to start this one and hear your opinions about it.
Dragutin