State of Oregon · 8 hours ago
Database Analyst/Developer
The Oregon Department of Education is seeking a Database Analyst/Developer to maintain and evolve the enterprise data/application resources. This position involves writing and optimizing SQL queries, ensuring data integrity, and maintaining technical documentation.
GovernmentNon ProfitPublic SafetySocial
Responsibilities
Write, optimize and maintain SQL queries, views and functions
Analyze and improve query performance
Ensure data integrity, consistency and accuracy across systems
Write and maintain technical documentation
Qualification
Required
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 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 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 Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above
Preferred
Strategic planning and documentation of complex data processing systems
High understanding SQL Server
Highly skilled T-SQL Programming
Preparing detailed system and program technical specifications
Deployment of database applications
Ensuring data integrity, security, and conformance to ODE and state standards
Benefits
Oregon State provides amazing benefits!
Company
State of Oregon
Official LinkedIn page for the state of Oregon. Oregon is a state in the Pacific Northwest region of the United States.
Funding
Current Stage
Late StageRecent News
2025-05-04
Company data provided by crunchbase