April 23, 2015 at 11:59 am
Hi, I need to create a job description for a SQL developer. My company has several applications which use stored procs so we're going to hire a SQL guy so we can offload all SQL work to a single specialist. That being said, how would you write a job description for this? What sort of bullet points would you put in the JD? I'm decent at SQL but not a specialist. I wouldn't be qualified to interview a SQL specialist because I'm more of a full stack developer.
Some things that might be helpful might be 5+ years of BI, Data Warehousing and Reporting. Could you be any more specific than this? Are there any specific technical concepts that would make sense as bullet points? What about things like 10+ table join queries? What sort of interview questions would ask and how would you assess a candidates qualities and abilities for this role?
April 23, 2015 at 12:16 pm
Search the forums for 'interview questions' or 'interviewing'.'
I know I've seen several discussions of this over the years.
Sigerson
"No pressure, no diamonds." - Thomas Carlyle
April 23, 2015 at 10:14 pm
sqlguy-736318 (4/23/2015)
Hi, I need to create a job description for a SQL developer. My company has several applications which use stored procs so we're going to hire a SQL guy so we can offload all SQL work to a single specialist. That being said, how would you write a job description for this? What sort of bullet points would you put in the JD? I'm decent at SQL but not a specialist. I wouldn't be qualified to interview a SQL specialist because I'm more of a full stack developer.Some things that might be helpful might be 5+ years of BI, Data Warehousing and Reporting. Could you be any more specific than this? Are there any specific technical concepts that would make sense as bullet points? What about things like 10+ table join queries? What sort of interview questions would ask and how would you assess a candidates qualities and abilities for this role?
Step 1 would be to identify what you want such a person to actually do. You say you want an "SQL Developer" and then you list BI, Data Warehousing, and Reporting. That's more of a "BI" guy.
SQL Server has a huge number of facets. You need to decide what you want your "SQL Guy" to actually do.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 24, 2015 at 6:22 am
The thing to do might be to hire a consultant to do the job description and the interviews for you. As Jeff says, you've split the difference between a BI person and a database developer. They are two different skill sets and different people will apply to the job depending on which set of skills you describe.
Assuming you can't get a consultant to help out, I'd start with listing the actual needs in plain language. That might be all you need. However, once you have that list, translate as much of it as seems appropriate to technical language. Something like "I need someone who can create fast procedures to query the database" might translate to "Proven track record with high performance T-SQL queries."
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 24, 2015 at 8:13 am
You could also do searches for similar jobs and see what their job descriptions look like. After all, one of the greatest documents in history, the "Declaration of Independence", was a cut and paste job too!
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply