. NET Interview experience talk (i)

Recently it was the season of the Jumping nest, with four years of working experience. NET Little Ape joined the ranks of the army. Interviewed 4 companies in 3 days, by the way, the details and experience.

If the interview is an exam, then you must try to be ready before the exam. Although 4 years of work experience, but actually can take the shot of the project also on 5, is really little poor, after all, is also two companies, the project is less, the company also has the money to keep, during the use of leisure time to learn English, is also a leisurely learning environment. Well, the background is too verbose, now quickly talk about the interview situation and experience. This article is the first test:

Submit your CV

Job Requirements:
1. Skilled in developing with C #,. Net framework.
2. Be proficient in using MSDN to solve development problems.
3, familiar with the three-layer framework and some other commonly used frameworks.
4, familiar with SQL Server database design, can skillfully write stored procedures and triggers.
5, familiar with the principle of soket communication programming and implementation mode.
6. Understand the technologies and frameworks of WPF, MVVM, and WCF.
7, good at communication, rich team spirit, able to cooperate with colleagues.
8, have good analytical and problem-solving ability.

The little ape is also carefully read the requirements of the job, feel that their knowledge structure very in line with each other's requirements, on the resume of the past, did not expect to interview the next day. Thought: Haha, sure enough hit.

Interview

The next day is also the appointment to this company, a set of interview questions, 40 minutes to finish. The general technical aspects of the interview are divided into two parts, 20% is a C # code requires optimization and find out unreasonable logic and potential SQL injection, 80% database design, SQL statement inspection, are some relatively basic knowledge.

But there are two ways the little ape really wants to spit it out:

1, one of the questions given a stored procedure, the requirement is to write out the code to execute the stored procedure with ADO. (with more than 3 years of ORM, really do not know how to write the original ecology, they do not use ORM Framework programming?) ）

2. What are the interview questions? Not a C # language feature review? No socket knowledge to investigate? No problem with WCF?

Successfully answer the questions, handed in, about 20 minutes after the interviewer interview. A young man who looks similar to the age of a small ape (but certainly older than me), or the old-fashioned first sentence: Introduce yourself ... And then the problem is all around the database optimization. Talk about the interviewer's question: "Now there are millions data, how to do Baidu search box to fill the same keyword?" ", the question did not give a plan, and then asked the interviewer's answer is that there is a third-party search framework to do this index library (I thought you were testing me what?).

Later the second day of the re-examination, and telephone and personnel to negotiate pay. The interviewer is two people, one is an old man in the Personnel department (not the salary he talked about), and the Director of the Technology Division (not much, looks like 85). After the personnel asked some basic situation, the technical director asked some knowledge of the database. Difficult to understand yesterday interview me is an ordinary colleague? ), or the old question "How to optimize a database?" ", simple answer (around distributed, indexed, stored procedures, SQL statement optimization), the small ape ability is limited, the answer will be able to give this degree, if there is insufficient also please point out. The last personnel asked what else to add, I briefly introduced the advantages (English technical documents, solution reading ability). Later, the personnel said that they would submit my information to trial, the appropriate words will be contacted as soon as possible, then I felt the end. Because this is two side, two side did not talk about offer is basically belong to Gameover.

Summarize:

1, the position of the company recruitment is very unclear, should be a DBA, at least face test questions and even interview talk about how the data optimization. If you encounter this interview again, you can ask the other person whether you are hiring a. NET engineer or a DBA?

2, the interview when the other party will generally let the interviewer do self-introduction, but also can ask the interviewer is currently in the company's position, responsibility. This would allow for appropriate adjustments in the way and atmosphere of the dialogue.

. NET Interview experience talk (i)