[Hiring] Database Analyst @State of Oregon

Role Description

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
• 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.

If this opportunity aligns with your strengths, background, and commitment to fostering inclusivity, we encourage you to apply!

Qualifications

• Six (6) years of information systems experience in enterprise database administration, including:
• 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.
• 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 enterprise database administration.
• OR a Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience in enterprise database administration.
• OR a Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

Requirements

• 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.
• 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.
• Proficiency in T-SQL, PowerShell, and database administration automation.
• 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.

Benefits

• 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.