Database Developer

Date Posted: 05/02/2025

Hiring Organization: Rose International

Position Number: 482077

Job Title: Database Developer

Job Location: Jefferson City, MO, USA, 65101

Work Model: Hybrid

Shift: 8am to 5pm CST

Employment Type: Temporary

Estimated Duration (In months): 13

Min Hourly Rate : 45.00

Max Hourly Rate : 50.00

Must Have Skills/Attributes: Azure, Database, Developer, SQL, VISIO

Job Description

Required Skills:

• Must have previous experience with Missouri Department of Elementary and Secondary Education SAFA Reporting.

• Experience with database development on large data driven projects at a State government or equivalent organizational level.

• Must have experience with DESE database structure.

• 5+ year''s experience with Microsoft Visio and Microsoft Office.

• 5+ year''s experience with Microsoft SQL Server, SQL Server Management Studio, SQL, stored procedures, ETL, SSIS, and SSRS.

• 5+ year''s experience with Visual Studio 201-2022

• 5+ year''s experience with Azure DevOps (ADO)

The goal of this projects is to perform tasks pertaining to database development for the project. This project team is tasked with producing the clients Annual Report Card and Annual Performance Reports (APRs) for the SAFA which provides Local Education Agency (LEA) and building-level data through Missouri Comprehensive Data System (MCDS) portal as well as reports for federal reporting. The SAFA project is a huge data driven project that takes a lot of time and effort to complete by the requested deadline.

The scope of the SAFA project will include performing the development, maintenance, and architecture for ETLs, stored procedures, SSIS packages and job reviews, for jobs/tasks communicating and working across multiple databases and environments. Preparing all the data for all of our supporting applications and mandatory reporting needs driven by federal requirements, state statutes, and departmental and organizational policies.

Duties:

• Develop, rewrite, and maintain ETLs, stored procedures, SSIS packages, SSRS Reports.

• Perform job reviews for jobs/tasks.

• Communicating and working across multiple databases and environments.

• All work will be prioritized by the Client Application Development Manager or Client Project Manager.

• Research and respond to Client business staff when they need issues or work items researched based on their testing activities.

• Be involved in meetings with Client business staff for various assignments, issues, or clarifications.

• Research and resolve assignments or issues reported.

• Ensure the flow of work by effectively managing the work items in ADO thereby ensuring the resolution of issues reported are not delayed beyond the reasonable due dates set during creation.

• Investigate/Research questions and problems from the business unit.

• Monitor and regularly update ADO work items used to report issues and request enhancements.

• Handle errors received from jobs.

• 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.

• Provide batch support for operational amends and extracts.

• Create SQL queries to validate report numbers are correct.

• Request database changes.

**Only those lawfully authorized to work in the designated country associated with the position will be considered.**

**Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

Benefits:

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).