Ask Slashdot: Getting Exchange and SQL Experience? 293
First time accepted submitter william.meaney1 writes "I'm the sole network admin at a 25 person company. I was lucky enough to get the opportunity less than a year after getting a technical degree in IT. I've had some huge opportunities here (for a first time network admin). After my schooling, I went ahead and I'm now CompTIA A+, Network+, and CCNA certified. Now, being hired out of school, I was grateful for the job, and the boss hired me for peanuts (Less than $30,000/year) I've been living at home, using that money for loan payments, car payments, and certification expenses. I've started looking for other work, and I feel more than qualified for most of the requirements I'm seeing. The big hurdle I'm coming across that EVERYONE seems to want is experience with SQL databases, and Microsoft Exchange. I was wondering if anyone had any ideas for getting usable experience on a low budget. I have some SQL experience, I deployed a source control program here that uses a SQL express backend, but what else do you need to know for database maintenance?"
Re:Join MSDN Technet (Score:5, Insightful)
Sadly, personal experience != 'experience' in the corporate sense. I've had this fight with IT recruiters and headhunters - they want experience in a corporate setting with corporate problems, not 'I dorked with it at home for x months or years'. Of course, people who actually know what the hell they need value ANY experience, so its not a complete waste - just getting to interview with them versus the HR drone can be the biggest problem.
Good advice on TechNet though - helps you get a leg up on new OSes and obscure software without having to buy those licenses separately. BIG COST SAVINGS!
Re:Join MSDN Technet (Score:5, Insightful)
Personal experience can be 'experience' on your resume. What you need to do is to put them as 'personal projects' or 'side projects' instead of listing them as your job functions. Then, they will still trigger the keyword search, and it's enough to justify saying you have 'entry level experience' (which is MUCH better than not listing them at all). Better yet, once you have a little experience with them do a little consulting that makes use of that skill set.
ALWAYS work on your skill set. Don't wait for a position to come along to allow you to do it.
Re:Just do it (Score:3, Insightful)
Well to avoid getting the experience of getting yelled at for being stupid.
You can get Microsoft SQL Server Express. While it doesn't have some advanced features it does have enough to give you some experience.
Go threw Micorosfts SQL Server Management Studio, and Check out each feature and do some test examples until you understand them.
Make a Database, Add Tables, Create Views, Write TSQL Stored Procedures, Add triggers....
Install an other Type of Database server. and create a Link Server. Try to get them all to work togeter.
If you don't know how hit F1 for Help or Google it.
Re:Work for a local IT company (Score:2, Insightful)
So go out and get the support contracts on your own. Charge what you feel is acceptable. Let me know how well that goes for you.
Re:Work for a local IT company (Score:5, Insightful)
Re:Just do it (Score:5, Insightful)
"I see here on your resume that you have SQL experience. Can you tell me about some of the SQL deployments and experience that you were doing in your last job? How did you integrate that into your business requirements?"
Its exactly THIS sort of question, which I'm getting a bit, which trips people up who self learn. I'm getting it with VMware... I had VMware experience building, maintaining, updating machines... but never anything server side, and never anything on the farm level of things like vMotion. After I was let go at end of contract after 5 years on build team/CMDB remediation team, all the interview screen questions tended to focus toward vmWare and Exchange. So, I went out, got myself a beefy machine, installed vSphere 5.1 on it, and have done quite a few things with it... but that experience means SQUAT when you're sitting in front of a board which includes interviewing manager, vmWare SME, and a couple other general members of the IT team who are trying to probe you for you BUSINESS level experience.
There's a heck of a lot difference between test lab, and business level, and interviewers can ferret that out REAL quick.
Re:Just do it (Score:5, Insightful)
However, this is only half the work required. If he can't point to work experience with SQL Server, then a lot of potential employers don't care what he claims to know from self-study.
this why IT need more trades / apprenticeships tha (Score:4, Insightful)
this why IT need more trades / apprenticeships that have ways to letter people learn. The trades schools are nice but should be more drop in to learn X skill.
Re:Start with SQL proper. (Score:4, Insightful)
It doesn't matter if Exchange is crap or not. Your personal opinion is pointless if the companies he's applying for use it. Having said that, I personally don't see many issues with the Exchange servers I've maintained over the years, if they're setup properly.
Anyway, back on topic. Going into an interview for a position that requires experience with certain software, only to tell them that not only do you not have that experience, but that they shouldn't even be using the software in the first place, isn't likely to make for a good first impression.
Re:Join MSDN Technet (Score:4, Insightful)
This is good advice. I got my current position based on experience with open source projects I wrote and was able to demonstrate. Going to the interview with code print-outs in hand really helped.
Specialist IT recruiters barely know enough to turn their PCs on. All they do is look for keywords, copy/paste requirements from other similar jobs and then try to bullshit both you and their client into getting together. As long as you really do have the skills to do the job don't be afraid of bullshitting them too.
Re:Work for a local IT company (Score:5, Insightful)
Considering I was being paid $20 an hour and when the company I was working for charged $95 an hour. I do believe that there is a problem.
$95/hr is split into:
Your $20/hr + (Plus any benefits, Federal taxes, blah, blah)
Plus the time that someone spent getting that client you just did $95 worth of work for
Plus the money that was spent marketing to get that client you just did $95 worth of work for
Plus the admin time that will be spent billing that client
Plus dealing with the clients that don't pay
Plus office rent, utilities, other office overhead that you probably have no clue about
Plus tools used to perform the work (ticketing system, remote access tools?) . Again, you probably have no clue how much that actually costs
Plus you were paid to drive to that client, and if using your own vehicle should have gotten mileage
In addition to the drive, you are likely not billing 100% of your time anyway - Company still pays you when you are not billable right?
Believe it or not, the Margin on those accounts is not that much. Does it make money? Well I hope so or your company will no longer exist - Does it make someone filthy rich? Probably not.
SQL? (Score:4, Insightful)
Dude, you have a CCNA.
You aren't exactly clear what your experience has entailed so far, but, (if you enjoy networking) you should try to continue down that path.
You're already a considerable way down the networking road with the CCNA. If you have been getting hands-on experience with Cisco gear at your current job, I would definitely leverage that to try and get a more networking-intensive position somewhere, where SQL experience would be superfluous.
Re:[OT] A+ = F (Score:4, Insightful)
Hell, if at all possible, customize your resume for *every* job. A pure Windows shop is unlikely to care how much Linux knowledge I have, so I remove that and use the space to play up my skills in Win-specific areas and soft skills. A non-developer job (for example, security test) may care that I know how to program, but isn't going to be very interested in my knowledge of software development lifecycles and so forth. A job in a leadership role (even if nobody reports to you) requires different soft skills than one where you're part of a team, which in turn requires different skills from one where you work alone.
Customize everything. Don't lie, and do have a good, general-purpose resume that you can use for almost any scenario, but if you really want to get hired you should go the extra mile and at least tweak things for each job where you have the opportunity. Additionally, you definitely need to write cover letters wherever possible. Keep them short, professional, and on topic, and ensure they are as well edited as is practically possible - poor grammar can lead to a mark against you just by making you look sloppy or uneducated - but unless your writing is absolutely terrible, they are well worth the time it takes. You want to stand out from the crowd.
Re:this why IT need more trades / apprenticeships (Score:4, Insightful)
this why IT need more trades / apprenticeships that have ways to letter people learn. The trades schools are nice but should be more drop in to learn X skill.
IT moves way too fast for that.
I didn't learn SQL until I was 5 years into my career. Virtualisation didn't start to take off until late last decade, now it's everywhere. The versions of Windows and Linux I would have done my apprenticeship on would have been obsolete a year after I finished. A carpenter almost never needs to update their skills after their apprenticeship, sysadmins always needs to be updating theirs.
IT education needs to be more focused on how things work, then extrapolate what you need to do, not how to do things by rote memorisation. In this regard it's more suited for the university style of education as opposed to an apprenticeship.
That being said, more companies need to offer paid internship (as opposed to an apprenticeship) for new sysadmins to get experience. Taking on juniors and giving them enough real world experience to turn them into seniors in a few years. This is the way it works in Australia where unpaid internships are illegal (The ATO and FWA will nail you to the wall for not paying staff).