SQL Server Database Administrator; Information Systems Analyst, Principal - GIS Enterprise
Portland, Multnomah County, Oregon, 97204, USA
Listed on 2026-06-27
-
IT/Tech
Database Administrator, Systems Administrator, IT Consultant
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. 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 (PROTEC
17). To view this labor agreement, please . 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.
The following minimum qualifications are required for this position:
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…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).