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.
- Oracle Architecture And Options
- Security and Network Access
- Application Design and Modelling
- Backup And Recovery
- Software Maintenance And Operation
- SEGMENT and DATA MANAGEMENT
- 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.
- ORACLE ARCHITECTURE AND OPTIONS
- Demonstrate an understanding of memory structures
and processes which make up an Oracle instance
- Demonstrate an understanding of the logical and
physical structures associated with an Oracle database
- Demonstrate an understanding of PL/SQL constructs
(triggers, functions, packages, procedures) and their
processing
- Demonstrate an understanding of distributed
architecture and client server and 3 tier
architectures
- Demonstrate an understanding of Oracle
Globalisation
- SECURITY and NETWORK ACCESS
- Create, alter, and drop database users
- Develop and implement a strategy for managing
security using roles, privileges, authentication,
- Demonstrate an Appreciation of implementing row
level security using Application Contexts and Fine
Grain access control
- Demonstrate an Appreciation of implementing
Network security using Oracle Internet Directory (OID)
,LDAP and Single Sign On (SSO)
- Demonstrate an Appreciation of implementing
firewalls in Oracle using Standard Oracle Net features
- Use Database and Fine grain auditing
7.Demonstrate an understanding of the implications of
distributed
processing on the security model
- Appication Design and Modelling
- Implement the physical database from the logical
design
- Understand the benefits of using stored procedures
and constraints to
implement the application
- Maintain familiarity with the structure and
characteristics of database applications
- Manage the bulk loading of data with SQLLDR
- Manage Data transfer or reorganisation using
EXPORT/IMPORT
- BACKUP AND RECOVERY
- Understand Oracles Recovery Structures and
Architecture
- Understand the Functionality of RMAN and its
benefits
- Develop a suitable backup, restore and recovery
Strategy
- Understand and implement multiplexed control files
- Understand and implement redo log groups and redo
log members
- Perform backups of databases and tablespaces with
and without RMAN
- Perform restores and recoveries with and without
RMAN both complete and incomplete
- Perform Block Media Recovery (BMR) with RMAN
- Perform test recovery
- SOFTWARE MAINTENANCE AND OPERATION
- Install and upgrade Oracle and supporting products
using the Oracle Universal Installer and various
maintenance tools
- Configure the Oracle instance using init.ora or
SPFILES and OMF
- Create a database with or without OMF
- Distinguish among Instance startup and shutdown
options
- Configure and Manage Listeners and client naming
methods using Oracle Net
- Demonstrate an understanding of the capabilities
of underlying
operating systems and File Systems as they relate to
the Oracle database
- Manage maintenance contracts and support
agreements
- SEGMENT and DATA MANAGEMENT
- Understand and Implement tablespaces - locally
managed and dictionary managed and their datafiles
- Understand the benefits of automatic segment space
management
- Understand and Implement the various types of
Segments in Oracle for storing Table data, including
Tables,Clusters, IOTs, External Tables
- Understand and implement different Index options
available in Oracle including B*Tree, Bitmap, reverse
key, and function based
- Implement integrity constraints
- Understand the implementation of Workspace
Management for table Versioning
- TUNING AND TROUBLESHOOTING
- Use data dictionary and Dynamic Performance views
to Monitor the Database and the Instance
- Collect and analyze relevant database performance
information
- Identify and implement appropriate solutions for
database performance problems
- Diagnose and resolve locking conflicts
- Diagnose Oracle Net problems
- Perform capacity planning
- Control system resource contention using the
Oracle Resource Manager
- Implement profiles to limit resource consumption.
- Use vendor support services when necessary
- Communicate with users about problem resolution
and proper system usage
- SCALABILITY
- Demonstrate an appreciation of Real Application
Clusters Architecture Scaleup and Speedup capabilities
- Demonstrate an Appreciation of Shared Server
Architecture
3.Demonstrate an appreciation of parallel execution
(Parallel Query,DML, DDL, and Recovery)
- Understand Scaleup using Oracle Net Connection
Pooling, Connecton Multiplexing
- HIGH AVAILABILITY
- Demonstrate an appreciation of Real Application
Clusters Architecture High availability capabilities
Including RAC Guard
- Understand Connect time Failover and Load Balancing
- Understand Transparent Application Failover
- Understand Data Guard Architecture and Physical and
Logical Standby Databases
- Understand Replication using Advanced Replication
and Oracle Streams
- BUSINESS INTELLIGENCE
- Understand and Use Oracles Extranction,
Transformation, and Load facilities including External
Tables, and Incremental Change Data Capture
- Understand the use of Star Schemas, Bitmap Indexes
and Bitmap Join Indexes
- Understand Summary Management using Materialised
Views, and Oracle Dimensions for Realtional OLAP
processing
- 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: oraracdba_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Apr 01 2003 - 15:14:12 CST
