drjobs
Database Administrator DBA
drjobs
Database Administrat....
drjobs Database Administrator DBA العربية

Database Administrator DBA

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs

Job Location

drjobs

- USA

Monthly Salary

drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Req ID : 2634112

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

REQUIRED SKILLS/EXPERIENCE # YEARS Consultant
Experience Extensive experience with development of stored procedures and ETL processes using TSQL 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
Preference given to candidates with the below skills/experience.
Must also meet minimum requirements. Consultant
Experience 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

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.

Employment Type

Full Time

Company Industry

Key Skills

  • Databases
  • Disaster Recovery
  • SQL
  • High Availability
  • Microsoft SQL Server
  • ssrs
  • Database Design
  • Performance Tuning
  • SSIS
  • Database Administration
  • Sybase
  • Oracle
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.