Senior Database Engineer - San Francisco, United States - Hummingbirds Innovations

    Hummingbirds Innovations
    Hummingbirds Innovations San Francisco, United States

    1 month ago

    Default job background
    Description
    This requirement is for a San Francisco Bay Area resident only:

    Senior Database Developer/Engineer

    This position will provide Clinical data solutions for Healthcare informatics efforts. We are looking for a highly motivated professional with strong organizational, analytical, and problem-solving skills.

    Responsibilities
    • Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
    • Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
    • Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering data driven solutions.
    • Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment
    • Provide solutions to promote data integrity in enterprise systems.
    • Participate in code reviews to validate effectiveness and quality of code.
    • Liaise with developers to improve applications and establish best practices
    • Publish documentation and collaborative information using internal tools.
    Requirements

    Requirements:
    • Expertise in Database Architecture in an environment that handles large volume of data, excess of 500 million of new data records every day.
    • Strong analytical and organizational skills. This job involves analyzing existing databases and the client's needs to develop effective data driven solutions.
    • Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
    • Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures
    • Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
    • Hands-on development experience in SQL Server 2016 or above using SSIS and SSRS
    • Experience in troubleshooting and resolving data related issues.
    • Excellent oral and written communication skills
    • Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies
    Nice to have:
    • Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.
    • Performance tuning experience using 3rd party tools
    • Audit/compliance experience in highly regulated environment.
    • Experience using Jira & Confluence as part of development life cycle
    • Experience with Business Intelligence tools like Tableau, SSRS, Power BI etc.
    • Familiar with Continual Improvement processes
    • Familiar with Git