spring-testing | A Spring Boot application with lots of test examples | Security library

I am using SQL Server 2016 as a production and development database (so no h2) with a Spring Boot 2 backend and Angular 7 frontend. If I run the application normally, everything works as intended. For integration testing (JUnit5), I would like to use Selenium, so the application needs to actually run on a port and be accessible with a browser. I also need to prepare some data before each test (as I cannot use production data). In order to achieve both, I planned to use spring's @Sql annotation, which allows me execute any .sql file before the tests (In my case, I insert data I would like to manipulate). Spring rolls back everything after the test, so It should work well. However, when I am inserting data, the transaction the test started locks the database tables and the other services/repositories the application use (to query data for example) are blocked.

Example.: I insert an employee in the file I linked in the @Sql annotation, then Selenium starts the browser and I navigate to a list with the employees. At this point, the employee listing won't work (which is served using a REST endpoint and the EmployeeRepository), because it is blocked by the test's transaction.

I can also confirm this locking manually, while the tests run, I cannot execute queries using SQL Server Management Studio (waiting and completes when I end the tests).

Can I use @Sql or any other data preparation tool for my tests and let the application work normally, while also being able to roll back the changes after the tests?

Test class: