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?
Disaster recovery and high availability. Basic Database concepts, Encryption, Mirroring clusterring logshipping,etc
What's your desire salary?
Master database crash , what will you do.
Dba question and project related experience
Architect a redundant SQL Server environment
Tell us about yourself and your experience as a Database Administrator. Why do you want to work for our company? What motivates you in your career as a DBA? Describe a challenging situation you faced as a DBA and how you resolved it. How do you handle stress or tight deadlines? How do you prioritize your tasks when managing multiple projects? How do you keep yourself updated with the latest developments in database technologies? Can you describe a time when you had to work as part of a team? How would your previous colleagues describe you? Where do you see yourself in the next 3-5 years in your DBA career?
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 221 - 230 interview questions