Massachusetts School Building Authority (MSBA) · 20 hours ago
SQL Database Developer II
Boston, MA
Full-time
Hybrid
Senior Level
$95K/yr - $106K/yr
7+ years expThe Massachusetts School Building Authority (MSBA) is seeking a SQL Database Developer II who will be responsible for the design, development, testing, and support of Microsoft SQL-based relational databases. This role involves ensuring data availability, optimizing database performance, and collaborating with the IT team to meet business objectives.
Construction
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
Qualification
Required
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
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
Company
Massachusetts School Building Authority (MSBA)
The Massachusetts School Building Authority (“MSBA”) is a quasi-independent government authority created to reform the process of funding capital improvement projects in the Commonwealth’s public schools.
51-200 employees
H1B Sponsorship
Massachusetts School Building Authority (MSBA) 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 (1)
2022 (1)
2021 (1)
2020 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase