Home > Ask the Oracle Experts > Managing an Oracle shop Questions & Answers > What is the difference between a production DBA and a developer?
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

What is the difference between a production DBA and a developer?

Michael Hillenbrand EXPERT RESPONSE FROM: Michael Hillenbrand

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 07 May 2008
I want to become an Oracle DBA, but I don't have any idea which side I should go into: development or production.

Please tell me, what does a production DBA do? Is it different from a developer? If so, what is the difference?


>
EXPERT RESPONSE
There is definitely a difference between a production DBA and a developer. A developer will work with code, specifically SQL, PL/SQL, java, etc. and will develop applications and software. A production DBA has to support the infrastructure needed to run the code against the database systems (backups, troubleshooting, installs, upgrades, security, monitoring, etc.).

If you ultimately want to become a DBA, starting out as a developer is definitely a good choice. Some of the best DBAs I know started their careers as developers. As a developer you can expect to learn the basics of how relational database systems work and how to write good (well-tuned) code against the database. Once you learn these basics you can progress into database design and ultimately into how the database internals work. Or, if you are the creative type that likes to have something to show for your work at the end of the day, you may just be satisfied staying a developer.

Jumping right into DBA will be a very difficult task and is not something you can expect to do overnight. A DBA must be a jack of all trades and have a thorough understanding of logical and physical database design, operating systems, networks, applications, programming languages and tools, storage hardware, security, web technologies, middleware, scripting, monitoring software, etc. If you do not already have a solid technical background in at least some of these areas, becoming a DBA will certainly be a challenge.

Most DBAs I know are satisfied with their jobs, but being a DBA isn't all glory and is certainly not for everyone. The database is at the heart of most mission critical systems. When a critical system stops working, more often than not, folks will come running to the DBA. You must be able to handle this pressure, be willing to be on-call 24x7, work long hours, and have a thick skin for when things get rough. Some people thrive on this, some do not.

No matter which path you take, I suggest starting out by learning SQL and the basics of relational databases.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Managing an Oracle shop
Remote database administration: What to look for in a provider
What is the difference between a database engineer, architect and administrator?
Oracle DBA interview questions
Oracle certification tips and advice
Becoming a Junior DBA
How important is ERP knowledge?
Value of Oracle Certified Professional (OCP) exam in landing entry-level job
When trying to find a job, should I focus on becoming educated in Oracle or SQL?
Staying marketable as a DBA
Oracle 11i vs. Oracle 11g

Oracle management topics
Remote database administration: What to look for in a provider
Oracle DBA interview questions
Becoming a Junior DBA
How important is ERP knowledge?
Value of Oracle Certified Professional (OCP) exam in landing entry-level job
When trying to find a job, should I focus on becoming educated in Oracle or SQL?
Staying marketable as a DBA
Oracle 11i vs. Oracle 11g
Shifting from IT Manager to Oracle DBA
What is the best book for Oracle certification?

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts