Database Programmer

Overview

Reporting to the Manager of Application Development, the Database Programmer will be responsible for designing databases from tables to stored procedures and views, and the maintenance of these databases (backup and restore, migrations, etc), creating ETL processes for importing and exporting data, and building reports for our users. They will be carrying out these tasks independently or as part of a project team.

Responsibilities

• Installation, backup, and maintenance of our Microsoft SQL Server databases and servers.
• Implement access controls, encryption, and data-protection measures.
• Maintain compliance with the City of Boston and Boston Police Department legal data security standards.
• SQL programming to provide data feeds to department personnel.
• Stored procedure programming for department personnel and application development efforts.
• Creating, modifying, and maintaining reports using SQL Server Reporting Services.
• Creating, modifying, and maintaining data feeds using SQL Server Integration Services.
• Querying our databases to fulfill custom data requests from the Freedom of Information Act.
• Managing data content on the department portal.
• Performs related work as required.

Minimum Entrance Qualifications

CRIMINAL RECORD CHECK REQUIRED

PRE-EMPLOYMENT DRUG TEST REQUIRED

BOSTON RESIDENCY REQUIRED

Terms :

Union / Salary Plan / Grade : SENA / MM1-6

Hours per week : 35