2007-03-19 07:09:08 · 5 answers · asked by curious_person 2 in Computers & Internet ➔ Software
can a developer become a dba? what are the extra things that he needs to learn??
2007-03-19 07:22:54 · update #1
I can not understand that up to what level you want to know .
Anyway now I just give the top-view only.You use the term ORACLE , but we can generalized the concept into MS-SQL, IBM DB2 , SYBASE etc. DBA means database administrator ,who can work with three different schemes , such as physical schema , logical schema etc along with some sub schemes also.Mainly,a database administrator (DBA) is a person who is responsible for the environmental aspects of a database .They provide different view levels, enable different options on a database.Their work mainly for, data recoverability ,data security, data integrity, availability, performance, physical block distribution and so on.
In general, ORACLE developer means the person who provide a database with some software to handle the database in a good logical environment .In corporate world, DBA means who work for
a database physically and logically, they create an E-R diagram,
normalized the system ,provide the ACID rule , create log based or shadow page based recoverability with mutex lock , views and so on depending upon the demands.But a developer creates various tables, views ,softwares to fetch and store the data various logical supports etc using ODBC, JDBC, SQL command etc.But they never
handle the database in physical level.So, a developer can never be a dba , but a dba can be.
At last, if you want to know more please ask more specifically .
2007-03-20 23:58:57 · answer #1 · answered by aveeshek d 2 · 0⤊ 0⤋
An Oracle DBA controls and administers the many instances that are created for all the databases. He/she configures the databases and makes sure that they start/stop during system shutdown; they get backed up using RMAN, or scripting via tapes or electronic data archiving. They interface with most Systems Administrators to achieve optimal uptime for the organization. He/She writes scripts and adds patches and has to have at least a base knowledge of UNIX os.
A Developer on the other hand writes databases using all the different Oracle packages and writes, adds, and changes databases for the organization.
2007-03-19 07:22:50 · answer #2 · answered by rleflore@ameritech.net 2 · 0⤊ 0⤋
the difference is about $15 an hour.
seriously, an oracle DBA is a database administrator, who makes sure your data tables are correct, error free and can be accessed by all the users of the applicaitons on your database server. a lot of applicaitons, even if they are not oracle based or branded run on an Oracle databse.
an Oracle developer on the other hand is the one who creates the applications or help link other aplications to run with or on oracle products.
2007-03-19 07:19:48 · answer #3 · answered by viper102661 2 · 0⤊ 0⤋
A DBA is a DataBase Administrator, and would be in charge of various things like running queries, adding fields, perhaps adding data, running (and maybe writing) scripts to update the database, and so on.
A developer is one who develops applications (programs) for use.
2007-03-19 07:17:08 · answer #4 · answered by T J 6 · 0⤊ 0⤋
oracle dba.. is your database.. and oracle developer are use to create oracle applications.. usually oracle forms and reports.......
2007-03-19 07:13:00 · answer #5 · answered by DenRoCK 3 · 0⤊ 0⤋