Database engineer [h1.location_city]

Formed in 1974, Harvard Management Company (“HMC”) manages Harvard University's endowment and related financial assets. Our singular mission is to help ensure Harvard University has the financial resources to maintain and expand its leadership in teaching, learning, and research for future generations. The endowment is managed by a highly experienced generalist investment team whose members each take ownership of the entire portfolio, regardless of asset class. HMC's operational structure brings a wide range of expertise to our portfolio management. These functions include legal, compliance, finance and accounting, human resources and administrative services as well as information technology to develop and implement the systems necessary to support our investment activities.

Summary :

We are seeking a skilled and motivated Database Engineer to join our dynamic team. The ideal candidate will be able to implement robust data models, relational database schemas, and data warehouses. They should possess a working knowledge with data modeling, RDMS, and data warehousing, along with extensive experience in creating and optimizing database structures and stored procedures using T-SQL. Proficiency in working with Azure services, particularly Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage, is essential for this role.

Summary of Responsibilities :

• Design and implement robust data models, relational database schemas, and data warehouses.
• Utilize Azure Data Lakes and Data Warehouses to develop modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes.
• Implement end-to-end database solution development lifecycle, including data modeling, data flow design, ETL processes, and database schema design.
• Develop and deploy complex stored procedures, tables, views, functions, triggers, indexes, constraints, and sequences using T-SQL.
• Utilize Azure services for data-related tasks, including data ingestion, processing, and storage.
• Collaborate with developers to provide necessary database support and guidance for their projects.
• Work closely with other data engineers, data scientists, and other teams to ensure seamless integration of data sources and enable advanced analytics and reporting capabilities.
• Conduct comprehensive database reviews for development projects, ensuring adherence to standards and best practices.
• Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014 / 2017 / 2019).
• Design and implement data security and access controls to ensure data integrity and compliance with industry regulations.
• Optimize database performance by fine-tuning queries, indexes, and configurations, and proactively monitor and address performance bottlenecks.
• Work with the system engineers to recommend and implement disaster recovery and backup strategies to ensure high availability and data resiliency.
• Stay up-to-date with the latest advancements in Azure Cloud database tools and recommend appropriate enhancements or migrations to improve the overall database architecture.

Qualifications :

Base Salary Range : $140,000 - $180,000

The range provided is based on what we believe is a reasonable estimate for the base salary range for this job at the time of posting. This role is also eligible for an annual bonus. Actual base salary will be based on several factors, including skills, competencies, experience, and other job-related factors permitted by law.

Other Details :

Required Skills

Required Experience