Allscripts

  • Associate Database Administrator (SQL)

    Job Locations US-NC-Raleigh
    Requisition ID
    2018-18717
    Posted Date
    14 hours ago(1/16/2019 9:52 AM)
    Category
    Client Service/Support
  • Overview

    home-header-logo

     

    Welcome to Allscripts!  Our Mission is to be the most trusted provider of innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. Our Vision is a Connected Community of Health that spans continents and borders. With the largest community of clients in healthcare, Allscripts is able to deliver an integrated platform of clinical, financial, connectivity and information solutions to facilitate enhanced collaboration and exchange of critical patient information.

     

    The primary purpose of this role is to install, design, implement, upgrade, and optimize the performance of databases required to operate Allscripts software solutions.

    Responsibilities

    • Ensure the technical integrity and performance for SQL Server DBMS in support of business intelligence reporting and multiple data driven projects within the CDO Reporting and Analytics organization.
    • Develop and manage sustainable ETL processes both in and out of SQL Server based data warehouses and data marts.
    • Ensure and manage data, password, user security and privacy.
    • Work towards becoming the DBMS technical process owner in support of the CDO Reporting and Analytics organization.
    • Work towards influencing process maturation and standards for data management within the CDO Reporting and Analytics organization.
    • Ability to estimate self-effort and agree on task schedules across multiple teams and priorities.
    • Provide timely input when schedules, tasks or delivery dates conflict.
    • Contribute to a team oriented, supportive, customer focused, continuous improvement environment.
    • Creates and maintains appropriate documentation (Database, Architecture, etc.)
    • Analyzes and diagnoses problems, escalates issues appropriately and proposes solutions
    • Discusses issues/requirements with internal/external team members
    • Works with the team in data modelling and database design of reports and dashboards and efficient SQL.
    • Researches and identifies third party tools / software that improves team/customer experiences
    • Installs, configures and updates database system software plus third-party system tools, applications and products
    • Conducts DBMS performance monitoring, optimization, measurement and capacity planning of solutions, recommending changes and standardized System configurations
    • Implements, periodically tests and reviews appropriate data access and security measures, including access control, audit, backup/restore and system rebuild & recovery processes
    • Implements and continuously improves the database infrastructure environment
    • Provides fast and value-added services to the CDO Reporting and Analytics organization
    • Participate in the process of ensuring that identified Business Continuity measures (KPI) are implemented, documented and regularly tested to enable continued operations. 
    • Stays current with the DB technology.
    • Performs software upgrades and new software installation both pro-actively and in response to requests from users of systems, including any necessary patches to database systems and applications to ensure continuing stable and secure operation
    • Provides an ad-hoc support service to users of all computer systems, troubleshooting and resolving problems
    • Pro-actively seeks and acquires technical training, vocational training and market and product awareness such that skills remain current, relevant and valued within Allscripts
    • Accurately estimates effort for self and agree schedules with manager
    • Liaise with manager and team; keeps manager informed of progress.
    • Implement Backup and Recovery Plan 

    Qualifications

    Academic and professional qualifications:

    • Bachelors Degree or relevant database experience
    • Certifications: SQL DBA or analogous.
    • Good experience in writing SQL stored procedures in MS SQL Server.
    • Good experience in developing reports using MS SQL Server Reporting Services (SSRS).

    Optional:

    • Experience with SQL Server Integration Services (SSIS) or other ETL tools.
    • Experience with SQL Server Analysis Services (SSAS).
    • Experience with PowerBI or other Business Intelligence software
    • Experience with MS Access
    • Thorough Knowledge of SQL 
    • Understanding of Popular Database Management Software (SQL and MySQL)
    • Understanding of database architectural structures such as STAR or Snowflake as well as data layering.

     

    Experience:

    • 0-2 years of experience

    Travel Requirements:

    • Dependent upon project / program needs

    Working Arrangements:

    • Hours required to complete projects / assignments

    At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 post-acute organizations across the globe. Allscripts offers a comprehensive compensation and benefits package, including holidays, vacation, medical, dental, and vision insurance, company paid life insurance and retirement savings.

     

    Allscripts policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire.

     

    From a "VEVRAA Federal Contractor" We request Priority Referral of Protected Veterans

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with Allscripts for future communications and career opportunities.