Database Analyst/Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

State of Oregon · 6 hours ago

Database Analyst/Developer

The State of Oregon is seeking a Database Analyst/Developer to join the Office of Finance and Information Technology at the Oregon Department of Education. The role involves maintaining and evolving enterprise data/application resources, including writing and optimizing SQL queries, ensuring data integrity, and maintaining technical documentation.

GovernmentNon ProfitPublic SafetySocial
badNo H1Bnote

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

SQLETL (SSIS)Performance tuningT-SQL ProgrammingDatabase applications deploymentData integrityComplex joinsSubqueriesIndexing strategiesStrategic planningPreparing specificationsUnderstanding large datasetsTechnical documentation

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

company-logo
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 Stage

Leadership Team

leader-logo
William Wise
Chief Executive Officer
linkedin
leader-logo
Kate Nass
Chief Financial Officer
linkedin
Company data provided by crunchbase