Talent.com
City of Boston
Database ProgrammerCity of Boston • Boston, Massachusetts, United States
No longer accepting applications
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

Senior Database Administrator

Contact Government ServicesBoston, MA, United States
Full-time

Employment Type: Full-Time, Mid Level.Contact Government Services is seeking a Senior Database Administrator to assist with administering all aspects of Microsoft SQL Server.CGS brings motivated, h... 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

DOTNET Developer + SQL

Syntricate TechnologiesBoston, MA, United States
Full-time

SQL Location: Boston, MA (Onsite) Duration: Full Time.SQL + DOTNET Developer work experience in.SQL server for 6+ years Work with cross-functional teams to understand Data models Data analysis and ... Show more

 • Promoted

Software Engineer (GCP/ Python/ Big Query)

DamcoNorth Andover, MA, United States
Full-time

We are seeking a highly skilled professional with expertise in Google Cloud Platform (GCP), App Engine, Data Store, Python, and BigQuery.The candidate will take ownership of an existing application... 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

Bad gatewayError code 502

FSC, IncBoston, MA, United States
Full-time

The web server reported a bad gateway error.Please try again in a few minutes.Cloudflare Ray ID: a1a81b124e98ff01 Performance & security by Cloudflare. Show more

 • Promoted

Medical Billing and Coding - Entry Level Training Program

Dreambound Inc.Beverly, Massachusetts, US
Full-time

Note : This is an educational program, not a job.Successful completion of the program does not guarantee employment but will equip you with valuable skills for the healthcare job market.Looking to ... Show more

 • Promoted

Bindery Specialist

JLS Mailing ServicesBrockton, MA, United States
Full-time

We provide a comprehensive suite of services to some of the most prestigious companies in the Northeast- from data processing and the development of both digital and paper mail communications right... Show more

 • Promoted

Board Certified Behavior Analyst BCBA

Behavioral ConceptsLawrence, MA, United States
Full-time +1

BCI is hiring a Board Certified Behavior Analyst (BCBA) to join them in providing high-quality, evidence-based, contemporary ABA therapy to children with autism.Our clinicians are committed to deli... Show more

 • Promoted

CI/CD Role -Boston,MA

StaffingBoston, MA, United States
Full-time

Job Description: Experience with continuous integration tools (Jenkins).Experience with continuous delivery/devops practices and unit test automations.Experience in J2ee appserver configurations (t... 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

Information Technology Professional

US NavyNorth Lakeville, 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

Remote Software Developer $60 - $120/hourpay

Micro1Middleborough Center, Massachusetts, US
$60.00–$120.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

PL/SQL Developer

RIT SolutionsBoston, MA, United States
Full-time

Oracle PL/SQL Developer | MedImpact.Location: San Diego, CA hybrid work so must sit in San Diego, CA.PL/SQL development specifically Oracle.Work experience with Stored Procedures, Functions, Pack... Show more

 • Promoted

Senior Business Analyst - Greater Boston, MA

Georgia IT, Inc.Boston, MA, United States
Full-time

US citizens, GC, EAD (H4, L2), E3 TN visa holders preferred, NO third party corp to corp accepted for this job.Bachelor's degree is required preferably in an analytical field (computer science, sta... Show more

 • Promoted

Java Developer

KaavBoston, MA, United States
Full-time

Boston, MA (Locals or nearby states).Need 8+ years of experience candidate, OPT also works.Note- Visa independent only, H1B transfer wont be work, pls use above grid for all my submissions.Skills -... Show more

 • Promoted

Records Coordinator

Careers Integrated Resources IncAndover, MA, United States
Full-time

Provide records coordination support for the process monitoring and Informatics team.Major responsibility includes tracking entry and verification of batch records across three manufacturing suites... Show more

 • Promoted

Python/SQL Developer - Remote

SynergisticITBoston, MA, United States
Remote
Full-time

Job Opportunities at Synergisticit.Almost 390,000 tech employees have been laid off since 2022 and it's still ongoing.The effect of this has led hundreds of thousands of laid off tech employees com... 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