Apply on Employer Site

City of Boston · 2 weeks ago

Database Programmer

Boston, MA

Full-time

Onsite

Mid Level

3+ years exp

The City of Boston is seeking a Database Programmer who will be responsible for designing and maintaining databases, creating ETL processes, and building reports. This role involves installation, backup, and compliance with legal data security standards while working independently or as part of a project team.

Government

H1B Sponsor Likely

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

Qualification

Microsoft SQL ServerSQL programmingStored proceduresSQL Server Reporting ServicesSQL Server Integration ServicesVBScriptC#Analytical skillsTeamworkCommunication skillsProblem-solvingSelf-motivatedAttention to detail

Required

Applicants must have at least three (3) years of full-time or equivalent part-time paid professional experience in Microsoft SQL Server programming and/or DBA experience

Ability to design and create tables, stored procedures, views, and indexes as a back end to applications developed by the Application Development team

Experience with SQL Server Management Studio and Microsoft Visual Studio

Experience in creating scripts with languages such as VBScript and C#

Basic understanding of software development and the ability to work in a team setting

Self-motivated & self-sufficient

Works well in a team environment

Flexible and can adapt to changing role requirements

Strong communication skills to translate business needs into appropriate data queries

Ability to exercise good judgment and focus on detail as required by the job

Ability to create SSRS reports and SSIS packages, and the ability to deploy and maintain them

Ability to independently learn new technologies and concepts

Strong analytical, problem-solving, and communication skills

Preferred

Bachelor's of Science in Mathematics, Computer Science, Information Management, Statistics, or a related field is preferred

Company

City of Boston

City of Boston is a government agency.

Founded in 1630

Boston, Massachusetts, USA

10001+ employees

https://www.boston.gov/

H1B Sponsorship

City of Boston has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (13)

2024 (8)