Актуальные заказы по MySQL

MySQL/PHP Application Developer

Постоянная работа
Full-time

В информационное агентство, специализирующееся в сфере финансовых рынков требуется MySQL/PHP Application Developer. Формат работы удаленный, но будет необходимо раз в квартал посещать офис в Санкт-Петербурге или Ереване.


Обязанности:

  • Участие в проектировании БД, проекций для витрин данных (сайтов), разработка репликаторов для поддержания актуального состояния проекций.
  • Поддержка и развитие слоя работы с БД, который в дальнейшем используется другими командами.
  • Оптимизация сложных SQL запросов работающих с большими объёмами данных для увеличения быстродействия;
  • Поддержка и развитие проекта по организации доставки данных клиентам (дата фиды);


Требования:

  • Уверенное понимание принципов проектирования реляционных БД, знание SQL (MySQL 8+) и его возможностей (CTE, оконные функции, триггеры и т.п.);
  • Опыт и понимание принципов оптимизации SQL запросов;
  • Уверенное знание PHP 7.4+, принципов ООП, шаблонов проектирования;
  • Опыт работы PHP backend программистом 5+ лет;
  • Опыт работы с GIT;
  • Желание работать в команде;


Будет плюсом:

  • Опыт работы с highload проектами и оптимизации структуры БД и SQL запросов для увеличения быстродействия;
  • Опыт работы с noSQL хранилищами (MongoDB).

Разработчик MediaWiki

Удаленно
Full-time
Постоянная работа
Строительная компания ищет опытного разработчика MediaWiki для работы на проекте по созданию информационной платформы.

Senior Web Developer - WordPress

We are looking for an experienced Web developer on WordPress. The successful candidate will be responsible for creating websites of the company.


Responsibilities:

  • WordPress websites` creation and development.
  • Integration of WordPress websites with the company's analytics systems / API / Salesforce and other services and testing them before launch.
  •  Creating special effects, animation on the WordPress websites.
  • Working with our SRE team to create and optimise pipelines and deploy processes.
  • Analyse and find optimised technical solutions for tasks` implementation.
  • Estimate time of tasks` implementation.


Skills Required:

  • HTML5, CSS, PHP, JS, jQuery, Ajax, JSON, MySQL
  • WordPress hooks, custom posts/taxonomies/fields, REST API, creating queries using wpdb, etc.
  • Development of custom themes and plugins for WordPress
  • Working with custom JS scripts
  • Compliance with valid layout and cross-browser compatibility, creation of websites with adaptive design
  • Ability to layout (using Figma), flex, grid, layout without using Bootstrap if necessary
  • Experience in optimising/improving WordPress security
  •  Setting up caching, customising themes, WP plugins for maximum performance
  • Optimisation and refinement of projects
  • Experience with Github
  • Experience with Amazon Web Services
  • Knowledge of administration: Shell, Apache, Nginx, MySQL, Cron
  • Code validation and code audit for problem areas
  • At least 3 years of experience working with customised WordPress websites
  • Portfolio: at least 3 customised WordPress sites (mandatory)
  • Intermediate English level (please submit your CV in English)
  • Russian language would be a plus


Nice to have:

  • Experience in performing tasks for SEO requirements
  • Experience in optimising website loading speed
  • Experience with migration plugin from Drupal to WordPress
  • Experience with CI/CD and automated deployments
  • Experience with website testing


Service Administrator

Офис
Full-time

An international powerhouse in the online trading industry with over 25 years of financial markets expertise is looking for a Service Administrator to join the team in Montenegro. In this role, you should have excellent problem-solving skills, proficiency in administrating OS Windows, Apple Mac and iOS expertise.


Requirements

- Excellent knowledge of PC/laptop components, experience of assembling PC/laptop;

- Running hardware and office equipment diagnostics, maintenance and troubleshooting;

- Proficient administrator OS Windows;

- Office’ IT Infrastructure maintenance;

- Wireless network installation and maintenance;

- Experience in installation and maintenance SCS (structured cable system);

- Experience in coordinating with hardware vendors and service providers;

- Excellent interpersonal and communication skills

- Strong team player – collaborates well with others to solve problems and actively incorporates input from various sources

- Demonstrated customer focus

- Builds strong customer relationships and creates processes with customer viewpoint

- Strong analytical skills – strong problem solving skills, communicates in a clear manner and · effectively evaluates information / data to make decisions

- Anticipates obstacles and develops plans to resolve

- Broad understanding of IT Infrastructure and support processes

- Apple Mac and iOS expertise

- Strong track record of understanding and interest in current and emerging technologies demonstrated through training, job experience and / or industry activities

- Change oriented – actively generates process improvements

- Supports and drives change, and confronts difficult circumstances in creative ways


Computer and special software skills:

- IT experience from 3 years old 

- Professional IT area education or relevant experience

- Windows family user and administrator knowledge/experience

- Citrix service

- TCP/IP knowledge and work experience

- PC Desktop/Laptop hardware knowledge at professional level

- Basic knowledge of monitoring systems and strategies

- Basic knowledge of recovery systems and strategies

- Knowledge with SQL queries for databases

- Basic knowledge in ITSM / ITIL. Atlassian products knowledge is a plus

- Customer focusing. Politeness, loyalty in any aspect

- Resistance to stress, ability to work under pressure

- Familiarity Database (MySQL, PostgreSQL, MS SQL) is a plus

- Familiarity writing scripts (at least one: PHP, JS, Bash, Visual Basic) is a plus

- Basic knowledge of GSuite


English language knowledge working level both oral and written (intermediate level minimum). TOEFL or IELTS certificates are a plus.


Responsibilities:

- Preparing and support workplaces in the offices and remote

- Participation in projects for repair offices and open new ones

- Fixing incidents with OLA (operating level agreement) conditions otherwise escalate it to the next level support

- Users support for any IT problem via any communication method (face-to-face, skype, phone, voIP, im, mail, Service Desk system) with high loyalty to the VIP consumers

- Maintain documentation (knowledge database) among entire support team, keep it up to date, create Standard Operating Procedures

- Collaboration with service providers

- Report on progress in Service Desk system

- Software support: installation, recovery, consultancy

- Deliver local IT support & proximity services (incident & Service Requests)

- Resolve backlog for incidents & SRs, report progress to end users and track root cause analysis

- Installation, configuration, operation, and maintenance of systems hardware and related infrastructure (amount of PCs – 400 +)/ troubleshooting (Windows 10 - 11, Chrome OS and MacOS)

- Preparing and support Citrix workplaces

- Carry out maintenance work of hardware and ensure that system hardware, operating systems work properly

- Keep hardware equipment inventory list up to date in database CMDB

- Hardware and software upgrade when necessary

- System’s and application software troubleshooting when necessary

- Video conferencing support - ZOOM, Google Meet, etc.

- Work closely with hardware vendors and service providers (quality assurance of services provided)

- Writing User manuals for internal employees

- LAN and VoIP support

- Maintain and support existing servers

- Participation in various IT projects

- Work from office in the Podgorica

- Other senior management orders\assignments

Senior PHP Developer

Одному из крупнейших ретейлеров детских товаров в России требуется опытный PHP разработчик для автоматизации графиков персонала на внутреннем портале.


Обязанности:

- Поддержка транспортной системы, инфокиосков, мобильного приложения по части PHP.

- Разработка на PHP / JavaScript для поддержки внутренних WEB-приложений, а также мобильного приложения для сотрудников.

- Поддержка скриптов на PowerShell, VBS, CMD.


Требования:

- Опыт разработки web-приложений 3+ лет.

- Умение разбираться в чужом коде.

- Знание PHP (ООП) и фреймворков: Yii, Laravel.

- Хорошее знание JavaScript (Angular, TypeScript).

- Умение строить и поддерживать сервисы интеграции на базе PHP, SOAP, Ajax, REST.

- Умение работать с Git.

- Опыт разработки на C#.

- Опыт развертывания и поддержки баз данных (MySQL, MSSQL).

- Базовые навыки работы с Unix-системами, гипервизором OpenVZ.

- Понимание таких сервисов как LDAP, DNS, DHCP, SMTP, SNMP, NGINX, APACHE, RSYNC.

- Умение писать скрипты на PowerShell, VBS, CMD.

- Коммуникабельность.

- Умение простым языком объяснять бизнес-пользователям сложные «вещи».


В команду проекта входит PHP разработчик, с которым предстоит работать вместе.