Responsibilities of Junior DBA's

HI,
I know this is a very trivial question to ask , but without asking i would'nt know.
I want to know what are the basic Responsibilities and duties of an entry level or junior DBA's...
Like what job exactly a entry level DBA do.

thanks.

depends where you work, different people expect things of different people

You should be able to:

Know database object structures -ddl-,dml-,security operations
Make coffee/tea
Drive the boss's wife to airport
Act as if you know everything allways
Backups

Quote:

---

Originally Posted by robertbalmer

You should be able to:

Backups

---

you would trust some junior nobody who knows nothing with the protection of your data?

Quote:

---

Originally Posted by robertbalmer

You should be able to:

Know database object structures -ddl-,dml-,security operations
Make coffee/tea
Drive the boss's wife to airport
Act as if you know everything allways
Backups

---

if you dont wish to ans plz ignore the question...
no need to ans crap
answering as if you kno everything

it was a fair answer, most of that is probably what you will be expected to do.

Just expect to do no dba work and have no repsonsibility

Lighten up Junior !!

ditto 2 Davey's reply

Davey

Backups only,not Recovery....that will come later.

:-)

once they know the basics then responsibilty for a small internal database is sometimes a good idea, as long as they are given backup from a senior DBA.

by internal I mean a system that is just used in the IT area, then at least if it fubar no external customers are effected.

hi

I am also a junior DBA.

I had done a project in a good mobile company.

Responsibilities may change from organization to organization.

I will explain you some responsibilities.


1. Come in the early mornnig and check whether all databases are up.
2. Monitor the alert log file and take actions if any errors found.

3. Check the growth of database.

4.Take Full Database Export at frequent intervals like once in a week or fortnightly.

5. Take Cold/Hot Backup at frequent intervals.

6. Attending user calls and give a solution to their problems.

7. Maintain a Log Activity Report and report the same to the Senior DBA.

8.Read some DBA books for one hour.

Regards
SALIH KM :)

wow, sounds like a crao place you work in

What dno you have tools to monitor whether a database is up / check the alert log

Why check database growth

You have exports for backups huh - nice

Why take a cold backup at frequent intervals.

Why not take a hot backup at a specified interval, rather than just 'frequently'