What are the responsibilities and job description for the Database Administrator III position at The Jackson Laboratory?
Job Summary
We are seeking a highly skilled and experienced Database Administrator (DBA) to join our dynamic IT team. Reporting to the Manager of IT Data Services and Intelligence, the successful candidate will oversee and maintain our enterprise database infrastructure, focusing on SQL Server and Azure SQL databases. This role ensures database reliability, performance, and security while supporting data warehouse and development initiatives.
This position includes participation in a remote on-call rotation.Periodic travel to a JAX site is expected 3x per year.
What You'll Contribute
Database Administration
- Design, implement, and maintain SQL Server and Azure SQL databases.
- Monitor performance, troubleshoot issues, and optimize queries.
- Manage backup, recovery, and high-availability solutions.
- Perform capacity planning and optimize performance.
- Ensure database security and compliance.
Security and Compliance
- Implement and maintain security policies and procedures.
- Ensure regulatory compliance, including encryption and access controls.
- Conduct regular security assessments and address vulnerabilities.
- Collaborate with IT security to respond to incidents.
Data Warehouse and BI Support
- Manage data warehouses and ETL processes.
- Oversee SSIS and Python solutions for data integration.
- Collaborate with BI teams for reliable data integration.
MS Fabric and Power BI Support
- Administer Power BI datasets, workspaces, and reports.
- Support Microsoft Fabric initiatives.
Data Development and Release Support
- Collaborate with developers on database solutions.
- Guide best practices for database design and data modeling.
- Manage Python environments for ETL and automation tasks.
- Support Python-based workflows and scripts.
- Administer Git repositories and CI/CD pipelines.
- Coordinate release activities to ensure minimal downtime.
What You're Good At
- Bachelor's degree in Computer Science, IT, or related field, or equivalent experience
- 5 years as a SQL Server DBA in enterprise environments.
- Proficiency with SQL Server 2016/2019/2022/Azure SQL Managed Instance.
- Experience with DW/BI tools like SSIS, Power BI, and MS Fabric.
- Proficiency in managing Git repositories and source control workflows.
- Excellent problem-solving and communication skills.
The salary range is $98,885 - $165,554. Salary will be determined based on qualifications and relevant years of experience.
About JAX:
The Jackson Laboratory is an independent, nonprofit biomedical research institution with a National Cancer Institute-designated Cancer Center and nearly 3,000 employees in locations across the United States (Maine, Connecticut, California),Japan andChina. Its mission is to discover precise genomic solutions for disease and empower the global biomedical community in the shared quest to improve human health.
Founded in 1929, JAX applies over nine decades of expertise in genetics to increase understanding of human disease, advancing treatments and cures for cancer, neurological and immune disorders, diabetes, aging and heart disease. It models and interprets genomic complexity, integrates basic research with clinical application, educates current and future scientists, and provides critical data, tools and services to the global biomedical community. For more information, please visitwww.jax.org.
EEO Statement:
The Jackson Laboratory provides equal employment opportunities to all employees and applicants for employment in all job classifications without regard to race, color, religion, age, mental disability, physical disability, medical condition, gender, sexual orientation, genetic information, ancestry, marital status, national origin, veteran status, and other classifications protected by applicable state and local non-discrimination laws.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
Salary : $98,885 - $165,554
