Apply Now

ZipRecruiter
Posted on

Database Administrator

U.S. Medical Management in Troy, MI, USA

Database Administrator

U.S. Medical Management (USMM) is an affiliate of a leading Fortune 100 company. A national organization built on a continuum of care with premier healthcare providers, clinicians and patient focused individuals working together. Our Mission – “Through Compassionate Patient-Centered Care in the Home; We will Provide Exceptional Outcomes across our Continuum of Services” – Visiting Physicians Association, Pinnacle Senior Care, Grace Hospice, Comfort Hospice, Home DME & our In Home Health Assessments (IHA).

Our Values of Integrity, Respect, Teamwork & Excellence are leading us to a better tomorrow for patient care. Our Purposes Centered on “We are Unified in our Work through our Continuum of Services” “We can Find Comfort that We are Making a Difference for our Patients” & “We make a Broader Positive Impact on Society”, allows USMM to be poised for a phenomenal future.

We are seeking candidates who desire the experience of delivering quality & compassionate healthcare within proven care models with patients at the forefront of everything we do.

 

Position Description

The Database Administrator is responsible for designing and maintaining complex and large-scale database environments for new and existing applications. Responsibilities will also include partnering with infrastructure for patching, moving databases, backup & restore, provisioning, retiring, or otherwise maintaining the database environments.

The DBA will participate in establishing rules, standards, specifications, and nomenclature with regard to database development and design. In addition, the Database Administrator will have to build a vast understanding of the company’s databases, schemas, tables, stored procedures and other objects contained within for quick and easy locating of the data elements as needed. Participation in deployments, query optimization, and troubleshooting processes as needed.

 

Essential Duties and Responsibilities

  • Administers SQL Server databases
  • Database replication, back-ups, and restoration
  • Participates in database design
  • Develops and maintains database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.)
  • Writes scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers
  • Supports and troubleshoots issues
  • Mentors and supports developers at all levels of the database development team
  • Additional duties as assigned

REQUIRED Knowledge, Skills, and Experience

  • College degree (or equivalent experience) in Applicable Technology
  • 5+ years of experience using SQL Server (development and DBA roles), SSRS, and SSIS
  • Analytic ability
  • Working knowledge of software versioning and revision control systems, preferably SVN
  • Strong communication skills
  • Motivated and positive attitude

Preferred Knowledge, Skills, and Experience

  • Healthcare data and regulations
  • GIT source code repository
  • Jira
  • Health Catalyst EDW
  • QlikView