Talent.com
Database Programmer
Database ProgrammerCity of Boston • Boston, MA, United States
[error_messages.no_longer_accepting]
Database Programmer

Database Programmer

City of Boston • Boston, MA, United States
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [job_card.part_time]
[job_card.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

    [job_alerts.create_a_job]

    Programmer • Boston, MA, United States

    [internal_linking.similar_jobs]
    Senior Lead Database Administrator

    Senior Lead Database Administrator

    Lumen Inc • Boston, MA, United States
    [job_card.full_time]
    We are igniting business growth by connecting people, data and applications - quickly, securely, and effortlessly.Together, we are building a culture and company from the people up - committed to t...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Software Architect - Hybrid (Boston) Leading Data Platform

    Software Architect - Hybrid (Boston) Leading Data Platform

    NeedleFinder Recruiting • Boston, Massachusetts, United States
    [job_card.full_time]
    A business intelligence platform in Boston, MA, is seeking a talented Software Architect to lead the software development life cycle (SDLC). The role involves managing developers, overseeing softwar...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Remote Investment Analyst – AI Trainer ($50-$60 / hour)

    Data Annotation • Brockton, Massachusetts
    [filters.remote]
    [job_card.full_time] +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Database Engineer

    Senior Database Engineer

    Ironside • Boston, Massachusetts, United States
    [job_card.full_time]
    Get AI-powered advice on this job and more exclusive features.This range is provided by Ironside.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more...[show_more]
    [last_updated.last_updated_1_hour] • [promoted] • [new]
    Senior Database Engineer

    Senior Database Engineer

    Knack Solutions • Boston, MA, United States
    [job_card.full_time]
    Hybrid - 3 times / month onsite; Any of the offices in : .We areseeking a Senior Database Engineer to assist in implementing software enhancements and providing technical leadership for the team primar...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Test Field Engineer

    Test Field Engineer

    Fuchs Lubricants • Taunton, MA, US
    [job_card.full_time]
    United States operating unit of FUCHS S.We provide high quality lubricants and services to a wide range of industries such as automotive, appliance, aerospace manufacturers, pharmaceuticals, transp...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Oracle PL / SQL Developer

    Oracle PL / SQL Developer

    The Ceres Group • Boston, MA, United States
    [job_card.full_time]
    We are looking for a well-rounded developer with demonstrable experience in PL / SQL.Assist / lead with Oracle EBS R 12 Applications Development. Map technical processes, designs layouts, validates func...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Azure confidential computing (ACC) Engineer - Remote With Travel

    Azure confidential computing (ACC) Engineer - Remote With Travel

    The Dignify Solutions, LLC • Boston, MA, United States
    [filters.remote]
    [job_card.full_time]
    Azure confidential computing (ACC) Engineer - Remote With Travel.Be among the first 25 applicants.Knowledge / Exposure with ACC, ACI, AKS, TEE config(s), Confidential Inferencing.Knowledge of deployi...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Database Support Specialist

    Database Support Specialist

    Kelmar • Wakefield, Massachusetts, United States
    [job_card.full_time]
    The Database Support Specialist position combines strong database and analytical skills to work with the product owner, business team and development staff. The KAPS application utilizes a complex M...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SSBT DataStage Developer

    SSBT DataStage Developer

    CData Software • Boston, MA, United States
    [job_card.full_time]
    Location : Boston, MA Princeton, NJ.Overall 5+ years of Experience and having good exposure to Regulatory Reporting is an added advantage • Should be able to write complex queries, views, procedures...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Architect - Azure Databricks Lakehouse

    Senior Data Architect - Azure Databricks Lakehouse

    Clarus Technology • Boston, MA, United States
    [job_card.full_time]
    A leading pet health technology company is seeking an experienced Data Architect to design scalable data solutions using Azure Databricks. The successful candidate will implement robust data models,...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SQL Database Developer II

    SQL Database Developer II

    Massachusetts School Building Authority • Boston, MA, US
    [job_card.full_time]
    SQL Database Developer 2 .Information Technology .The SQL Database Developer II is responsible for the design, development, testing, implementation and support of Micr...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    SQL DBA / Systems Analyst

    SQL DBA / Systems Analyst

    Contact Government Services, LLC • Boston, MA, US
    [job_card.full_time]
    Employment Type : Full Time, Mid-level.Department : Information Technology.CGS is seeking a SQL DBA / Systems Analyst to join our team supporting a wide-ranging technical support initiative for a lar...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Enterprise Data Architect (Boston)

    Enterprise Data Architect (Boston)

    Applegreen (US) Welcome Centers • Boston, Massachusetts, United States
    [job_card.full_time]
    We are seeking an experienced and strategic.In this role, you will be responsible for designing, implementing, and maintaining our enterprise data architecture to support business objectives, ensur...[show_more]
    [last_updated.last_updated_1_hour] • [promoted] • [new]
    Data Warehouse Developer

    Data Warehouse Developer

    Boston Medical Center (BMC) • Boston, MA, United States
    [job_card.full_time]
    Responsible for delivering enterprise‑level data solutions that empower business partners to provide affordable, high‑quality patient care and services. Engages with business owners and stakeholders...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Database Engineer

    Senior Database Engineer

    Kforce Technology Staffing • Boston, MA, United States
    [job_card.full_time]
    Assist the Quantitative Investment Systems group in testing and deploying internal applications.Code, run and maintain test suites for applications and data quality and validation purposes.Work wit...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SQL Developer

    SQL Developer

    Compunnel • Boston, MA, United States
    [job_card.full_time]
    Direct message the job poster from Compunnel Inc.Design and develop SQL tables, views, stored procedures, functions, and triggers to support reporting, analytics and business logic.Support ETL proc...[show_more]
    [last_updated.last_updated_1_day] • [promoted]
    Application Engineer / SQL / Hybrid / Boston, MA

    Application Engineer / SQL / Hybrid / Boston, MA

    Motion Recruitment Partners LLC • Boston, MA, United States
    [job_card.full_time]
    Application Engineer / SQL / Hybrid / Boston, MA.This is a contract role with a well-established financial services firm in Boston, MA (hybrid). The position supports mission critical investment and...[show_more]
    [last_updated.last_updated_1_day] • [promoted]