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

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

SQL-разработчик

Удаленно
Full-time

О компании

Крупнейший российский разработчик инженерного ПО в поиске сильного SQL-разработчика, который присоединится к команде компании. От разработчиков на данную позицию ожидаем качественных навыков проектирования структуры базы данных, разработки на диалектах SQL, понимания принципов работы планировщика и оптимизации SQL-кода.


Требования

  • специалист с опытом в разработке более 3-х лет
  • проектирование структуры базы данных
  • разработка программного кода на Transact-SQL (обязательно, будет плюсом опыт разработки на PL\pgSQL)
  • разработка высоконагруженных систем
  • разработка БД, ориентированных на наполнение большого размера (>500гб)
  • работа с инцидентами (ошибки, проблемы производительности)
  • оптимизация производительности БД, понимание работы планировщика запросов, анализ планов запросов
  • работа с легаси
  • для хранения и обработки данных в системе используются СУБД Microsoft SQL Server и PostgreSQL


Дополнительные навыки

  • опыт разработки backend в стеке .NET
  • опыт разработки OLTP-систем


Софт-скиллз

  • ответственность, нацеленность на достижение результата
  • коммуникабельность, умение работать в команде
  • инициативность

Solution Architect

Удаленно
Full-time

A specialist is required for our client's project to create specific solutions working with a stack of technologies:

Docker, Azure Container Apps, Bicep templating, Powershell, Azure Devops yaml CI/CD, Azure Storage, Azure Service Bus, Azure Networking (Private DNS Zones, Private Network/Subnets, CDN, Firewall, Network Security Group), Azure Frontdoor, Azure B2C, Azure Application Insights, M-Files, Document360, .NET 7, C# 11, ASP.NET Core, Blazor WASM, SwaggerGen, Azure Key-Vault, SQL Server.


Required Skills:

  • Experience building distributed architectures (microservices, service oriented architecture).
  • Event Driven Communication (Saga, Transactional Inbox/Outbox, Durable chains, Routing Slip).
  • Relational/non-relational Databases expertise - SQL Server.
  • Networking / Security (private networks and tunneling).
  • .NET Core 6,7 / C# 10,11 expertise, Entity Framework Core, Identity Server4.
  • UML Diagramming (Component/Flow/Sequence diagrams).
  • Monitoring tools / Alerting configuration experience.

English: B2+, C1

Locations: USA, Mexico, Lithuania

Data Engineer with Informatica

Удаленно
Full-time

Project: IT service provider for the life science and healthcare industry.


Requirements:

  • Proficiency in administering Informatica PowerCenter or Informatica Cloud, including installation, configuration, and maintenance of the Informatica environment.
  • Knowledge of securing the Informatica environment, including user access management, authentication methods, and data encryption.
  • Proficiency in monitoring Informatica resources, managing server logs, and performing routine maintenance tasks to ensure smooth operations.
  • Experience with scripting languages (e.g. Python or Bash) and automation tools to automate administrative tasks and improve efficiency.
  • Experience in optimizing Informatica workflows, sessions, and mappings for better performance and efficiency.
  • Ability to diagnose and resolve issues related to Informatica workflows, data integration, connectivity, and performance.
  • Ability to handle change requests, coordinate deployments.
  • Knowledge of data quality management, including profiling, cleansing, standardization, and validation techniques.


Nice to have:

  • Familiarity with database concepts and SQL queries.
  • Experience with ETL processes and tools, including the ability to design and implement efficient data workflows.
  • Understanding of Informatica Cloud IDMC integration process with other applications and systems using APIs.
  • Knowledge of data warehousing concepts, such as data modeling, dimensional modeling, and star schemas.
  • Familiarity with big data technologies, such as Hadoop, Spark, and NoSQL databases.
  • Understanding DevOps methodologies and tools can help in managing and deploying Informatica Cloud IDMC pipelines and processes more efficiently.



SRE/DevOps Engineer

Офис
Удаленно
Full-time
Постоянная работа

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.



Lead Java developer

Full-time

Who we are looking for Server software expert (Java 11+, Spring Boot, Maven / Gradle, Junit, Mockito, SQL / ORM)

Certain responsibilities that involve development and deployment of strategic products


5 reasons why you would like to work with us


1. Fintech

Unique domain area that contains lots of interesting tasks.

Real Highload - estimated number of unique users per day is expected to be 5 million people.

Increased requirements for security and fault tolerance of the solution.

We are creating a payment method which means that the Platform we are creating must be available 24/7/365.

At the same time, we are constantly testing new product hypotheses, so we are focused on the "purity" of the solutions created and the internal quality of the code.

2. Real product development

We are developing a product that is very important in daily life of people.

You can tell your mom what you're working on, and she'll not only understand you, but she'll be happy that you're solving real problems of real people.

Each sprint we fulfill a business goal - we actively test business hypotheses.

What you do today will be sold tomorrow by a sales specialist, you will be fully integrated with the business team.

You can influence the product and we need such proactive people. We have a flat structure and open communication.

3. We develop – we launch.

We are engaged not only in development, but also in operation.

We build and develop a mature DevOps process; system engineers are part of our development team.

You will develop the ability to think about how your solution will behave in operation.

4. Mature Scrum process, no “inventing the wheel”

We work with Scrum; we scale Scrum with LeSS.

This means we work in small, long-lived product feature teams.

You will work hand-in-hand with colleagues from other disciplines to get the job delivered.

We practice swarming - we are constantly communicate online with other team members.

Participation in our teams involves T-shaping, you can painlessly and comfortably master related specialties.

You won't be left alone with process issues - we have one scrum master for every three teams.

You will influence the effectiveness of the team, avoiding unnecessary losses, influence the process as a whole.

5. A real startup with all it entails

A unique experience that will be useful to you in the future if you are going to create your own startup.

We go through all phases of development, from finding early followers to launching marketing campaigns.

This is a startup, not an enterprise - minimum bureaucracy, open communications, a culture of errors and security.

International multicultural mature team with average team member age of 30.

How about building together an alternative financial ecosystem in one single country with the potential to scale into Asian markets?

Would you like to digitize oriental bazaars with us?

We are creating a new payment method, an alternative to cash and plastic cards, with our own unique set of financial instruments aimed at ordinary people.


We are looking for

A person who can take responsibility for the quality of the backend code and the efficiency of the backend developers.

A backend development expert (Java 11+, Event Driven Microservices on Spring's stack).


Experience, Competencies and Skills Required

  • Participation in the design of platform components, audit of design solutions offered by other developers
  • Selection of technologies and tools for development and operation, we profess the “you code it you run it” approach
  • Expert leadership of the backend developer community - coaching, implementation of effective development practices, facilitation, design sessions
  • Development of code conventions and responsibility for their implementation by the community of backend developers
  • Identification of problems and wastes in the work of backend developers
  • Collaboration with the Scrum Master service to improve current processes and practices
  • Of course, you will write code, both purely technological parts of the system and product features.