SQL Database Developer II

$94,893 - $105,569/Yr

Massachusetts School Building Authority (Msba) - Boston, MA

Full-time - Mid Level

Boston, MA

About the position

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. This role involves ensuring data availability, administering database systems, and supporting complex data sets through various reporting platforms. The developer will work closely with the IT team throughout the full development life cycle to meet the business objectives of the MSBA.

Responsibilities

• Design, develop, test, and implement changes and enhancements to current and developing SQL Databases.
• Develop 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.
• Work with the Web development team to design and develop application business and data layers.
• Write and maintain comprehensive documentation, including database dependencies, database inventory, and daily database operations documents.
• Maintain and optimize the databases, data sources, and Query server performance.
• Design and implement new tables to store data and related performance monitoring.
• Code stored procedures of high complexity to meet business requirements.
• Implement and maintain SSRS reports ensuring high data and visual quality.
• Oversee database performance issues and guide optimizations in systems design.
• 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.

Requirements

• Four-year degree in technical discipline and 7+ years of relevant professional experience in SQL database development.
• Strong Microsoft Windows and SQL Server 2017 (and above) and T-SQL programming skills.
• 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.
• Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Experience in Database Design, Development, and administration.
• Experience in architecting, designing, and implementing complex databases.
• Strong communication skills and the ability to work both independently and as part of a team.

Nice-to-haves

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