I have over four years of experience with SQL Server as my work as a Data Analyst at Rystad Energy primarily involved working with the database. I have experience working with the following:

• Writing queries of any complexity
• Importing data from .csv files and MS Access databases; some experience of working with SSIS packages to automate data import
  
• Developing stored procedures for data transformations, cleaning and deduplicating the raw data, and data modeling
• Optimizing existing stored procedures written in a non-optimal way (splitting large update queries into smaller ones, adding and removing indexes of tables where required)
• Using SQL Server Agent for scheduling both SQL stored procedures, Python scripts, and CMD /PowerShell scripts
• Connecting SQL Server to PowerBI dashboards
  
• Implementing change management of SQL Server stored procedures using: 
• Azure Data Studio with SQL Database Project extension - for rebuilding database project after making changes
  
• BitBucket git repository - for version control
  
• Azure DevOps for managing CI/CD pipeline to deploy the changes to both development and production server