April 22, 2009 at 7:06 am
Hey all
Long story but the company I work for has an opening for a half DBA / half (junior) Software Developer role which I've expressed my interest in.....I'm currently a junior software developer with the company and have been for over a year now.
This has come about because the testers we have are as much use as an ash tray on a motorbike to be honest and spend most of their time "setting up" the environments their going to use for testing and tend to balls it up, so work is returning to the developers when 70-80% of the time there shouldn't be any need for it to.
So what they want this role to do is setup and manage the test environments, manage the scripts sent for test, run the scripts on the test environment (ready for the testers to test), queue and deploy builds of frontends ready for test, insert the scripts into Source Control (TFS) then once a job has been signed off by the customer, deploy the scripts and/or frontend changes relating to that job to live.
So the Testers actually do more testing and less setting up.....
Now I understand a DBA is a Database Administrator and that DBAs tend to have their heads in SQL or SQL Server problems all day - which I quite enjoy.
Everything is currently "on the back of a *** packet" so its still in planning and/or discussion.
Now my question is, have you come across any resource that you have found helpful on your SQL travels?
Any comments or ideas?
If your a DBA, what do you get up to day to day?
Any reply, however big or small would be helpful!
Thank you in advance.
GE
April 29, 2009 at 8:11 am
Hello,
I am a DBA and software designer, actually was hired to learn how to code in several coding languages and then my boss sent me to a SQL class and i fell in love. been the DBA ever since. This website is normally the first place i come looking for answers when i get stuck on a problem. Also http://www.databasejournal.com and the MS SQL server Management Studio Express online help.
if you company will get it for you the Red Gate toolbelt is awesome. It’s helped me a lot.
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
April 29, 2009 at 9:36 am
Cool thank you....
April 29, 2009 at 9:52 am
You may find this useful
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2009 at 10:19 am
June 30, 2009 at 10:50 am
Well if it helps at all, I used to be in your shoes. I was doing QA at a start up company. Moved up, took over the QA department. Got bored and started playing with the DB's. Now I am the first DBA at my company (which means I get to clean up the mess that was created by all the developers for the last 3-4 years).
I would just start playing with the DB's. Set up your own instance and start backing up and restoring DBs. Take the adventureworks DB and destroy it a couple of times.
Also, look at your current DB problems and google the hell out of them. And of course, spend a lot of time on this site. It's helped me out A LOT.
I also agree purplebirky. Redgate toolbelt is great. Makes life easy.
Good luck.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply