Description

You will manage and maintain production and non-production MS SQL database environments, ensuring data integrity and accessibility across multiple platforms.

Responsibilities

• Design, test, and implement MS SQL database management systems and optimize database access for performance.
• Develop complex, efficient queries, views, stored procedures, and user-defined functions using MS T/SQL.
• Create and maintain reports within Azure Power BI and SQL Server Reporting Services (SSRS), including parameters and drill-down technologies.
• Produce technical documentation, including requirements, specifications, traceability matrices, and design documents.
• Perform backup and recovery operations and collaborate with Business Analysts to update project and training materials.

Required Skills

• 8+ years of experience with MS SQL database management, design, and administration.
• 8+ years of experience writing complex MS T/SQL, stored procedures, and user-defined functions.
• 5+ years of experience with SQL Server Reporting Services (SSRS) using parameters, sub-reports, and drill-down technologies.
• 5+ years of experience testing custom applications, reports, dashboards, and large data sets.
• 5+ years of experience producing technical documentation and design specifications.
• 3+ years of experience creating and maintaining reports in Azure Power BI.
• 3+ years of experience developing with web applications.
• 1+ years of experience with Azure DevOps (TFS), Visual Studio .NET, and Azure SQL Managed Instance.
• Proficiency in Microsoft Word, Excel, and Visio.

Preferred Skills

• Degree in Computer Science or Management Information Systems.
• Experience with MVC, C#, and ADO.
• Experience working in state government, specifically in Education or Early Learning.

Key Skills

Education

Any Graduate