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 reasons for this. 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.
George Trujillo