Oracle DBA  Blog
Unix for Oracle DBA
Unix handbook
Real Appl  Cluster
Oracle RAC Handbook
Oracle dba Jobs
DBA Certification
Oracle dba training
Oracle RMAN
Oracle SQL
Oracle PL/SQL
Oracle Data Guard
Oracle datawarehouse
ERP
Oracle App Server

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

 

Oracle DBA Guide

All you need to be Oracle DBA and Database Administration Top Tips

So you want to be a successful oracle DBA in the lucrative career of Database Administration.

Well I remember there was a Unix System administrator in one of the company I worked, used to joke about DBA’s saying “Who wants to be DBA?” whenever help desk rang with problem tickets .

Gone are the days when you (Oracle DBA) could put on your blinkers and focus on a single skill set. Instead, the DBA needs to bridge the gap between several functional areas of the Business, hopefully acting as an enabler.

The Practical guide to Unix Commands and Tips for Oracle DBA’s and Developers. Click the image on RIGHT!

Unix handbook for Oracle DBA

I think you agree that you need a wide variety of skills to be a successful Oracle DBA these days.

In IT world you must have realized that whenever there is a issue with the component of the business, it is always DBA’s who get problem ticket or help desk would call DBA’s first . Why is that ?

Let’s discuss why do companies need any Database administrator leave alone Oracle DBA ?

What is a database administrator ?

A company's data is its lifeblood and without this companies possibly cannot be in business. We are really talking about the data integrity of the entire company.

Therefore it needs an experienced, skilled steward like you who can look after their valuable information.

Why is Database Administrator or DBA is becoming more popular ?

I remember when I was in my primary school, when the post man arrived to deliver any mail I was so curious to know where it came from and what it contains. I am sure My parents had the same curiosity. These days when I check my Mail box, I always wish that my Mail box is empty. I think in this modern world we are all bombarded with information.

Wait a minute we are actually in “Information age” we have passed the “Industrial age”. You guessed it!. Somewhere this information needs to be stored , processed , Indexed, Managed, networked. For any company to have such detail information about anything for that matter. That is why Companies databases are growing bigger and bigger.

Olden days you were talking about kilobytes and these days you talk about Terrabytes. That explains why Database Administrator job is becoming more and more popular and oracle is the biggest database company in the world and obviously there is high demand for Oracle DBA.

The Practical Handbook on Oracle Real Application Cluster for Oracle DBA’s. Click the image on RIGHT!

Oracle Real Application Cluster Field DBA Admin Handbook

Well what additional skills make a good successful oracle DBA these days?

Apart from knowing the database administration skill, I believe you need to have following skills to various degree to be a successful Oracle DBA

  • Development skills
  • Networking skills
  • System administration
  • System/Business analysis and design
  • Leadership skill/People Skill
  • Communication skills
  • Scripting Skills
  • Project management
  • Nevertheless as an Oracle DBA your task has been simplified by some of the database administration tools available these days.

    To name few

  • Oracle Backup and Recovery Manager (RMAN)
  • Oracle Enterprise Manager (Grid Control)
  • Oracle Automatic Storage Manager (ASM)
  • Oracle Logminer
  • Oracle AWR (Automatic Workload Repository) and ADDM
  • Oracle Statspack
  • Oracle Automatic Storage Manager (ASM)
  • Oracle Flashback
  • Oracle Automatic CBO (cost based Optimizer) Statistics Gathering
  • Oracle Automatic Undo Management
  • Oracle Active Session History (ASH)
  • Oracle Automatic Segment Space Management
  • Oracle Automatic memory management
  • Apart form these there are lots of third party companies who provide Oracle Database administration tools in the intention of simplifying Database administrator job.

    Ok then what does it takes to be a successful Oracle DBA ?

    What do you normally do and how you feel when you are on call and helpdesk calls you at 2:00am in the morning when you are fast asleep saying we can not access the database. How about those extended outage windows for regular database maintenance work in odd hours. Have you ever thought I wish I had chosen a different career sounds familiar ?

    Worst still after working on weekend with round the clock, when you go back to work on Monday, some users complain about performance issue due to weekend maintenance work.

    Oh dear! What goes on in your mind after fixing some critical issues when your manager and Business manager & few more invite you for Incident review meeting and make you go through all the drama once again and expected to answer technical questions to non-technical managers. It is not much fun isn’t it ?

    Well personally, I believe you can still be a successful Oracle DBA and enjoy being what you are if you equip yourself with few skills I mentioned earlier.

    The Practical Handbook on Oracle Real Application Cluster for Oracle DBA’s.

    The “Oracle Real Application Cluster Field DBA Admin Handbook” is a practical guide for Oracle DBA’s who manage and administer the Oracle Real Application Cluster High availability solution.

    This book provides practical steps to administer Oracle Real Application Cluster (RAC). It’s like a field guide rather than an in depth manual. It’s written for the DBA’s to handle the day to day challenges faced by DBA’s managing RAC on the job.

    Click Oracle Real Application Cluster Field DBA Admin Handbook. for more details.

    The Practical guide to Unix Commands and Tips for Oracle DBA’s and Developers.

    The “Unix Handbook for Oracle DBA” is a practical guide for Oracle DBA’s and Developers working on Unix. It has the unix commands, tips and short scripts to help you find the most needed help on the job. It’s from my collection for over 15 years of practical usage of these tips and techniques as a Database Specialist on Unix.

    Click Unix handbook for Oracle DBA. for more details.

    Oracle DBA Guide blog
    The Oracle dba guide blog keeps you up-to-date with all additions and changes to the oracle-dba-database-administration.com website. Subscribe here.

    unix for oracle dba practical handbook
    Top tips and commands on unix for oracle dba. All you need to know on unix as oracle DBA

    Practical unix handbook, unix tips, unix commands for Oracle DBA and developer
    unix handbook for oracle dba and developers, practical unix tips, commands and scripts for dba and developer

    Oracle Real Application Cluster tips and commands to manage Oracle RAC.
    Must know secret of administering and managing Oracle Real application Cluster effectively.

    Practical guide Oracle RAC handbook for oracle DBA
    Oracle Real Application Cluster Field DBA Admin Handbook for oracle DBA. Oracle RAC handbook is field guide for easy Reference and handy commands

    oracle dba jobs and secret behind securing an oracle dba position
    Know the 3 step process to succeed in top paid oracle dba jobs market

    Successful oracle dba resume writing secret.
    Oracle dba resume preparation is most important part of securing a job as an oracle dba. 9 steps of successful oracle dba resume preparation

    Top dba interview questions to qualify you as a dba
    what is expected of dba during dba interview and common dba interview questions

    Oracle DBA Certification and database administration
    What are the Oracle dba Certification paths? which path OCA, OCP, OCM is more suitable to oracle dba.? Is Oracle dba certification really worth ?

    Oracle dba Training and database administration for oracle DBA
    Why oracle dba training ? Which training is suitable for Oracle dba. Are you a High availability (HA) Oracle dba?

    Oracle RMAN backup restore must know commands and tips
    Restore and recover your database within SLA using oracles RMAN backup restore utility.

    Top tips on Oracle database administration
    Oracle dba resource

    Essential oracle SQL for Oracle DBA
    What is Oracle SQL and why it is the most popular data manipulation language

    Essential oracle PL/SQL for Oracle DBA
    What is Oracle PL/SQL and why it is oracle’s most popular application development tool

    Oracle data guard administration. Most popular high availability disaster recove
    Oracle data guard. or oracle Real application Cluster which one is better? How to choose your High availability

    Oracle data warehouse for oracle DBA. High performance Data warehouse database
    What you need to know as an oracle DBA to manage and administer oracle data warehouse

    ERP software is modern solution for Data integration and Process management
    Popular ERP software and erp system for better decision making

    Oracle application server E-business suite from oracle
    What is an oracle application server and why it is a fully integrated standard E-business suite