Installing and upgrading the Oracle server and application tools
Allocating system storage and planning future storage requirements for the database system
Creating primary database storage structures (tablespaces) after application developers have designed an application
Creating primary objects (tables, views, indexes) once application developers have designed an application
Modifying the database structure, as necessary, from information given by application developers
Enrolling users and maintaining system security
Ensuring compliance with your Oracle license agreement
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information
Maintaining archived data on tape
Backing up and restoring the database
Contacting Oracle Corporation for technical support
A good knowledge of the operating system(s)
A good knowledge of physical database design
Ability to perform both Oracle and also operating system performance monitoring and the necessary adjustments.
Excellent knowledge of Oracle backup and recovery scenarios.
Good skills in all Oracle tools.
A good knowledge of Oracle security management.
A good knowledge of how Oracle acquires and manages resources.
Sound knowledge of the applications at your site.
Experience and knowledge in migrating code, database changes, data and
menus through the various stages of the development life cycle.
A good knowledge of the way Oracle enforces data integrity.
A DBA should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers.