1) Creates and maintains all databases required for development, testing,
education and production usage.
(2) Performs the capacity planning required to create and maintain the
databases. The DBA works closely with system administration staff because
computers often have applications or tools on them in addition to the Oracle
Databases.
(3) Performs ongoing tuning of the database instances.
(4) Install new versions of the Oracle RDBMS and its tools and any other tools
that access the Oracle database.
(5) Plans and implements backup and recovery of the Oracle database.
(6) Controls migrations of programs, database changes, reference data changes
and menu changes through the development life cycle.
(7) Implements and enforces security for all of the Oracle Databases.
(8) Performs database re-organisations as required to assist performance and
ensure maximum uptime of the database.
1) A good knowledge of the operating system(s)
(2) A good knowledge of physical database design
(3) Ability to perform both Oracle and also operating system performance
monitoring and the necessary adjustments.
(4) Be able to provide a strategic database direction for the organisation.
(5) Excellent knowledge of Oracle backup and recovery scenarios.
(6) Good skills in all Oracle tools.
(7) A good knowledge of Oracle security management.
(8) A good knowledge of how Oracle acquires and manages resources.
(9) Sound knowledge of the applications at your site.
(10) Experience and knowledge in migrating code, database changes, data and
menus through the various stages of the development life cycle.