I am putting together a prelimanary job task analysis
for Oracle DBA's and would like some input from you
hardworking DBA's on this list.
Here is what I have so far for core competencies and I
would like to add or subtract from this list based on
your input.
A. Oracle Architecture And Options
B. Security and Network Access
C. Application Design and Modelling
D. Backup And Recovery
E. Software Maintenance And Operation
F. SEGMENT and DATA MANAGEMENT
G. Tuning And Troubleshooting
My Recommendations for slightly more advanced
competencies that are still quite important
For many installations.
H. Scalability
I. High Availability
J. Business Intelligence
Here is what I have as sub-components for the core
competencies.
A. ORACLE ARCHITECTURE AND OPTIONS
1. Demonstrate an understanding of memory structures
and processes which make up an Oracle instance
2. Demonstrate an understanding of the logical and
physical structures associated with an Oracle database
3. Demonstrate an understanding of PL/SQL constructs
(triggers, functions, packages, procedures) and their
processing
4. Demonstrate an understanding of distributed
architecture and client server and 3 tier
architectures
5. Demonstrate an understanding of Oracle
Globalisation
B. SECURITY and NETWORK ACCESS
1. Create, alter, and drop database users
2. Develop and implement a strategy for managing
security using roles, privileges, authentication,
3. Demonstrate an Appreciation of implementing row
level security using Application Contexts and Fine
Grain access control
4. Demonstrate an Appreciation of implementing
Network security using Oracle Internet Directory (OID)
,LDAP and Single Sign On (SSO)
5. Demonstrate an Appreciation of implementing
firewalls in Oracle using Standard Oracle Net features
6. Use Database and Fine grain auditing
7.Demonstrate an understanding of the implications of
distributed
processing on the security model
C. Appication Design and Modelling
1. Implement the physical database from the logical
design
2. Understand the benefits of using stored procedures
and constraints to
implement the application
3. Maintain familiarity with the structure and
characteristics of database applications
4. Manage the bulk loading of data with SQLLDR
5. Manage Data transfer or reorganisation using
EXPORT/IMPORT
D. BACKUP AND RECOVERY
1. Understand Oracles Recovery Structures and
Architecture
2. Understand the Functionality of RMAN and its
benefits
3. Develop a suitable backup, restore and recovery
Strategy
4. Understand and implement multiplexed control files
5. Understand and implement redo log groups and redo
log members
6. Perform backups of databases and tablespaces with
and without RMAN
7. Perform restores and recoveries with and without
RMAN both complete and incomplete
8. Perform Block Media Recovery (BMR) with RMAN
9. Perform test recovery
E. SOFTWARE MAINTENANCE AND OPERATION
1. Install and upgrade Oracle and supporting products
using the Oracle Universal Installer and various
maintenance tools
2. Configure the Oracle instance using init.ora or
SPFILES and OMF
3. Create a database with or without OMF
4. Distinguish among Instance startup and shutdown
options
5. Configure and Manage Listeners and client naming
methods using Oracle Net
6. Demonstrate an understanding of the capabilities
of underlying
operating systems and File Systems as they relate to
the Oracle database
7. Manage maintenance contracts and support
agreements
F. SEGMENT and DATA MANAGEMENT
1. Understand and Implement tablespaces - locally
managed and dictionary managed and their datafiles
2. Understand the benefits of automatic segment space
management
3. Understand and Implement the various types of
Segments in Oracle for storing Table data, including
Tables,Clusters, IOTs, External Tables
4. Understand and implement different Index options
available in Oracle including B*Tree, Bitmap, reverse
key, and function based
5. Implement integrity constraints
6. Understand the implementation of Workspace
Management for table Versioning
G. TUNING AND TROUBLESHOOTING
1. Use data dictionary and Dynamic Performance views
to Monitor the Database and the Instance
2. Collect and analyze relevant database performance
information
3. Identify and implement appropriate solutions for
database performance problems
4. Diagnose and resolve locking conflicts
5. Diagnose Oracle Net problems
6. Perform capacity planning
7. Control system resource contention using the
Oracle Resource Manager
8. Implement profiles to limit resource consumption.
9. Use vendor support services when necessary
10. Communicate with users about problem resolution
and proper system usage
H. SCALABILITY
1. Demonstrate an appreciation of Real Application
Clusters Architecture Scaleup and Speedup capabilities
2. Demonstrate an Appreciation of Shared Server
Architecture
3.Demonstrate an appreciation of parallel execution
(Parallel Query,DML, DDL, and Recovery)
4. Understand Scaleup using Oracle Net Connection
Pooling, Connecton Multiplexing
I. HIGH AVAILABILITY
1. Demonstrate an appreciation of Real Application
Clusters Architecture High availability capabilities
Including RAC Guard
2. Understand Connect time Failover and Load Balancing
3. Understand Transparent Application Failover
4. Understand Data Guard Architecture and Physical and
Logical Standby Databases
5. Understand Replication using Advanced Replication
and Oracle Streams
J. BUSINESS INTELLIGENCE
1. Understand and Use Oracles Extranction,
Transformation, and Load facilities including External
Tables, and Incremental Change Data Capture
2. Understand the use of Star Schemas, Bitmap Indexes
and Bitmap Join Indexes
3. Understand Summary Management using Materialised
Views, and Oracle Dimensions for Realtional OLAP
processing
4. Understand Oracles implementation of Analytic
Workspaces for Multidimensional OLAP processing
Thanks in advance for your help,
Scott
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
