Database Analyst/Developer

The Oregon Department of Education is seeking a Database Analyst/Developer to maintain and evolve the enterprise data/application resources for the Department of Education.

Typical duties of this position include:

• Highly skilled T-SQL Programming

• Strategic planning and documentation of complex data processing systems

• Planning, recommending, and performing database restructuring for optimization and tuning, The Oregon Department of Education's (ODE's) mission is to foster equity and excellence for every learner through collaboration with educators, partners, and communities. In fulfilling its mission, ODE has the vision to ensure all students have access to and benefit from a world-class, well-rounded, and equitable education system. This position is located in the Office of Finance and Information Technology (OFIT), and specifically in the Application Development - IT Unit of the Oregon Department of Education (ODE). This unit's primary functions are the support of technology to deliver on initiatives and meet ODE's technology needs in support of the ODE mission to foster excellence for every learner through innovation, collaboration, leadership and service to our education partners. The technical expertise of staff in this unit are available to districts to support business and financial functions. The work of OIT affects all internal staff and every school, program, school district and ESD in the state. Nearly all students in the State of Oregon public school system are affected by the work produced by this unit. This position is an integral part of the collecting and reporting of the data the ODE collects from all 197 school districts. Oregon State provides amazing benefits! Follow the link below to learn more: Oregon Job Opportunities : Benefits : State of Oregon

Minimum Qualifications: ODE reviews resumes to determine whether applicants meet the minimum qualifications for this position. Please ensure your resume clearly reflects your relevant experience, as it will be used in place of detailed Workday work history for this agency-specific recruitment.

(a) Six (6) years of information systems experience in:

• Complex joins and subqueries

• Optimizing queries and indexing strategies

• Creating stored procedures, triggers, views

• ETL experience (SSIS)

• Understanding of performance tuning

• Working with large datasets

OR (b) An Associate's degree in computer science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or Database administration or SQL Server programming field;

AND

four (4) years of information systems experience in:

• Complex joins and subqueries

• Optimizing queries and indexing strategies

• Creating stored procedures, triggers, views

• ETL experience (SSIS)

• Understanding of performance tuning

• Working with large datasets

OR (c) A Bachelor's degree in Information Technology, Computer Science, or related field

AND

two (2) years of information systems experience in:

• Complex joins and subqueries

• Optimizing queries and indexing strategies

• Creating stored procedures, triggers, views

• ETL experience (SSIS)

• Understanding of performance tuning

• Working with large datasets

OR (d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

Preferred Skills & Knowledge (Desired Attributes): A cover letter is required and is an important part of the application process. All application materials are reviewed by Human Resources, the Hiring Manager, and panel members throughout the recruitment process. Your cover letter is a key opportunity to speak directly to each decision-maker, highlight your skills and experience, and demonstrate how your qualifications align with the desired attributes for this role. Cover letter must be no more than two pages.

Advanced PL/SQL proficiency in Microsoft SQL Server: including complex joins, subqueries, CTEs, window functions, stored procedures, views, and functions

Demonstrated experience in relational data modeling: including normalization principles, logical vs. physical design, and translating business rules into maintainable structures

Experience with database object standards and version control: demonstrated ability to ensure database objects follow naming conventions, documentation practices, and version control requirements

Demonstrated ability to identify and resolve query and schema performance issues: including isolating root causes and applying logical troubleshooting rather than trial and error

Experience participating in solution design discussions: including communicating tradeoffs, proposing practical solutions, and engaging early when requirements shift

Experience designing and deploying database solutions in a production environment: including full lifecycle involvement from initial design through deployment and post-deployment support, * Visa Sponsorship: The Oregon Department of Education does not offer visa sponsorship. Applicants must be authorized to work in the United States. Applicants who require VISA sponsorship will not be considered at this time.