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.
Monitor database performance by gathering and analyzing database statistics, reviewing database initialization parameters, and performing benchmarks
Tune database instance/server for maximum performance
Provide database guidance to application and systems administration teams for database application performance issues.
