Install and configure database software like SQL Server Database engine, SSAS,SSRS and associated database toolsÿfor versions 2019/2017/2016 on both stand alone and cluster environment.
Automation of SQL Server installation along with Service pack through Slip Stream method.
Should have good experience in deploying AWS Amazon EC2 instance for SQLServer version 2016,2017 & 2019.
Experience in Microsoft Azure services like BLOB storage, ADF and SQL Instance.
Should have good experience in migrating the database from on premise to cloud.
Hands on experience in exporting and importing using data tier.
Install and configure the new features like Always On in failover cluster environment.
Experience in troubleshooting and resolving blocking and deadlocking issues replication issues log shipping issues connectivity issues security issues.
Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler/Extended events/Query store and other related monitoring and troubleshooting tools.
Automation of SQL Server installation along with Service pack through Slip Stream method using PowerShell, T-sql.
Should have good experience in developing stored procedures,SSIS packages and deployment.
Monitoring and sending critical report on daily basis as per business requirement.
Good experience in migrating SQLServer database to latest version using side by side migration and also using in place upgrade.
