Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


DBA Role/Responsibility

Posted on 2003-02-27
Medium Priority
Last Modified: 2012-05-04
Basically I'm interested in the straight role of a DBA; designing, creating, implementing, fine tuning, reporting and backup & recovery.

SQL Server appears to be a more manageable entry into the world of a DBA (complexity wise) as opposed to Oracle... however from talking to some tech's I get the impression that SQL Server DBA's are regarded more as VB developers who are quasi-administrators. Personally I have little interest in coding (beyond SQL syntax) and therefore I'm concerned that a MCDBA is one part administrator 2 parts developer??

With Oracle, does programming generally revolve around PL/SQL or as future versions are released, is it expected that administrators can code in other languages such as Java? I'd like to confirm the value of being good at PL/SQL (qualified) in the job market, not necessarily administrator qualified.

Any constructive insight would be appreciated.
Question by:hazzard_2000
  • 2

Expert Comment

ID: 8035738
My experience is that you aren't going to get close to being a DBA until you prove yourself at something else. My route was as a retired Navy chief without a CIS degree: application support, SQL user, PL/SQL developer, unix & shell scripts, production support, and now finally, junior DBA.  It took five years and three jobs.  

The cert exams were crucial in qualifying me for an interview. Once I had completed the first one, SQL, I was taken for an interview with a big client by a small local consulting firm who gave me a try out. That exam didn't get me the job. It got me the interview.  I haven't finished them yet.

In an information society, the data is the most important thing the company owns. The smart ones don't just hand you the keys.  Expect to pay your dues and gradually approach your goal.

Accepted Solution

asimkovsky earned 300 total points
ID: 8036310
I myself am an Oracle DBA.  In my opinion, you should go for Oracle, and not just because that's what I'm doing.  Oracle has a much larger market share for databases, and therefore there are more jobs. Also, since Oracle is a much more complex beast, the pay is substantially higher.  And as far as capabilities, Oracle beats SQL Server hands down.  Therefore, most of the really important systems that companies are willing to throw money into usually end up on Oracle.  You will get to work on many more very high-visible systems on Oracle than you would on SQL Server.

As far as coding goes, it would be wise to be very familiar with PL/SQL, but not to the point of a developer. You will need to know some PL/SQL as a DBA to do your job (it comes in very handy for many things). Also, being a DBA, you might be expected to be the on-site Oracle expert, so you might be expected to review and approve developer's PL/SQL code before putting it into production.  You have to look at it from a performance and security perspective, rather than functionality, so your point of view will be different from that of a developer's.


Author Comment

ID: 8046457
Thanks to Don, for views on working towards the goal.
Thanks to Andrew for explaining significance of PL/SQL and expectations.

Curious to hear from anybody with SQL Server experience?

Author Comment

ID: 8068908
Would have liked to have had confirmed whether SQL server DBA's are generically expected to code in VB or languages other than Transact-SQL.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question