Position: Database Administrator
Company: Proxet
Category: SQL
Experience required: 2y
English level: intermediate

Skills & Experience:

— Excellent knowledge of MS SQL Server and relational database concepts;
— Expert knowledge of T-SQL;
— 3-4 years of practical work with SQL Server 2016;
— Experience in ETL processes design and implementation;
— Experience with SSIS;
— Experience in day-to-day communication with English speaking customers;
— Readiness to work in PST time zone (Kiev: 02: PM — 23 РM).

Будет плюсом
— Experience with migration to Azure;
— Experience with Azure SQL Managed Instance;
— Experience in the development of complex stored procedures for SQL Server;
— Good understanding and practical knowledge of optimization queries, procedures and index tuning for SQL Server;
— Experience in ETL processes design and implementation Azure Data Factory;
— In-depth understanding of ETL processes design and implementation;
— Telegraf + Grafana;
— Azure DevOps;
— PowerShell;
— JSON.

Предлагаем
— Challenging work in an international professional environment;
— The long-standing team as this is for a long term project;
— Competitive salary;
— Flexible work-from-home & remote work policy;
— Mastering the English language with a native speaker;
— 40-hour work week with flexible working hours;
— PE accounting and support;
— 20 paid vacation days per year;
— 14 paid sick days per year;
— Collaborative friendly team environment;
— Cozy fully equipped office space in the city center.

Обязанности
— Troubleshooting — provider tier 2/3 support to identify system issues and resolve in real time;
— Perform database administration/maintenance on all production and pre-production database environments;
— Query optimization;
— Index tuning/maintenance;
— High-Availability (Log Shipping, Always-On);
— Backup / Restore;
— Research and develop new technologies and approaches for building highly available data persistence systems.

О проекте
MGB, Inc. operates community and specialty hospitals, a managed care organization, a physician network, community health centers, and home care and other health-related entities in the United States. The Insight Research Portal — one of internal products of Partners Healthcare — is a web based application with over 10,000 current users developed for the entire research community to review, monitor and manage Partners’ research portfolio. The main goal of Insight is to unite distributed and complex organizational processes into one application and help alleviate administrative burdens.