Remote-Ready Cloud Database Architect – Azure & Snowflake

Multnomah County; Portland (OR); Hybrid; USD 86,788 - 106,075; Full time

Job summary

Multnomah County is seeking a Senior Database Administrator to lead the transition from on-prem to cloud, focusing on Azure and Snowflake. The role emphasizes data security, optimization, and preparing our data systems for the future.

You will manage SQL servers daily, design backups, mentor staff, and collaborate on BI projects, including Tableau Server and Power BI Server. Telework is routine with onsite meetings.

Qualifications

• Bachelor’s degree or equivalent years of experience required.
• 5 years of database administration experience (or equivalent training).
• Advanced knowledge of Azure Cloud services such as Azure SQL Managed Instance/Database, Data Lake, Data Factory, DevOps, Boards, etc.
• Advanced knowledge of data warehousing and BI data marts.
• Experience building ETLs for reporting with developers.
• Proficiency with database logging tools (Idera, RedGate Monitor, Splunk).
• Working knowledge of BI reporting platforms: Tableau, Tableau Server, Power BI, Power BI Report Server, SSRS.
• Expertise in installing, tuning, securing, and administering on-prem MS SQL Server and cloud environments.
• Experience with SSIS and Microsoft Integration Services.
• Familiarity with AD and Azure Entra ID security.
• Knowledge of backup/recovery design for MS SQL Server and Azure.
• Basic knowledge of networking, Windows Server admin, SAN/NAS storage, virtualization, and HA technologies.
• Scripting skills in T-SQL, C#, WMI, PowerShell.

Responsibilities

• Manage SQL servers and databases daily with proper configuration and storage.
• Lead migration to cloud platforms; redesign storage from on-prem to Azure and Snowflake.
• Design and implement backup and recovery plans for rapid data restoration.
• Identify performance bottlenecks and optimize for efficiency.
• Mentor IT staff; troubleshoot complex issues and educate on new tools.
• Apply latest patches and updates; stay informed on emerging technologies.
• Collaborate on Snowflake projects to migrate BI data from on-prem SQL servers.

Skills

Analytical thinking

Excellent communication

Curious learner

Team player

Education

Bachelor’s degree or equivalent years of experience

Tools

Azure SQL Managed Instance

Azure SQL Database

Azure Data Lake

Azure Data Factory

Azure DevOps

Azure Boards

SSIS / Microsoft Integration Services

Microsoft SQL Server (on-prem & cloud)

Snowflake

Tableau Server

Power BI

Power BI Report Server

SSRS Server

Idera

RedGate Monitor

Splunk

Tableau

ETL tools

Active Directory

Azure Entra ID

C#

PowerShell

Job description

Multnomah County is seeking a Senior Database Administrator to lead the transition from on-prem to cloud, focusing on Azure and Snowflake. The role emphasizes data security, optimization, and preparing our data systems for the future.

You will manage SQL servers daily, design backups, mentor staff, and collaborate on BI projects, including Tableau Server and Power BI Server. Telework is routine with onsite meetings.