IT Database Administrator Senior

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

Pay Range:

$59.19 - $72.85 Hourly

Department:

Department of County Assets (DCA)

Job Type:

Regular Represented

Exemption Status:

United States of America (Non-Exempt)

Closing Date (Open Until Filled if No Date Specified):

March 12, 2025

The Opportunity:

Please be advised that this recruitment will close once we have received 150 applications.

All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. 

**WE ARE UNABLE TO SPONSOR WORK OR STUDENT VISAS.

Overview

This Work Matters…

Help Us Turn Data into Impactful Change!

Are you someone who loves working with data and creating solutions that make a real difference? We're looking for a Senior Database Administrator to join our team and help advance the County’s Business Intelligence and Data Warehousing platforms. We are focused on the successful adoption of Business Intelligence tools throughout the county. The officially supported BI tools are: SQL Server Reporting Services (SSRS), Tableau, and Power BI. We have On-Prem servers as well as databases in the Azure Cloud and in Snowflake.

In this role, you'll be doing more than just maintaining databases—you’ll be solving complex problems, driving innovation, and helping shape the future of how we manage and use data. You’ll work on both day-to-day production support and exciting new projects, including redesigning our Data Warehouses to run on platforms like Azure Cloud and Snowflake.

We’re looking for someone who’s experienced with on-premises SQL servers, loves diving into the details, and is ready to take on the challenge of working with cloud technologies like Azure and Snowflake. If you’re someone who gets excited about making systems faster, smarter, and more scalable, this is the perfect opportunity for you.

Join us in building something that matters and will have a lasting impact on our community.

The job responsibilities include:

Database Administration and Maintenance

• Develop large-scale databases and data warehousing.

• Perform database architecture and develop technical standards for large-scale databases for our data warehouses (SQL Server, Azure, and Snowflake).

• Manage and maintain SQL Server and Cloud (Azure, Snowflake, etc) databases for development, testing, and production.

• Administer database components (e.g., tablespaces, tables, indexes) and ensure security.

• Design, implement, and manage database backups, restoration, and recovery processes.

• Configure network connections and manage storage requirements.

• Develop and schedule maintenance jobs and scripts to support database activities.

• Standardize naming conventions and oversee database migrations.

• Provide consulting and support for IT projects involving database solutions.

• Provide technical assistance to IT developers and users.

• Offer guidance on SQL tuning and error debugging.

• Assist in troubleshooting complex SQL statements and database problems.

• Provide training as appropriate.

• Assist with the installation of database client software.

• Participate in data quality efforts and architecture design.

• Migrate data between databases.

• Participate in database SQL code walkthroughs.

Tableau Server Admin and PBIRS Server Admin

Database Performance Tuning

• Define performance tuning goals and objectives.

• Monitor database performance and identify bottlenecks.

• Recommend and perform optimizations for applications, databases, I/O, and OS.

• Participate in application system performance tests to ensure optimal performance.

• Troubleshoot performance issues, and optimize database functionality.

Software Installation, Upgrades, and Innovation

• Install database software, SQL Serve