LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 04-20-2009, 01:35 PM   #1
latinmusic74
Member
 
Registered: Jun 2007
Posts: 118

Rep: Reputation: 16
Steps to become a Database Administrator


Best steps to become a database administrator.

Thanks
 
Old 04-20-2009, 02:09 PM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985
Study and practise database administration... what else can we say?

Pick a database that you wish to specialise in... Oracle, Mysql, Postgresql, MSSQL even, and use it, learn it. Get a junior job working with it, and climb the ladder.
 
Old 04-20-2009, 04:44 PM   #3
latinmusic74
Member
 
Registered: Jun 2007
Posts: 118

Original Poster
Rep: Reputation: 16
Which one will you recommend for a Junior Position:

Oracle
Mysql
Postgresql
MSSQ
 
Old 04-20-2009, 07:21 PM   #4
Blinker_Fluid
Member
 
Registered: Jul 2003
Location: Clinging to my guns and religion.
Posts: 683

Rep: Reputation: 63
1. Learn Database Administration stuff.
2. ???
3. Profit.


(sorry had to)
 
Old 04-21-2009, 03:06 AM   #5
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985
Depends what kind of DBA you want to be. Oracle is probably the "safest" choice in enterprise environments.
 
Old 04-22-2009, 12:31 AM   #6
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
All good DBAs are mathematicians.
 
Old 04-22-2009, 01:26 AM   #7
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 952

Rep: Reputation: 217Reputation: 217Reputation: 217
Get a basic qualification As acid_kewpie says, Oracle is probably the "safest".

Entry level job after this should be to join a service organisation where you will be part of a team that does administration for clients. Most of these jobs involve monitoring and recording the health of the data base and raising alerts. This will teach you good practices and procedures for basic server maintenenace and uptime.

Ideally an entry level person shouldn't join clint organisations strainght away since there will be less likelihood of learning the best practices and procedures (relating to your chosen field of DBA).

End
 
Old 04-22-2009, 07:32 AM   #8
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
A lot of developers think they're DBAs and a lot of sysadmins think they're DBAs too.

IMHO, if you can't create a Venn diagram for union, intersect, difference and compliment, then you're not a DBA.

http://en.wikipedia.org/wiki/Venn_diagram
http://en.wikipedia.org/wiki/Set_theory
http://en.wikipedia.org/wiki/Edgar_F._Codd

Last edited by Crito; 04-22-2009 at 07:33 AM.
 
Old 04-22-2009, 12:45 PM   #9
latinmusic74
Member
 
Registered: Jun 2007
Posts: 118

Original Poster
Rep: Reputation: 16
Thanks for all you advise and information. I will take a look in oracle, but first I will do a review on SQL.
 
Old 04-22-2009, 01:31 PM   #10
ncsuapex
Member
 
Registered: Dec 2004
Location: Raleigh, NC
Distribution: CentOS 2.6.18-53.1.4.el5
Posts: 770

Rep: Reputation: 44
Quote:
and a lot of sysadmins think they're DBAs too.
I do not wish nor think I'm a DBA.
 
Old 04-22-2009, 02:00 PM   #11
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985
Having spent half a day screwing around with Oracle XE, I am also no DBA.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i copt the MYSQL Database to a other server (Database) halvorls Linux - Server 3 07-27-2008 09:19 PM
why im not administrator thatgirl Linux - Newbie 3 12-28-2007 08:01 PM
(my)sql: drop database doesn't remove database kpachopoulos Programming 3 09-19-2007 01:32 PM
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 08:20 AM
LXer: A database solution is more than database software LXer Syndicated Linux News 0 09-25-2006 08:54 AM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 07:20 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration