IT Senior Database Administrator
IT Senior Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Current employees: Please apply through the employee portal to be considered for this opportunity.
Pay Range:
$59.19 $72.85 HourlyDepartment:
Department of County Assets (DCA)Job Type:
Regular RepresentedExemption Status:
United States of America (NonExempt)Closing Date (Open Until Filled if No Date Specified):
April 23 2025
The Opportunity:
Please be advised that this recruitment will close once we have received 150 applications.
All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. WE ARE UNABLE TO SPONSOR WORK OR STUDENT VISAS. No exceptions.
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 Were looking for a Senior Database Administrator to join our team and help advance the Countys 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 OnPrem servers as well as databases in the Azure Cloud and in Snowflake.
In this role youll be doing more than just maintaining databasesyoull be solving complex problems driving innovation and helping shape the future of how we manage and use data. Youll work on both daytoday production support and exciting new projects including redesigning our Data Warehouses to run on platforms like Azure Cloud and Snowflake.
Were looking for someone whos experienced with onpremises 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 youre 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 largescale databases and data warehousing.
Perform database architecture and develop technical standards for largescale 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
Define performance tuning goals and objectives.
Monitor database performance and identify bottlenecks.
Recommend and perform optimizations for applications databases I/O and OS.
Participate in application system performance tests to ensure optimal performance.
Troubleshoot performance issues and optimize database functionality.
Software Installation Upgrades and Innovation
Install database software SQL Server and Windows patches.
Set up server directory structures to support database administration.
Develop project plans for installing new software releases or patches.
Install and test new database software releases and patches.
Plan and perform database upgrades and changes (onprem and cloud).
Stay updated on new trends and innovations in database technology.
Evaluate and participate in the purchase of thirdparty vendor database products or tools.
Provide primary or backup support for managing SQL Server and Azure Cloud environments.
You will be successful in this role if you:
Are creative and innovative: You actively seek opportunities to improve processes and foster a work environment of imagination and critical thinking.
Adept with navigating change: You accept change as an inevitable part of work and adapt plans as needed. You demonstrate selfawareness and emotional self regulation and readily offer support and encouragement to others.
A strong communicator: You are clear timely and effective in sharing information.
An equity promoter: You contribute to an inclusive workplace where diversity is valued and leveraged to achieve the organizations goals.
Are adaptable: You actively seek additional knowledge in order to understand and obtain relevant information and improve outcomes.
Are empathetic: You have a Think Yes attitude actively seek feedback to understand customer needs focus on collaboration and respond promptly to requests.
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:
Bachelors degree or equivalent years of experience will be considered AND
5 years of experience in IT development and database administration
Ability to pass a criminal history record check
The specific knowledge skills and abilities (KSAs) listed below.
All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. WE ARE UNABLE TO SPONSOR WORK OR STUDENT VISAS. No exceptions.
Required Knowledge Skills and Abilities (KSAs) for this role:
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).
Working knowledge of or skill with Snowflake.
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 will 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 HyperV 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 (TSQL) 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).
Screening and Evaluation
The Application Packet:
A completed online application.
A resume covering relevant experience and education. Please be sure your resume includes the following for each employer: name of employer location dates of employment your title a brief summary of your responsibilities the number of employees under your supervision.
A cover letter that expands on your resume addresses why you are interested in this position and demonstrates how your experience and skill set aligns with the minimum and preferred qualifications listed.
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:
Initial review of minimum qualifications: We may do an additional preferred review and/or send out additional supplemental questions to identify those highest qualified.
Evaluation of technical knowledge skills and abilities: There is a virtual scored evaluation session with the hiring manager to review the required technical skills and knowledge for this position.
Consideration of top candidates: We will consider qualified candidates in order of rank and score from the list of eligible candidates. This may include panel interview(s) a hiring interview and/or additional testing to determine the best candidates for a position.
Background check and reference checks: All finalists must pass a thorough a criminal record check and reference check.
Additional Information:
This recruitment may be used to fill fulltime parttime temporary limited duration and oncall 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 UNABLE TO SPONSOR WORK OR STUDENT VISAS. No exceptions.
Type of Position: This is an hourly AFSCME Local 88 unionrepresented 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:
58s: 8 hours a day Monday through Friday
410s: 10 hours a day Monday through Thursday
410s: 10 hours Tuesday through Friday
494: 9 hours a day Monday through Thursday 4 hours on Friday. Etc
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 dont 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 ConklingEmail:
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 SeniorRequired Experience:
Senior IC
Employment Type
Full-Time
