Backend әзірлеушісі

Жариялану күні:

15.03.2023

Бос орын жабылды

Қажетті жұмыс тәжірибесі: 2-3 жыл.

Жұмыс кестесі: толық жұмыс күні.

Технологияның негізгі стегі:
— .NET Core/Python.
— PostgreSQL.
— RabbitMQ.
— Redis.
— Mongo.
— Git.
— Docker.
— CI/CD.
— Nginx.

Кандидатқа қойылатын талаптар:
— ОP, SOLID, CQRS туралы білім.
— Дизайнның негізгі заңдылықтарын білу.
— Командада жұмыс істей білу.
— Нақты түсіндіре білу.
— Техникалық құжаттаманы ағылшын тілінде оқу.
— JavaScript/TypeScript, NodeJS, ReactJS, HTML, CSS-ті білу плюс болады.

Міндеттері:
— Модуль/веб-қосымшаның архитектурасын жобалау.
— Веб-қосымшалар мен қызметтерді әзірлеу және жетілдіру.
— Веб-қосымшаларды оңтайландыру.
— Даму процесін автоматтандыру және дамыту.

Үн қату

ID	(4,1)	Class	SQL
0	0,32	DB	SELECT * FROM kz_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LI SELECT * FROM kz_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,22	DB	SELECT * FROM kz_rubrics WHERE 1=1 AND (kz_rubrics.furl='vacancy') AND active = :active AND activ SELECT * FROM kz_rubrics WHERE 1 = 1 AND (kz_rubrics.furl = 'vacancy') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,5	DB	SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,26	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
4	0,16	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
5	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,27	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,19	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,15	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,11	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,15	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,11	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,1	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,1	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,12	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,13	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(4,1)

Class

SQL

0,32

SELECT * FROM kz_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LI

SELECT 
  * 
FROM 
  kz_vacancies 
WHERE 
  id = :id 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,22

SELECT * FROM kz_rubrics WHERE 1=1 AND (kz_rubrics.furl='vacancy') AND active = :active AND activ

SELECT 
  * 
FROM 
  kz_rubrics 
WHERE 
  1 = 1 
  AND (kz_rubrics.furl = 'vacancy') 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,5

SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1

SELECT 
  * 
FROM 
  kz_rubrics 
WHERE 
  1 = 1 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,26