Lead Database Developer
Job posting number: #7089284
Posted: November 16, 2021
Application Deadline: Open Until Filled
Job DescriptionJob-Specific Responsibilities
Harvard Medical School nurtures a diverse group of leaders and future leaders in both clinical care and biomedical inquiry who are on the front lines of medicine and science serving individuals and populations locally, nationally, and globally. The Information Technology Department at Harvard Medical School enables this mission by delivering secure and scalable services.
We are expanding our team. We are looking for a passionate Database Developer with diverse experience in database development and administration. The position requires you to be a self-starter and work in a small, focused team that will be responsible for architecting, designing, building, scaling, and supporting RDBMS platforms in on-prem and cloud environments. You will work collaboratively with Data Architecture, DevOps, Infrastructure, and Engineering teams to deliver solutions that support our mission.
Job Specific Responsibilities:
Apply depth of knowledge and experience to enable buildout of secure database environments for our cutting-edge research endeavors.
Bring both relational and non-relational skills to help us design, build and maintain our data stores on-premises and in the cloud (AWS/Azure)
Develop databases (schema, structures, views, stored procs)
Manage our AWS RDS, MySQL, MariaDB, SQL Server and PostgreSQL databases
Conquer the day-to-day operational aspects of our systems:
Cloud instance/storage design, provisioning, and performance monitoring (Database PaaS)
On-prem to cloud migrations
Ensure the continuous availability of our mission critical systems.
Automate routine tasks with scripts and open source tools.
Typical Core Duties
Lead aspects of data management services which may include database and analytics platform research and design, database performance and optimization, recovery/load strategy and implementation, and data modeling
Collaborate to prepare data verification and testing methods for data/applications loaded into the warehouse, or other data repositories, to ensure compatibility across different sources
Code, develop, and document complex scripts integration mappings and workflows, and stored procedures
Provide technical expertise and direction in developing and supporting system level programs
Troubleshoot advanced data problems and recommend appropriate action
Create new or enhanced components of data architecture and interfaces
Collaborate with business partners to determine needs and evaluate solutions
Provide training to clients and staff
May function as subject matter expert or project lead
Actively contribute to formulation of plans and policies
Abide by and follow the Harvard University IT technical standards, policies and Code of Conduct
Minimum of five years’ post-secondary education or relevant work experience
Additional Qualifications and Skills
Knowledge of information technology applications, processes, software, and equipment
Advanced knowledge of ETL (Extraction, Transformation, and Loading), reporting and database technologies
Advanced communication, technical, and project management skills
Demonstrated team performance skills, service mindset approach, and the ability to act as a trusted advisor
Bachelor's Degree or equivalent experience in Information Technology, Computer Science, or other related discipline preferred
7+ years of solid experience with designing, implementing, supporting, and scaling up database environments.
Experience with a variety of database platforms such as SQL Server, PostgreSQL, MariaDB, MySQL.
Experience working with database services offered by cloud vendors (Azure and AWS) in PaaS configuration including designing, provisioning, sizing, and implementation.
Proficiency with complex SQL
Strong experience in optimizing and tuning databases
Experience with large, high volume, mission-critical environments
Experience with agile scrum and Kanban methodologies. What you will need to be successful:
Demonstrated self-starter who can operate independently without supervision and ability to “ramp up” quickly in both technology and business processes
Works inter-dependently toward enterprise goals and objectives by deep collaboration with the community
Thrive in a rapid-paced environment and love new challenges, blending big picture with attention to detail
Passion for solving business data problems.
This Staff role may start as a remote position due to the COVID-19 pandemic and while restrictions are still in place. The current remote nature of this role is considered temporary and may change as the University continues to evaluate options. While we continue to monitor the evolving COVID-19 guidelines, local on-campus work may be expected for some roles. Harvard Medical School does support flexible schedules, subject to individual departments’ business needs.
Harvard will require COVID vaccination for all Harvard community members who will have any on-campus presence. Individuals may claim exemption from the vaccine requirement for medical or religious reasons. More information regarding the University’s COVID vaccination requirement and exceptions may be found at the University’s “COVID-19 Vaccine Information” webpage: http://www.harvard.edu/coronavirus/covid-19-vaccine-information/.
Please note that we are currently conducting a majority of interviews and onboarding remotely and virtually. We appreciate your understanding.
We are committed to cultivating an inclusive workplace culture of faculty, staff, and students with diverse backgrounds, styles, abilities, and motivations. We appreciate and leverage the capabilities, insights, and ideas of all individuals. Harvard Medical School Mission and Community Values
Harvard University offers an outstanding benefits package including:
Time Off: 3 - 4 weeks paid vacation, paid holiday break, 12 paid sick days, 12.5 paid holidays, and 3 paid personal days per year.
Medical/Dental/Vision: We offer a variety of excellent medical plans, dental & vision plans, all coverage begins as of your start date.
Retirement: University-funded retirement plan with full vesting after 3 years of service.
Tuition Assistance Program: Competitive tuition assistance program, incredibly affordable classes directly at the Harvard Extension School, and discounted options through participating Harvard grad schools.
Transportation: Harvard offers a 50% discounted MBTA pass as well as additional options to assist employees in their daily commute.
Wellness options: Harvard offers programs and classes at little or no cost, including stress management, massages, nutrition, meditation, and complementary health services.
Harvard access to athletic facilities, libraries, campus events, and many discounts throughout metro Boston.
The Harvard Medical School is not able to provide visa sponsorship for this position.
Harvard Medical School strives to cultivate an environment that promotes inclusiveness and collaboration among students, faculty and staff and to create new avenues for discussion that will advance our shared mission to improve the health of people throughout the world.