PHP

How to implement processing of 200,000 database records in Symfony with Doctrine: selection, processing, API request, record update?

Tell us about the use of caching (Redis, Cache Lock) — why it was used, how it helped, especially in high-load projects.

What is the difference between DELETE and TRUNCATE in PostgreSQL? Can DELETE be rolled back without a transaction?

How is the facade pattern in Laravel implemented, which appears as static calls but works as regular objects?

Regarding DevOps — what tasks and tools have you encountered?

How would you organize work and session storage in horizontal scaling?

What project in your career was the most challenging and why?

How comfortable would it be to interact directly with users/clients?

Tell us about your experience at your last job, especially regarding high-load and fintech parts, architectural solutions, and optimization.

Have you had disagreements with colleagues over technical solutions? How did you resolve them?

How do you take freelance orders?

Tell about your last place of work — [organization]. What did you do?

Tell about the team structure at your last workplace and the processes (code review, etc.).

Are there problems when using iterate() in Doctrine for a large table? What happens to memory during iteration?

Find the error in the code and the vulnerability (code with SQL concatenation via QueryBuilder)

Regarding languages other than PHP, which ones are you familiar with and at what level?

What is the name of the method chaining pattern in Laravel (User::where()->orderBy()->get()) and what do the methods inside it technically do to make the chain work?

How would you implement processing large volumes of tasks (millions in queue) without hitting memory and execution time limits?

What is an index in a database and when does it help or hinder?

Why did you leave your previous team?