Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Should I become a DBA?!? Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 11:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
Hi All,

I've been offered a job as the sole MSQL DBA at an up and coming online retailer. I'm from a development background, started out in asp.net, c#, html,css but have a load of experience in SQL developer based projects. Ranging from reporting services to SSIS work and other scripting for migrations etc.
I'm pretty comfortable with T-SQL. However i'm a newbie when it comes to other DBA skills. I can do backups / restores, setup mirroring but things like performance monitoring, security and working on a DB that has 100% HA is new to me.

Is this very challenging work? Will i be stressed to my core? Does anyone on here regret becoming a DBA? As you can tell i'm rather nervous about taking the plunge!

Thanks
Post #1372851
Posted Monday, October 15, 2012 12:15 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:11 AM
Points: 36,995, Visits: 31,516
bugg (10/15/2012)
Hi All,

I've been offered a job as the sole MSQL DBA at an up and coming online retailer. I'm from a development background, started out in asp.net, c#, html,css but have a load of experience in SQL developer based projects. Ranging from reporting services to SSIS work and other scripting for migrations etc.
I'm pretty comfortable with T-SQL. However i'm a newbie when it comes to other DBA skills. I can do backups / restores, setup mirroring but things like performance monitoring, security and working on a DB that has 100% HA is new to me.

Is this very challenging work? Will i be stressed to my core? Does anyone on here regret becoming a DBA? As you can tell i'm rather nervous about taking the plunge!

Thanks


All the things you mentioned are kind of easy. Find out what will be required of you insofar as security goes.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1372874
Posted Monday, October 15, 2012 12:24 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 7, 2014 8:21 AM
Points: 33, Visits: 325
It depends on how large is the environment . How motivated you are to learn new skills. Focus on fundamentals , such as availability - incluing backup strategy , error managemenmt etc.
It might be worth finding out if they allow external help - in case of emergency.
Where is everything hosted?


Jack Vamvas
sqlserver-dba.com
Post #1372880
Posted Monday, October 15, 2012 12:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
Well that's it i'm not entirely sure, they are willing to train me in these areas. I am used to active directory accounts and using those as secure logins but when it come to stored user accounts in tablse what should i be looking out for security wise? Besides SQL injection what other threats does a DBA have to watch out for?
Post #1372881
Posted Monday, October 15, 2012 12:29 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 7, 2014 8:21 AM
Points: 33, Visits: 325
Do they have a Security Policy? If not , maybe that is an opportunity for you to implement. You can also develop reports which audit the security .


Jack Vamvas
sqlserver-dba.com
Post #1372884
Posted Monday, October 15, 2012 12:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
The current setup is one database that is mirrored for fail over. I can get external help if required. I am always keen to learn, i think being in IT this is a prerequisite.
I just want to know how stressful this job can be, i do have a life outside of work and would like to keep it this way. Ive been reading up on DBA roles and a lot people mention the stress! this scares the cr@p out of me.

The company said i would be on call 24/7 but told me last year they only had 3 instances when the server went down. I can live with 3 call outs in a year. Just wanted to know if going down the DBA career route is worth it. If DBAs on this forum love the job.
Post #1372890
Posted Monday, October 15, 2012 12:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
I guess they must have some sort of security policy. If not , like you said my first job could be implementing one :)
Do you have any links showing what different types of security polices one can implement in an online web application?
Post #1372896
Posted Monday, October 15, 2012 3:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
The servers are hosted off site.
Post #1372957
Posted Monday, October 15, 2012 4:44 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
bugg (10/15/2012)
The company said i would be on call 24/7


On call 24/7 on your own? That pretty much means no vacations, never out of touch, laptop with you anywhere, any time just in case.
When I worked for the bank it took a team of 8 DBAs to do a 24x7x365 rotation.

I'd question them on that point, carefully. What exactly do they expect, how quickly are you required to respond, how available are you required to be (and what are they paying for you being on call all the time)?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1372988
Posted Tuesday, October 16, 2012 2:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:49 AM
Points: 184, Visits: 653
GilaMonster (10/15/2012)
bugg (10/15/2012)
The company said i would be on call 24/7


On call 24/7 on your own? That pretty much means no vacations, never out of touch, laptop with you anywhere, any time just in case.
When I worked for the bank it took a team of 8 DBAs to do a 24x7x365 rotation.

I'd question them on that point, carefully. What exactly do they expect, how quickly are you required to respond, how available are you required to be (and what are they paying for you being on call all the time)?


Well not exactly on my own, there is one guy who currently tends to the DB but he isn't a DBA. When I mentioned the 24/7 on call to them they said the team get each others back but I can see this falling on my back quite a bit.

Another thing is they don't pay extra for being on call. Its a small IT office , there is 1 database to look after currently. The company is expanding at a rate of knots and now they need a full time DBA rather then the developers tending to the DB occasionally. For me its an opportunity to join a fast growing Company with prospects and rather then dabble in loads of different technologies focus on one. I suppose i'm scared, i'm a developer who has in the past pushed my code to DBAs to release to production and now i'm going to be on the other side.
Post #1373072
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse