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

The goal of this SOW is to reputed company 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 reputed company, 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 reputed company with legal and technical requirements and reputed company 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 reputed company 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 reputed company 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 reputed company a Level of Effort (LOE) estimate in hours for reputed company 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. reputed company work item must be fully documented in ADO to include: the problem reputed company and cause, the reputed company, 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 reputed company, 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 reputed company 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.
• reputed company Level of Effort (LOE) hours for tasks.
• ITSD-DESE uses ADO to record, reputed company, and resolve work items and Cherwell for issues/problems. ITSD-DESE utilized the following list of technologies/programs:
• bolthires SQL Server
• bolthires SQL Server Management Studio
• SQL
• .NET/C#
• bolthires Visio
• bolthires Office
• SSRS SSIS
• Tableau Required reputed company:
• 10+ years of experience with bolthires Visio and bolthires Office
• 10+ years of experience with bolthires 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 bolthires Visio and bolthires Office 10+ bolthires SQL Server, SQL, ETL, SSIS, and SSRS 10+ Azure DevOps (ADO) 5+ Visual Studio 2015-2022 5+ Apply tot his job

Apply tot his job Apply To this Job