SQL Server Developer

March 1, 2019

NOTE: This job listing has expired and may no longer be relevant!

Job Description

Cambridge, MA

Harvard University

SQL Server Developer
Harvard Graduate School of Education

Duties & Responsibilities
Center for Education Policy Research (CEPR) at Harvard University is looking for a MS SQL Server Developer/DBA to perform technical implementation and database maintenance of SQL Server database systems, used to ingest and integrate education data from external sources to support data-driven decision-making. Responsibilities of this position include configuring, monitoring and maintaining SQL server environments, as well as database tuning and optimization. Additionally, the SQL Server Developer/DBA will work closely with CEPR Data Management team and research analysts and design and develop efficient processes to extract, transform, and load (ETL) data between systems using SQL Server Integration Services (SSIS), stored procedures, and related scripting. She/He will also provide production support to regular data loading and will configure and monitor batch processes using SQL Server utilities or third-party auto-scheduling tools.
• Design and implement ETL solutions using SQL Server Integration Services (SSIS), stored procedures, and functions.
• Configure and monitor SQL Server systems and proactively address issues to ensure optimum performance. Maintain database integrity, stability and availability.
• Define, implement and monitor database access control policies and procedures to ensure data security in compliance to regulations and contractual terms. Define and maintain data quality assurance metrics and perform database auditing.
• Administer SQL Server Reporting Services (SSRS) including scheduling, integration and user access management.
• Schedule and monitor data processing jobs and provide troubleshooting in timely fashion.
• Create and maintain documentation related to ETL processes and database procedures.
• Research and evaluate new tools and technologies to improve efficiency and better support growing data processing needs.
• Monitor, maintain and deploy multiple databases and implement automated database processes.
• Manage regular database backup and on-demand recovery.

This is a one year term position with the possibility of continuation.

Basic Qualifications

• Bachelor’s degree in computer science or related fields.
• 3+ year experience of development and administration of Microsoft SQL server 2008/2012 R2 with minimum of 1 year experience as Database Administrator (DBA).
• Prior experience writing and debugging SQL codes (stored procedures, functions, views, triggers and maintenance scripts).
• Experience troubleshooting and resolving database integrity issues and performance bottlenecks.
• Experienced in database security, backup and recovery.
• Hands-on experience of MS SQL SSIS and SSRS development and system configuration.
• Extensive experience in performance tuning, query optimization using SQL Server utilities, scripting, or other related tools.
• Working knowledge of Microsoft PowerShell.
• Experience in production support, change control and automation.
• Coverletter is required of all applicants

Additional Qualifications

• Strong communication, problem solving, and analytical skills.
• Prior development experience in a data warehousing environment.
• Experience in database migration and upgrade.
• Experience with database resource planning.
• Ability to work independently and flexibly with sound judgement and attention to details.
• Knowledge of FERPA regulations and related data security best practices.

Additional Information
Please attach resume and cover letter as one document.

We regret that the Harvard Graduate School of Education does not provide Visa sponsorship.

About the Harvard Graduate School of Education
Many choose to work at the Harvard Graduate School of Education because they believe in our mission and are excited by our vision for the future. We have a reputation as a great place to work, for our excellent leadership, and we are a strong community which values diversity. For more information about HGSE, its programs, research, and faculty, please visit: www.gse.harvard.edu

Job Function
Information Technology

Sub Unit

USA – MA – Cambridge


Time Status

00 – Non Union, Exempt or Temporary

Salary Grade

Pre-Employment Screening
Education, Identity

Mon to Fri 7hrs/day

EEO Statement
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation or any other characteristic protected by law.

Apply Here: http://www.Click2Apply.net/gstktn36f62n2wqy


How to Apply

Apply Online

Apply for this Job