Can one explain the differences between the PL / SQL programmer and the Oracle DBA ? I know there are many differences, but I'm not sure how to specify them.
I have some doubts too ...
For example:
Can a DBA program
Procedures?
Can the career of the PL / SQL programmer expand to DBA ?
I believe that they are different specializations within the Database aspect in computing, but complementary.
As I work in Software Factory, each project focuses on one: sometimes SQL programming (PL-SQL), sometimes it is a role more than "AD" (which performs data modeling), another time visa Administration of DBMS.
In simple terms:
DBA ( Database Administrator )
It is the person (or team) responsible for administering the database. Some of your key responsibilities are:
Ensuring bank performance;
Ensure that access / permissions are correct;
Ensure that data is available and accessible;
Identify and resolve benchmark and performance issues;
Identify and report execution of slow queries that consume lots of processing and / or memory;
PL / SQL (Procedural Language / Structured Query Language) Programmer
It is any person (or team) who writes procedures , functions , packages , and queries .
This activity is not exclusive to a DBA. In fact, DBAs typically do not create queries or procedures . This is the responsibility of the "PL / SQL Programmers" themselves.
It is common for a programmer of any language like Java, C #, VB and etc. to write procedures and queries . The DBA, on the other hand, will assist them with whatever is necessary with regard to the bank.
