What is the difference between database administrator and database developer:

difference between dba and sql programmer: 

Database Administrator:

The DBA handle backups and restores of the databases maintain user security, index maintenance, performance tuning, analyze queries to identify. Usually they are also responsible for the creation of the databases themselves as well as the objects within them (table spaces, tables, indexes, views, etc.) They also tend to be the ones to resolve issues such as recovering lost data, adding new user access, planning for disaster recovery, etc.

Administrator Roles:

Install and configure SQL Server 2005-2008
• Plan and create databases
• Back up the databases
• Restore the databases when necessary
• Set up and manage users for SQL Server
• Manage security for new users and existing users
• Import and export data
• Set up and manage tasks, alerts, and operators
• Manage the replication environment
• Tune the SQL Server system for the optimal
performance
• Troubleshoot any SQL Server problems

Database Developer:

 

The Application DBA will be responsible in general for the role of a dba with the additional responsibilities of managing the application. They usually interacts with the  application team members to help and maintain the database queries ,sp’s ,functions ,trigger’s etc. The developer is the one who creates applications that utilize the databases. They are usually responsible for design and creation of any user interface objects (reports, forms, etc.) and process objects (stored procedures, scripts, batch files, etc.)