Situational Questions
Sql Server Database Administrator Developer Interview Questions
137 sql server database administrator developer interview questions shared by candidates
The interviewer asked question-related to past experience and roles and responsibility in my project. Scenario-based question on Always ON, Log shipping, and Blocking. Installation and troubleshooting SQL errors during installation. User login issues and how we troubleshooting this.
Technical interview: I was asked questions relevant to my experience with the various technologies related to SQL Server Database Administration. They asked different level of questions. What was the scope of your work? What kind of problems did you solve and how. Management interview: I was asked some questions such as following: What are you looking for in your prospective employer? Where do you see after 3 years in this organisation?
Any experience with ETL (SSIS) use this alot to load data
Disaster recovery and high availability. Basic Database concepts, Encryption, Mirroring clusterring logshipping,etc
Dba question and project related experience
Master database crash , what will you do.
log shipping, mirroring, clustering, Always on
Almost everything about core Sql dba like backups, clustering, high availability, performance tuning.
Aptitude test as first round
Viewing 101 - 110 interview questions