SQL Database Administrator

Task Summary

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

Minimum Qualifications

• Bachelors degree.
• 7 years of extensive experience with development of stored procedures and ETL processes using TSQL.
• 7 years of 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.
• 5 years of experience creating and scheduling elastic jobs.

Desirable Qualifications

• Experience with student information management systems and K12 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.

Minimum Application Requirements

Your application will be disqualified if you do not meet all these minimum application requirements.

• Must meet or exceed the Minimum Qualifications.
• Must be a current resident of the United States.
• Must have current work authorization for the United States.
• Must be a direct hire.

Make sure to check your junk/spam folders as we will use email to reach out to you.