• Senior SQL Server Developer

    Job Locations US-NC-Raleigh | US-VT-Burlington | US-IL-Chicago
    Requisition ID
    Posted Date
    3 weeks ago(3/29/2018 10:55 AM)
    Software Development
  • Overview



    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 worldclass 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.


    • Estimates effort for self and agree on schedules with Project Manager
    • Creates and maintains appropriate documentation (Database, Architecture, etc.)
    • Analyzes and diagnoses problems reported to the help desk, escalate support issues
    • Discusses issues/requirements with client
    • Works with the development teams in the data modelling and database design of product and efficient SQL for fast application performance
    • Effectively supports Sales, BSG and Professional Services
    • Researches and identifies third party tools / software that improves development process
    • Installs and configures database system software plus third-party system tools, applications and products
    • Performance Optimization
    • Performance monitoring, measurement and capacity planning of Production Software solutions, recommending changes to Allscripts products 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 development organization
    • Participates in the process of ensuring that identified Business Continuity measures are implemented, documented and regularly tested to enable continue operations of systems identified as requiring such protection in accordance with the corporate Disaster Recovery program
    • 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 database problems
    • Carries out prescribed programs of computer system performance management and capacity planning for systems as designated by Management to ensure the necessary system capacity and performance is available as required
    • 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 agrees schedules with manager
    • Liaise with manager; keeps manager informed of progress
    • Trains, coaches, and mentors junior team members
    • Helps recruit to build the organization with the right talent


    Academic and Professional Qualifications:

    •  Successful completion of a Bachelor's Degree or relevant database experience


    • 4 - 8 years of relevant SQL Server database development experience
    • Experience with SQL Server, preferably including SQL Server 2014 or later
    • Ability to produce production-quality T-SQL code complete with internal documentation
    • Ability to quickly analyze existing T-SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.
    • Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, and debugging techniques
    • Familiar with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
    • Solid teamwork and interpersonal skills; ability to work well on cross-functional project teams and foster team commitment to tasks
    • Clinical (Health Care) knowledge and/or knowledge of Allscripts applications (Touchworks , Pro, or PM) is preferred.
    • Experience with full application development life cycle
    • Experience with Powershell, SSRS, Windows and SQL Clustering, monitoring using SQL Extended Events, and TFS
    • Knowledge of C# / front end coding / web service / IIS / Azure knowledge
    • Ability to work effectively with team members with little supervision
    • Interest and ability to learn new technologies, a tireless appetite for learning new things

    Travel Requirements:

    •  May require 10-20% domestic and some international travel is possible

    Working Arrangements:

    • Work is performed in a standard office environment with minimal exposure to health or safety hazards


    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


    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.