Sample cover Letter, this is the sample letter available in Indeed for IT specialist, and can be used for any IT role with modifications.

Jensen Pope

(111) 789-3456

jensen.pope@email.com

28-Jun-19

Dear Hiring Manager,

I'm happy to be applying to the currently open IT Specialist position at Crossover Software. I have have loved tinkering with computers since childhood and have had an intense desire to pick them apart and learn how they work from the start. This early fascination grew in me over the years and I acquired a strong set of problem-solving skills. I think that with my analytical acumen, I can bring something of value to your company.

I have previous experience working as a software developer for Flagship Computer Engineering. In this role, I not only wrote intricate software, but I also interacted regularly with customers to help them resolve their issues with software products. In addition to this, I have earned A+ and Network+ Certifications from CompTIA, which have given me significant hands-on experience setting up Wi-Fi networks, configuring them, working with routers, adding and removing additional devices to private networks and debugging a wide range of software and hardware issues in the IT world.

Moreover, I am familiar with a broad assortment of malware types and how to remove them or present them from infecting a system. Using what I know, I have been able to work with customers both remotely and in-person to resolve their computer-related difficulties. I thus am just as experienced with the technical end of IT as I am with the customer service end.

I am grateful for your time, kindness and attention in considering me for this position. Working as an IT Specialist at Crossover Software would not only allow me an outlet for what I think are my natural analytical abilities, but it would also allow me to do something I love while providing service and assistance to others. It would be an honor to be able to work as part of the team of excellent IT Specialists and Technicians that you have at Crossover. 

Sincerely,

Jensen Pope 

Common SQL Interview questions

1. What is Database?
2. Define primary key, foreign key and unique key?
3. Difference between clustered index and non clustered index?
4. What are the files associated with a database in SQL server?
5. What is normalization?
6. What is a join and what types of joins in SQL Server?
7. What are constraints in SQL Server?
8. What is a view? How to update a view in SQL Server?
9. Difference between Union and Union ALL?
10. Difference between Stored procedure and function?
11. Difference between truncate and delete?
12. What is a linked server?
13. What is difference between clustered index and non clustered index?
14. What is cursor and what are alternatives to cursor in sql server?
15. What are DBCC commands?
16. What is a trigger and types of triggers in SQL server?
17. What are isolation levels in SQL server?
18. What is SQL profiler why is it used?
19. What is Activity monitor why is it used?
20. What is SQL server agent?
21. What is SQL Server Browser?
22. What are ACID properties in a database?
23. What are DMV’s ?
24. What are the types of Backups in SQL server?
25. What is log shipping and why is it used?

Interview Preparation

Behavirorial skills are as important as technical skills expecially in North American interviews. This questions are mostly part of Hr Interview. Personality or Behavior questions are used to assess how well you will fit in an environment and your likely behaviour in work enovironment.

Common Behavioral Questions:

1)    Tell me about yourselves?

This question is the first question to understand your skill set and what you can offer to this job. Answer should have your years of experience, Mention about skilled areas i.e trouble shooting, Performance tuning, security and access, Relevant education. Also talk about your recent job and explain how it helps this job.

2)    What Interests you in this job?

Talk about company/brand, Technical skills which are required for the job and skills you have and how they match, talk about the company culture and Environment.

3)    Why should we hire you?

This question is to see why you think you are good fit for the job. Talk about Your experience, skill set, how it helps them, your soft skills and team player skills, Positive attitude.

4)    What are your strengths and weakness?

Don’t say you’re a hard worker and punctual. You are expected to work hard and be punctual when you are getting paid.  Come up with something genuine. You can say you’re technically strong, Can work well in pressurized environments.  Weakness should sound like strength.

5)    Where you want to be in next 5 years?

You can say that you want to be expert or senior in the field you are working. Talk about your certification and new skill sets you think you need and how you are working to get to the position you want to be in 5 years

6)    What would your Ideal environment be?

This question is to know more about you. Some people can work well if it’s quiet environment and some people don’t. Some people can work in high pressure environments and some may not. Talk about if you are detailed or deadline oriented. Best answer would be trying to be a mix of both and choose the optimal one based on the scenario.

7)    Can you describe a scenario when you had a difference of opinion with a team member and how did you resolve it?

This question is to see how you deal with unpredictable and how best you can work in a team.  Working in a team sometimes we have difference of opinion on the best solutions, approaches and ego’s. Good answer is irrespective of your differences you communicate about the problem, analyze the solutions, address the question in terms of pro and con’s and selects the best solution/approach which is good for the team. Sometimes Choice’s made may go against your preference but we should move on with team spirit.

8)    What motivates you to do your job?

Talk about your interests and environment, challenges you are trying to find solutions for, Positive attitude.

9)    Tell us a scenario where you used your analysis skills or communication skills?

Talk about a problem why you felt it was challenging, Impact of it , Analysis on the causes of the problem and how you communicated with different parties to resolve the issue in a timely fashion.

10)   Do you have any questions for us?

Always ask this question. Ask about team size, what kind of role the job is, what kind of projects they handle.