What are the responsibilities and job description for the IT Database Administrator Senior position at Multnomah County?
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) :
January 28, 2025
The Opportunity :
Please be advised that this recruitment will close once we have received 100 applications.
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
Software Installation, Upgrades, and Innovation
You will be successful in this role if you :
A Little About Us : Multnomah County IT is one of the most innovative government IT organizations in the nation, dynamically aligning itself with emerging industry trends. We are a group of creative, smart, and talented people who foster an inclusive environment of collaboration and fun. Our strength is the diversity of our people.
To Qualify
We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant.
Minimum Qualifications / Transferable Skills :
Required Knowledge, Skills and Abilities (KSAs) for this role :
Screening and Evaluation
The Application Packet :
Note : The application, resume and cover letter should demonstrate your work experience / skills and how it is related to those shown in the Overview and To Qualify sections of the job announcement. Please be thorough, as these materials will be scored and determine your eligibility for an intervi ew.
The Selection Process : For details about how we typically screen applications, review our overview of the selection process page. We expect to evaluate candidates for this recruitment as follows :
Additional Information :
This recruitment may be used to fill full-time, part-time, temporary, limited duration and on-call positions.
Routine Telework : This position is designated as "routine telework," meaning you will be working remotely (from home); a hybrid schedule also is available. As with all routine telework positions, employees may be required to come into the office on occasion. The designation of Routine Telework may be subject to change at a future time. All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. We are not able to sponsor H1-B visas.
Type of Position : This is an hourly, AFSCME Local 88 union-represented position and is eligible for overtime.
Location : This position is located in the Multnomah Building, 501 SE Hawthorne Blvd. See above for information about teleworking.
Schedule : A variety of work schedules are available. Some examples :
Serving the Public, Even During Disasters
Everyday, 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 disaster, or other types of community emergency response. During these emergency responses, while typically there begins with a call for volunteers, county employees may ultimately be reassigned from their current position to a role in the emergency response in order to support the critical needs presented by our communities. For more information, please visit the Disaster Service Worker Information page.
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 : Allison Conkling
Email :
allison.conkling@multco.us
Phone :
Application 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 Senior
Salary : $59 - $73
