Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Microland Team. If you also belong to the team, you can get access from here

Microland

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Microland MS SQL DBA Interview Questions and Answers

Updated 19 Dec 2022

Microland MS SQL DBA Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. New SQL Server installation and configuration
  • Ans. 

    New SQL Server installation and configuration

    • Determine hardware and software requirements

    • Install SQL Server software

    • Configure server settings and security

    • Create and configure databases

    • Set up backup and recovery procedures

  • Answered by AI
  • Q2. Maintaining high availability like log shipping mirroring transactional replication always on and clustering
  • Q3. Database migration from lower version to higher version
  • Ans. 

    Database migration involves upgrading a lower version of a database to a higher version.

    • Ensure compatibility between the source and target database versions

    • Backup the source database before migration

    • Use a migration tool or script to transfer data and schema

    • Test the migrated database thoroughly before deploying to production

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Worked as a Database Administrator with microland Bangalore

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Personal Details, Strength and Strong Areas, SQL Server Performance Optimization, Windows Clustering, Always On, Shipping, Mirroring, Replication.

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Personal Details
2.Communication must be good
3.Strong Knowledge of Technology and the fundamentals
4.Resume Should be Good
5.Show Your Good areas
6.Be Confident While Interview
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Share your experience about your company with us
  • Q2. Tell me about roles and responsibilities
Round 2 - HR 

(2 Questions)

  • Q1. What ctc are you expecting
  • Ans. 

    I am expecting a competitive salary based on my experience, skills, and the market rate for MS SQL DBAs.

    • I am looking for a salary that reflects my expertise in MS SQL Server administration.

    • I am open to negotiation based on the specific responsibilities and benefits offered.

    • I have researched the average salary range for MS SQL DBAs in this location and industry.

    • I am also considering other factors such as opportunities f

  • Answered by AI
  • Q2. Are you willing to relocate

Interview Preparation Tips

Interview preparation tips for other job seekers - very good
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Start up parameters of sql server
  • Ans. 

    Start up parameters are used to configure the behavior of SQL Server when it starts up.

    • Start up parameters are specified in the SQL Server Configuration Manager.

    • Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

    • Start up parameters can be modified to customize the behavior of SQL Server during startup.

    • Example: -dC:\Program Files\Microso...

  • Answered by AI
  • Q2. Differential backup query
  • Q3. Sql server statics
  • Q4. Log file architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - kindly prepare all the topics about sql server.

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. WHAT IS YOUR EXPIRENCE?
  • Q2. WHAT IS YOUR HIGHER GRADUATION PERIOD.

Interview Preparation Tips

Interview preparation tips for other job seekers - MY NAME IS NAVEEN KUMAR . I AM FROM BADVEL. MY HIGHER GRADUATION DEGREE BSC COMPUTERS.

MS SQL DBA Interview Questions & Answers

TCS user image urugonda soumya

posted on 15 Jul 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the steps involved in migration
  • Ans. 

    Steps involved in migration process

    • Assess current environment and identify migration goals

    • Choose migration method (manual, scripted, tool-based)

    • Prepare target environment and perform data migration

    • Test migrated data and applications for functionality

    • Implement post-migration tasks like user training and support

  • Answered by AI
  • Q2. How to do migrating from 2008 to 2019
  • Ans. 

    Migrating from SQL Server 2008 to 2019 involves upgrading the database, transferring data, and testing for compatibility.

    • Perform a side-by-side upgrade by installing SQL Server 2019 on a new server and transferring databases using backup and restore or detach and attach methods.

    • Use the Data Migration Assistant tool to assess compatibility issues and plan for any necessary changes.

    • Update applications and scripts to ensu...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Dba backups in sql
  • Ans. 

    DBA backups in SQL are essential for data protection and disaster recovery.

    • Regularly schedule full, differential, and transaction log backups to ensure data is protected.

    • Store backups in secure locations to prevent data loss in case of hardware failure or corruption.

    • Test backups regularly to ensure they can be restored successfully in case of emergency.

  • Answered by AI
  • Q2. Dba replication
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about urself
  • Ans. 

    I am a dedicated and experienced MS SQL DBA with a strong background in database administration and performance tuning.

    • Over 5 years of experience working as a MS SQL DBA

    • Proficient in database administration tasks such as backup and recovery, performance tuning, and security

    • Skilled in troubleshooting and resolving database-related issues

    • Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Serv...

  • Answered by AI
  • Q2. Strengths and weakness

Skills evaluated in this interview

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.
Contribute & help others!
anonymous
You can choose to be anonymous

Microland Interview FAQs

How many rounds are there in Microland MS SQL DBA interview?
Microland interview process usually has 2 rounds. The most common rounds in the Microland interview process are Resume Shortlist and One-on-one Round.
What are the top questions asked in Microland MS SQL DBA interview?

Some of the top questions asked at the Microland MS SQL DBA interview -

  1. Database migration from lower version to higher vers...read more
  2. New SQL Server installation and configurat...read more
  3. Maintaining high availability like log shipping mirroring transactional replica...read more

Recently Viewed

LIST OF COMPANIES

Discover companies

Find best workplace

LIST OF COMPANIES

Diaspark Infotech

Overview

COMPANY BENEFITS

Diaspark Infotech

No Benefits

JOBS

Dolat Capital Market

No Jobs

REVIEWS

Mastek

No Reviews

REVIEWS

HCLTech

No Reviews

REVIEWS

BNP Paribas

No Reviews

DESIGNATION

REVIEWS

Diaspark Infotech

No Reviews

JOBS

Diaspark Infotech

No Jobs

Tell us how to improve this page.

Microland MS SQL DBA Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

MS SQL DBA Interview Questions from Similar Companies

View all
Microland MS SQL DBA Salary
based on 16 salaries
₹3.6 L/yr - ₹8.4 L/yr
17% less than the average MS SQL DBA Salary in India
View more details

Microland MS SQL DBA Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

1.0

Skill development

3.0

Work-life balance

3.0

Salary

2.0

Job security

3.0

Company culture

3.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Senior Engineer
362 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Administrator
260 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Administrator
228 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sme Associate
217 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
195 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Microland with

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent