Talent.com
City of Boston
Database ProgrammerCity of Boston • Boston, Massachusetts, United States
Database Programmer

Database Programmer

City of Boston • Boston, Massachusetts, United States
30+ days ago
Job type
  • Full-time
  • Part-time
Job description

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:

  • 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.
  • Bachelor's of Science in Mathematics, Computer Science, Information Management, Statistics, or a related field is preferred.
  • 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.

CRIMINAL RECORD CHECK REQUIRED

PRE-EMPLOYMENT DRUG TEST REQUIRED

BOSTON RESIDENCY REQUIRED

Terms:

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

Hours per week: 35

Create a job alert for this search

Database Programmer • Boston, Massachusetts, United States

Similar jobs

Python/SQL Full stack developer (Fixed income Market Data pricing)

Cyber Space Technologies LLCBoston, MA, United States
Full-time

Python/SQL Full stack developer (Fixed income Market Data pricing).Location: Boston (Complete onsite).Interviews will be conducted in person in Boston office.Strong Python/SQL developer with 1-2 ye... Show more

 • Promoted

Remote Senior Mainframe Modernization Consultant

Rocket SoftwareBoston, MA, United States
Remote
Full-time

A technology solutions firm in Boston is seeking a Mainframe Modernization Senior Consultant.Responsibilities include leading technical projects, modernizing applications, and deploying solutions i... Show more

 • Promoted

TAS Analyst

Gray, Gray & GrayCanton, MA, United States
Full-time

Transactional Advisory Analyst.Gray, Gray & Gray is one of New England's fastest growing independent full-service consulting, accounting and advisory firms and we are looking for highly motivated, ... Show more

 • Promoted

Information Technology Professional

US NavyRaynham Center, MA, US
Full-time

Information Technology Professional (IT/CTN/IS).Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specialists keep the Fleet connected, informed, and secure by oper... Show more

 • Promoted

Business Analyst - Business Analyst III

Apex SystemsNorth Reading, MA, United States
Full-time

Support development of dashboards, reporting tools, and AI-enabled process workflows that drive team efficiency and decision-making.Working cross-functionally with product managers, sourcing, plann... Show more

 • Promoted

Quality Analyst

Bossard AmericasRandolph, MA, United States
Full-time

Job Category: Quality Requisition Number: QUALI002114.Full-Time Stoughton, MA 02072, USA.Quality Data, Analysis & Reporting.Collect, analyze, and interpret quality and operational data to identify ... Show more

 • Promoted

Statistical Programmer Consultant (REMOTE)

The Steely GroupCambridge, MA, United States
Remote
Permanent

Job DescriptionJob DescriptionWorking with the Biometrics staff, the Statistical Programmer Consultant provides programming support for Phase 1 to Phase 3 studies, including project integration and... Show more

 • Promoted

Software Architect (Boston)

SHIBoston, MA, United States
Full-time

Since 1989, SHI International Corp.We’ve grown every year since, and today we’re proud to be a $15 billion global provider of IT solutions and services.Over 17,000 organizations worldwide rely on S... Show more

 • Promoted • New!

Senior Software Engineer

SaabNorth Dighton, MA, United States
Full-time

Autonomous and Undersea Systems (AUS) division is seeking an innovative and experienced.Unmanned Surface/Underwater Vehicles (USVs/UUVs/AUVs) and Remotely Operated Vehicles (ROVs).As the successful... Show more

 • Promoted

Azure Data Architect (Boston)

Trinity Technology Solutions LLCBoston, MA, United States
Full-time +1

Technical Recruiter at Trinity IT Solution.In this role, you will be the Lead on designing, implementing, and managing data architecture and cloud-based solutions with Microsoft Azure.Developing an... Show more

 • Promoted • New!

Programmer/Analyst - Remote - LLJP00001834

Softworld IncBoston, MA, United States
Remote
Temporary

Job Title :Programmer / Analyst Job Location :Lexington MA 02420 Onsite Requirements :Remote Experience with Power BI Extracting and importing data via APIs from multiple Data sources Ability to ob... Show more

 • Promoted

Absorb LMS - Remote

Lorven TechnologiesBoston, MA, United States
Remote
Full-time

Our client seeks an Absorb LMS for a Full Time project in Remote.Below is the detailed requirementJob Title :Absorb LMSWork location :RemoteDuration :Full TimeJob Description :Bachelor's degree pre... Show more

 • Promoted

Senior Software Development Engineer (SQL / NoSQL, Scala, Node.js) - Remote

BioLegendBoston, MA, United States
Remote
Part-time

We are looking for a talented Senior Software Development Engineer (SQL / NoSQL, Scala, Node.Signals Software Team, building a product we call the Signals Data Factory.The Signals Data Factory is a... Show more

 • Promoted

Senior Software Engineer (Boston)

XometryBoston, MA, United States
Full-time

Be among the first 25 applicants.Xometry (NASDAQ: XMTR) powers the industries of today and tomorrow by connecting the people with big ideas to the manufacturers who can bring them to life.Xometry’s... Show more

 • Promoted • New!

Sr Programmer Sr Data Scientist/Analyst OMOP (NA & UK Only)

Syneos Health/ inVentiv Health Commercial LLCBoston, MA, US
Full-time

Sr Programmer Sr Data Scientist/Analyst OMOP (NA & UK Only).Syneos Health is a leading fully-integrated life sciences services organization built to accelerate customer success.We partner with inno... Show more

 • Promoted • New!

Remote Software Developer $60 - $120/hourpay

Micro1Middleborough Center, Massachusetts, US
$60.00 hourly
Remote
Full-time

AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowledge across domains such as finance, healthcare, STEM engineering, and more.AI... Show more

 • Promoted

Senior Director, Database Product Strategy (Remote)

Teradata Corporation (SE)Boston, MA, United States
Remote
Full-time

A leading data platform company is seeking a Senior Product Manager to devise strategies and manage the roadmap for its database technologies.The role involves collaboration with cross-functional t... Show more

 • Promoted

Statistical Programmer Consultant (Remote)

Tandym GroupWoburn, MA, United States
Remote
Full-time

A biotech company in California is looking to add a new Statistical Programmer Consultant to its growing team.Responsibilities :Oversee programming activities on multiple projects / studies across ... Show more

 • Promoted

Senior Software Engineer (Boston)

LogRocket, IncBoston, MA, United States
Full-time

Founded in 2016, LogRocket's goal is to make every experience on the web as perfect as possible.We're solving a huge challenge for product managers and developers - understanding the user experienc... Show more

 • Promoted • New!

Senior Software Development Engineer (Scala, SQL / NoSQL, Spark) - Remote

RevvityBoston, MA, United States
Remote
Part-time

Job TitleSenior Software Development Engineer (Scala, SQL / NoSQL, Spark) - RemoteLocation(s)US Remote - MAAbout UsRevvity is a developer and provider of end-to-end solutions designed to help scien... Show more