SQL Server Database Administrator (Information...

City of Portland
Portland, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 161K

Job location

Remote
Portland, United States of America

Tech stack

IBM AIX
Configuration Management
Computer Security
Information Systems
Databases
System Configuration
Data Security
Relational Databases
Database Design
Database Encryption
Disaster Recovery
Failover
PostgreSQL
Microsoft SQL Server
Windows Server
MySQL
Oracle Applications
Performance Tuning
Query Optimization
Red Hat Enterprise Linux - RHEL
Sqlprofiler
SQL Databases
Systems Architecture
Systems Integration
Informix
Diagnostic Tools
System Availability
Information Technology
Performance Monitor
Tools for Reporting
Vulnerability Analysis

Job description

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.

Requirements

  • 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.

Benefits & conditions

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)

Apply for this position