I’m a SQL Server Expert involved in SQL Database Development and Administration for over 10 years. I’m a specialist in SQL server performance tuning, have skills and experience of resolving critical SQL issues in production environment. Being a Data Warehouse Consultant, I have helped IT and development managers by providing solutions of developing Data Warehouse in the cloud (Azure and Amazon Redshift) and on-premises. Analyzed and Evaluated OLTP databases, Designed data structures, database schemas, and SQL server integration services (SSIS) packages. As a SQL Server DBA, I helped businesses to implement the best data security and recovery strategy. I’m skilled and experienced in implementing best backup strategy and disaster recovery systems, automating SQL server maintenance, and resolving complex performance issues such as wait statistics, latches etc. I have helped many organizations by planning proper upgrade and migration strategy and implemented them successfully in production. To resolve SQL server performance issues, I use profiler to capture complex and critical queries and analyze them using database tuning advisor. By deploying productive indexes, joining tables correcting, using plan guide, using searchable terms, I helped production environment to experience the best performance. My knowledge in SSRS and PowerBi helped me to create proper reporting for BI users. So far, I have supported Microsoft SQL Server (2005-2017), MySQL platform, PostgreSQL etc. My consulting helped many midsize businesses and non-profit organizations to secure, administer, manage, and develop the databases without hiring a full time database administrator or DBA. I`m willing to hear your problem(s) and concern(s) and hopefully, I can come up with a solution that will give you better experience in the technology world.
©