SoftConstruct is the innovator in the field of big data and computer vision among Ukrainian IT companies with HQ in Armenia, Yerevan. We combine our extensive experience in the development of SportTech software with advanced technologies to develop original software for sports statistics, risk analysis and security.
14 апреля 2021

MS SQL Database Administrator (Big Data Team) (вакансия неактивна)

Киев

Необходимые навыки

— Experience in Microsoft SQL database administration in a production environment for at least 5 years;
— Knowledge of Windows Server administration;
— Advanced T-SQL skills including development and performance optimization;
— Experience working in a virtualized environment including basic troubleshooting abilities;
— Excellent communication skills for working with incident and application teams;
— Experience in process orchestration and workflow design;
— High-level knowledge of key business drivers measures, processes, and challenges;
— Ability to think more broadly about data management and information architectural concepts and principles;
— Strong collaboration skills and ability to promote ideas and advocate for change;
— Familiarity with Infrastructure as Code and Desired State Configuration;
— Good overall exposure to various technology stacks like Storage, Network, OS, and databases;
— Familiarity with and capable of enforcing technology management practices such as CI/CD (Continuous Integration/Continuous Delivery).

Предлагаем

— Interesting and challenging work in a product and customer-oriented technology company;
— Plenty of opportunities to learn, grow and progress in your career;
— We keep a work-life balance;
— Health insurance;
— Paid vacation and sick leave;
— Cozy office near Lukyanivska metro station;
— Participate in R&D projects.

Обязанности

— Development, maintain and support the current environment of MS SQL database infrastructure, ETL jobs, and reporting procedures. Investigate, troubleshoot, and fix the issue. Work with the Data Engineering team to make sure any change made to ETL code to fix any issue is committed to the main branch after proper design and code review.
— Research and develop monitoring and alerting capabilities to ensure all ETL, database, and reporting jobs execute and successfully complete on an established schedule.
— Design and deploy improvements to the existing databases, ETL jobs, SQL stored procedures, tables, schemas, and other database elements for improved performance and reliability.
— Assist and advise onshore data engineers with the design and deployment of a modern enterprise data warehouse. The company plans on re-architecting and re-building the data warehouse.

О проекте

We are looking for an experienced Database Architect who will work closely with the Big Data team of Involving in all development & deployment phases, including designing schemas and supporting developers in database-related code. This position involves business trips to Armenia, Yerevan

ABOUT COMPANY
SoftConstruct Ukraine is one of the innovators in the field of big data and computer vision among Ukrainian IT companies with HQ in Armenia, Yerevan. We combine our extensive experience in the development of SportTech software with advanced technologies to develop original software for sports statistics, risk analysis, and security.
We love sports and want to make it more technological and innovative.

ABOUT PRODUCT
Data Platform that delivers the performance, simplicity, concurrency, and affordability for data collecting, rapid analytics, and extracting data-driven insights for business users.
Lambda architecture, designed to handle massive quantities of data by taking advantage of both batch and stream-processing methods. This approach to architecture attempts to balance latency, throughput, and fault-tolerance by using batch processing to provide comprehensive and accurate views of batch data, while simultaneously using real-time stream processing to provide views of online data.
In many organizations, data consumption processes for timely reporting or crucial analytical requirements are hindered by delays in query execution and information presentation. The main challenge is to minimize decision delay with the help of flexible solutions with open and simplified architecture and high performance based on future-oriented technologies using AI models and forecasting analytics.

IN NUMBERS
Up to 1 PB of data from 500+ partners in long-term storage
30+ M new records daily
Latency for insight based on data delivery time <5 sec