Why I Love to be an Oracle DBA?

Oracle DBA role is perceived to very hectic and demanding in terms of both energy and time. It is well understood that Oracle DBA’s will be mostly working in rotational shifts, overtime and few times are deprived of good sleep.

For a moment, let us look at some other profiles/roles which demand similar working styles. How many of our friends and colleagues, in Application support, Technical support or Application Developers work overnights? We can recollect a few in each area who are working hard for doing something good.

I am very honest when I tell you folks, that I enjoy my work and love to be an Oracle DBA. Here are some of the reasons, why I feel so:

My Workgroup:

Though my workgroup is so called database support, but I have never been stacked to the same group all the time every day of my work. It is not something you should be worried of; I feel privileged to be part of a workgroup that can be visualized below.

Woo!!! That’s very exciting to see that I belong to so many teams of IT Infrastructure management. I am further detailing it out how my team work closely with other teams in an overall IT landscape.

Network Team:

When do we need?

  • Network setup for your RAC environment.
  • DNS server cannot find the appropriate IP.
  • Client server cannot find database server in the network.
  • Network latency and so on …

Have you ever seen one or all these issues? then certainly you would have reached network team for their support. Before we approach, we would have certainly have understanding about TCP/IP protocols, Subnets, IP address classes etc. to communicate with the network team.

   Temporarily, I become a junior network administrator 🙂 as I understand how the problems are raised and fixed.

Storage team:

When do we need?

  • File systems/mount points extension/addition.
  • To have clustered file systems.
  • Assigning file systems to ASM.
  • Snapshot backups of your disks.
  • I/O issue on the disk and so on…

I am sure that we should be understanding the storage terminologies like RAID, NAS, SAN storages and their possibilities as we approach storage team.

–   Now, I am a junior Storage administrator 🙂

Server team:

When do we need?

  • File systems/mount points extension/addition.
  • Setup all pre-requisites as root to run Oracle software.
  • Configuring mail server.
  • Cannot find Crontab.
  • Permissions on file systems.
  • Heavy resource contention.
  • Allow/block ports and on …

You must have added some knowledge on what sort of file system type you need ext4/3, SWAP space, CPU/Memory structure, permission levels etc. to get support from server team.

–   Now, I am a junior Server administrator 🙂

Backup team:

When do we need?

  • Tape drives setup.
  • Tape backups.
  • Tape restorations.
  • Scheduling and planning and on…

It can be IBM Tivoli, NetBackup, Powervault, Commvault, Iperius or any similar tool; We take efforts to understand retention policies, TAPE sizes, Drive capacities, time lines from backup team.

–   Now, I am a junior Backup administrator 🙂

Monitoring team:

We interact for –

  • Database server unavailability.
  • Database not reachable.
  • Monitoring tool configuration.
  • Tool access.
  • Ticketing and follow ups and on…

BMC monitoring, DHC, HP OVO, Spotlight, OEM and it can be any other tool; Oracle DBA should have knowledge on how the tool works and produces the alerts to the tool.

–   Now, I can debug any Monitoring issues 🙂

Application support team:

We interact for –

  • Database access.
  • Data maintenance.
  • Performance issues.
  • Application testing.
  • Application release/maintenance and on…

For application support, Oracle DBA’s are the main point of contact for any issue in availability, performance even when it is not a database issue 🙂

–   Here, I get to understand various aspects of application in terms of functionality and technology 🙂

All that said, I am no more acting just as an Oracle DBA in silos but becoming an all-rounder technically. This summarizes why I love to be an Oracle DBA with exciting activities day in day out.

I am sure, some of you might co-relate to these. But it would be great to know your passion and reasons behind continuing an awesome Oracle DBA role.

Leave your comments – I love to know your versions of the journey.

Related Posts

About The Author

19 Comments

  1. amolkumtakar@gmail.com'
    Amol
    December 11, 2015
    • kumar@orskl.com'
      Kumar
      December 15, 2015
  2. shivattri01@gmail.com'
    shiv
    December 12, 2015
  3. skvbalaji@gmail.com'
    Vinod
    December 12, 2015
    • kumar@orskl.com'
      Pawan Kumar
      December 15, 2015
  4. padmalochan.singh@gmail.com'
    padmalochan
    December 14, 2015
    • kumar@orskl.com'
      Pawan Kumar
      December 15, 2015
  5. vamsee1005@gmail.com'
    vamsi krishna
    December 15, 2015
  6. mayanksharma1293@gmail.com'
    Mayank
    December 21, 2015
    • kumar@orskl.com'
      Pawan Kumar Yaddanapudi
      December 22, 2015
  7. Charloboy@gmail.com'
    Charles bate
    December 31, 2015
  8. vivekmcm@gmail.com'
    vivek
    January 22, 2016
    • Pawan Kumar Yaddanapudi
      January 25, 2016
  9. pinto.das88@yahoo.com'
    Pinto
    January 28, 2016
    • Pawan Kumar Yaddanapudi
      January 29, 2016
  10. praveenkumar.cheyat@gmail.com'
    praveeen
    March 25, 2016
    • Pawan Kumar Yaddanapudi
      April 15, 2016
  11. jupitorberg@gmail.com'
    jupitorberg berg
    August 16, 2016

Add Comment