Sql Dba

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.



Requirements REQUIRED DEGREE Bachelor's degree

REQUIRED CERTIFICATION(S) # YEARS 7

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

7

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

7

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

7

Familiarity with continuous integration

7

Experience creating and scheduling elastic jobs

5

REQUIRED SKILLS/EXPERIENCE # YEARS 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)

No min.

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