• Senior SQL Server Database Admnistrator

    Location US-NY-New York
    Posted Date 2 weeks ago(7/11/2018 9:39 AM)
    Job ID
    2018-10094
    Category
    Information Technology - All Openings
    Emp Status
    Regular Full-Time
    Hours per Week
    35
    Shift
    Days
  • Overview

    Senior SQL Server Database Administrator

    At Hospital for Special Surgery our clinicians and scientists collaborate to deliver the most innovative care. Our specialized focus on orthopedics and rheumatology enables us to help patients get back to what they need and love to do reliably and efficiently. Our patients are overwhelmingly satisfied with the care they receive at our facilities. When you join us, you will become part of this legacy of commitment to the most cutting-edge research and coordinated care.

    The Senior SQL Server Database Administrator will be responsible for the implementation, security and maintenance of our analytics SQL server environments. The ideal candidate must be passionate about the field of analytics and well versed in all aspects of an enterprise-wide analytics architecture. The database administrator will work closely with the Infrastructure and Server teams and support and collaborate with our data engineers, researchers, report writers and data analysts.

    Responsibilities

    • Install, secure, upgrade and maintain the Data Analytics SQL Server environments
    • Lead performance analysis and database tuning
    • Implement access control configuration
    • Assist with High Availability and Disaster Recovery implementation
    • Perform resource allocation and monitoring
    • Help with modeling and table design of new data sources
    • Manage indexing and SQL optimization
    • Assist in ETL deployment and maintenance
    • Educate on best practices
    • Assist in processes and procedures development and implementation
    • Assist in resolution of production problems and root cause analyses

    Technical Qualifications and Experience

    • 5+ years administrating SQL Server 2008, 2012 and 2014
    • 1+ year experience with SQL Server 2016
    • 5+ years managing 500Gb to multi terabytes data warehouses
    • 5+ years’ experience and expert level in T-SQL scripting and optimization techniques
    • 3+ years’ experience and strong knowledge in PowerShell scripting
    • 3+ years’ experience in SQL Server Integration Services
    • Experience with monitoring tools such as SQL Server Profiler, SQL Sentry and Red Gate tools required
    • Experience with Resource Governor required
    • Experience with mirroring and clustering a big plus
    • Knowledge of a programming language such as Python, C# or Java a plus
    • Experience with Azure a plus
    • Experience in healthcare a plus

    Elements of success

    • Passionate about data
    • Enjoy learning and exploring new technologies (noSQL, Hadoop and Cloud)
    • Problem solver and critical thinker
    • Team player, committed to improving quality and service and maintaining a spirit of cooperation and respect

    Education and Certifications

    • Master’s degree or bachelor’s degree in computer science
    • MCDBA track certification

     

    Other Requirements

    #LI-JL1

    Options

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