Position: Database Administrator
Company: Proxet
Category: SQL
Experience required: 3y
English level: upper

Required skills

Job Summary:

We are inviting an experienced Database Administrator (DBA) to join our team and diversify our experience. You will be responsible for the database administration & maintenance on all production and pre-production database environments

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)

Additional requirements (nice to have):

— 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

We offer

— 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 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

Responsibilities

— 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

Project description

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.