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

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 enterprise applications using Microsoft SQL Server, Oracle, Informix, MySQL, and PostgreSQL platforms deployed on AIX, RHEL, and Windows Server operating systems. The team has a strategic focus on data security and operational excellence.

Responsibilities Handle database design, implementation, operational, and troubleshooting tasks, including use of high availability SQL Server FCI, Availability Groups, and database encryption. Ensure databases are backed up and perform restores where needed. Patch, upgrade, and tune database performance.

Lead lifecycle replacement projects. Complete security hardening and vulnerability analysis tasks 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 with query tuning and optimization. Author, update, and peer-review database documentation including standards, procedures, diagrams, and configuration management information.

Minimum Qualifications 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.

Additional Qualifications (Preferred) 8+ years of experience directly managing and maintaining mission-critical Microsoft SQL Server databases in enterprise environments. 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 experience. 8+ years of experience in performance tuning and query optimization using Perfmon, SQL Profiler and related tools. 6+ years of installing, configuring and administering Microsoft SQL Server Reporting Services and Integration Services. 5+ years administering Microsoft SQL Server databases in a shared instance environment. Benefits Benefits are provided in accordance with the City of Portland benefits policy. Please consult the benefits tab for an overview of benefits for this position. #J-18808-Ljbffr