I am still unclear about these jobs. In my opinion that DB admins monitor, manage and keep database(s). But just what DB designers do? Will they write query to produce table, to update database,... or they write programs (in ADO.Internet, for instance) for connecting and manipulate data?

Do you know the cons and pros of those jobs? Do you know me?

Thanks.

DB Admins maintain MOSTLY the servers. index entertainment, backup, storage issues, performance and capcity planning. They normally reside in procedures - as a result they're, in bigger shops, seaparated from designers. Additionally they oversee data loading tasks for data warehouses etc.

Db develoeprs concentrate on programming database servers (saved methods) and really know a great deal concerning how to tune queries etc. They live - clearly - in rise in bigger shops, not in programming. It normally won't concentrate on front-end technologies (ADO.Internet is trivial, though). You might be surprised the number of web develoeprs pretty essentially rape their database servers because of being unsure of the fundamentals concerning the relational theorem, or how much of an Index is )

That which you like more is dependent a great deal on which you.... like more.

Db designers frequently do a lot more than write queries, they design relational databases, they design data warehouses, they've created ETL processes, they write reviews, they performance tune. Frequently they're backup on daatbase admin and really should have fundamental admin abilities. They have a tendency to take more time in development and qa than push.

DBAs keep your production server running well. They most likely keep up with the other servers too, however their focus is on push. They perform backup copies and reinstates, update statistics, make certain the best indexes can be found. Additionally they usually performance tune, espcially when there's a question running on push that's leading to an issue. Frequently they're available to deal with center of the evening issues. they frequently get involved with suggesting new hardware and setting up it. They setup SANs. They monitor the healthiness of the machine including observing trends that will need more hardware over time to have it prior to the require is critical (drained of disk space for example).

Merely a large shop may have both. You will find many more compact shops, such as the one I began in, where both responsibilites fall around the designated database person. If you are looking at engaging in the database world, this really is frequently the starting point as you become to determine what both of them are like and may choose the journey. DBA is frequently a greater stress job as you've to repair push now when something goes lower. I can not say this is a disadvantage though becasue some peopl clearly enjoy this type of responsibility. One disadvantage I can tell for jobs could it be is challenging recognition permanently work. Within the database world great work means things are running easily with no one notices, they merely really notice if things aren't going easily. That's not to reward the dba because there have been no major problems this month (actually it could lead some management types to question when the individual is needed) and that's not to reward the database developer because that ETL package that runs dailly has not unsuccessful ever.

So far as benefits and drawbacks, I believe the 2 tasks are both good career pathways if you are looking at databases. I believe what differentiates what's best for you personally is that if you care more about the information and it is meaning or interested in the machine and hardware.

generally, its not all situation

usually DB designers work 8-5, while DB admin work same 8-5 however with 24/7 available.

DB developer can get swept up running a business logic, ending up in customers other designers, have due dates for projects, etc, while DB admin is generally more isolated from business logic and customers.

DB designers write more code, usually meant for the front-end creating designers, than DB admins

DB Admins setup database installations, handle security issues etc...

DB Designers develop programs that actually work with databases.

DB admins need to setup the database to ensure that the programs th DB developer produces works...