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.

Friday, November 03, 2006

Changing Skillsets for Oracle DBAs - The New Challenge

Oracle DBAs have spent years developing their expertise in internals, backup/recovery, performance tuning and writing really cool scripts. Although these skills are still required, these are considered more standard skills. Today, organizations are struggling in new areas where there are not enough experienced DBAs.

The traditional DBA has worked on writing scripts to manage enterprise environments, how to optimize storage for tables and indexes, and how to optimize databases for different types of environments. The traditional DBA usually started out developing code in C, C++, Forms, Reports and PL/SQL. As this type of person became a DBA it was easy for them to support development environments on Oracle. Today's middle-tier environments are running BPEL, XML, J2EE, Web Services, SOA, ADF, JSF, Single-Signon, Identiy Managment, JMS, .NET, etc. and the traditional DBA does not have the right skill set to support these development environments. Recently a manager of a large organization told me "Things go fine in our XML and Java development environments but when we go to deploy our applications the DBAs mess everything up because they do not know how to optimize the environment for the types of applications we are writing".

The application server is also becoming a central piece of the architecture. BI and Internet applications are retrieving millions of records across the network and then processing them on the application server. Middleware developers are very knowledgeable on developing applications for the middle tier, however their priority is usually not how to optimize these applications for database performance. The issues between the database server and the application server are creating a lot of issues in organizations.

Most databases look more like a version 7 database and are using only a small subset of new features from Oracle9i and Oracle10g. There are a lot of reasons for this but what would you think of any company that was pretty much running their company with the same tools they had fifteen years ago. You would definitely see a lot of typewriters.
Today's DBAs are going to need to improve their enterprise management skills for environments running:

1) Oracle RAC, Data Guard, Streams, Oracle Grid, 3rd Party Database Monitoring and Management software, Advanced Queuing as well as understanding how to leverage new features in Oracle9i and Oracle10g.

2) Application servers and middle-tier applications. Middle-tier environments for large organizations are just as complex as database servers and address the similar issues such as performance, availability, scalability and backup/recovery.

3)The Oracle Fusion technology platform using technologies such as XML, BPEL, SOA, Web Services, J2EE, ADF and Grid.
Another area for DBAs to master is in governance and compliance. DBAs need to expand their skill sets to be able to increase the integration of technology and business in a world of Sarbanes-Oxley, ITIL, COBIT, ISO 17799 and COSC.

New technologies, larger databases, increased customer demand for performance and quicker deployments and Oracle Fusion are putting increased demands on today's DBAs. How are you addressing these challenges?


At 4:02 PM, Anonymous Anonymous said...

Understanding Oracle directions especially the new Fusion space is very confusing. As an Oracle DBA I am looking forward to seeing how this web site develops. My input is to help the DBA community understand Fusion and why we should care about it.


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