Senior Database Administrator
Multnomah County, Portland, OR, United States
Overview
The Opportunity:
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, ensuring space and correct setup for the team.
Lead our move to the cloud: you’ll help redesign data storage, shifting from on-site setups to modern cloud technology like Azure, Google GCP, and AWS.
Protect our data: design backup plans and ensure rapid recovery if needed.
Fix and improve: identify bottlenecks and optimize performance.
Draw the blueprints: create data models showing how information fits together.
Help the team: mentor IT staff, solve tricky coding problems, and teach new database tools.
Stay updated: keep software current with updates and patches and learn about new tech trends.
As a person, you are:
Service-minded: act with integrity and ensure work benefits the community fairly.
A great communicator: explain complex ideas clearly to teammates and other departments.
A natural learner: curious and adaptable to changing technology.
A careful problem-solver: consider the whole picture for long-term solutions.
A team player: enjoy building relationships and working with others to get the job done.
The Team:
You will join the IT Division within the Department of County Assets (DCA). Led by IT Manager Michelle Smith, the team focuses on providing technical support to keep the County moving. We are undergoing a shift to cloud-based tools and seek someone excited about this evolution.
To Qualify
We consider any combination of relevant work experience, volunteering, education, and transferable skills. Please be clear and specific about how your background relates to this role.
Minimum Qualifications/Transferable Skills:
Bachelor’s degree or equivalent years of experience will be considered.
5 years of experience in IT development and database administration (Equivalency: 9 years of qualifying training and/or experience).
This position requires specialized knowledge. Demonstrate KSAs listed below.
Knowledge, Skills, and Abilities (KSAs):
Advanced knowledge of Azure Cloud services (Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, etc.).
Working knowledge of Snowflake.
Advanced knowledge of BI Data Marts and Data Warehousing, including design and best practices.
Experience working with developers to build ETLs for reporting.
Advanced knowledge of database logging tools (e.g., Idera, RedGate Monitor, Splunk).
Working knowledge of BI reporting platforms (Tableau, Tableau Server, Power BI, Power BI Report Server, SSRS).
Advanced knowledge of installing, tuning, maintaining, securing, and administering an on-prem MS SQL Server database and cloud environments.
Working knowledge of MS SSIS environment installations and maintenance.
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, firewall concepts, and Windows Server administration.
Basic knowledge of SAN/NAS storage, virtualization (Hyper-V/VMWare), and high availability technologies.
Advanced knowledge of RDBMS management tools (MS SQL Server Management Studio).
Working knowledge of SQL Server development (T-SQL) including stored procedures, queries, functions, views, indexes, and triggers.
Working knowledge of database modeling, data conversion, and ETL tools (e.g., SSIS).
Basic knowledge of administrative scripting (C#, WMI, PowerShell, Rs Utility, MSBuild).
Ability to pass a criminal records check.
Preferred Qualifications:
Tableau Server Administration
Power BI Server Administration
Screening and Evaluation The Application Packet:
A completed online application.
A resume covering relevant experience and education.
A cover letter addressing how you meet the minimum qualifications and why you are interested in this position.
The Selection Process:
Initial review of minimum qualifications.
Assessment of candidates, which may include training review, a technical screening, or an exam.
Consideration of top candidates, which may include panel interviews and a final hiring interview.
Reference and background checks for finalists.
Additional Information
Type of Position:
Hourly, AFSCME Local 88 union-represented, overtime eligible.
Work Location:
Multnomah Building, 501 SE Hawthorne Blvd., Portland, OR 97214.
Telework Schedule:
Routine Telework; primarily from home with required onsite meetings.
Residency: All employees must reside in Oregon or Washington.
Visa Sponsorship:
We are unable to sponsor work visas (H-1B, F-1 OPT, STEM OPT).
Equal Pay Law:
The pay range listed provides general guidance. Actual compensation will comply with the Oregon Equal Pay Law and consider experience, education, seniority, training, and tenure. Offers may be within the range and not at the top.
Commitment to Safety, Trust, and Belonging:
Multnomah County aims for workforce equity and an inclusive, racially just environment, guided by the 2024-2028 Workforce Equity Strategic Plan.
Serving the Public During Disasters:
County staff serve as a safety net for communities during emergencies; roles may be reassigned to support critical needs.
In Accordance with Oregon Law:
Multnomah County is not collecting school attendance dates in the initial application process; do not include these dates in resumes or cover letters.
Diversity and Inclusion:
We value diversity and are an Equal Opportunity Employer. The EEO Know Your Rights poster is available. We are a VEVRAA Federal Contractor and seek priority protected veteran referrals.
Veterans’ Preference:
Eligible veterans may apply for veterans’ preference. See our veterans’ preference page for details.
Accommodation under the Americans with Disabilities Act:
We provide reasonable accommodation for applicants with disabilities. Contact the recruiter to request assistance. Telecommunications Relay Service is available at 711.
Questions?
Recruiter:
Allison Conkling
Email:
allison.conkling@multco.us
Phone:
+1 (503) 260-4572
Application information may be used throughout the selection process. This process is subject to change without notice. Disclaimer: This announcement is a general recruitment guide and may change.
Job Profile:
6408 - Database Administrator Senior
#J-18808-Ljbffr
The Opportunity:
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, ensuring space and correct setup for the team.
Lead our move to the cloud: you’ll help redesign data storage, shifting from on-site setups to modern cloud technology like Azure, Google GCP, and AWS.
Protect our data: design backup plans and ensure rapid recovery if needed.
Fix and improve: identify bottlenecks and optimize performance.
Draw the blueprints: create data models showing how information fits together.
Help the team: mentor IT staff, solve tricky coding problems, and teach new database tools.
Stay updated: keep software current with updates and patches and learn about new tech trends.
As a person, you are:
Service-minded: act with integrity and ensure work benefits the community fairly.
A great communicator: explain complex ideas clearly to teammates and other departments.
A natural learner: curious and adaptable to changing technology.
A careful problem-solver: consider the whole picture for long-term solutions.
A team player: enjoy building relationships and working with others to get the job done.
The Team:
You will join the IT Division within the Department of County Assets (DCA). Led by IT Manager Michelle Smith, the team focuses on providing technical support to keep the County moving. We are undergoing a shift to cloud-based tools and seek someone excited about this evolution.
To Qualify
We consider any combination of relevant work experience, volunteering, education, and transferable skills. Please be clear and specific about how your background relates to this role.
Minimum Qualifications/Transferable Skills:
Bachelor’s degree or equivalent years of experience will be considered.
5 years of experience in IT development and database administration (Equivalency: 9 years of qualifying training and/or experience).
This position requires specialized knowledge. Demonstrate KSAs listed below.
Knowledge, Skills, and Abilities (KSAs):
Advanced knowledge of Azure Cloud services (Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, etc.).
Working knowledge of Snowflake.
Advanced knowledge of BI Data Marts and Data Warehousing, including design and best practices.
Experience working with developers to build ETLs for reporting.
Advanced knowledge of database logging tools (e.g., Idera, RedGate Monitor, Splunk).
Working knowledge of BI reporting platforms (Tableau, Tableau Server, Power BI, Power BI Report Server, SSRS).
Advanced knowledge of installing, tuning, maintaining, securing, and administering an on-prem MS SQL Server database and cloud environments.
Working knowledge of MS SSIS environment installations and maintenance.
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, firewall concepts, and Windows Server administration.
Basic knowledge of SAN/NAS storage, virtualization (Hyper-V/VMWare), and high availability technologies.
Advanced knowledge of RDBMS management tools (MS SQL Server Management Studio).
Working knowledge of SQL Server development (T-SQL) including stored procedures, queries, functions, views, indexes, and triggers.
Working knowledge of database modeling, data conversion, and ETL tools (e.g., SSIS).
Basic knowledge of administrative scripting (C#, WMI, PowerShell, Rs Utility, MSBuild).
Ability to pass a criminal records check.
Preferred Qualifications:
Tableau Server Administration
Power BI Server Administration
Screening and Evaluation The Application Packet:
A completed online application.
A resume covering relevant experience and education.
A cover letter addressing how you meet the minimum qualifications and why you are interested in this position.
The Selection Process:
Initial review of minimum qualifications.
Assessment of candidates, which may include training review, a technical screening, or an exam.
Consideration of top candidates, which may include panel interviews and a final hiring interview.
Reference and background checks for finalists.
Additional Information
Type of Position:
Hourly, AFSCME Local 88 union-represented, overtime eligible.
Work Location:
Multnomah Building, 501 SE Hawthorne Blvd., Portland, OR 97214.
Telework Schedule:
Routine Telework; primarily from home with required onsite meetings.
Residency: All employees must reside in Oregon or Washington.
Visa Sponsorship:
We are unable to sponsor work visas (H-1B, F-1 OPT, STEM OPT).
Equal Pay Law:
The pay range listed provides general guidance. Actual compensation will comply with the Oregon Equal Pay Law and consider experience, education, seniority, training, and tenure. Offers may be within the range and not at the top.
Commitment to Safety, Trust, and Belonging:
Multnomah County aims for workforce equity and an inclusive, racially just environment, guided by the 2024-2028 Workforce Equity Strategic Plan.
Serving the Public During Disasters:
County staff serve as a safety net for communities during emergencies; roles may be reassigned to support critical needs.
In Accordance with Oregon Law:
Multnomah County is not collecting school attendance dates in the initial application process; do not include these dates in resumes or cover letters.
Diversity and Inclusion:
We value diversity and are an Equal Opportunity Employer. The EEO Know Your Rights poster is available. We are a VEVRAA Federal Contractor and seek priority protected veteran referrals.
Veterans’ Preference:
Eligible veterans may apply for veterans’ preference. See our veterans’ preference page for details.
Accommodation under the Americans with Disabilities Act:
We provide reasonable accommodation for applicants with disabilities. Contact the recruiter to request assistance. Telecommunications Relay Service is available at 711.
Questions?
Recruiter:
Allison Conkling
Email:
allison.conkling@multco.us
Phone:
+1 (503) 260-4572
Application information may be used throughout the selection process. This process is subject to change without notice. Disclaimer: This announcement is a general recruitment guide and may change.
Job Profile:
6408 - Database Administrator Senior
#J-18808-Ljbffr