Senior Database Analyst
- Oregon Health Authority
- Remote
- Jun 02, 2023
Job Description
Senior Database Analyst (Information Systems Specialist 8) Remote and Hybrid Work Options
Close Date: 6/25/2023
Salary Range: $6,413 - $9,705
Location: Salem, OR/ Remote
The Oregon Health Authority (OHA) has a fantastic opportunity for an experienced Senior Database Analyst to join an excellent team and work to advance their IT operations.
The work of this role may be conducted remotely with full access to the needed operating systems and technology.
The Office of Information Service’s mission is to deliver technology solutions and services that support Oregon Health Authority and Oregon Department of Health Services in helping Oregonians achieve health, well-being, and independence.
This is a full-time permanent opportunity for anyone to apply. This position is a classified position represented by a union.
What's in it for you?
- Medical, vision, and dental benefits
- 11 paid holidays
- 8 hours of vacation per month, eligible to be used after 6 months of service
- 8 hours of sick leave per month, eligible to be used as accrued
- 24 hours of personal business leave per fiscal year, eligible to be used after 6 months of service
- Pension and retirement programs
- Opportunity to potentially receive loan forgiveness under the Public Service Loan Forgiveness Program (PSLF)
- Continuous growth and development opportunities
- Opportunities to serve your community and make an impact through meaningful work
- A healthy work/life balance, including fulltime remote options as well
What you will do! (Position Duties)
We are seeking a Senior Database Analyst to provide expert consultation to management, professional IS staff and other jurisdictions, and, in a leadership role, conducts comprehensive analysis, planning, development, implementation and coordination for the operations, maintenance, installation and construction of information systems. The Senior Database Analyst will be responsible for overseeing the work of other information technology professionals, ensuring that all tasks are completed to a high standard and in a timely manner. The successful candidate will have extensive experience in information systems, possess excellent leadership and communication skills, and be able to work collaboratively with a diverse group of stakeholders.
What we are looking for!
MINIMUM REQUIREMENTS: (Please clearly outline how you meet the minimum requirements and special qualifications in your application/resume/cover letter. Failure to do so might disqualify you from consideration)
(a) Seven (7) years of information systems experience, preferably in Database administration and/or Database development
OR
(b) An Associate's degree or higher 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 5 years of information systems experience, preferably in Database administration and/or Database development
OR
(c) A Bachelor's degree in Information Technology, Computer Science, or related field AND three (3) years of information systems experience, preferably in Database administration and/or Database development
OR
(d) Master's degree in Information Technology, Computer Science, or related field AND one (1) year of information systems experience, preferably in Database administration and/or Database development
Desired Attributes
Extensive Knowledge of:
- theories, principles, and practices of Information Systems Technology.
- project administration methods, principles, techniques, and practices.
- information systems architecture.
- methods and procedures for designing, developing, monitoring, and maintaining databases.
- tools for constructing database structures.
- automation products that support a variety of data management environments.
General Knowledge of:
- business systems and organizational structures.
- trends, technological changes, and developments in IS.
- operations and business of the organization.
Skill:
- administering and managing comprehensive, multi-system projects including directing and motivating internal staff, contractors, and other participants.
- identifying the scope and complexity of a project and assigning segments of that project to others.
- assigning and reviewing the work of others to determine accuracy and adequacy of identified conditions, criteria, recommendations and supporting materials.
- developing long and short-range plans to meet established goals.
- developing policies and procedures.
- analyzing organizational needs and implementing cost-effective solutions.
- determining efficient design of data structures and software applications.
- assessing new technology developments.
Specific DBMS Skills:
- Day-to-day operational support of SQL Server on-prem databases, ensuring database availability and performance, and monitor transaction activity and utilization.
- Leverage extensive DBMS skills to learn and support Avatar environment, provide coordination lead on vendor support for Caché object database and server.
- Windows Server administration, security, scripting, and monitoring experience.
Extensive knowledge of the following tools: SSMS, SSDT, Monitoring tools, Security implementation.
- Working knowledge of Azure SQL, Managed Instances, and Synapse Analytics.
- Working knowledge of AIX, utilities, and environment.
How to Apply
Please apply via Workday at the following link –
The Oregon Health Authority is an equal opportunity, affirmative action employer committed to workforce diversity.
URL
Salary
The Oregon Health Authority is at the forefront of lowering and containing costs, improving quality and increasing access to health care in order to improve the lifelong health of Oregonians. OHA is overseen by the nine-member citizen Oregon Health Policy Board working towards comprehensive health reform in our state.
Vision:
A healthy Oregon
Mission:
Ensuring all people and communities can achieve optimum physical, mental, and social well-being through partnerships, prevention, and access to quality, affordable health care.