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 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
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)T-SQL ProgrammingPerformance TuningData IntegrityStrategic PlanningDatabase Application DeploymentTechnical 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
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

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