Home
Tuesday, May 30, 2017
8:44:55 AM
Users online: 0   You are here >> Home > Programming

Forums | Programming Forums search
Forum FAQ
   
  1  
DBA role
dBUG 
17/7/08 5:42:25 PM
Champion

Hi all,

Hopefully i'm in the right section. If not, then Mod can move / delete this thread.

Anyway, I'm interested in doing a DBA role next year in my company. (we get to choose what role we want to do in the company after working 12 months as an IT Security Admin)

I've done some database courses when i was in Uni, but that was 3 years ago :

so, could someone recommend a book or perhaps explain what's DBA's duties etc? :)

Many thanks..

-----
xbox live : vzion
PSN : big-black-dog

playing:
GTA4 (X360)
MGS3 (PS2)

kikz 
17/7/08 6:14:16 PM
Immortal

The DBA's role is ensure the companies databases are kept in optimal conditions. They ensure replication is working (to backup sites, clusters), configure clusters and load balancing, monitor for bottlenecks in performance and apply indexes to queries where necessary. They maintain the lists of users and roles (security) for the databases and, depending on the company, can perform the role of database / data layer developers either directly developing the data access strategies or casting their eye over what has been developed, to ensure efficiency and correct implementation.

Go grab a book or three on the particular DMBS you want to use.

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

dave_blob 
17/7/08 8:07:14 PM
Guru

Quote by kikz
The DBA's role is ensure the companies databases are kept in optimal conditions. They ensure replication is working (to backup sites, clusters), configure clusters and load balancing, monitor for bottlenecks in performance and apply indexes to queries where necessary. They maintain the lists of users and roles (security) for the databases and, depending on the company, can perform the role of database / data layer developers either directly developing the data access strategies or casting their eye over what has been developed, to ensure efficiency and correct implementation.

Go grab a book or three on the particular DMBS you want to use.



or, more in line with people ive seen with the DBA title:

"the guy who restarts the SQL server service when stuff stops working"
:p

-----
Your comeback shames me

Phelan:
You exist. You are born and you die. That's it.
What matters is life before death - enjoy your time here, be nice to others and have some fun.

kikz 
17/7/08 8:52:10 PM
Immortal

lol. I'm a dba then. Nah I was just describing some of the stuff I do with databases, and I'm not even a DBA. I figured if I was, I'd be doing that anyway :)

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Amiga4eva 
17/7/08 8:59:44 PM
Hero
Titan


DBAs also look after packaging for database related applications or updates, so a developer might provide the DBAs with new SQL stored procedures, tables, updates to the schema etc, and the DBA will be responsible for packaging those or refining them for release into a production environment.

When Databases go suspect, or need to be restored or have transaction logs rolled forwards etc, DBAs are who you get in touch with. They may be responsible for all database related accounts as well, either DBO or lesser.

If you're going to try and drop a trigger onto a heavily written to table, it is more than likely the DBA who will do the performance testing and optimisation of the trigger to ensure it's not going to drag the database down etc.



-----
Mehing the Meh Meh.....

Jeruselem 
18/7/08 12:13:44 PM
Champion

I'm a real DBA ... I maintain multi-GB SQL Server databases and I'm also the programmer for the front-end to the databases too. I also fix workstations, try to fix networking issues ... I do too much.

-----
PC 1: XP Home SP2, Opty 165@1.8Ghz, GEIL 1GB PC3200, 320GB SATA Cuda ES,XFX 9600GSO 580/700x2/1450, Seasonic S12+ 550W
PC 2: XP Home SP2, XP 3000+@2.24 Ghz, 1GB PC3200, 80GB IDE,ASUS nVidia 6800 512MB, Codegen 450W

kikz 
18/7/08 1:40:39 PM
Immortal

Quote by Jeruselem
I'm a real DBA ... I maintain multi-GB SQL Server databases and I'm also the programmer for the front-end to the databases too. I also fix workstations, try to fix networking issues ... I do too much.


So where's your list of "Things a DBA does"? :p

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Jeruselem 
18/7/08 3:21:07 PM
Champion

Quote by kikz
Quote by Jeruselem
I'm a real DBA ... I maintain multi-GB SQL Server databases and I'm also the programmer for the front-end to the databases too. I also fix workstations, try to fix networking issues ... I do too much.


So where's your list of "Things a DBA does"? :p



Like ...

Ensure database backups are working as well as the copies to tape and off-site backups
Testing of server software hotfixes and service packs
Testing compatiblity of databases on future releases of server software
Ensure connectivity on workstation software works with server backend eg MDAC/ODBC, etc
Make sure maintenance tasks are doing what they should be doing
Testing changes to server SQL databases does not break current current front-end client functionality
Monitoring database size especially server transaction logs
Creating redundancy plans in case the main SQL server falls over and making sure backup servers are ready to take over
Testing the server backups of the databases can be restored on another server (ie backups work)
Maintaining test servers which emulate production systems for developers (in my case - me)
Make sure the backup systems are mostly automated, highly reliable and low maintenance

PS - I'm the DBA and developer at the same time ...


Edited by Jeruselem: 18/7/2008 3:28:25 PM


Edited by Jeruselem: 18/7/2008 3:31:14 PM

-----
PC 1: XP Home SP2, Opty 165@1.8Ghz, GEIL 1GB PC3200, 320GB SATA Cuda ES,XFX 9600GSO 580/700x2/1450, Seasonic S12+ 550W
PC 2: XP Home SP2, XP 3000+@2.24 Ghz, 1GB PC3200, 80GB IDE,ASUS nVidia 6800 512MB, Codegen 450W

dBUG 
18/7/08 6:13:23 PM
Champion

/head explodes

it is nothing like what i did in Uni after all..(i.e. basic/advance sql query, create a small database etc)

it all sounds....too hard for me :(

any book recommendation for me to start with?

thanks for the reply guys.

-----
xbox live : vzion
PSN : big-black-dog

playing:
GTA4 (X360)
MGS3 (PS2)

kikz 
18/7/08 6:52:00 PM
Immortal

There aren't (or at least wasn't a decade ago) a lot database courses. I did all the db units on offer and I think it totalled 3, Introduction to Relation Datbase, which covered basic DML and DDL. 2nd year databases covered execution plans, triggers, stored procs, DCL, indexing. 3rd year continued on where 2nd left off and included clusters and distributed database (along with object oriented databaswe). I also did a 2nd year Commerce course on Data Warehousing.

That's more than enough to get you going as a Junior DBA. I'll take a guess and say 90% of DBA's work exclusively with the same DBMS, so that's where head for skills: Industry certification in Oracle, Mysql, MS SQL Server etc. Uni doesn't teach you how to perform maintenance tasks on DBMS's.

Have a query in google and you'll be able to find free e-learning (videos and books) from Microsoft ( http://www.microsoft.com/learning/ )


EDIT: Honestly, if you're even midly famliar with with DML and to a lesser extent DDL, I'd hire you as a junior DBA (if I had an opening :)). Using the tools of the trade: Management Studio, can be learnt on the job and you'll pickup indexes and optimisation after working with senior DBA's for a while. Add a few courses, which any decent employer would send you on...


Edited by kikz: 18/7/2008 6:56:02 PM

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

Jeruselem 
18/7/08 7:48:12 PM
Champion

Quote by dBUG
/head explodes

it is nothing like what i did in Uni after all..(i.e. basic/advance sql query, create a small database etc)

it all sounds....too hard for me :(

any book recommendation for me to start with?

thanks for the reply guys.



Don't worry! I started young knowing nothing of the real IT world. You'll learn over time in the business. In my job, I have to know EVERYTHING but you'll get a job where there's others to help you.

Get a junior position and work your way up. Oh, I'm not a normal DBA ... I kinda a bit of everything IT at work. I'm a full Domain Admin in my job.

Uni does not teach you what's it's really like in the real IT world ...


Edited by Jeruselem: 18/7/2008 07:52:40 PM

-----
PC 1: XP Home SP2, Opty 165@1.8Ghz, GEIL 1GB PC3200, 320GB SATA Cuda ES,XFX 9600GSO 580/700x2/1450, Seasonic S12+ 550W
PC 2: XP Home SP2, XP 3000+@2.24 Ghz, 1GB PC3200, 80GB IDE,ASUS nVidia 6800 512MB, Codegen 450W

dBUG 
21/7/08 8:04:36 PM
Champion

Thanks for the info, Jeruselem.

i'll grab some book this week. =)

-----
xbox live : vzion
PSN : big-black-dog

playing:
GTA4 (X360)
MGS3 (PS2)

pappes 
26/7/08 12:18:09 PM
Titan

Quote by kikz
There aren't (or at least wasn't a decade ago) a lot database courses.


Thats only becasue you are using the wrong database :)

http://www.google.com/search?client=opera&rls=en&q=orcale+dba+training+brisbane&sourc

edit: some starter resources
http://www.oracle.com/technology/obe/2day_dba/index.html


Edited by pappes: 26/7/2008 12:19:55 PM

-----
I am petitioning to be the first person to be awarded a Nobel prize for prescience. It doesn't exist yet but mark my words it will.

kikz 
26/7/08 1:03:37 PM
Immortal

I was referring to uni courses :) ( we used Oracle as the DBMS throughout uni, and I've used it professionally for a few years, a while back now :p )

-----
Q6600 | 4Gb PC6400 | 2 x 500Gb RAID 0 + 2 x 320 Gb RAID 0 | 19" Benq FP591 + 24" Samsung 245B + 19" Dell | 8800GTS 640 Mb + 8400GS 256 Mb | Gigabyte GA-P35-DS3P | Antec P182 | Corsair HX-620 | Thermalright 120 Extreme | Vista x64

dBUG 
29/7/08 2:21:48 AM
Champion

IIRC, there aren't many courses on databases when i was in UNI.

i don't remember what vendor we used either, i think it's MS SQL, since we were developing .net application.

btw, Which DBMS should i choose? i know it probably doesn't matter since i'm still learning the basic, but which one would you go for?

cheers.


Edited by dBUG: 29/7/2008 2:22:07 AM

-----
xbox live : vzion
PSN : big-black-dog

playing: -

superfireydave 
29/7/08 2:31:49 AM
Titan

/enters thread
mySQL!!!
Or Oracle if you've got the money =P
/exits thread quickly

-----
Mreow?
http://www.atomicmpc.com.au/forums.asp?s=2&c=9&t=17306

SquallStrife 
30/7/08 3:14:39 PM
Titan

I'd recommend the Oracle DBA course.

Mainly for how well regarded the certification is.

If you can manage Oracle, you can manage any DBMS, purely because Oracle is a beast.

-----
Q6600 @ 3.6GHz | 8800GTS | XP x64 | Vista HP x64 | OSX 10.5.4 <- Back and better than ever!

  1  
Forums | Programming