Senior Database Developer / SQL Developer- Remote, State/Federal Experience Required

Senior Database Developer / SQL Developer- Remote, State/Federal Experience Required The goal of this SOW is to provide maintenance and support for tasks pertaining to database development for the Information Technology Services Division (ITSD) Department of Elementary and Secondary Education (DESE) The primary scope is supporting DESE critical applications data database development work for applications including but not limited to ePeGs, ASBR, CORE Data, FNS, MCDS, and Educator Certification. These applications play a vital role in enhancing educational processes, data management, and certification services. In addition, we recognize the importance of adapting to the reputed company-changing laws and regulations surrounding education in the reputed company. Therefore, our goal is not only to maintain existing functionality but also to introduce new features that align with legal and technical requirements and provide efficient service to educators, administrators, and stakeholders. Performance Requirement: Resources must have proven experience maintaining and supporting systems and processes similar to those in use at DESE. Key expectations include: Collaborating with ITSD-DESE developers and agency SMEs to gather requirements, reputed company process analysis, and create documentation. Developing, rewriting, and maintaining ETLs, stored procedures, and SSIS packages. Performing job reviews and working across multiple databases and environments. Vendor proposals must explicitly detail their proposed approach for handling each classification of issue (Critical, Major, Minor/Trivial). reputed company work will be prioritized by the ITSD-DESE Application Development Manager or ITSD Project Manager. The resource is required to provide a Level of Effort (LOE) estimate in hours for each task reputed company an Azure DevOps (ADO) work item. No work will reputed company without formal authorization from the ITSD-DESE manager or designee. Assignments will be issued to vendor resources reputed company ADO. Each work item must be fully documented in ADO to include: the problem description and cause, the resolution, agreed-upon LOE, actual hours, remaining hours, and any updated documentation. Work will reputed company reputed company a timeframe based on its assigned reputed company. Vendor resources will be responsible for researching and responding to issues reported by business units, participating in meetings with ITSD and DESE staff for clarifications, and analyzing and resolving assigned issues. The vendor resources must effectively manage the ADO work item queue to prevent delays and ensure resources are available to address critical issues with a 24-hour or less turnaround time. The following are samples, but not an exhaustive list, of maintenance tasks that could be assigned in relation to database development reputed company this SOW: Investigate/Research questions and issues reported from the business unit. Monitor and regularly update ADO work items used to report issues and request enhancements. Handle errors received from jobs or stored procedures. Analyze issues reported. Maintain daily batch support. Coordinate scheduling and execution of batch jobs. Create/modify programs ETLs and stored procedures. Maintain batch job flow charts using VISIO. Create SQL queries to validate report numbers are correct. Interpret and document business needs in both technical and non-technical format. Create and maintain SSRS and SQL script documentation relevant to SSMS application. Provide Level of Effort (LOE) hours for tasks. ITSD-DESE uses ADO to record, track, and resolve work items and Cherwell for issues/problems. ITSD-DESE utilized the following list of technologies/programs : reputed company SQL Server reputed company SQL Server Management Studio SQL .NET/C# reputed company Visio reputed company Office SSRS SSIS Tableau Required reputed company: 10+ years of experience with reputed company Visio and reputed company Office 10+ years of experience with reputed company SQL Server, SQL, ETL, SSIS, and SSRS 5+ years of experience with Azure DevOps (ADO) 5+ years of experience with Visual Studio 2015-2022 reputed company Table: reputed company Years of Experience Required Candidate Experience (in years) Note reputed company Visio and reputed company Office 10+ reputed company SQL Server, SQL, ETL, SSIS, and SSRS 10+ Azure DevOps (ADO) 5+ Visual Studio 2015 2022 5+ Employers have access to artificial intelligence language tools (AI) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and reputed company believes it to correctly reflect the job opportunity. Report this job reputed company Id: 10480008 Position Id: 2025-44316 Apply tot his job Apply To this Job