Database and Azure Cloud System Administrator

JOB SUMMARY:
Maintains and optimizes the Microsoft Azure infrastructure for the DVACO including virtual servers, databases and other cloud based applications that support Operations and Analytics functions for the DVACO. Works with external payers and venders to support monthly claims and roster loads that feed DVACO analytics platform. Maintain and create databases, views, ETL functions and stored procedures in conjunction with Operations and Analytics teams. Works in a DBA development capacity to assist with the integration of new data sets, optimize\automate system functions and assist the analytics team to build foundational layers for Power BI and other applications. Configures, maintains, recovers, and insures the performance of Relational Data Base Management Systems (RDBMS) on multiple database platforms.

Essential Accountabilities:

Azure Cloud

  1. Works with cloud vender and DVACO leadership to develop and strategies and deploy new capabilities that meet DVACO business requirements
  2. Ensures Azure cloud configuration meets MLH IT security policies
  3. Optimizes Azure cloud infrastructure while balancing budgetary considerations
  4. Maintains Azure server infrastructure
  5. Monitors server and application performance
  6. Creates and tests disaster recovery plans
  7. Maintains SFTP endpoints
  8. Monitors Azure Download and Upload performance
  9. Assists the development of appropriate testing methodology and migration paths for implementing changes

RDBMS Administration and Development

  1. Configures, maintains, and insures performance of RDBMS applications
  2. Designs and implements new physical RDBMS structures (i.e., tables, stored procedures and views) to meet business requirements
  3. Analyzes, optimizes and documents any customized RDBMS structures (i.e., tables
    and views)
  4. Insures recoverability of data bases
  5. Diagnoses and resolves RDBMS outages and failures
  6. Documents all configurations in writing

Extract, Transform and Load (ETL) and Automation

  1. Manages data feeds to and from Azure cloud
  2. Transforms and loads data sets into RDBMS structures
  3. Develops validation routines on data sets
  4. Ensures accuracy of loads and extracts
  5. Automates operations within the Azure cloud wherever possible

Primary Customers or Key Working Relationships:

  1. DVACO Operations and DVACO Analytics Staff
  2. External Venders

QUALIFICATIONS:

Education:
Bachelor of Science in Computer Science is preferred.

Experience:
Expertise with the following functions demonstrated by at least (x) years’ experience:

  1. Maintenance, recoverability and performance of MS SQL Server – 3 years
  2. Development and optimization of database tables, stored procedures and views – 4
    years
  3. Development and implementation of ETL and auto scripting capabilities – 2 years
  4. Experience managing Azure or AWS Cloud capabilities – .5 year
  5. DBA Support of software and\or analytics development team – 3 years

Technical Skills\Capabilities:

  • Maintains proficiency and expertise in MS SQL Server Components (Query
    Analyzer, SSRS, SSIS Analysis Server, Stored Procedures, Jobs, and Functions)
  • Practical experience programming in Python or similar tools.
  • Capable of programming in SAS, SQL Query Construction or other programming
    languages.
  • Experience creating and maintaining stored procedures, tables, views, indexes, etc
    that support the software and analytics development
  • Demonstrates strong mathematical, statistical, financial, technical, interpersonal,
    organizational, project management skills, and ability to maintain confidentiality.
  • Evidence of independent analytical and problem solving skills.
  • Exceptional time management and organizational skills.
  • Ability to effectively handle numerous priorities simultaneously.

WORKING CONDITIONS:
This position requires the ability to handle multiple tasks simultaneously, remain effective
under stress, and work hours outside the range of the regular schedule.


We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 59501

We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture.

Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls