This discussion is archived
1 2 Previous Next 22 Replies Latest reply: Feb 4, 2013 10:16 AM by jgarry RSS

Daily activities of a DBA

584671 Newbie
Currently Being Moderated
Hi there, can any experieced oracle DBA please tell me what is your roles at work, I mean what exactly do you do in a daily basis? will there be list of work to be done on that particular day, or you just go there and start monitoring a system and act accorndingly? Is there any set of rules that you have to follow? I just want to know how do you start and finish your day at work?
Thanks, regards Dennis
  • 1. Re: Daily activities of a DBA
    584650 Explorer
    Currently Being Moderated
    I think no matter whether you're an Applications DBA or Enterprise DBA you firstly need to completely understand the environment you support, how applications are configured and users access the database, SLA and OLAs that are in place, understand the OS that the database/s run on.

    Next, day to day and some of what you place more emphasis on might go back to what the SLAs are - backups and restores, did the backups work and are available for a restore that will also work? monitoring - what is being monitored and how it being reported, storage - database and server, capacity planning for future, monitor performance (SQL that is running) and how these can be improved. Show people/developers how to do things properly, performance gains or less resource usage. Try to find out what projects are coming up and any new requirements and how they could throw a spanner in the works.

    Last of all, don't stop learning new things. It's a constant learning and you need to know what's out there that can bring value to yourself and the business.

    What is a DBA - Part I
    http://www.dbazine.com/ofinterest/oi-articles/dba-1

    What does a DBA do -
    http://www.dbazine.com/blogs/blog-cm/craigmullins/blogentry.2005-06-12.2445906428/

    Some don'ts -
    Seven deadly habits of a DBA
    http://www.pythian.com/news/papers/7DBAhabits.html
  • 2. Re: Daily activities of a DBA
    293720 Newbie
    Currently Being Moderated
    Well, this is a pretty broad question, and will vary greatly depending on your workplace, roles, responsibilities, etc....

    However, some examples of stuff I may be doing any given day, include:
    - performance tuning, instance level, SQL tuning, etc.
    - backup/recovery - set up new databases for backup, manage any required recovery, in the case of any database failure or corruption.
    - manage security. Deal with requests from users for various database permissions. Work with architects on security model implementations.
    - Participate in code reviews.
    - Participate in design reviews.
    - Keep on top of Oracle database versions, new Oracle products, suggest to management how and where they ought to fit into the corporate IT infrastructure.
    - actively participate in various Oracle mailing lists and forums, such as this one, Oracle-L, etc.
    - read, study, play with Oracle, learn, learn, learn....

    But, that's just me......

    Hope that helps,

    -Mark
  • 3. Re: Daily activities of a DBA
    108476 Journeyer
    Currently Being Moderated
    Hi Dennis,
    what exactly do you do in a daily basis?
    As the primary manager and custodian of the data resource the Oracle DBA has many job duties. Many of the duties of the Oracle DBA have been clouded by the explosive growth in Oracle servers during the 1990's, when UNIX minicomputers caused IT shops to have hundreds of Oracle servers, each with their own instance, and copy of the Oracle software.

    Historically the senior Oracle DBA had total responsibility for the Oracle database and had the following job duties:

    - Install, patch and maintain all Oracle software
    - Tune all Oracle instance components including SQL and PL/SQL
    - Approve all production schema changes
    - Approve changes to database design
    - Control all migrations of Oracle schema objects
    - Design and implement a backup & recovery system
    - Implement Oracle failover technology

    I have my notes here:

    http://www.dba-oracle.com/t_job_duties.htm

    Hope this helps. . .

    Don Burleson
    Oracle Press author
  • 4. Re: Daily activities of a DBA
    584671 Newbie
    Currently Being Moderated
    Thanks all of you guys for your kind response, Its really been a great help... thanks again.
    dennis
  • 5. Re: Daily activities of a DBA
    584840 Newbie
    Currently Being Moderated
    DBA is terrible job, have to support 7X24, never been peace. don't do it!
  • 6. Re: Daily activities of a DBA
    Luckys Pro
    Currently Being Moderated
    I'd like to add further to it, as a question,
    Can there a part time DBA, as in, you are responsible for other things within the organization, but since the operations are not that huge, and the company won't have a full time DBA, on those regards what are the main daily/weekly/monthly tasks/reponsibilities of a part-time DBA.

    regards,
    Luckys
  • 7. Re: Daily activities of a DBA
    584650 Explorer
    Currently Being Moderated
    There can be a part time DBA that is responsible for backups/restores, managing storage, some monitoring, performing upgrades etc

    Maybe for an environment where the database has been running stable for some time but still requires a DBA to perform duties occassioanlly, maintenance mode. I think for smaller companies it might be common for a developer or System administrator to perform some of these duties although it might be best to outsource them to a consultant who is more experienced in Oracle.
  • 8. Re: Daily activities of a DBA
    549698 Newbie
    Currently Being Moderated
    hi,
    I dnt knw if this info will help u,but i had the same prblm when i first as a dba.here r some thing which u must do

    1)check if ur database and instance is up
    2)check the litsener if it's all fine
    3)check if the RMAN is working fine
    4)then just go trough the space if it's enuf
    automaticly u'll have things to do.

    Good luck
  • 9. Re: Daily activities of a DBA
    Luckys Pro
    Currently Being Moderated
    Just trying to be more specific,
    Daily preventive maintenance/proactive monitoring tasks of a "Part Time DBA".

    -L.
  • 10. Re: Daily activities of a DBA
    536603 Newbie
    Currently Being Moderated
    Well...

    I would say in this way.... the daily responsibilities would be differ w.r.t the number of years experience.

    If you are having 2-3 yrs exp then only monitoring and checklists would be part of your job but if you are more experienced, Capacity planning, Auditing, DB designing and many more things would come into the picture.

    You need to be confident and concepts should be more clear and strong where you are going to give any answers. Remember, More experience person does not necessary to have more knowledge and vece versa...

    Hope, it makes sense...

    Cheers / Star Nirav
  • 11. Re: Daily activities of a DBA
    258794 Newbie
    Currently Being Moderated
    Good Morning,

    Not to be funny but here is a job that you want to run from. What I do is take 90 days to evaluate the company just as the company evaluates me to determine if you are a good fit for them or not.

    Arrive: Get coffee, turn on screen, check backups, stare at tv, check flashback area used, sip coffee, look at tv. Go for breakfast, wander around halls, come back and read oracle articles. Sip coffee. Read more oracle articles. check email.
    Listen to your boss complain to you about program manager complaining you are reading too much. Go for lunch. This is what I am stuck in now. When the description of the position doesn't pan out to what it is in reality.

    If you see a pattern like this on your job, run, don't walk to the next interview.

    PRAY FOR JOB OFFER.

    regards,

    al
  • 12. Re: Daily activities of a DBA
    APC Oracle ACE
    Currently Being Moderated
    Jeez, so many people spend all their lives waiting for a job which requires them to do so little actual work. How did you get so lucky?

    Cheers, APC
  • 13. Re: Daily activities of a DBA
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Coffee, tv, breakfast, lunch, lunch... without a sport practice, this job is not good for the health at all. Hope you don't smoke either.

    Nicolas.
  • 14. Re: Daily activities of a DBA
    258794 Newbie
    Currently Being Moderated
    Hi Guys,

    You would think this is a plush job but it isn't. I didn't change careers from being a diesel mechanic to this just to sit around. I came into this career to make a difference and help improve some project. No I don't smoke but I am ready to fire up some of the people here in the office with their attitudes. Most of the people here are net working people that shows up and waits for something to happen. I don't want that attitude to get to me also. I made several recommendations to the lead dba to improve the performance of the database but to no avail. He said he will look into it, even after explaning what the changes would do. He said it is his database and he will do with it what he pleases. It was fun for 2 days here doing the above but it gets old real quick and you look for an out as soon as possible. I would much prefer being hired at a company that has alot of problems that need correcting. It would make me feel useful.

    Hopefully after today's visit I will snag something. This is a question I will ask them, if they presently got problems. Those that don't move to the bottom of my list.

    Nice hearing from you.

    regards,

    al
1 2 Previous Next