Senior Database Administrator

Multnomah County

Where
Portland, OR
Pay
$62.73 to $77.16 an hour

Posted 3 months ago· Checked live at Multnomah County 3 days ago

Stale: open 100 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what Multnomah County asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Multnomah County's own hiring page 3 days ago.
What is the job?
Current employees: Please apply through the employee portal to be considered for this opportunity. $62.73 - $77.16 Hourly
What does it pay?
$62.73 to $77.16 an hour, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

Current employees: Please apply through the employee portal to be considered for this opportunity.

$62.73 - $77.16 Hourly

Department of County Assets (DCA)

Regular Represented

United States of America (Non-Exempt)

This recruitment is Open Until Filled and may close at anytime. Applicants should apply without delay.

Pay Range

$62.73 - $77.16 Hourly

In this role, you will

● Keep things running: You will manage our sql servers and databases every day, making sure they have enough space and are set up correctly for our team to use.

● Lead our move to the cloud: You’ll help us redesign how we store data, shifting from older on-site setups to modern cloud technology like Azure and Snowflake.

● Protect our data: You will design the plans for backing up information and making sure we can get it back quickly if something goes wrong.

● Fix and improve: You’ll spend time finding bottlenecks that slow us down and fixing them so everything runs as fast as possible.

● Help the team: You’ll be a mentor for other IT staff, helping them solve tricky coding problems or teaching them how to use new database tools.

● Stay updated: You will keep our software safe by installing the latest updates and patches, and you’ll keep learning about new trends in technology.

● Work on Snowflake projects: You will work with our project teams to move business intelligence data from our on prem SQL Servers to our Snowflake platform.

Minimum Qualifications/Transferable Skills

● Bachelor's degree or equivalent years of experience will be considered

AND

● 5 years of experience in database administration. (Equivalency 9 years of qualifying training and/or experience).

● This position requires specialized knowledge. You must demonstrate that you have (KSAs) skills listed below.

Knowledge, Skills, and Abilities (KSAs)

○ Advanced knowledge of or skill in Azure Cloud (Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, etc).

○ Advanced knowledge of or skill with Business Intelligence Data Marts, and Data Warehousing, including design and best practices.

○ Advanced experience working with developers to build ETLs for loading data for reporting.

○ Advanced knowledge of or skill with database logging tools (Ex: Idera, RedGate Monitor, Splunk, etc.).

○ Working knowledge or skill with BI reporting platforms, functionality, and tools (Tableau and Tableau Server, Power BI and Power BI Report Server, SSRS, etc.).

○ Advanced knowledge in installing, performance tuning, maintaining, securing, and administering an on prem MS SQL Server database and Cloud environments.

○ Working knowledge in installing, performance tuning, maintaining, securing, and administering a MS Integration Services (SSIS) environment.

○ Working knowledge of security, authorization, and authentication in Microsoft Active Directory and Azure Entra ID.

○ Working knowledge of MS SQL Server and Azure cloud backup and recovery design and implementation.

○ Basic knowledge of networking and firewall concepts.

○ Basic knowledge of Microsoft Windows Server administration.

○ Basic knowledge of SAN/NAS Storage management and concepts.

○ Basic knowledge of virtualization technology using MS Windows Hyper-V or VMWare.

○ Basic knowledge of MS Windows Server high availability technologies Application Development, architectures, languages, and/or tools.

○ Advanced knowledge of RDBMS management tools including MS SQL Server Management Studio.

○ Working knowledge of or skill in developing on a SQL Server platform using Transact SQL (T-SQL) including stored procedures, query plans, functions, views, indexes, and triggers.

○ Working knowledge of or skill in database modeling, data conversion, and ETL tools, such as SSIS.

○ Basic knowledge of Administrative Scripting (C#, WMI, PowerShell, Rs Utility, MSBuild).

● Ability to pass a criminal records check.

Preferred Qualifications

● Snowflake Platform Administration

● Tableau Server Administration

● Power BI Server Administration

● Please provide your current Microsoft certifications

● Please provide your current Snowflake certifications

To be considered you must fill out this questionnaire