Database Analyst/Developer

Position Title: Database Analyst/Developer

Classification: Information Systems Specialist 7

Salary: $6,846 – $10,344 ($7,323 - $11,070 PERS)

Type: Limited Duration ending 6/30/2027, Full-time, Exempt

We are seeking a Database Analyst/Developer (Information Systems Specialist 7) to join our Office of Finance and Information Technology (OFIT) at the Oregon Department of Education. This is a limited duration position ending 6/30/2027 and represented by the Service Employees International Union (SEIU).

This position follows a hybrid work model. Onsite presence will be required when business or operational needs are best supported in person, such as collaboration, training, or work that requires access to onsite resources. Employees approved to work remotely must have a reliable and secure internet connection and maintain a professional work environment that supports productivity. While working remotely, employees are expected to maintain the same level of performance, responsiveness, communication, and availability as they would in the office.

What you will do!

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

• Performing diagnosis and correction of application/data errors

Please click here to view the full position description

If you would like to retain a copy of this job post or the PD linked above, please print a copy before submitting your application. Once the job posting has closed, you will not be able to access the posting.

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

We are most interested in finding the best candidate for the job. We would encourage you to apply, even if you don't meet every one of the attributes listed.

Our Agency Mission and Office Culture:

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

Application Resources & Information:

• 
  Eligible veterans and Oregon National Guard service members (current and former) who meet the qualifications of the position will be awarded candidate preference. For more information, please visit Veterans Resources. Be sure to submit your documentation prior to the close date of this posting to have the preference considered.

• Your application materials will be used to determine salary based on a pay equity assessment. For further information, please visit the Pay Equity Project homepage.

• The job posting closes at 11:59 PM (PDT) on the close date. After you submit your application, be sure to respond to the two questionnaires relating to public records requests and veterans’ preference immediately following your submission. These questions are necessary to complete the application process.

• Please contact ode.jobs@ode.oregon.gov if you have any questions on the application process or need an accommodation under the Americans with Disabilities Act (ADA). Please be sure to include the job requisition number.

• Oregon Job Opportunities: How to Apply (Internal & External)

• Understanding the State Application Process

• Resources for Job Seekers

Additional Information:

• 
  The salary listed is the non-PERS qualifying salary range. If the successful candidate is PERS qualifying, the salary range will reflect an additional 6.95%.

• Review the Classification and Compensation page for more details on the classification, or you may visit our website for information on the job offer process following pay equity.

• Future Vacancies: This recruitment announcement will be used to establish a list of qualified candidates to fill the current vacancy and may be used to fill future vacancies as they occur.

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

The Department of Education is an equal employment opportunity & affirmative action employer committed to a diverse workforce. The Department strives to create an inclusive environment that welcomes and values the diversity of the people we serve. We foster fairness, equity, and inclusion to create a workplace environment where everyone is treated with respect and dignity. We are most interested in finding the best candidate for the job. We would encourage you to apply, even if you don't meet every one of our qualifications listed. If you are unsure whether you meet the qualifications of this position, please feel free to contact us to discuss your application.

Come for a job. | Stay for a career. | Make a difference... for a lifetime!