Oracle Skills Matrix

Dr. Michael Bisconti

Database Administrator, Developer, Architect, Mentor, & Manager 

#2 Wednesday, February 2, 2011  Update of This Page

 

 

Skill

Versions 7.x

Versions 8.x

Versions 9.x

Versions 10g

Versions 11i

Backup/Recovery

Yes

Yes

Yes

Yes

Yes

Batch processing

Yes

Yes

Yes

Yes

Yes

Export/Import

Yes

Yes

Yes

Yes

Yes

Capacity planning

Yes

Yes

Yes

Yes

Yes

Clustering and redundancy design

Yes

Yes

Yes

Yes

Yes

Daily maintenance

Yes

Yes

Yes

Yes

Yes

Database maintenance plans, scheduling, alerts

Yes

Yes

Yes

Yes

Yes

DCL/DDL/DML

Yes

Yes

Yes

Yes

Yes

Devices, databases and tablespaces design, creation, and updating

Yes

Yes

Yes

Yes

Yes

Disaster Recovery

Yes

Yes

Yes

Yes

Yes

Documentation - policies and procedures

Yes

Yes

Yes

Yes

Yes

Hardware/RAID

Yes

Yes

Yes

Yes

Yes

Indexing and index optimization

Yes

Yes

Yes

Yes

Yes

Install/Configure/Upgrade

Yes

Yes

Yes

Yes

Yes

Load balancing

Yes

Yes

Yes

Yes

Yes

Logical design (schema)

Yes

Yes

Yes

Yes

Yes

Migration

Yes

Yes

Yes

Yes

Yes

Monitoring

Yes

Yes

Yes

Yes

Yes

Network/OS

Win, Unix

Win, Unix

Win, Unix

Win, Unix

Win, Unix

OLAP (Data warehousing)

Yes

Yes

Yes

Yes

Yes

OLTP

Yes

Yes

Yes

Yes

Yes

Performance Tuning (Optimization)

Yes

Yes

Yes

Yes

Yes

Physical design

Yes

Yes

Yes

Yes

Yes

Query Optimization

Yes

Yes

Yes

Yes

Yes

Replication

Yes

Yes

Yes

Yes

Yes

Security (User) administration

Yes

Yes

Yes

Yes

Yes

SQL (PL/SQL)

Yes

Yes

Yes

Yes

Yes

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

Yes

Yes

Yes

Yes

Yes

Oracle end of ecommerce solutions

Yes

Yes

Yes

Yes

Yes

Oracle vendor relations

Yes

Yes

Yes

Yes

Yes

Stored procedures, triggers, constraints, views

Yes

Yes

Yes

Yes

Yes

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

Yes

Yes

Yes

Yes

Yes

Troubleshooting

Yes

Yes

Yes

Yes

Yes

WEBSITE COPYRIGHT NOTICE

Copyright 2000 2011  Bisconti Databases  All rights reserved.

Chicago, Illinois

United States of America