Massachusetts School Building Authority
SQL Database Developer II
Massachusetts School Building Authority, Boston, Massachusetts, us, 02298
Job Title:
SQL Database Developer II
Department:
Information Technology
Reports To:
Development Lead
FLSA:
Exempt
Hours per Week:
37.5
Status:
Full-Time
Grade:
12
POSITION DESCRIPTION AND SCOPE
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 the 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 RESPONSIBILITIESDesign, develop, test, and implement changes and enhancements to current and developing SQL Databases as requiredDevelop an understanding of MSBA business processes and workflow 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 ariseWork 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 serverDesign and implement new tables to store data and related performance monitoringDesign appropriate indexes for new tables, and analyze existing indexes for improvementCode stored procedures of high complexity to meet business requirementsWork to implement and maintain SSRS reports ensuring they are of the highest data and visual qualityOversee database performance issues and guide optimizations in systems designImplement physical data model and data access layerDeliver work products that meet specifications, are free of defects, and have excellent performanceCultivate and maintain strong relationships with co-workers and project teamsSupport development and ongoing maintenance of MSBA ApplicationsKeep up to date with database development best practicesSupport the operational strategies and priorities of the MSBA.Perform other duties as assignedREQUIRED KNOWLEDGE AND SKILLS
Four-year degree in technical discipline and 7+ years of relevant professional experience in SQL database developmentStrong Microsoft Windows and SQL Server 2017(and above) and T-SQL programming skillsFollow 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 VSS, 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 standardsPractical database administration experienceExperience in architecting, designing and implementing complex databasesExperience in code migration, database change management and data management through the various stages of the development lifecycleStrong communication skills and the ability to work both independently and as part of a team.Strong analytical and problem-solving skillsAbility to work creatively, learn quickly and solve complex problems in high-pressure situationsA task driven mindset as well as effective multitasking and follow-up skillsExcellent verbal and written communication skills.Professional interpersonal, team-oriented style; ability to work and build trust with a diverse range of peopleAbility to work with tight deadlinesExhibit a professional 'can-do' attitude and flexible work style approach.Ability and willingness to proactively research and/or resolve issuesAbility to be reliable and punctualPREFERRED KNOWLEDGE AND SKILLS
Relevant Microsoft CertificationsMasters in technical disciplineExperience with cloud-based services and solutionsExperience with network/storage architecturesExperience with BI reporting tools such as Tableau and Power BIExperience with Project Management Methodologies like Agile and ITIL
$94,893 - $105,569 a year
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.
SQL Database Developer II
Department:
Information Technology
Reports To:
Development Lead
FLSA:
Exempt
Hours per Week:
37.5
Status:
Full-Time
Grade:
12
POSITION DESCRIPTION AND SCOPE
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 the 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 RESPONSIBILITIESDesign, develop, test, and implement changes and enhancements to current and developing SQL Databases as requiredDevelop an understanding of MSBA business processes and workflow 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 ariseWork 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 serverDesign and implement new tables to store data and related performance monitoringDesign appropriate indexes for new tables, and analyze existing indexes for improvementCode stored procedures of high complexity to meet business requirementsWork to implement and maintain SSRS reports ensuring they are of the highest data and visual qualityOversee database performance issues and guide optimizations in systems designImplement physical data model and data access layerDeliver work products that meet specifications, are free of defects, and have excellent performanceCultivate and maintain strong relationships with co-workers and project teamsSupport development and ongoing maintenance of MSBA ApplicationsKeep up to date with database development best practicesSupport the operational strategies and priorities of the MSBA.Perform other duties as assignedREQUIRED KNOWLEDGE AND SKILLS
Four-year degree in technical discipline and 7+ years of relevant professional experience in SQL database developmentStrong Microsoft Windows and SQL Server 2017(and above) and T-SQL programming skillsFollow 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 VSS, 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 standardsPractical database administration experienceExperience in architecting, designing and implementing complex databasesExperience in code migration, database change management and data management through the various stages of the development lifecycleStrong communication skills and the ability to work both independently and as part of a team.Strong analytical and problem-solving skillsAbility to work creatively, learn quickly and solve complex problems in high-pressure situationsA task driven mindset as well as effective multitasking and follow-up skillsExcellent verbal and written communication skills.Professional interpersonal, team-oriented style; ability to work and build trust with a diverse range of peopleAbility to work with tight deadlinesExhibit a professional 'can-do' attitude and flexible work style approach.Ability and willingness to proactively research and/or resolve issuesAbility to be reliable and punctualPREFERRED KNOWLEDGE AND SKILLS
Relevant Microsoft CertificationsMasters in technical disciplineExperience with cloud-based services and solutionsExperience with network/storage architecturesExperience with BI reporting tools such as Tableau and Power BIExperience with Project Management Methodologies like Agile and ITIL
$94,893 - $105,569 a year
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.