-5
Could someone explain to me the differences between the programmer PL/SQL and the DBA Oracle? I know there are many differences, but I’m not sure how to specify them.
I have some doubts too...
For example:
A DBA can program
Procedures?
The career of the programmer PL/SQL can expand to DBA?
3
In simple terms:
DBA (Database Administrator)
It is the person (or team) responsible for administering the database. Some of your main responsibilities are:
Ensuring the bank’s performance;
Ensure access/permissions are correct;
Ensure that data are available and accessible;
Identify and resolve bank and performance issues;
Identify and report execution of slow queries that consume a lot of processing and/or memory;
PL/SQL (Procedural Language/Structured Query Language) Programmer
It is anyone (or team) who writes procedures, functions, Packages, and darlings.
This activity is not exclusive to a DBA.
In fact, usually, Dbas do not create queries or procedures. This is under the responsibility of the "PL/SQL Programmers" themselves.
It is common for a programmer of any language like Java, C#, VB and etc to know how to write procedures and darlings.
The DBA, in turn, assists them with whatever is necessary as far as the bank is concerned.
1
I believe they are different specializations within the Data Bank aspect in informatics, but complementary.
As I work in Software Factory, each project the focus is one: sometimes SQL programming (PL-SQL), sometimes it is a role more of "AD" (which performs data modeling), other time aims DBMS administration.
I understand perfectly, @Melanie! Thank you very much!!!
You’re welcome, @Eduardor :)
Browser other questions tagged sql database postgresql oracle pl-sql
You are not signed in. Login or sign up in order to post.
Define what is Oracle DBA? It may be missing something, but the question doesn’t seem to make sense.
– Maniero
Read this: https://pt.meta.stackoverflow.com/a/5487/132
– Victor Stafusa