Senior Database Administrator

Multnomah County; Portland (OR); On-site; 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

Pay Range: $62.73 - $77.16 hourly
Department: Department of County Assets (DCA)
Job Type: Regular
Exemption Status: United States of America (Non-Exempt)
Closing Date: July 16, 2026

OVERVIEW

You are an experienced Senior Database Administrator with practical knowledge in Azure cloud and either Snowflake or BI platforms such as Tableau Server, Power BI Server, and SSRS Server. Join Multnomah County as a Senior Database Administrator to lead the transition from on‑premise servers to a modern cloud architecture while ensuring our data systems are secure, optimized, and future‑ready.

Responsibilities

• Manage SQL servers and databases daily, ensuring proper configuration and sufficient storage.
• Lead the migration to cloud platforms, redesigning data storage from on‑prem to Azure and Snowflake.
• Design and implement backup and recovery plans to guarantee rapid data restoration.
• Identify performance bottlenecks and implement optimizations for maximum efficiency.
• Serve as a mentor for IT staff, troubleshooting complex issues and educating on new database tools.
• Apply the latest patches and updates to keep software secure, while staying informed on emerging technologies.
• Collaborate on Snowflake projects to migrate business‑intelligence data from on‑prem SQL servers.

Desired Personal Qualities

• Service‑mindful, acting with integrity to benefit the community.
• Excellent communicator, simplifying complex technical concepts for diverse audiences.
• Curious learner, quickly adapting to technology changes.
• Analytical problem‑solver, focusing on root causes and long‑term solutions.
• Team player who builds collaborative relationships.

Minimum Qualifications

• Bachelor’s degree or equivalent years of experience.
• 5 years of database administration experience (equivalent to 9 years of qualifying training and/or experience).
• Advanced knowledge of Azure Cloud services (Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, etc.).
• Advanced knowledge of data‑warehousing and business‑intelligence 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 Active Directory and Azure Entra ID security.
• Knowledge of backup and recovery design for MS SQL Server and Azure environments.
• Basic knowledge of networking, firewall concepts, Windows Server administration, SAN/NAS storage, virtualization (Hyper‑V or VMWare), and high‑availability technologies.
• Skills in T‑SQL development, database modeling, ETL tools, and scripting (C#, WMI, PowerShell).
• Ability to pass a criminal records check.

Preferred Qualifications

• Snowflake Platform Administration
• Tableau Server Administration
• Power BI Server Administration
• Current Microsoft certifications
• Current Snowflake certifications

Application Requirements

• Completed online application.
• Resume detailing relevant experience and education.
• Cover letter addressing how you meet the minimum qualifications and why you are interested.
• Provide current Microsoft and/or Snowflake certifications if applicable.

Work Location & Telework

Official location: Multnomah Building, 501 SE Hawthorne Blvd., Portland, OR 97214. Telework: Routine Telework with expected onsite meetings. Residency requirement: Must reside in Oregon or Washington.

Equal Pay & EEO Statement

The pay range is for general guidance; final compensation follows the Oregon Equal Pay Law and considers experience, education, seniority, training, and tenure. Multnomah County is an Equal Opportunity Employer. Qualified applicants are evaluated without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other protected characteristic. Please refer to our EEO poster for more information.