Hi,
I have 15+ years of experience in SQL Server Administration and Development. I can assist you in AlwaysOn AG, SSRS, SSIS and SSRS configuration and implementation. have done so many projects and delivered training and Documents for future references.
I also have experience in ADF and Azure Synapse. Wrote pipelines to load data from SQL Server OnPrem, CRM 365 and Azure Data Lake.
I also have experience in SQL Server RDS in AWS cloud along with the instances on EC2 machines.
For Optimization, I can give you copmplete list on;
1. Missing Indexes
2. Unused Indexes
3. Redundant Indexes
4. CPU intensive queries
5. Memory intensive queries
6. Locks and Deadlocks
Please let me know if we can connect on this.
Looking forward for a healthy and long term working relationship.
Regards,
Atif