Of course we don't require everyone to do all of these or even be the best at the majority of them. If your focus is on TSQL, then your dev focus will be schema design and query optimization. You still need to know how to build the software and fix some smaller problems which are blocking or impacting your work, thus the C# requirement. In that case, you'd rarely touch AD interfaces. Works the same for any other focus area. It's just that we can't put people in a dev position for this who are only AD admins. Hiring discussions are very transparent and everything happens together. We ask real question from our product dev problem set and let people work on real code if they want. At least in Berlin, other locations might vary.