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»»»

Remote DBAs Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2007 5:41 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 10:36 AM
Points: 31,362, Visits: 15,823
SQL On Call


There's still hope for all you DBAs out there looking for a telecommuting job that allows you to work in your pajamas. Someone sent me this case study about remote DBAs and I decided to pass it along. It's a one page PDF, and it's a fluff piece to some extent for Bluewolf, a company that has outsourced IT staffing, but has a section on remote DBA work as well.


I've wanted a remote DBA company for a long time. It's something I thought was easy to do, most all DBA work is remote to the server anyway, and we tend to work alone. It's a specialized skill and for the most part, a production DBA is an insurance cost.


Face it, as a production DBA, I've typically had periods of time where we work really hard on upgrades, stabilizing systems, responding to issues, etc. Then we have some fairly quiet periods where we work on tuning things that don't work well. There are definitely exceptions for environments that are understaffed and have perpetual problems, but a lot of the time we are insurance for the bad times.


Which makes for a pretty good job.


I've usually enjoyed my jobs; they haven't had too much stress on a daily basis, and I could handle the tedious nature of production systems. If I had 4 or 5 of these jobs I did from home, that would be amazing. I've just struggled finding managers that were comfortable with a DBA working from home 3 or 4 days a week. For some reason they just want to see you there every day.


There are definitely jobs and companies out there making this work. A few friends of mine from Colorado Springs even have a company that does this: SQL On Call. They can help in many areas, but they're happy to fill in for a DBA on vacation. If you're a one-DBA shop, give them a call. I know, it's a plug, but I have no affiliation. They're friends of mine and good DBAs.


If you want to telecommute, especially on a part-time basis, be sure you save the case study link along with any others you come across. A lot of preparation and good evidence that it works will go a long way to convincing your boss to let you try it.

Post #400155
Posted Tuesday, September 18, 2007 7:35 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 8:47 PM
Points: 35,770, Visits: 32,436
quoteThen we have some fairly quiet periods where we work on tuning things that don't work well.

Heh.. thought you didn't spend anytime tuning... thought you always bought hardware so you had time to ride your horse

I agree... if you're a "Systems" DBA, then there's no reason why you can't tele-commute except for the obvious periods of duress...

But, if you're what I call an "Applications DBA", then you need to be at work as a mentor to the Developers and Systems Analysts (the kind that define what a project will consist of).

We have both... our main "Systems" DBA actually lives way out in Oregon (we're in Michigan and North Carolina) and our "Applications" DBAs are on site most of the time.



--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 #400171
Posted Wednesday, September 19, 2007 1:35 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, November 5, 2007 1:41 PM
Points: 115, Visits: 3

I like to think that managers who can't manage people who are working from home are bad managers.

In my former job, I had to take sick-leave one time because my wife's pregnancy wasn't going as planned and she had to be admitted to hospital. I had to be at home to watch over our oldest one (3 years old at the time). It was a bad time because we had several major projects going on at the same time and all the work culminated in this period. So I organized a VPN connection to our company network from my home PC and managed to setup the ODBC connections I needed. Luckily, the company had installed web-based e-mail a few weeks before and I was allowed an account. For three weeks, I did all the work I would normally do at the office just using MS Query. In fact, I got more of the structural work done because nobody was bugging me with issues all day and I was able to save those things for the evening hours. When I came back to the office, I discussed this with my manager but there was no way to convince him. He just didn't TRUST me doing my job remote and he wasn't able to define the criteria whether or not I had been productive enough.

And that's the whole thing: It all depends on defining the right goals and the right criteria to measure if these goals are met.Typically, salespeople are allowed to work from home easier. Not just because they need to be mobile, but also because it's easy for them to demonstrate their effectiveness. Sales and profit are being measured everywhere. How do you define the effectiveness of a DBA ?

A second point here is that salespeople are more used to having to account for their well doing. They can sell themselves as easy as the products or services they're selling. For us techies, that's not really part of our nature, at least not for most of us.




Post #400207
Posted Wednesday, September 19, 2007 2:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 5:00 AM
Points: 52, Visits: 138

Let's not forget the issue of security.  Do you really want highly confidential information left on display in the kitchen of your remote DBA while he runs to help a child with a cut finger?  The simple fact of the matter is, people will have a more relaxed attitude to security when they work from their own home, because it is only human to believe that home is the most secure place on earth -- by definition.

There is still no affordable and 100% reliable way to guarantee that when you see "Bill" remotely logged in on a server that it is in fact Bill sitting at the screen, whereas if Bill is in the office and you've implemented physical access controls, you just go and look.

Post #400225
Posted Wednesday, September 19, 2007 3:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 2:52 AM
Points: 75, Visits: 398

I have worked from home in the UK (more systems DBA than applications) since 1999. It wasn't seen as a big deal as my work had become remote even when I was office based. I like working from home although it doesn't suit everyone in the long term. I still feel part of a team even though my closest colleagues are 3 hours away. The phone, IM and netmeeting type tools help, we've been using them for years with company approval, so there are some enlightened companies out there. Referring to the previous post I don't see security as being an issue providing there is appropriate technology in place  (VPNs / secureid cards etc) to track remote access. If I hacked my companies systems I would be traced.




Post #400234
Posted Wednesday, September 19, 2007 5:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078

I have been a DBA / Developer for about a decade.  During this time I have been on both sides of the fence - a manager of up to 14 people, and a (happily) simple employee with my head down doing work.  From a management perspective, I have never had a problem with people working from home on a regular basis.  I have one consultant workng for me now that is home three days a week.  He is good at it and gets his work done.

However, I have found it difficult for myself to work from home more than one day a week.  I feel I lose a sense of urgency that comes with production issues.  Yes, from anywere I can see it is important when a server is down, but if I am not in the office listening to people, I don't get a good feel for which applications are not working well.

Working remotely is a great perk for the type of work we do, but I think it really needs to be handled well and at least some time every week needs to be spent in the mix wih the users or work product degrades very quickly.

Post #400284
Posted Wednesday, September 19, 2007 6:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 8:52 AM
Points: 91, Visits: 70

Works fine for a stable software enviromnent, but who has that?

One problem is that, like it or not, most development projects include meetings with a mixed bag of systems engineers, developers, business managers, and a dba or two. Usually somebody gets up and starts drawing servers, databases, code, business processes, etc on a whiteboard.  OK, OK, there are technical workarounds, but having a dba physically present is a good thing.

Another problem is that sometimes developers or systems folks need a very quick answer to a question to keep everybody else on a team working. My experience in working with remote consultants is that they are often committed to other customers as well. Phone calls, emails, IM's are not returned within a couple of hours. A couple of hours times each person working on a project equals a lot of team hours.




Post #400304
Posted Wednesday, September 19, 2007 7:29 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:11 PM
Points: 771, Visits: 1,971

Remember...

If your job can be done from home, it can be done from India.



...

-- FORTRAN manual for Xerox Computers --
Post #400341
Posted Wednesday, September 19, 2007 7:31 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031
A remote DBA IMO is valid only for non-confidential *and* stable environments. Most places I have seen have one or the other but never *both*. The weakest point of hiring an "external" firm (in my view ) is that still you will have to train that DBA in the processes and workflows of the place and if the location is very dynamic the costs will be considerable. In otherwise very slowly changing environments it does makes sense *as long as confidentiality is *not* an issue.




* Noel
Post #400344
Posted Wednesday, September 19, 2007 8:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 8:43 AM
Points: 417, Visits: 1,157

In my past job for a large global company, I exclusively worked from home for 7 years.  I was both a development (application) DBA and a production DBA.  We also had development DBA's in India and all over the world.  The fact that we had many people in many places made it easier to work from home because the infrastructure was in place for security, conference calls, instant messaging...  I think that if the infrastructure is there and management supports it then it is worth it.  However many small companies do not have this benefit, so it all depends.

The one drawback is that everyone knows you work from home so they always call you even when you are not supposed to be working.  However, I don't know many DBA's who are not supposed to be working.

Post #400386
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse