Senior Database Administrator

Multnomah County • Portland, OR

1d • $61 - $75 • Hybrid

About The Position

Are you a Senior Database Administrator with deep expertise in Snowflake and Azure Cloud? Join Multnomah County as a Senior Database Administrator (DBA) to lead our transition from on-premise servers to a modern cloud architecture. We are seeking a technical lead to ensure our data systems are secure, optimized, and ready for the future. Please read the Minimum Qualifications for all of the requirements for this position. In this role, you will: Keep things running: You will manage our 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, Google GCP and AWS. 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. Draw the blueprints: Using data modeling tools, you will create the maps that show how all our different pieces of information fit together. 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 tech As a person, you are: Service-minded: You believe in acting with integrity and making sure our work helps everyone in the community fairly. A great communicator: You can take complicated technical ideas and explain them clearly to teammates and other departments. A natural learner: You are curious and adapt quickly when technology changes. A careful problem-solver: You don't just look for a quick fix; you look at the whole picture to find the best long-term solution. A team player: You enjoy building relationships and working side-by-side with others to get the job done. The Team: You will be joining the IT Division within the Department of County Assets (DCA). Led by IT Manager Michelle Smith, our seasoned team focuses on providing the technical support that keeps the whole County moving. We are currently in the middle of a major shift to more modern cloud-based tools, and we are looking for someone who is as excited about this evolution as we are.

Requirements

• Bachelor's degree or equivalent years of experience will be considered AND 5 years of experience in IT development and database administration. (Equivalency 9 years of qualifying training and/or experience).
• 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).
• Working knowledge of or skill with Snowflake.
• 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.

Nice To Haves

• Tableau Server Administration
• Power BI Server Administration

Responsibilities

• Manage databases daily, ensuring sufficient space and correct setup.
• Lead the redesign of data storage, transitioning from on-site setups to cloud technology like Azure, Google GCP and AWS.
• Design plans for data backup and quick recovery.
• Identify and fix bottlenecks to improve system speed.
• Create data maps using data modeling tools.
• Mentor IT staff, assisting with coding problems and database tools.
• Keep software updated with the latest patches and stay informed about new tech trends.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level