Senior Database Administrator

Current employees: Please apply through the employee portal to be considered for this opportunity.Pay Range:$62.73 - $77.16 HourlyDepartment:Department of County Assets (DCA)Job Type:Regular RepresentedExemption Status:United States of America (Non-Exempt)Closing Date (Open Until Filled if No Date Specified):The Opportunity:This recruitment is Open Until Filled and may close at anytime. Applicants should apply without delay. OVERVIEW Are you an experienced Senior Database Administrator with practical working knowledge in both Azure cloud and either Snowflake or with Tableau Server, Power BI Server and SSRS Server?Are you a Senior Database Administrator that is passionate about building the SQL platforms that enable Business Intelligence?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.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 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.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 find the root cause of the issue and 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.TO QUALIFY We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying. Please be clear and specific in your application about how your background is relevant to this role.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 certificationsTo be considered you must fill out this questionnaireLINK TO QUESTIONNAIRESCREENING AND EVALUATION The Application Packet: 1. A completed online application. 2. A resume covering your relevant experience and education. 3. A cover letter that expands on your resume and addresses 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 a review of training by a subject matter expert, a technical screening interview or 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: This is an hourly, AFSCME Local 88 union-represented position and is eligible for overtime. Work Location: The official work location is the Multnomah Building, 501 SE Hawthorne Blvd., Portland, OR 97214. Telework Schedule: This position is designated for Routine Telework, meaning you will work primarily from home. However, you will be required to attend routine team meetings, performance coaching, and other required onsite meetings. A variety of work schedules are available. Some examples: 5-8s: 8 hours a day Monday through Friday 4-10s: 10 hours a day Monday through Thursday 4-10s: 10 hours Tuesday through Friday 4-9-4: 9 hours a day Monday through Thursday 4 hours on Friday. Etc… Residency: All employees must reside in Oregon or Washington.Visa Sponsorship: We are unable to sponsor work visas (H-1B, F-1 PT, STEM OP). Equal Pay Law: Please be advised that the pay range listed for this position is intended to provide general guidance on the earning potential for the role. However, actual compensation will be determined in accordance with the Oregon Equal Pay Law and will take into account factors such as the candidate's relevant experience, education,seniority, training, and/or tenure. Candidates should expect that initial offers will be made within the listed pay range and may not be at or near the top of the range. Our Commitment to Safety, Trust, and Belonging:Multnomah County is dedicated to developing and improving workforce equity. We are committed to creating a workplace where everyone can reach their full potential by addressing structural and policy barriers to equal opportunity. Our work is guided by the 2024-2028 Workforce Equity StrategicPlan, a roadmap created by employees to ensure an inclusive and racially just environment for all. Serving the Public During Disasters Every day, Multnomah County staff work together to serve as a safety net for our communities. During a disaster, this safety net becomes even more critical. All County employees have a role in serving the public during inclement weather, natural disasters, or other types of community emergency responses. You may ultimately be reassigned from your current position to a role in the emergency response to support the critical needs presented by our communities.In accordance with Oregon Law, Multnomah County is not collecting school attendance dates in the initial application process; please do not include these dates in your resume, cover letter and other application materials.Diversity and Inclusion: At Multnomah County, we don't just accept difference; we value it and support it to create a culture of dignity and respect for our employees.We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO Know Your Rights poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals.Veterans’ Preference: Under Oregon Law, qualifying veterans may apply for veterans’ preference. Review our veterans’ preference page for details about eligibility and how to apply.Accommodation under the Americans with Disabilities Act: We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711.Questions?Recruiter:Patsy MousheyEmail:View email address on click.appcast.io:+1 (503) 5459067Application information may be used throughout the entire selection process. This process is subject to change without notice.Disclaimer: This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract.Job Profile:6408 - Database Administrator SeniorSummaryLocation: Portland, ORType: Full time