i
Microland
Filter interviews by
Clear (1)
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
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
Top trending discussions
I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.
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
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
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...
I applied via Walk-in and was interviewed in Aug 2022. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
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
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...
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
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.
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...
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
Puzzles, Psychometric Test
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Engineer
362
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Administrator
260
salaries
| ₹0 L/yr - ₹0 L/yr |
System Administrator
228
salaries
| ₹0 L/yr - ₹0 L/yr |
Sme Associate
217
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
195
salaries
| ₹0 L/yr - ₹0 L/yr |
Wipro
HCLTech
Tech Mahindra
TCS