What are the responsibilities and job description for the IT Database Administrator Senior position at Mac's List?
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 (, 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 interview.
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.
