Overview
Job Description:
Responsibilities
The Database Manager will be responsible for the day-to-day monitoring, maintenance and optimization of the Vital Records cloud-based data warehouse. The incumbent will ensure the availability, security and accuracy of the sensitive vital records data. The incumbent will configure warehouses and databases to meet specific project or Bureau requirements and ensure optimal configuration settings for performance and cost-efficiency. The incumbent will also analyze and monitor the data warehouse environment and execute performance tuning strategies to optimize query execution and resource utilization. The incumbent will contribute to implementing and handling security measures, including encryption, access controls using network policies to protect sensitive information. The incumbent will be responsible for activities related to data storage, including data loading, transformation and extraction processes. The incumbent will document database schemas, configurations and procedures. The incumbent will also manage user accounts, roles and access privileges to ensure secure and appropriate access to the database. Lastly, the incumbent will collaborate with software engineers, analysts and IT team to support data-related activities.
Minimum Qualifications
Bachelor’s degree in a related field and three years of database management experience or closely related experience; OR an Associate’s degree in a related field and five years of such experience; OR seven years of such experience. A Master’s degree in a related field may substitute for one year of such experience.
Preferred Qualifications
Strong understanding of Snowflake’s architecture, including four years’ experience with virtual warehouses, databases, roles, and security features. Four years’ experience in SQL and Python for querying and managing databases. Skills in query performance tuning and resource optimization in a cloud environment. Knowledge of best practices in data security within cloud environments. Demonstrated ability to troubleshoot and resolve database issues efficiently.
Conditions of Employment
Grant funded position. Compliance with funding requirements such as time and effort reporting, grant deliverables, and contract deliverables, is required.
Valid and unrestricted authorization to work in the U.S. is required. Visa sponsorship is not available for this position.
Travel up to 10% of the time will be required.
The selected candidate must reside within a reasonable commuting distance of the official work location specified in the job posting and must also be located in or willing to relocate to one of the following states: New York, New Jersey, Connecticut, Vermont, or Massachusetts, prior to hire. Telecommuting may be available on a limited basis.
HRI participates in the E-Verify Program.
Affirmative Action/Equal Opportunity Employer/Qualified Individuals with Disabilities/Qualified Protected Veterans
www.healthresearch.org
About Health Research, Inc.
Join us in our mission to make a difference in public health and advance scientific research! At Health Research, Inc. (HRI), your work will contribute to meaningful change and innovation in the communities we serve! At HRI, we are on a mission to transform the health and well-being of the people of New York State through innovative partnerships and cutting-edge public health initiatives. As a dynamic non-profit organization, HRI plays a crucial role in advancing the strategic goals of the New York State Department of Health (DOH), Roswell Park Comprehensive Cancer Center (RPCCC), and other health-related entities.
HRI offers a robust, comprehensive benefits package to eligible employees, including:
o Health, dental and vision insurance – Several comprehensive health insurance plans to choose from;
o Flexible benefit accounts – Medical, dependent care, adoption assistance, parking and transit;
o Generous paid time off – Paid federal and state holidays, paid sick, vacation and personal leave;
o Tuition support – Assistance is available for individuals pursuing educational or training opportunities;
o Retirement Benefits – HRI is a participating employer in the New York State and Local Retirement System and offers optional enrollment in the New York State Deferred Compensation Plan. HRI provides a postretirement Health Benefits Plan for qualified retirees to use towards health insurance premiums and eligible medical expenses;
o Employee Assistance Program – Provides educational and wellness programs, training, and 24/7 confidential services to assist employees, both personally and professionally;
o And so much more!
About Health Research, Inc.
Health Research, Inc. (HRI) contributes to the health and well-being of the people of New York State by complementing and enabling the strategic public health goals of the New York State Department of Health (DOH), Roswell Park Cancer Institute Corporation (RPCIC), and other health-related entities.
HRI provides best-in-class resource administration for stakeholders and programs related to the work and priorities of the Department of Health and its other partners. HRI does this through the provision of knowledge, expertise, funding guidance, and fiduciary oversight of sponsored program funding for public health and research programs in concert with community partnerships.
