We invite an experienced Database Administrator (DBA) to join our team and diversify our experience. You will be responsible for the database administration & maintenance in all production and pre-production database environments.
About the client:
MGB Inc. operates community and specialty hospitals, a managed care organization, a physician network, community health centers, home care, and other health-related entities in the United States.
The Insight Research Portal — one of the 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.
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;
Responsibilities:
— Troubleshooting — provider tier 2/3 support to identify system issues and resolve them 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.