Back to results: sql dba openings / US

SQL DBA

HexaQuest Global

Posted on: 21 Mar 2024

Job Location: Jackson, US

Job Description:

Job Description:

The Mississippi Department of Education (MDE) is implementing the Generate tool developed by the Center for Integration of IDEA Data (CIID).

The current Generate application is based on an older version of the CEDS data warehouse. The latest version of the warehouse is version 10.

This project includes updating the Generate data model to utilize version 10 of the CEDS data warehouse and the update ETL processes that generate federal reports (EDFacts files) using the data model.

This position will require a qualified SQL DBA to take the lead in the following tasks:

Rationalizing and mapping data between transactional and dimensional database models/systems

Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system

Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application

Translate application storyboards and use cases into functional applications.

Ability to work independently and cooperatively as part of a team.

Ability to work under severe time constraints.

Must possess analytical and complex problem-solving skills.

REQUIRED DEGREE: Bachelor's degree.

REQUIRED SKILLS/EXPERIENCE Years of Experience Required Actual Years of Experience

Extensive experience with development of stored procedures and ETL processes using T-SQL 7 Years

Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas 7 Years

Use of ALM tools for work item management, version control, code analysis, and testing 7 Years

Broad and extensive knowledge of the software development process and its technologies 7 Years

Familiarity with continuous integration 7 Years

Experience creating and scheduling elastic jobs 5 Years

Preference given to candidates with the below skills/experience. Must also meet minimum requirements.

Experience with student information management systems and K-12 data and reporting

Experience with Common Education Data Standards (CEDS)

Experience with EDFacts Federal Reporting

Experience with designing and modeling database structures based on business use cases

.Net/Angular experience

Azure Synapse pipeline experience

Three (3) references of submitted candidates required. Please provide the following information. Must submit with resume.

First/last name of reference

Title

Company Name

Job title of contractor while reporting to this supervisor/manager

Telephone number.

Email Address (if available)

Apply

Similar jobs

SQL DBA

Jackson, US

21 Mar 2024

SQL DBA

Jackson, US

21 Mar 2024

SQL DBA

Jackson, US

21 Mar 2024

SQL DBA

Jackson, US

21 Mar 2024