Position: Middle or Senior MS SQL Database Administrator
Company: NCube
Category: SQL
Experience required: 3y
English level: intermediate

NCube Ltd. opens the position of a Middle/Senior Database Administrator to join the project of our US partner, the leading expert in the healthcare industry within the USA for the last 14 years.
We are looking for data operations engineers to document, improve, maintain, and support the current ETL processes and database infrastructure. The data warehouse consists of a collection of Microsoft SQL databases running on virtual machines hosted in the Microsoft Azure cloud. ETL processes are orchestrated using the Diyotta tools and SQL Server Integration Services to move data from sources to the collection of databases.

Responsibilities:

— Document, maintain and support the current environment of SQL database infrastructure, ETL jobs, and reporting procedures including SQL Server Reporting Services (SSRS). If jobs or reports fail; investigate, troubleshoot, and fix the issue. Work with Client 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 established schedule.

— With support from the onshore data architects, 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 architects with the design and deployment of a modern enterprise data warehouse. The company plans on re-architecting and re-building the data warehouse to use current Azure platform-as-a-service technologies in the future.

Requirements:

— Microsoft SQL database administration in a production environment
— SQL Server Integration Services (SSIS)
— SQL Server Reporting Services (SSRS)
— Experience with ETL processes and tools. Experience with Diyotta is not required.
— Ability to research and “reverse-engineer” an existing data warehouse, document the environment, and design and deploy improvements.
— Experience monitoring and creating alerts and exception handling framework for ETL processes and jobs.
— The willingness to contribute to the research, design, and build of a modern data warehouse using Azure-native services and technologies.
— Upper-Intermediate level of English language

We offer:

— Challenging project
— Competitive remuneration based on qualification and contribution
— Full-Time job (Office in Kyiv, Maidan Nezalezhnosti area or on-remote)
— Flexible working schedule, vacations, paid sick leaves, English courses, regular parties
— Good working environment
— Great team spirit