SQL Database Developer II at Massschoolbuildings

Massschoolbuildings logo
Massschoolbuildings

SQL Database Developer II

us flag
United States

Hybrid

Full Time

#Operations

#IT

#SQL Server

#T SQL

#SSIS

#C#

#Visual Studio

#Azure DevOps

#Git

Massschoolbuildings is looking for a SQL Database Developer II

Sign up to unlock quick summaries and profile fit assessments

 
Job Title:  SQL Database Developer 2 
Department: Information Technology 
Reports To:  Development Lead  
FLSA: Exempt
Hours per Week: 37.5 
Status: Full-Time 
Grade: 12
Position Summary
The SQL Database Developer II is responsible for the design, development, testing, implementation and support of Microsoft SQL-based relational databases and the suite of MSBA Applications. These databases are used to collect and analyze data gathered through the MSBA’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting complex data sets utilizing various reporting platforms.  
This position will ensure that data is available to all users and administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database Developer II will participate in the full development life cycle to meet the business objectives of the MSBA. 

Essential Functions and Responsibilities
  • Design, develop, test, and implement changes and enhancements to current and developing SQL Databases as required 
  • Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows. 
  • Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various complex issues as they arise 
  • Work with Web development team to design and develop application business and data layers. 
  • Write and maintain comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.  
  • Maintain and optimize the databases, data sources and Query server performance, including migrating new changes from online databases to the query database server 
  • Design and implement new tables to store data and related performance monitoring 
  • Design appropriate indexes for new tables, and analyze existing indexes for improvement  
  • Code stored procedures of high complexity to meet business requirements  
  • Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality  
  • Oversee database performance issues and guide optimizations in systems design 
  • Implement physical data model and data access layer 
  • Deliver work products that meet specifications, are free of defects, and have excellent performance 
  • Cultivate and maintain strong relationships with co-workers and project teams 
  • Support development and ongoing maintenance of MSBA Applications 
  • Keep up to date with database development best practices 
  • Support the operational strategies and priorities of the MSBA. 
  • Perform other duties as assigned 


  • Required Education, Experience, and Skills
  • Four-year degree in technical discipline and 7+ years of relevant professional experience in SQL database development 
  • Ability to work hybrid work schedule - minimum of two (2) in-office days per week
  • Strong Microsoft Windows and SQL Server 2017(and above) and T-SQL programming skills 
  • Follow proper application, operations, standards, policies, and procedures. Ensure that the integrity and consistency of company databases is maintained. 
  • Experience planning, testing and implementing database software upgrade cycles. 
  • Minimum 5 years of working in an object-oriented environment, hands-on experience with ASP.Net or Core, VB .Net, C# and Visual Studio 2017 (or above). 
  • Experience with versioning control environments, such as Azure DevOps, Git, TFS is a must. 
  • Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) 
  • Experience in Database Design, Development, and Administration. 
  • Experience with web-enabled enterprise applications, protocols and standards 
  •  Practical database administration experience 
  • Experience in architecting, designing and implementing complex databases 
  • Experience in code migration, database change management and data management through the various stages of the development lifecycle 
  • Strong communication skills and the ability to work both independently and as part of a team. 
  • Strong analytical and problem-solving skills 
  • A task driven mindset as well as effective multitasking and follow-up skills 
  • Professional interpersonal, team-oriented style; ability to work and build trust with a diverse range of people 
  • Ability to work with tight deadlines 
  • Exhibit a professional ‘can-do’ attitude and flexible work style approach. 
  • Ability and willingness to proactively research and/or resolve issues 
  • Ability to be reliable and punctual 


  • Preferred Education, Experience, and Skills
  • Relevant Microsoft Certifications 
  • Masters in technical discipline 
  • Experience with cloud-based services and solutions 
  • Experience with network/storage architecture 
  • Experience with BI reporting tools such as Tableau and Power BI  
  • Experience with Project Management Methodologies like Agile and ITIL 


  • This job description is intended to be general and will evolve over time.  The description is subject to periodic updating. At management’s discretion, the employee may be assigned different or additional duties from time to time. 
    Massschoolbuildings logo

    Massschoolbuildings

    6 views

    0 applied
    Visit Massschoolbuildings
    Share this job
    Copy Permalink
    Open roles at Massschoolbuildings
    Massschoolbuildings logo
    Massschoolbuildings

    Senior Web Application Developer

    us flag
    United States

    Hybrid

    Full Time

    #Operations

    #IT

    #C#

    #VB.NET

    #ASP.NET

    #HTML5

    #CSS3

    #JavaScript

    #Git

    #Azure

    #Agile

    Discover similar jobs
    O
    OLIVER Agency - APAC

    Events Operations Manager

    Remote

    Full Time

    #Project Management

    #Event Marketing

    #Stakeholder Management

    #Operations

    #Logistics

    #Production

    #Process Improvement

    #Risk Management

    Flower logo
    Flower

    Founding Research Engineer in the Flower Frontier Model Team

    Remote

    Full Time

    #Engineering

    #Artificial Intelligence

    #PyTorch

    #Jax

    #Transformers

    #Optimization

    #Training

    #Docker

    #Git

    #Linux

    Versapay logo
    Versapay

    Principal .NET Software Engineer

    Remote

    Full Time

    #Engineering

    #Payments

    #C#

    #.NET

    #SQL

    #AWS

    #Azure

    #GitHub Actions

    #RESTful APIs

    #ISO 8583

    LetsGetChecked logo
    LetsGetChecked

    Graduate Software Engineer

    76k - 95k USD

    Remote

    Full Time

    #Technology

    #Healthcare

    #Python

    #C#

    #JavaScript

    #AWS

    #Azure

    #GCP

    #Splunk

    #Datadog

    S
    SecondDinner

    Senior Director, Engineering

    270k - 300k USD

    Remote

    Full Time

    #Engineering

    #Game Development

    #Unity

    #AWS

    #Git

    #.NET

    #Technical Leadership

    Minted logo
    Minted

    AI & Automation Engineer

    97k - 127k USD

    Remote

    Full Time

    #Technology

    #Artificial Intelligence

    #Python

    #JavaScript

    #TypeScript

    #RESTful APIs

    #Git

    #AWS

    #Azure

    #GCP

    #Okta

    CompanyCam logo
    CompanyCam

    Machine Learning Engineer

    220k - 250k USD

    Remote

    Full Time

    #Engineering

    #Machine Learning

    #Computer Vision

    #Python

    #PyTorch

    #TensorFlow

    #SQL

    #Git

    #Transformers

    #Data Analysis

    B
    Branch

    Cloud Operations Engineer

    us flag
    United States

    135k - 150k USD

    Remote

    Full Time

    #Cloud Operations

    #Infrastructure

    #GCP

    #Python

    #Docker

    #Kubernetes

    #Terraform

    #Ansible

    #Git

    #BASH

    #Java

    Agiloft logo
    Agiloft

    Senior Platform Engineer

    Remote

    Full Time

    #Product

    #Engineering

    #Python

    #AWS

    #Serverless

    #API Gateway

    #Lambda

    #DynamoDB

    #Git

    #Postgres

    #CloudFormation

    #SAM

    #RESTful API

    #GitHub Actions

    #Docker

    #ECS

    B
    Bankjoy

    Senior Software Engineer - Full Stack - .NET

    ca flag
    Canada

    Remote

    Full Time

    #Engineering

    #Fintech

    #C#

    #.NET Core

    #Angular

    #React

    #TypeScript

    #SQL

    #AWS

    #Azure

    #GCP

    #API Design

    Q
    Quandri

    AI Solutions Consultant

    Remote

    Full Time

    #Sales

    #Insurance

    #Consulting

    #Solutions Consulting

    #Enterprise Sales

    #Operations

    #Change Management

    #Business Acumen

    #Technical Sales

    #ROI Analysis

    BridgeTech2 logo
    BridgeTech2

    IT Sales Executive

    Remote

    Full Time

    #Business Development

    #IT

    #Cold Calling

    #Lead Generation

    #Interaction

    #Vendor Management

    FANtium logo
    FANtium

    Senior Full Stack Engineer

    Remote

    Full Time

    #Engineering

    #Blockchain

    #TypeScript

    #NodeJS

    #React

    #NextJS

    #AWS

    #API

    #Git

    #Solidity

    #IPFS

    Kpaonline logo
    Kpaonline

    Senior Cloud & Systems Engineer

    110k - 125k USD

    Remote

    Full Time

    #Technology

    #IT

    #Azure

    #Microsoft

    #PowerShell

    #Active Directory

    #Intune

    #AWS

    #Cisco Meraki

    #Windows Server

    #API Integrations

    Collabora logo
    Collabora

    GPU Consultant Engineer

    Remote

    Full Time

    #Engineering

    #Open Source

    #Graphics

    #Vulkan

    #C++

    #Linux Kernel

    #Git

    #Python

    #Rust

    G
    GR8_TECH

    Senior Artificial Intelligence Specialist

    Remote

    Full Time

    #IGaming

    #Artificial Intelligence

    #Python

    #SQL

    #AWS

    #Docker

    #Git

    #LLM

    Kyivstar logo
    Kyivstar

    Application Support Engineer

    Remote

    Full Time

    #IT

    #Support

    #SQL

    #Oracle

    #MS SQL Server

    #Windows

    #Unix

    #ITSM

    #Testing

    B
    BigTime

    Lead Game Designer

    Remote

    Full Time

    #Game Design

    #Operations

    #Analytics

    #SQL

    #Data Analysis

    T
    TreehouseStrategyAndCommunicatio

    Technical Lead Full Stack Developer

    25k - 25k USD

    Remote

    Full Time

    #Engineering

    #Software Development

    #C#

    #React

    #HTML5

    #CSS

    #JavaScript

    #Bootstrap

    #Entity Framework

    #LINQ

    #SQL

    #MS SQL Server

    Valiantys logo
    Valiantys

    Account Manager

    de flag
    Germany

    Remote

    Full Time

    #Sales

    #IT

    #Account Management

    #Sales Strategy

    #Upselling

    #Cross Selling

    #Forecasting

    #CRM

    #Presentation Skills

    Your dream job awaits.

    Explore exciting opportunities, connect with top employers, and ignite your career.