Oracle Career Options -
As well as DBA work,a very attractive Option involves PL/SQL, which is Oracle's proprietary
Programming Language.
PL/SQL includes and extends SQL, and is primarily intended for developers who work close
to the Database, rather than close to the User.
Working with PL/SQL often includes some DBA work, for example, in data extraction and migration
from a Database.
It is therefore much more of a development job and offers design challenges and is more creative
than 100% DBA work.
Here's a typical Help Wanted Ad to give you a feeling for the skills required -
"PL/SQL Developer With DBA Skills"
Multinational Multimedia organisation requires an experienced PL/SQL Developer who also has had DBA exposure,
with good Unix Shell Scripting skills.
Working on a systems migration project, you will have proven technical ability and excellent interpersonal skills.
An ability to be able to write PL/SQL packages & procedures, create database load scripts and
set-up development databases is essential.
The position will demand some DBA support (approximately 20% of the role) however the support
will be of a wholly ad-hoc nature.
Working within an Oracle 7, 8 & 8i environment, associated experience is essential,
as is solid commercial experience with PL/SQL.
Oracle Designer is used by system designers to define the Data Model/Database and functions in a system.
The actual code is then generated automatically.
Oracle Developer is used by developers to produce Forms, Reports etc., and provides more control over the
appearance and functioning of the final application.
PL/SQL is Oracle's proprietary extension to SQL,(PL stands for Programming Language
or Procedural Language).
You certainly need to know SQL, and learning PL/SQL will teach you SQL, but
you could learn 'vanilla SQL' first.
Check out this page for 'Online Training' which includes some SQL Tutorials ...
http://www.databaseanswers.com/links.html
DBA Training Courses
DBA courses given by the Oracle Corporation are rather expensive.
Cheaper alternatives may be available from other training organizations, but
if they are not Oracle Education partners you may be taking a risk.
Alternatives are available online from a variety of sources.
Check out this page for some suggestions
in Oracle training.
Oracle Certification
The cheapest and quickest way to get Oracle Certification is to take a 4-day Course
in Internet Database Operator.
This costs substantially less than full DBA training but would give you basic skills and
confirmation that you would like DBA work.
Also you should consider signing up as an Oracle Partner.
It costs about the same as a 5-day course, but includes 5 days free training (so it pays for itself),and
subsequently you get 25% discount off training.
As I note on the http://www.databaseanswers.com/what_is_a_dba.html page, Oracle is continually providing
more point-and-click facilities for DBA work,
so what you learn now for DBA work may become a legacy skill in six months time.
In practice, new versions of Oracle,(they are now selling 9i), will take some time to filter into the
marketplace so 8 and 8i skills will still be in demand for a while.
Two other career choices I would recommend for consideration are System Architect using Oracle Designer,
which would leverage an Infrastructure background, and Database Analyst, using Oracle's PL/SQL.
This would involve much more hands-on work than the Architect role.
The choice therefore depends largely on your preferences and how easily you can define 'job satisfaction'
and translate that to one of a number of clearly-defined job profiles or roles in the marketplace.
About the only thing which is clear is that if you like Database work, then Oracle is the right choice.
Check any online recruitment Web Site, for example,Monster.com,
and search for 'database' and the number of Oracle-related openings is far greater than the second or third choices,
(IBM DB2 and Microsoft SQL Server).