RDBMS Solutions, OCC
OLTP/OLAP
Career Center
RDBMS Skills Matrix v1.2
This is the core skill set necessary to
obtain certification as a Sybase, Informix, DB2, or other RDBMS (not including
SQL Server and Oracle) database administrator.
|
Skill |
|
Backup/Recovery |
|
Batch processing |
|
Export/Import |
|
Capacity planning |
|
Clustering and redundancy design |
|
Daily maintenance |
|
Database maintenance plans, scheduling, alerts |
|
DCL/DDL/DML |
|
Devices and databases – design, creation, and updating |
|
Disaster Recovery |
|
Documentation - policies and procedures |
|
Hardware/RAID |
|
Indexing and index optimization |
|
Install/Configure/Upgrade |
|
Load balancing |
|
Logical design (schema) |
|
Migration |
|
Monitoring |
|
Normalization |
|
OLAP (Data warehousing) |
|
OLTP |
|
Performance Tuning (Optimization) |
|
Physical design |
|
Query Optimization |
|
Replication |
|
Security (User) administration |
|
SQL |
|
RDBMS end of architecture (2-tier, 2½-tier, 3-tier &
other n-tier) |
|
RDBMS end of ecommerce solutions |
|
RDBMS vendor relations |
|
Stored procedures, triggers, constraints, views |
|
Tables, fields (columns), records (rows) - creation and
updating |
|
Troubleshooting |