What are the responsibilities and job description for the Oracle Historical SQL Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, INNOVIT USA INC, is seeking the following. Apply via Dice today!
PROJECT DETAILS
The Mississippi Department of Education has a current goal for every community to effectively use a World-Class Data System to improve student outcomes. This goal has an outcome to increase the availability of quality data to drive decisions that improve student outcomes. We are planning to satisfy this goal in part by modernizing our current student information system along with improving the quality of data in connected systems. This will include web-based application development, and creation of dashboards and reports that will improve access, accuracy and ease of use for all stakeholders.
Job Description
This position will require a qualified Developers to take the lead in the following tasks:
Rationalizing and mapping data between transactional and dimensional database models/systems
Development and maintenance of data dashboards, reports, and data visualization tools and products Working closely with the database and system administrators to optimize stored procedures, views, and the overall performance of the data warehouse system
Working in collaboration with vendors and other agency staff to design, develop and manage the MDE data portal to publish data both internally to schools and agency staffs, and externally to the public
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
PROJECT DETAILS
The Mississippi Department of Education has a current goal for every community to effectively use a World-Class Data System to improve student outcomes. This goal has an outcome to increase the availability of quality data to drive decisions that improve student outcomes. We are planning to satisfy this goal in part by modernizing our current student information system along with improving the quality of data in connected systems. This will include web-based application development, and creation of dashboards and reports that will improve access, accuracy and ease of use for all stakeholders.
Job Description
This position will require a qualified Developers to take the lead in the following tasks:
Rationalizing and mapping data between transactional and dimensional database models/systems
Development and maintenance of data dashboards, reports, and data visualization tools and products Working closely with the database and system administrators to optimize stored procedures, views, and the overall performance of the data warehouse system
Working in collaboration with vendors and other agency staff to design, develop and manage the MDE data portal to publish data both internally to schools and agency staffs, and externally to the public
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
- Extensive experience with development of front-end reports, dashboards, and data visualizations using Oracle tools such as Reports, Forms 7 Years
- Experience with web site programming (HTML and XML) and JavaScript - 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
- Strong knowledge of Java, C , and PL/SQL - 7 Years
- Familiarity with continuous integration - 7 Years
- Understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds - 7 Years
- Experience with student information management systems and K-12 data and reporting is a plus
- PL/SQL
- Oracle
- Version Control tools
- Code analysis
- Testing
- Java
