Ask ATOT: Database Admins

[gothamhunter]

Hey guys,

At my current company, there will be a 2013 opening for a database administrator. I have 5+ years in IT, mainly on the application side though, and some SQL database experience.

Can any experience DBA's out there give me some tips and ideas on what I should focus on throughout the next year so that I may be a good candidate for the position?

 

[guyver01]

Find out what the Anandtech DBA's are doing... and do the opposite.

Your database will have 100% uptime.

 

[SKORPI0]

Find out what the Anandtech DBA's are doing... and do the opposite.

Your database will have 100% uptime.

The Cloud server didn't help, only about 86% up time. (>12 hours for the DB transfer, 10 hours for the weekend maintenance). :'(

 

[guyver01]

The Cloud server didn't help

i am guessing the 'cloud server' is designed to be CHEAPER... not better.

 

[Red Squirrel]

service mysqld start

Leave it like that, and it will stay up.

 

[VinylxScratches]

Try this out on a dB "DROP DATABASE *;"

 

[sdifox]

it really is an aptitude thing. try to go through a sql course of some sort see if you like it.

 

[gothamhunter]

it really is an aptitude thing. try to go through a sql course of some sort see if you like it.

I have one this week

 

[lxskllr]

Try this out on a dB "DROP DATABASE *;"

 

[sdifox]

I have one this week

beware of sql injection :sneaky:

 

[gothamhunter]

Class is going good so far. Kind of boring right now as it's a high level overview, but that was to be expected.

 

[IndyColtsFan]

Hey guys,

At my current company, there will be a 2013 opening for a database administrator. I have 5+ years in IT, mainly on the application side though, and some SQL database experience.

Can any experience DBA's out there give me some tips and ideas on what I should focus on throughout the next year so that I may be a good candidate for the position?

Work on certifications and take as many training courses as you can. If you're talking about being a SQL Server environment, build a lab at home.

 

[AMCRambler]

Don't bother. They already hired me. Hehehe, j/k.

 

[manlymatt83]

Depends on what DB you want to work with.

If MySQL, read "High Performance MySQL". Then read it again. Follow Percona's blog.

 

[Tea Bag]

Depends on what DB you want to work with.

That's the biggest thing. Most employers will want experience with the database you're working with (duh) . If you know what that is, taylor your training towards managing that particular database and tinkering around with their administrative stack to support users and developers.

General SQL knowledge is important as a DBA because you'll get all sorts of questions tossed your way, but familiarizing yourself with the toolset available to admins will go a long way as well. When you get interviewed at least you can say you have some familiarity with it. That coupled with your general admin experience may clinch it for you if you've been around for a while.

(I notice you're in my locale based on some other posts, and I don't know if I'm a whole lot of help but PM me if you have any other questions)

 

[Exterous]

Ah - I love xkcd....