Database Operations Specialist (Remote/Information Systems Specialist 7)
We have an exciting need for a Database Operations Specialist (Information Systems Specialist 7) with our Enterprise Services unit at the Oregon Department of Education.
Our Database Operations Specialist plays an important role in our organization. It allows for flexibility and creativity in solving unique issues that arise in our various systems.
This position works in a small, but mighty, unit of four, which is housed in a larger development IT team of over 20 developers. Sharing and collaborating is engrained within our team. We manage over 100 home grown applications that we maintain and enhance to meet the needs of our customers. We have over 100 databases that ODE manages and maintains. This position will help manage various tasks with our databases from make sure they are running at optimal speed to making sure that Extract Transform and Load (ETLs) are running smoothly to optimizing procedures for better performance.
This position has the possibility to be primarily remote.
If you are an IT professional who thrives in an environment that promotes collaboration, innovation and proactive problem solving, this is the place for you!
As our Database Operations Specialist, you will maintain information technology operations (data/application resources) for the Department of Education. This includes monitoring existing systems and processes, scheduling and rescheduling jobs based on operational needs; performing routine maintenance tasks on databases such as rebuilding indexes; perform upgrades to database software i.e., patches and installations; perform database optimization and tuning tasks; assist with restoration of operations following system failures; maintain system documentation of complex data processing systems and follow roll out processes ensuring successful code deployments.
Typical duties include:
- Database maintenance
- SQL performance review
- Working through the ticket log including projects, fixes, and/or enhancements
Our amazing benefits:
At the Oregon Department of Education, we pride ourselves on creating an inclusive, collaborative and innovative atmosphere. Autonomy is supported while also being offered opportunities to work in dedicated teams or partnerships across the agency. Our office supports a healthy work/life balance and shows genuine care for team members, students, partners and school leaders.
Our benefits include:
- Excellent medical, vision and dental benefit package for the employee and qualified family members with very low monthly out-of-pocket cost
- Paid days off –
- 11 paid holidays per year
- 3 additional paid "Personal Business Days" per year
- 8 hours of sick leave accumulated every month
- Progressive vacation leave accrual, starting at 8 hours per month, with increases every 5 years
- In addition to standard medical benefits and employee leave, the state also provides additional optional benefits, such as basic life insurance, short-term disability, long-term disability, deferred compensation savings program, and flexible spending accounts for health care and child care expenses.
- Student Loan Forgiveness Program: if you have federal student loan debt or are thinking of going back to school, then you will want to look into this program. If you make 120 qualifying payments on your student loan while working full time for a qualifying employer, your student loan debt may be forgiven.
If you have a desire to make a difference in the lives of Oregonians, apply today!
What are we looking for?
Candidates with a minimum of:
Six (6) years of information systems experience in computer science, network, database operations;
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 related field and four (4) years of information systems experience in computer science, network, database operations
OR
A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience in computer science, network, database operations
OR
A Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.
Candidates who are the most competitive will possess a compelling combination of the following background, skills, and experience:
- Database design, construction, security and maintenance
- Experience with Microsoft SQL Server
- Experience with Microsoft SQL diagnostics
- General understanding of Network operations
- Experience with IDERA
- Experience with tracing and SQL profiling
- General knowledge of Windows server
- Experience with Microsoft Team Foundation Server
- Experience diagnosing SQL server system and query performance issues
- Experience with DOS, PowerShell
- Strong verbal and written communication skills
- Strong documentation skills
- Experience monitoring and reviewing logs
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.
How to apply:
Materials Required –
- Resume
- Cover Letter stating your experience with diagnosing Microsoft SQL Server failures and maintenance on a Microsoft SQL Server. (limit to no more than 2 pages)
External Applicants: Click on the “Apply” button and submit your resume and cover letter. Please make sure to attach all required documents in the section titled Resume/CV. View this video for help.
Internal Applicants: (this includes Current State of Oregon employees): Apply via your employee Workday account. View this job aid for help.
Helpful links and contact information:
Learn more about ODE
Help & Support webpage
Learn more about Oregon
For additional information you may contact us by e-mail at ode.jobs@state.or.us.
The Department of Education is an equal 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.