SQL Server Database Administrator (Information Systems Analyst, Principal - GIS Enterprise)

SQL Server Database Administrator (Information Systems Analyst, Principal - GIS Enterprise)

Salary

$114,275.20 - $160,784.00 Annually

Location

Portland Building, 1120 SW 5th Ave, OR

Job Type

Regular

Job Number

2026-00488

Bureau

Bureau of Technology Services

Opening Date

06/15/2026

Closing Date

6/29/2026 11:59 PM Pacific

• Description
• Benefits
• Questions

The Position

Job Appointment: Regular, Full-Time

Typical Schedule: Monday - Friday 8 am - 5 pm, alternate schedule may be available after probation.

Work Location: This position has an exception to work primarily remotely. However, there will be instances when it is necessary to come onsite for work (with as much advance notice as possible). Remote work must be performed within Oregon or Washington. For more information,click here.

Benefit: Please check our benefits tab for an overview of benefits for this position

Language Pay Premium Eligible: This position is or may be eligible for Language Pay Differential for qualifying employees (Include this for classifications identified as eligible or if bureau requests languages)

Union Representation: This position is represented by Professional Technical Employees, Local 17 (PROTEC17). To view this labor agreement, please click here.

Application Material: Please click APPLY to submit your application via the City of Portland's online portal. You will need to attach a resume and cover letter. Note: Do not include your age, date of birth, or the dates you attended or graduated from school. Only provide this information if it is specifically requested to meet job requirements or to follow federal, state, or local laws or rules.

Position Summary

The Bureau of Technology Services (BTS) is seeking a SQL Server Database Administrator (Principal Information Systems Analyst) to join our Enterprise Database Administration Team. This team is responsible for implementing, maintaining, and supporting a variety of mission critical databases which support applications used throughout the enterprise, using Microsoft SQL Server, Oracle, Informix, MySQL and PostgreSQL platforms deployed on AIX, RHEL, and Windows Server operating systems. This team has a strategic focus on data security and operational excellence.

Collaborating with members of the Enterprise Database Administration Team, other technical teams, and project managers, this position works with database users to deliver needed services to bureaus and external customers. This position specializes in the administration and support of SQL Server databases in the production, test and development environments with minimal instruction or assistance.

As a SQL Server Database Administrator, you will:

• Handle database design, implementation, operational, and troubleshooting tasks, including use of high availability SQL Server FCI (Failover Cluster Instance), Availability Groups and database encryption.
• Ensure databases are backed up, performing restores where needed.
• Patch, upgrade, and performance tune databases.
• Lead lifecycle replacement projects.
• Complete security hardening and vulnerability analysis tasks in conjunction with the Information Security Team.
• Handle incident and request tickets, provide excellent customer service, and manage problem tickets as needed.
• Engage with project managers on larger efforts and perform project management tasks for smaller internal projects.
• Assist SQL developers as needed with query tuning and optimization.
• Author, update, and peer review database documentation including standards, procedures, diagrams, and configuration management information.

Have a question?

Contact Information:

TroyLynn Craft

Senior Recruiter

troylynn.craft@portlandoregon.gov

To Qualify

The following minimum qualifications are required for this position:

• Experience administering and supporting complex database systems, including database operations, maintenance, performance monitoring, and troubleshooting.
• Knowledge of database architecture, relational database systems, database design principles, and performance tuning in shared or enterprise database environments.
• Knowledge of quality assurance practices, security principles, and procedures used to protect and maintain computer information systems and data.
• Experience leading or managing technical projects, including planning work, identifying tasks and milestones, estimating effort, and coordinating with stakeholders to achieve project goals.
• Ability to lead, organize, and review the work of technical staff, while providing guidance, support, and technical expertise.
• Ability to research, evaluate, document, and communicate technical standards, system architectures, procedures, and technologies to both technical and non-technical audiences.

Candidate must also have:

• The ability to pass a comprehensive police background investigation to have their employment retained.

Although not required, you may have one or more of the following:

• 8+ years of experience directly managing and maintaining mission critical Microsoft SQL Server databases in enterprise environments. This includes database design, implementation, networking, securing, database encryption, patching, upgrading and troubleshooting.
• 6+ years of experience with backup and recovery of Microsoft SQL Server databases using enterprise backup tools.
• 6+ years of Microsoft SQL Server FCI cluster High Availability and Disaster Recovery options, including implementing and supporting High Availability FCI clusters with Availability Groups, patching Microsoft SQL Server FCI clusters and Availability Groups, and troubleshooting Microsoft SQL Server FCI cluster and Availability Group errors.
• 8+ years of experience in performance tuning and query optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• 6+ years of installing, configuring and administering Microsoft SQL Server Reporting Services and Microsoft Integration Services.
• 5+ years administering Microsoft SQL Server databases in a shared instance environment.

The Recruitment Process

STEP 1: Apply online between June 15 - 29, 2026

Required Application Materials:

• Cover letter

• Details are key! The city uses a merit-based system, so your cover letter should be thorough and specifically address each qualification listed in the "To Qualify" section of the job announcement. Your cover letter can exceed one page, to ensure you are able to provide the detailed information for every qualification. Follow the instructions, as a subject matter expert will be evaluating your details to confirm that you meet the minimum requirements.

• Resume

• Answer the three (3) Supplemental Questions (click on the Questions tab to preview the questions)

Optional Application Materials:

• If you wish to request Veterans Preference, please submit your veteran documents (e.g., DD214-Member 4, VA Benefit Letter) by the recruitments closing date.
• Effective January 1, 2026, the State of Oregon law ORS 408.225 - 408.238 is amended to expand eligibility for Veterans' Preference to current and former Oregon National Guard service members. If applicants are existing state or former Oregon National Guard servicemembers, they are encouraged to attach appropriate documentation to their future recruitment applications.
• Update: As of March 3rd, 2025, if you made the eligible list and met the eligibility to receive veteran preference, you will no longer need to submit veteran documents for future recruitments.

If you need to update or remove your veteran preference for a specific recruitment or from your master profile, please contact the recruiter listed in the job announcement.

Application Tips:

• Your cover letter can exceed one page, to ensure you are able to provide the detailed information for every qualification. A subject matter expert will be evaluating your details to confirm that you meet the minimum requirements.
• Your résumé should support the details described in your cover letter.
• How We Determine Pay: The City of Portland is covered by the Oregon Equal Pay Act. Your salary is determined based on the experience listed in your resume that is directly related and equivalent to the position for which you are applying. It is strongly encouraged to include any transferable experience (paid or unpaid regardless of how recent) to ensure your offer is reflective of all your relevant experience.
• Do not attach any additional documents.
• Please note, all completed applications for this position must be submitted no later than on the closing date and time of this recruitment.
• You can use AI tools to assist with your job application, but please make sure to personalize your responses to supplemental questions. Avoid copying and pasting. We encourage use AI to generate ideas and then tailor them to reflect your own experiences and skills.
• All applications must be submitted via the Citys online application process.
• E-mailed and/or faxed applications will not be accepted.

Step 2: Minimum Qualification Evaluation: Week of June 29, 2026

• An evaluation of each applicants training, paid and unpaid experience, as demonstrated in their cover letter, and resume, weighted 100%.
• Your cover letter and résumé will be the basis for our evaluation of your qualifications for this position. Incomplete or inappropriate information may result in disqualification.
• You have 14 days from the notice of the minimum qualification evaluation results to let us know if you would like to review and discuss your evaluation result. Please read the City of Portland Administrative Rule 3.01 for complete information.
• Additional evaluation may be required prior to establishment of the eligible list and/or final selection.

Step 3: Establishment of Eligible List: Week of July 6, 2026

• Candidates who meet the minimum qualifications will be placed on the equally ranked eligible list.

Step 4: Selection (Interview): Mid-July

• Hiring bureau will review and select candidates for an interview

Step 5: Offer of Employment:

• Some positions will require those offered employment to complete and sign a criminal background statement before being considered for employment.

Step 6: Start Date:

• A start date will be determined after all conditions of employment have been met.
• Timeline is approximate and subject to change.

Additional Information

Click here for additional information regarding the following:

• City of Portland Core Values
• Recruitment Process - Work Status
• Equal Employment Opportunity
• Veteran Preference
• ADA, Pregnancy, and Religious Accommodations

A Career with the City of Portland offers many Employee Benefits

We offer a comprehensive benefits package, including but not limited to

• Health Care (Medical, Vision and Dental)
• Carrot Fertility
• Wellness Benefits
• Life Insurance
• Long-term disability coverage to eligible employees and their families.
• Employee Assistance Plan
• Flexible Spending Accounts
• Retirement
• Oregon Public Employees Retirement System (PERS), including contributions to the PERS IAP plan paid by employer
• Family Medical Leave
• City Paid Parental Leave

AND SO MANY MORE!

Benefits may vary depending on bargaining unit and employment status. Click here to review the many different benefits the City of Portland offers.

01

Thank you for your interest in the City of Portland. We value your time and hope to make your application experience as positive as possible.

Your Cover Letter and Resume are an important step to assist us in the review for minimum qualifications for the posted vacancy.

In your Cover Letter, write specific and unique responses to address each of the minimum qualification listed in the "To Qualify" section. The information you provide must correctly reflect your work history/resume. A lack of information in your application materials to each of the minimum qualifications may result in elimination from the recruitment.

Note: Request for veterans preference, please add a copy of your DD214 and/or Veterans Benefit letter. All documents must be uploaded by the closing date and time of this announcement.

Have you read and understood all the information listed above?

• No - If you have a questions, please contact the recruiter on the announcement.
• Yes

02

Where did you first learn about this job opportunity? (If on a website or job board, please specify which one)

03

The City of Portland receives public records requests at times. Please indicate which response you find appropriate: (Answer will not disqualify you from the process)

• My application was submitted with the understanding that the City of Portland would keep the information confidential and would only disclose the information if ordered to do so. I would not have submitted this application without the promise of confidentiality.
• You may release my application; I am waiving confidentiality.

Required Question

Employer City of Portland

Address 1120 SW 5th Ave, Room 987

Portland, Oregon, 97204

Website http://www.portlandoregon.gov/jobs