Senior Database Administrator
About The Position
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 Senior Database Administrator to ensure our data systems are secure, optimized, and ready for the future. In this role, you will manage SQL servers and databases daily, ensuring they have adequate space and are correctly configured. You will lead the redesign of data storage, migrating from on-site setups to cloud technologies like Azure and Snowflake. A key responsibility is designing backup and recovery plans to ensure data can be quickly restored if issues arise. You will also identify and resolve performance bottlenecks to optimize system speed. Additionally, you will mentor other IT staff, assist with complex coding problems, and teach new database tools. Staying current with software updates and patches is crucial, as is continuous learning about new technology trends. You will also collaborate with project teams to migrate business intelligence data from on-prem SQL Servers to the Snowflake platform.
Requirements
- Bachelor's degree or equivalent years of experience.
- 5 years of experience in 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).
- 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
- Snowflake Platform Administration
- Tableau Server Administration
- Power BI Server Administration
- Current Microsoft certifications
- Current Snowflake certifications
Responsibilities
- Manage SQL servers and databases daily, ensuring adequate space and correct configuration.
- Lead the redesign of data storage, migrating from on-site setups to cloud technologies like Azure and Snowflake.
- Design backup and recovery plans to ensure data can be quickly restored if issues arise.
- Identify and resolve performance bottlenecks to optimize system speed.
- Mentor other IT staff, assist with complex coding problems, and teach new database tools.
- Install the latest software updates and patches, and continuously learn about new technology trends.
- Collaborate with project teams to migrate business intelligence data from on-prem SQL Servers to the Snowflake platform.
Benefits
- Eligible for overtime
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
