Database Analyst (Information Systems Specialist 7)

State of Oregon • Salem, OR

8d • $6,846 - $10,344 • Remote

About The Position

The Information Systems Specialist 7 provides advanced technical expertise and leadership in analyzing, planning, developing, integrating, implementing, and maintaining database management system infrastructure. The position ensures information systems operate efficiently, securely, and reliably in support of organizational needs and business objectives.

The role works with vendors and contracted personnel to evaluate new technologies, oversee project deliverables, negotiate contract modifications, and ensure compliance with contract specifications. It requires strong technical knowledge, independent decision-making and problem-solving, and the ability to coordinate complex IT projects and infrastructure improvements. The position is a full-time, permanent, represented SQL DBA Cloud Engineer vacancy with the Oregon Health Authority. It is based in Salem, Oregon, and is remote.

Requirements

• Six years of information systems experience in enterprise database administration; alternatively, an associate degree or a two-year accredited vocational training program in information technology or a related field plus four years of such experience; alternatively, a bachelor's degree in information technology, computer science, or a related field plus two years of such experience. A master's degree in information technology, computer science, or a related field may substitute for these requirements.
• Enterprise database administration experience must include 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.
• Meet OHA criminal-records and driving-records check criteria at hire and throughout employment.
• Submit an up-to-date applicant profile and work history, current resume, cover letter, and responses to all supplemental questions.
• Be authorized to work in the United States; the agency does not offer visa sponsorship.

Nice To Haves

• Hands-on administration of enterprise Microsoft SQL Server environments, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• Designing, implementing, and maintaining highly available and disaster-resilient database environments, including backup and recovery, failover clustering, replication, and business continuity planning.
• Database performance monitoring, troubleshooting, query optimization, indexing, capacity planning, and maintaining data integrity in complex enterprise environments.
• Planning and executing database installations, upgrades, patching, migrations, and modernization, including database design, data modeling, and metadata management standards.
• Supporting Azure data platform services such as Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, Azure Databricks, Microsoft Purview, and related data integration technologies.
• Database security and regulatory compliance knowledge, including role-based access controls, encryption, auditing, vulnerability management, and applicable requirements such as HIPAA, CJIS, and state information security standards.
• Proficiency in T-SQL, PowerShell, and database administration automation; experience with source control, infrastructure-as-code, CI/CD pipelines, and controlled deployment processes.
• 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.
• Experience administering, supporting, and modernizing enterprise Microsoft SQL Server and Azure SQL environments supporting mission-critical systems with complex availability, performance, security, and compliance needs.
• Strong technical problem-solving, cloud database technology experience, ability to manage complex database operations and production issues, implement automation, and contribute to infrastructure modernization.
• Effective communication, sound technical judgment, and ability to collaborate across technical teams while maintaining reliable, secure, and sustainable enterprise database services.

Responsibilities

• Analyze, plan, develop, integrate, implement, and maintain database management system infrastructure.
• Help ensure information systems operate efficiently, securely, and reliably in support of organizational needs and business objectives.
• Work with vendors and contracted personnel to evaluate new technologies, oversee project deliverables, negotiate contract modifications, and ensure compliance with contract specifications.
• Administer enterprise database environments, including installation, configuration, monitoring, maintenance, performance tuning, backup and recovery, security, and troubleshooting.
• Support database infrastructure improvements and complex IT projects.

Benefits

• Medical, vision, and dental benefits for employees and qualified family members.
• Optional life insurance, short-term disability, and long-term disability.
• Deferred compensation savings program and flexible spending accounts for health care and childcare expenses.
• 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 to support career growth.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree