Solution Oracle, OCC

OLTP/OLAP Career Center

 

 

 

HOME PAGE

SQL Server Site Map

Oracle Site Map

RDBMS Site Map

 

 

 

 

 

 

Oracle Skills Matrix v1.2

 

This is the core skill set necessary to obtain certification as an Oracle database administrator.

 

 

 

Skill

Versions 7.x

Versions 8.x

Versions 9.x

Backup/Recovery

Yes

Yes

Yes

Batch processing

Yes

Yes

Yes

Export/Import

Yes

Yes

Yes

Capacity planning

Yes

Yes

Yes

Clustering and redundancy design

Yes

Yes

Yes

Daily maintenance

Yes

Yes

Yes

Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

DCL/DDL/DML

Yes

Yes

Yes

Devices, databases and tablespaces design, creation, and updating

Yes

Yes

Yes

Disaster Recovery

Yes

Yes

Yes

Documentation - policies and procedures

Yes

Yes

Yes

Hardware/RAID

Yes

Yes

Yes

Indexing and index optimization

Yes

Yes

Yes

Install/Configure/Upgrade

Yes

Yes

Yes

Load balancing

Yes

Yes

Yes

Logical design (schema)

Yes

Yes

Yes

Migration

Yes

Yes

Yes

Monitoring

Yes

Yes

Yes

Network/OS

NT, Unix

NT, Unix

NT, Unix

Normalization

Yes

Yes

Yes

OLAP (Data warehousing)

Yes

Yes

Yes

OLTP

Yes

Yes

Yes

Performance Tuning (Optimization)

Yes

Yes

Yes

Physical design

Yes

Yes

Yes

Query Optimization

Yes

Yes

Yes

Replication

Yes

Yes

Yes

Security (User) administration

Yes

Yes

Yes

SQL

Yes

Yes

Yes

Oracle end of architecture (2-tier, 2-tier, 3-tier & other n-tier)

Yes

Yes

Yes

Oracle end of ecommerce solutions

Yes

Yes

Yes

Oracle vendor relations

Yes

Yes

Yes

Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Tables, fields (columns), records (rows) - creation and updating

Yes

Yes

Yes

Troubleshooting

Yes

Yes

Yes