Oracle DBA / Developer

Comparison between D.B.A. and Oracle Developer

	D.B.A.	Oracle Developer
Full form	Database Administrator	-
Definition	A database administrator is the one who is basically responsible for managing databases. A D.B.A. is associated with the design, implementation, maintenance and repair of an organization's database.	Oracle developer is the one who has extensive knowledge of Oracle databases. He generally works on delivering applications/products using Oracle technologies.
Focus	Monitoring and maintenance	Development (coding)
Type of tasks	Streamlined	Wide Range
Duties	To establish the needs of users and to monitor user access related tasks. To secure the database. To monitor the performance and manage parameters to provide fast query responses to front-end users. To synchronize the conceptual design with the actual database. To enhance and refine the logical design of the database. To take care of the system storage requirements. To update the database by installing and testing new versions of the D.B.M.S. To prepare the documentation related to the database. To ensure the integrity of a database. To control access permissions and privileges. To develop and manage back-ups. To construct recovery plans.	Perform design and development of Oracle applications according to project requirements. Design, code, and maintain the Oracle systems so that they match with the established standards. Understand project requirements and develop design specifications. Perform initial design reviews and suggest improvements if required. Write clear codes and prepare various documentations like of coding, etc.. Provide technical assistance to other developers as needed. Analyze and troubleshoot system issues. It is very important to sort out the problems in a timely manner. Develop Oracle reports, database procedures and UNIX shell scripts. Modify existing codes to optimize Oracle applications. Assist in system integration and acceptance testing and fix the bugs. Train less experienced staffs on programming guidelines.
Database Environment	Works in production environment. This is the external customer-facing system.	Works in development and testing environments. These are internal non-customer facing systems.