State of Oregon
State of Oregon·13 days ago

Database analyst (information systems specialist 7)

Apply now

Location

remote, OR, United States

Salary

$82k – $124k/yr

Commitment

Full Time

Level

Middle (2-4 years)

Required skills

Microsoft SQL ServerAzure SQL DatabaseDatabase administrationPerformance tuningBackup and recoveryT-SQLPowerShellAzure Data FactoryAzure Synapse AnalyticsData modelingInfrastructure-as-codeCI/CD pipelinesDisaster recoverySecurity complianceTroubleshootingTechnical leadership

Job Description

Opportunity Awaits, Apply Today!

The role of an Information Systems Specialist 7 (ISS 7) is to provide advanced technical expertise and leadership in analyzing, planning, developing, integrating, implementing, and maintaining database management system (DBMS) infrastructure. This position ensures that information systems operate efficiently, securely, and reliably while supporting organizational needs and business objectives.

The ISS 7 also works closely with vendors and contracted personnel to evaluate new technologies, oversee project deliverables, negotiate contract modifications, and ensure compliance with contract specifications. As an advanced professional-level position, it requires strong technical knowledge, independent decision-making, problem-solving skills, and the ability to coordinate complex IT projects and infrastructure improvements.

What We Are Looking For

Minimum Qualifications:

These qualifications must be visible in your application for consideration.

  • (a) Six (6) years of information systems experience in: Experience in enterprise database administration, including the installation, configuration, monitoring, maintenance, performance tuning, backup and recovery, security, and troubleshooting of Microsoft SQL Server or comparable relational database management systems in on-premises, cloud, or hybrid environments.
  • (b) 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: Experience in enterprise database administration, including the installation, configuration, monitoring, maintenance, performance tuning, backup and recovery, security, and troubleshooting of Microsoft SQL Server or comparable relational database management systems in on-premises, cloud, or hybrid environments.
  • (c) A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience in: Experience in enterprise database administration, including the installation, configuration, monitoring, maintenance, performance tuning, backup and recovery, security, and troubleshooting of Microsoft SQL Server or comparable relational database management systems in on-premises, cloud, or hybrid environments.
  • (d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

Desired Attributes:

The following are skills and lived experiences that we have identified as key to success in this role at OHA. These are the attributes we are looking for in our top candidate. If you possess any of these, please let us know in your application.

  • Demonstrated experience administering enterprise Microsoft SQL Server environments, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
  • Experience designing, implementing, and maintaining highly available and disaster-resilient database environments, including backup and recovery, failover clustering, replication, and business continuity planning.
  • Strong knowledge of database performance monitoring, troubleshooting, query optimization, indexing, capacity planning, and maintaining data integrity across complex enterprise environments.
  • Experience planning and executing database installations, upgrades, patching, migrations, and modernization initiatives, including applying database design, data modeling, and metadata management standards.
  • Experience supporting Azure data platform services, including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, Azure Databricks, Microsoft Purview, and related data integration technologies.
  • Knowledge of database security and regulatory compliance, including role-based access controls, encryption, auditing, vulnerability management, and applicable security requirements such as HIPAA, CJIS, and state information security standards.
  • Proficiency in T-SQL, PowerShell, and database administration automation, with experience using source control, infrastructure-as-code, CI/CD pipelines, and controlled deployment processes.
  • Demonstrated ability to independently resolve complex technical issues, provide technical guidance and mentoring, develop clear documentation, and communicate effectively with technical teams, business programs, vendors, and leadership.

Special Requirements:

To be hired, you must have a criminal records and driving records check that meets OHA criteria at the time of hire, and throughout employment.

Preference Statement:

Preference may be given to candidates who demonstrate substantial hands-on experience administering, supporting, and modernizing enterprise Microsoft SQL Server and Azure SQL environments, particularly those supporting mission-critical systems with complex availability, performance, security, and compliance requirements.

Application Guidance

How to Apply: Submission Requirements - At the time of application, ensure the work history in your applicant profile is up to date and attach a current copy of your resume, cover letter, and answer all supplemental questions.

External Candidates: Visit the State of Oregon job opportunities webpage to submit your application. Be sure to follow all application submission requirements.

Internal Candidates: Current State of Oregon employees must apply through their employee Workday login. Be sure to follow all application submission requirements.

Benefits of Joining Our Team

We offer a workplace that balances productivity with enjoyment; promote an atmosphere of mutual respect, dedication, and enthusiasm. You will collaborate with a team of bright individuals to work with and learn from. If you're driven by the passion to do something meaningful that changes lives, the Oregon Health Authority is the place for you. We also offer a competitive benefits package including:

  • Excellent medical, vision, and dental benefits package for the employee and qualified family members with a very low monthly out-of-pocket cost.
  • Optional life insurance, short-term disability, long-term disability, deferred compensation savings program, and flexible spending accounts for health care and childcare expenses.
  • Employee benefits include 11 paid holidays, 3 personal business days, 8 hours of monthly sick leave, and vacation accrual starting at 8 hours per month.
  • Possible eligibility for the Public Service Loan Forgiveness Program.
  • Membership in the Public Employees Retirement System (PERS)/Oregon Public Service Retirement Plan (OPSRP).
  • Training opportunities that will help grow your career with the State of Oregon.

Additional Details

The information in your application will be used to complete an Equal Pay Analysis to determine salary placement upon hire. Visit the Department of Administrative Services Equal Pay Analysis Webpage for more information.

The salary listed is the non-PERS qualifying salary range. If the successful candidate is PERS qualifying, the salary range will reflect the additional 6.95%. Review the Classification and Compensation page for more details on the classification.

Agency does not offer visa sponsorship. Within three days of hire, applicants will be required to complete I-9 documentation and confirm authorization to work in the United States. If your employment authorization and documentation is contingent on sponsorship now or in the future, you will not meet Agency employment eligibility standards.

Ready to join the team?

Apply now

Similar Jobs: