Проект: разработка и сопровождение брокерской системы в части БД (MS SQL Server 2019).

Требования:

• опыт в оптимизации запросов для нагруженных систем,
• понимание механизмов работы MS SQL Server,
• понимание работы компонента Service Broker,
• знание предметной области (брокерская деятельность) будет плюсом.

Looking for a SRE/DevOps Engineer to work on a trading product.

Requirements:

• Strong knowledge of Linux (or any other Unix);
• Experience with DevOps tools (Docker, Jenkins, Gitlab-CI, Ansible, Terraform, Chef, Puppet etc.);
• Understanding of principles of web-servers (ex. Nginx);
• Understanding of HTTP Stack;
• Understanding CI/CD;
• Version control systems: Git;
• Knowledge of SQL;
• Basic knowledge of databases: PostgreSQL/MySQL;
• Basic knowledge of networks.

Tasks/responsibilities:

• Monitor the operation of reporting systems in production, solve current problems and work on improving the operation of systems (find errors in logs and performance loss, detect problems in the interaction of services, analyze application performance metrics and system metrics of host resources on which the application is deployed and create tasks for development team to fix the problems);
• Incident resolution, root cause analysis, reporting, collaboration in problem;
• solving including problems related to other teams;
• Configure and adjust monitoring of services;
• Build, release and configuration management of production systems;
• Deploying, automating, maintaining and managing AWS cloud-based production system, to ensure the availability, performance, scalability and security of production systems;
• Managing dev QA and production environments.

Tech stack:

• *nix family OS;
• AWS;
• Kubernetes;
• ELK;
• Zabbix, Grafana, Dynatrace;
• Git;
• Jenkins, Gitlab CI;
• Terragrunt;
• PostgreSQL;
• Kafka;
• Consul, Vault.

Relocation to Montenegro.

Who are we?

Role Description

Data engineer will be responsible for improving and expanding our data capabilities:

· You will design and develop data applications in one of languages: Python, Scala, SQL

· Develop, customize and manage data integration tools, databases, warehouses, and analytical systems

· Design, build and maintain scalable data models that are clean, tested, and well documented

· Work closely with product teams and other stakeholders to desing and build data marts providing reliable and accurate data in a fast way

· Handle all our data pipelines and contribute towards our data strategy and its execution

Experience, Competencies and Skills Required

· 2+ years of experience as a Data Engineer building data pipelines and analytical data models

· At least 2 years of hands-on experience with Python, SQL. Knowledge of Scala is a plus

· Strong competencies in algorithms and software architecture

· Strong experience in real-time data processing and data ingestion

· At least 2 years of hands-on experience with Big Data systems like Hadoop, Spark

· Experience building data infrastructure using at least one major cloud provider, preferably AWS

· Knowledge of Terraform is a plus

· Knowledge of Scrum, Agile

· Advanced English, good Russian

Project

The (further) development of software for the purpose of iterative experiment design, data visualisation and connection to the Alb. database.

Backend Components:

Therefore, the software development also requires the design and development connectivity to the Alb. database via REST API as well as the frontend with user interface. The first component of API development is required to be developed using Python and TypeScript as well as serverless technologies based on Azure. Developer will be responsible for creating web application backend components from scratch, which will be exposed as REST Web APIs to frontend. In this role, you should be able to write functional code, which handles data from external REST APIs as well as from NoSQL database.

Frontend:

The second frontend component requires proficiency in AngularJS and TypeScript with the ability to make code design decisions. In addition, the developer has Python development skills, experience in API development and testing as well as in data visualization frameworks like D3.js.

Backlog items will be assigned in Azure DevOps containing business requirements and acceptance criteria.

Tasks:

-       Affiliation of scalable and responsive cloud-based Web application using state-of-the-art frontend engineering practices by:

o  Designing a technical concept, coding, testing and documentation according to the backlog item based on TypeScript and Python [BE]

o  Designing a technical concept, coding, testing and documentation according to the backlog item based on AngularJS and TypeScript [FE]

o  Translation of UI/UX design wireframes to actual code, by developing web user interface components and related tests [FE]

o  Designing and testing of APIs [FE]

o  Implement serverless technologies based on Azure, Azure Cosmos DB as well as Azure Event Hub [BE]

o  Creating web application backend components from scratch, which will be exposed as REST Web APIs to frontend [BE]

o  Write functional code, which handles data from external REST APIs and from NoSQL database [BE]

o  Implementing JWT-based authentication and access token handling [BE]

o  Performing visualization within data visualization frameworks like D3.js [FE]

o  Developing CI/CD build pipelines for the developed web components and takes actions to keep code/systems stable and efficient [BE, FE]

o  Testing including unit, integration, and performance tests [BE, FE]

-       Identify, design, and implement product improvements for the project related tasks according to the discussed backlog [BE, FE]

-       Documentation of technical implementation and related processes in Azure DevOps. Company will validate and approve it [BE, FE]

\Gambling Industry, Long-Term Project

• Start date is as soon as the candidate is selected

Server Management

• Installing, configuring and maintaining PostgreSQL, the servers and tools
• Installing, configuring and managing replication databases
• Performing Database backup & recovery procedures. Creating backups, testing backups sustainability

Database Management

• Access Management
• Implementing database monitoring & automation
• Monitoring database performances, design and development of SQL and PL/pgSQL code
• Provide guidance and support to Application Developers
• Identifying low perform queries and performance tuning
• Owning security compliance
• Mitigating database-oriented risks and creating policies for high availability on databases
• Implementing high-availability, clustering and replication for databases, performance and capacity
• Managing data and database versions
• Implementing DR procedures
• Other job duties as assigned

Requirements:

• Three (3) or more years of experience with PL/pgSQL coding
• Three (3) or more years of experience with Postgres
• Expertise in SQL
• Excellent problem-solving and analytical skills
• Good communication, teamwork and negotiation skills
• Experience in DML and the principles of database design
• Business awareness and understanding of business requirements
• Understanding of compliance regulations (privacy, financial)

We are looking for a Senior Database Developer/Architect who is interested to advance their skills.

Timezone GMT+3

Your skillset (education, experience, and abilities):

• Experience in Database Development/architecture;
• Good knowledge of PostgreSQL architecture, administration experience, monitoring, and tuning DBMS performance;
• Knowledge of SQL at the level of a database developer (stored procedures/functions, analytic functions, JSON functions, custom types.);
• Ability to build an optimal data storage scheme (data model) for a formulated business requirement;
• Experience in optimizing SQL queries, database structures, analyzing incidents and problems in the operation of the database;

As a great advantage:

• Experience with any BI tool (like Qlik, Tableau, Power BI).
• Experience with Git;
• Experience with AWS;
• Experience with MS SQL;
• Experience in setting up backup and recovery of databases;

Your core responsibilities in this role:

• Implementation of new features using PostgreSQL, work with support tickets