Oracle Database Management Strategic Directions

1. Best Practices for managing Oracle database servers.
2. Oracle Fusion Middleware products like J2EE, ADF, XML, BPEL, SOA, Web Services, Discoverer...).
3. Oracle Application Servers and Apache.

Thursday, November 15, 2007

Oracle Open World - Changing Role of the DBA

One thing that stands out at Oracle Open World 2008 in San Francisco is the changing role of the Oracle DBA. There are a number of presentations showing how new Oracle technologies and the next generation of Oracle Grid Control are going to change how DBAs manage databases. Oracle DBAs that want to stay marketable are going to have to make sure their skills are consistent with the demands of the market. Oracle DBAs in demand are going to need to specialize in some of the following areas:
  • Oracle High Availability - RAC and Data Guard
  • Storage Management - Automatic Storage Management (ASM)
  • Oracle Streams
  • Oracle Grid Control - Using new tools, advisors and metholdologies for managing the enterprise.
  • Oracle Fusion Middleware - Ability to manage multi-tiered architectures.
  • Identity Management - Ability to work with Oracle Internet Directory and other LDAP servers.
  • Ability to support Enterprise Web 2.0
  • Ability to support multiple database platforms like MySQL.
The old days of an Oracle DBA being able to get by on just performance tuning and backup/ recovery skills are not going to be enough to stay marketable in the future. Basic skill sets are easy to find and easy to outsource. To get a better vision of the future you should look at new features in Oracle Database 11g that can greatly simplify database administration. Some of these include:
  • Automatic SQL tuning
  • New Diagnostics Advisor
  • RMAN Advisor
  • SQL Tuning Advisor
This list is a very small subset of all the diagnostic and advisor tools available in the Oracle Enterprise Manager for Oracle Database 11g. These large set of tools are going to play a large role in managing Oracle production environments. The old days of writing custom scripts are almost over. DBAs are going to use more tools like Grid Control automate a lot of the day to day tasks DBAs typically perform.

Labels: , ,


At 2:03 AM, Anonymous Anonymous said...

I've always been impressed by the presentations by Trubix consultants. I agree with your assessment. presentations by people like Tom Kyte reiterate the direction you have given.

At 3:17 PM, Blogger jkanagaraj said...

Upgrading skill sets is an essential element for any DBA (or Developer/IT person for that matter!). If you (the reader) missed Oracle OpenWorld, then you should not plan to miss the COLLABORATE 08 conference which will have a large number of papers, presentations, technical panels, networking opportunities and University sessions.


Post a Comment

<< Home


George Trujillo


Popular Classes

  • Oracle11gR2 New Features

  • Intro to Java Programming
  • Intro to Linux for Oracle
  • Intro to PL/SQL Programming
  • Oracle11gR2 Fusion Dev Wkshp I



    The Trubix Blog is focused on discussions on strategic directions in database technology and the challenges Oracle technologists are addressing today and in the future. This site will focus on issues and challenges of database management that cannot be resolved with a code snippet. There are already a lot of great websites out there with tons of code samples. We would like to facilitate more discussions on issues Oracle technologists are dealing with today that a quick search on the Internet cannot solve. There will also be a group of recognized industry leaders that will also participate in this blog. This blog is an extension of the Tim Tam Group, an international group of industry leaders that meet once a year to discuss strategic directions in the industry.



    Powered by Blogger