June 28, 2021 at 9:11 pm
Steve Jones - SSC Editor wrote:When I see that list, I'm not at all scared. I've seen many descriptions, not just in tech, but in medicine, legal, hospitality, etc. where a job ad is created by a committee. It's a chore, so the person doing it asks others, and ends up with lots of "wishes", but not requirements.
I've always told people if you hit 50% of the skills, apply. Likely they would like someone to have them all, but they know it's not possible, so they can train you on the things you don't know if you are a good candidate.
Likely any project you are on contains only a portion of those skills, so this isn't any different than many descriptions I've seen. If that kind of things scares you, likely you are letting opportunities go by.
The point is, such litanies keep even good people from applying for one of two reasons...
- The list is overwhelming to people that don't know it's a wish list.
- Other people look at it and say that if they can't properly distinguish between requirements and "nice to haves", they might suck as a place to work for because they can't define what they actually need are so they take the shotgun approach.
Even knowing it is a wish list it is a bit overwhelming. Makes me nervous the expectations are way high.
On the topic of not being able to distinguish requirements from "nice to haves" this is a shining example. There is both a "Desired Experience" and "Requirements Qualifications" sections. But then under the requirements you see "Experience with TDD is a plus". It's on the wrong list which is another potential warning sign.
So to Steve's point, maybe this would be me missing a good opportunity. Or perhaps Jeff is right that it scared away a good person. There is no right or wrong here, I just gave my opinion that it made me shy away because it seems to be looking for too much.
Sorry to pick this one apart Luis. I know you were posting here hoping to find some leads, not a critique of the posting that you didn't write. Hopefully you are able to find somebody soon.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 28, 2021 at 9:17 pm
Sorry to pick this one apart Luis. I know you were posting here hoping to find some leads, not a critique of the posting that you didn't write. Hopefully you are able to find somebody soon.
Don't worry about that. I should probably give this feedback to my manager (without mentioning names) as it makes sense that people that actually know could be scared away.
June 29, 2021 at 2:16 am
Do you have an actual example of a 30 million row transaction where every row was actually required or you had to fail all 30 million rows? I'm not looking for something hypothetical... I'm looking for an actual example that you've personally experienced.
I cannot remember exact number of records in those files, it was most certainly less than 30 million, but definitely exceeding 3 million "uninvoiced deliveries" to certain customers per one XML file, which we've been loading into what used to be "AirBP eNabler".
It took more than 3 hours for BizTalk to just parse those files and dump the content into temporary tables for further processing.
And yes, those XML files had, apart from "Header", a section named "Summary", which contained all sorts of aggregations of the data in the file: total deliveries, total items delivered, total volume, etc.
The ETL system marked all those 3+million deliveries as "successfully submitted" upon the file uploading.
Of course, if any of the records failed to upload for any reason, we could not change the numbers in the file's summary. If we'd partially accepted the file the ETL system still would have "success" status assigned to the number of entries mentioned in the Summary.
We had to reject the whole file, and in the response file we did our best identifying the issue as detailed as possible, so the ETL guys could either correct or exclude the faulty entry and submit the better version of that file.
_____________
Code for TallyGenerator
June 29, 2021 at 4:53 pm
Jeff Moden wrote:Do you have an actual example of a 30 million row transaction where every row was actually required or you had to fail all 30 million rows? I'm not looking for something hypothetical... I'm looking for an actual example that you've personally experienced.
I cannot remember exact number of records in those files, it was most certainly less than 30 million, but definitely exceeding 3 million "uninvoiced deliveries" to certain customers per one XML file, which we've been loading into what used to be "AirBP eNabler".
It took more than 3 hours for BizTalk to just parse those files and dump the content into temporary tables for further processing.
And yes, those XML files had, apart from "Header", a section named "Summary", which contained all sorts of aggregations of the data in the file: total deliveries, total items delivered, total volume, etc.
The ETL system marked all those 3+million deliveries as "successfully submitted" upon the file uploading.
Of course, if any of the records failed to upload for any reason, we could not change the numbers in the file's summary. If we'd partially accepted the file the ETL system still would have "success" status assigned to the number of entries mentioned in the Summary.
We had to reject the whole file, and in the response file we did our best identifying the issue as detailed as possible, so the ETL guys could either correct or exclude the faulty entry and submit the better version of that file.
The bottom line is as it always is... "It Depends" on what is needed. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
June 30, 2021 at 6:44 am
A while ago I was looking for a new job. A friend of mine connected me with a company that he worked at their DBA team at the past. After few interviews, I was hired. About a year after I started working there, we needed to hire another DBA. My manager posted an ad and I looked at it. That ad had nothing to do with what we needed. We did not have a single DBA in our team that met half the requirements in the ad. I asked my boss why did he post such an ad and he told me, that this is the ad that they always post when they are looking for a DBA and it is the same ad that they posted when I was interviewed. I told him that I never saw the ad, because the connection between us was done by another DBA, but if I would have seen that ad, most chances are that I would have not applied to this job because according to the ad, I'm not qualified for that job. Never did understand ads that have nothing to do with reality.
June 30, 2021 at 2:21 pm
The bottom line is as it always is... "It Depend" on what is needed. 😀
Yep, too right.
It depends, and it depends on requirements, not on file size or any other property of the data channel.
_____________
Code for TallyGenerator
June 30, 2021 at 2:27 pm
Never did understand ads that have nothing to do with reality.
How many ads did you actually see?
How many of them passed reality check?
Any?
_____________
Code for TallyGenerator
June 30, 2021 at 3:26 pm
Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.
If you think you have to meet every item before you apply, you're letting opportunities go. This isn't the fault of the ad. It's the way you're looking at the ad. Same for many others.
June 30, 2021 at 5:23 pm
Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.
If you think you have to meet every item before you apply, you're letting opportunities go. This isn't the fault of the ad. It's the way you're looking at the ad. Same for many others.
Actually, it IS the fault of the ad. Just look at the damned things. People need to ask for what they actually need instead of the pie in the sky plus the kitchen sink BS they typically ask for.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 30, 2021 at 7:48 pm
Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.
If you think you have to meet every item before you apply, you're letting opportunities go. This isn't the fault of the ad. It's the way you're looking at the ad. Same for many others.
I'm reminded of when I applied / was headhunted for my current job. The list of what they WANTED would've been enough to scare me off if I'd come across the listing, I opted to give it a go though.
Worked out pretty well for me, even if I did have to crash course via Google how to at least keep an Oracle Database running for a couple months.
But yeah, I've seen plenty of comments about job listings that sound like they're looking for a "one-stop-shop" for everything including building maintenance...
June 30, 2021 at 8:28 pm
I "love" some of the ads I've seen... they start with needing only 2 years of experience but want a full stack developer that is also an expert at database design, keeping the entire application and multiple servers performance tuned, must be an expert in 3 different versions of "C", anything and everything having to do with Java ,Python, PowerShell, and more, must be an expert in SQL Server, Oracle, Postgre, MySql, Access, and AWS Redshift, must be an expert in Power BI, SSIS, SSRS, SSAS, SSSB, and a couple of other 4 letter words, must be an expert mentor in everything having to do with all the SQL for all the previously mentioned RDBMSs, must be an expert in troubleshooting and designing all code. must be an expert in things like partitioning, indexes, index maintenance, an expert at anything and everything having to do with the SAN and S3 storage, have a good understanding of Azure as both a DBA and and a Developer, must be able write all testing, and write the company standards at the same time with gathering requirements from customers, must have a minimum of a Bachelor's degree in computer science AND statistics, but a Master is preferred, and must have multiple certifications including Cisco certifications and be a Windows ninja, must be able to do updates to all of that, must take part in 24/7 on-call although you'll be the only one working there, and it's an entry level job with salary commensurate to experience with a cap at 60K.
Yeah... let's apply for that. I wouldn't apply for that for 300K per year. In fact, I actually turned one down for 325K. It was just stupid and anyone that writes such an ad is stupid. Period.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 30, 2021 at 8:53 pm
I "love" some of the ads I've seen... they start with needing only 2 years of experience but want a full stack developer that is also an expert at database design, keeping the entire application and multiple servers performance tuned, must be an expert in 3 different versions of "C", anything and everything having to do with Java ,Python, PowerShell, and more, must be an expert in SQL Server, Oracle, Postgre, MySql, Access, and AWS Redshift, must be an expert in Power BI, SSIS, SSRS, SSAS, SSSB, and a couple of other 4 letter words, must be an expert mentor in everything having to do with all the SQL for all the previously mentioned RDBMSs, must be an expert in troubleshooting and designing all code. must be an expert in things like partitioning, indexes, index maintenance, an expert at anything and everything having to do with the SAN and S3 storage, have a good understanding of Azure as both a DBA and and a Developer, must be able write all testing, and write the company standards at the same time with gathering requirements from customers, must have a minimum of a Bachelor's degree in computer science AND statistics, but a Master is preferred, and must have multiple certifications including Cisco certifications and be a Windows ninja, must be able to do updates to all of that, must take part in 24/7 on-call although you'll be the only one working there, and it's an entry level job with salary commensurate to experience with a cap at 60K.
Yeah... let's apply for that. I wouldn't apply for that for 300K per year. In fact, I actually turned one down for 325K. It was just stupid and anyone that writes such an ad is stupid. Period.
And this on top of the required 10+ years of experience in technologies only introduced in the last two years
😎
Obviously missing from your list Jeff, are the pilot qualifications, at least a LearJet, Citation and a couple of others that aren't in production yet.
June 30, 2021 at 9:23 pm
Reading through some of these comments jogged the old memory bank. When I was applying for my current job my company had two separate adds. The jobs sounded similar but each had a a few requirements in common but from my point it looked like two separate jobs. When I was interviewing I asked about the other listing. They told me it was for the same position I was applying for, they had just wanted to cast a wider net. Didn't want to scare away some from applying. I guess that's one way to do it.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
July 1, 2021 at 3:37 am
Jeff Moden wrote:I "love" some of the ads I've seen... they start with needing only 2 years of experience but want a full stack developer that is also an expert at database design, keeping the entire application and multiple servers performance tuned, must be an expert in 3 different versions of "C", anything and everything having to do with Java ,Python, PowerShell, and more, must be an expert in SQL Server, Oracle, Postgre, MySql, Access, and AWS Redshift, must be an expert in Power BI, SSIS, SSRS, SSAS, SSSB, and a couple of other 4 letter words, must be an expert mentor in everything having to do with all the SQL for all the previously mentioned RDBMSs, must be an expert in troubleshooting and designing all code. must be an expert in things like partitioning, indexes, index maintenance, an expert at anything and everything having to do with the SAN and S3 storage, have a good understanding of Azure as both a DBA and and a Developer, must be able write all testing, and write the company standards at the same time with gathering requirements from customers, must have a minimum of a Bachelor's degree in computer science AND statistics, but a Master is preferred, and must have multiple certifications including Cisco certifications and be a Windows ninja, must be able to do updates to all of that, must take part in 24/7 on-call although you'll be the only one working there, and it's an entry level job with salary commensurate to experience with a cap at 60K.
Yeah... let's apply for that. I wouldn't apply for that for 300K per year. In fact, I actually turned one down for 325K. It was just stupid and anyone that writes such an ad is stupid. Period.
And this on top of the required 10+ years of experience in technologies only introduced in the last two years 😎
Obviously missing from your list Jeff, are the pilot qualifications, at least a LearJet, Citation and a couple of others that aren't in production yet.
And the ever popular "turn water to wine" requirement (although some of my favorite Developers and fellow DBAs were really good about turning water into some excellent beer).
--Jeff Moden
Change is inevitable... Change for the better is not.
July 1, 2021 at 4:17 am
Shifting gears to another aspect to employment, I'd say "and so it begins" except that it's been this way for a long time. It's just getting worse. If you have one of those "self evaluation/set your own goals" thingies going on at work, good luck. The one in the article below doesn't even allow that.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 65,521 through 65,535 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply