-
Notifications
You must be signed in to change notification settings - Fork 21
/
Copy pathdba_as_a_career.htm
198 lines (158 loc) · 8.46 KB
/
dba_as_a_career.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
<HTML><HEAD><TITLE>DBA as a Career</TITLE></HEAD>
<BODY TEXT="#202020">
<TABLE WIDTH=90%>
<TR>
<TD ALIGN=left VALIGN=top>
<IMG ALT="Database Answers Header" HEIGHT=58 WIDTH=400 SRC="images/dba_400_home.jpg">
</TD>
<TD ALIGN=right ROWSPAN=2 VALIGN=middle>
<IMG ALIGN=right ALT="The DBA has to be like a Rock" HEIGHT=110 WIDTH=99 SRC="images/underwater_block.gif">
</TD>
</TR>
<TR>
<TD><FONT COLOR=red FACE="Comic Sans MS" SIZE=4>
<B>DBA as a Career</B></FONT>
</TD>
</TR>
</TABLE>
<FONT COLOR=blue FACE=Verdana SIZE=2>
<!-- end Standard Header - Version 3-->
<TABLE BGCOLOR=blue WIDTH=90%>
<TR>
<TD ALIGN=left COLSPAN=1 VALIGN=TOP WIDTH=40>
<A HREF="index.htm"><IMG ALT="Home" BORDER=0 SRC="images/buttons/home_alt.gif"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=100>
<A HREF="ask_a_question.htm"><IMG ALT="Ask a Question" BORDER=0 SRC="images/buttons/ask_a_question_alt.gif"></A>
</TD>
<TD ALIGN=middle BGCOLOR=white VALIGN=middle WIDTH=60>
<A HREF="careers.htm"><IMG ALT="Careers" BORDER=0 SRC="images/buttons/careers_alt.jpg"></A>
</TD>
<TD ALIGN=left VALIGN=top WIDTH=85>
<A HREF="data_models/index.htm"><IMG ALT="Data Models" BORDER=0 SRC="images/buttons/data_models_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="faqs.htm"><IMG ALT="FAQs" BORDER=0 SRC="images/buttons/faqs_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=75>
<A HREF="sql_scripts/index.htm"><IMG ALT="SQL Scripts" BORDER=0 SRC="images/buttons/sql_scripts_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=50>
<A HREF="site_map.htm"><IMG ALT="Search" BORDER=0 SRC="images/buttons/search_alt.gif"></A>
</TD><TD ALIGN=left VALIGN=top WIDTH=62>
<A HREF="site_map.htm"><IMG ALT="Site Map" BORDER=0 SRC="images/buttons/site_map_alt.gif"></A>
</TD>
<TD> </TD>
</TR>
</TABLE>
<!-- end Standard Header - Version 3-->
<!-- begin body Text -->
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<!-- end Standard Header - Version 3-->
<!-- begin body Text -->
<TABLE BGCOLOR="#98CEDF" WIDTH=90%>
<TR>
<TD VALIGN=top>
<IMG ALIGN=left ALT="Boschendal Esate, South Africa" BORDER=0 HEIiGHT=122 WIiDTH=95 SRC="images/boschendal_vertical_sml.jpg"></A>
</TD>
<TD VALIGN=top>
<FONT COLOR=blue FACE=Verdana SIZE=2>
<B>A DBA</B> is a Database Administrator, and this is the most common job that
you find a database specialist doing.
<BR> Check out this page on my Database Answers Web Site to get an idea of What is a DBA :-
<BR> http://www.databaseanswers.com/what_is_a_dba.htm
<P><A HREF="http://swz.salary.com/salarywizard/layoutscripts/swzl_titleselect.asp?jobcode=IT10000022&jobaltername=Database+Administrator&jobtitle=Database+Administrator&narrowdesc=IT+%2D%2D+All&narrowcode=IT03&zipcode=&metrocode=&geo=U%2ES%2E+National+Averages" TARGET=_NEW>
'How much does a DBA earn ?'</A> is always an interesting question !!!
<P>A DBA is responsible for maintaining Databases within an organisation, so it is a
very difficult and demanding job.
<BR>Therefore, of course, it is also a rewarding job, both financially and in terms
of job satisfaction.
<BR><BR>I have many years experience of working as a DBA, maintaining Production Databases
in Investment Banks, such as J.P.Morgan and Salomon Smith Barney.
<BR>Those were some of the most demanding and high-pressure years in my professional career.
<HR>
For IBM people, here's a good starting point for information on <A HREF="http://www-4.ibm.com/software/data/db2/skills/" TARGET=_NEW>DB2 Universal Database Skills.</A>
</TD></TR>
<!--- </TABLE> --->
<TR><TD COLSPAN=2>
<A NAME="ORACLE_CAREER_OPTIONS"></A>
<HR><FONT COLOR=blue FACE=Verdana SIZE=2>
<FONT COLOR=red><B>Oracle Career Options - </B></FONT>
<BR>As well as DBA work,a very attractive Option involves PL/SQL, which is Oracle's proprietary
Programming Language.
<BR>PL/SQL includes and extends SQL, and is primarily intended for developers who work close
<BR>to the Database, rather than close to the User.
<BR>Working with PL/SQL often includes some DBA work, for example, in data extraction and migration
from a Database.
<BR>It is therefore much more of a development job and offers design challenges and is more creative
than 100% DBA work.
<P>
<FONT COLOR=red><B>Here's a typical Help Wanted Ad to give you a feeling for the skills required - </B></FONT>
<BR><B>"PL/SQL Developer With DBA Skills"</B>
<BR>Multinational Multimedia organisation requires an experienced PL/SQL Developer who also has had DBA exposure,
<BR>with good Unix Shell Scripting skills.
<BR>Working on a systems migration project, you will have proven technical ability and excellent interpersonal skills.
<BR>An ability to be able to write PL/SQL packages & procedures, create database load scripts and
set-up development databases is essential.
<BR>The position will demand some DBA support (approximately 20% of the role) however the support
<BR>will be of a wholly ad-hoc nature.
<BR>Working within an Oracle 7, 8 & 8i environment, associated experience is essential,
as is solid commercial experience with PL/SQL.
<HR>
<B>Oracle Designer</B> is used by system designers to define the Data Model/Database and functions in a system.
<BR>The actual code is then generated automatically.
<BR><B>Oracle Developer</B> is used by developers to produce Forms, Reports etc., and provides more control over the
<BR>appearance and functioning of the final application.
<P>PL/SQL is Oracle's proprietary extension to SQL,(PL stands for Programming Language
<BR>or Procedural Language).
<P>You certainly need to know SQL, and learning PL/SQL will teach you SQL, but
<BR>you could learn 'vanilla SQL' first.
<BR>Check out this page for 'Online Training' which includes some SQL Tutorials ...
http://www.databaseanswers.com/links.htm
<FONT COLOR=blue FACE=Verdana SIZE=2>
<FONT COLOR=red FACE=Verdana SIZE=2><B>DBA Training Courses</B></FONT>
<PRE><FONT COLOR=blue FACE=Verdana SIZE=2>
<B>DBA courses</B> 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 <A HREF="oracle_training.htm">this page</A> for some suggestions
in Oracle training.
<FONT COLOR=red FACE=Verdana SIZE=2><B>Oracle Certification</B></FONT>
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.htm 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,<A HREF="http://www.monster.com" TARGET=_NEW>Monster.com,</A>
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).
</PRE>
</FONT>
<!-- Start of Standard Footer -->
<HR SIZE=3>
<CENTER><FONT FACE="Verdana" SIZE=1>
[ <A HREF="index.htm">Home Page</A>
| <A HREF="ask_a_question.htm">Ask Us a Question</A>
| <A HREF="a_day_in_the_life.htm">Day in the Life</A>
| <A HREF="mailto:info@databaseanswers.com">Email Us</A>
| <A HREF="faqs.htm">FAQs</A>
| <A HREF="site_map.htm">Search & Site Map</A> ]
</CENTER>
<P>
<!-- End of Standard Footer -->
<CENTER><FONT COLOR=blue SIZE=1><I> © IceBreaker WebDesigns 2001</I></FONT></CENTER>
</TD></TR>
</TABLE>
</BODY>
</HTML>