(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.
(9) Puts standards in place to ensure that all application
design and code is
produced with proper integrity, security and
performance. The DBA will perform
reviews on the design and code frequently to ensure
the site standards are
being adhered to.
(10) Evaluates releases of Oracle and its tools, and
third party products to
ensure that the site is running the products that are
most appropriate.
Planning is also performed by the DBA, along with the
application developers
and System administrators, to ensure that any new
product usage or release
upgrade takes place with minimal impact.
(11) Provides technical support to application
development teams. This is
usually in the form of a help desk. The DBA is usually
the point of contact
for Oracle Corporation.
(12) Enforces and maintains database contraints to
ensure integrity of the
database.
(13) Administers all database objects, including
tables, clusters, indexes,
views, sequences, packages and procedures.
(14) Assists with impact analysis of any changes made
to the database objects.
(15) Troubleshoots with problems regarding the
databases, applications and
development tools.
(16) Create new database users as required.
(17) Manage sharing of resources amongst applications.
(18) The DBA has ultimate responsibility for the
physical database design.
The DBA should posses the following skills
(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.
(11) A good knowledge of the way Oracle enforces data
integrity.
(12) A sound knowledge of both database and program
code performance tuning.
(13) A DBA should possess a sound understanding of the
business.
(14) A DBA should have sound communication skills with
management, development
teams, vendors, systems administrators and other
related service providers.