Database Analyst; Information Systems Specialist

Position Title:

Database Analyst (Information Systems Specialist
7)

Position Type:
Employee

Organization:
Oregon Health Authority (OHA)

Salary Range: $6,846 - $10,344

Location:

Salem, Oregon (remote)

Work Hours:

Full-time, permanent

• Information Systems Specialist 7 (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.
• Information Systems Specialist 7 (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.
• Information Systems Specialist 7 (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.
• Information Systems Specialist 7 (d) Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

• 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, Power Shell, 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.

Preference may be given to candidates who demonstrate substantial hands‑on experience administering, supporting, and…