Database Administrator

Tacoma Community College • Tacoma WA 98466, WA

1d • Onsite

About The Position

Under administrative direction, this position performs advanced analysis, design, technical coding, and database management tasks to resolve complex application database issues. The Database Administrator is responsible for providing technical support for the database environment, including overseeing the development and organization of databases, assessment, reporting, and implementation of new technologies. This role provides technical and strategic direction on all TCC databases, including advising and consulting with management, teams, system developers, and external customers. The position maintains the database application environment and supports multiple customers utilizing the college’s mission-critical applications. It also provides database administration support for all database software and utilities for TCC mission-critical applications, not limited to MS SQL Server. The role involves planning and participating in scheduled disaster recovery exercises, ensuring all databases have recovery plans, and all services meet TCC standards and requirements. Additionally, the Database Administrator is responsible for installing software and making changes into production environments while mitigating or minimizing customer impacts. The position also involves developing and maintaining reports for TCC reporting requirements in SSRS and other BI platforms, designing, coding, testing, and documenting new or modified reports and their interfaces with other applications and programs. Furthermore, it includes developing ETL tasks in SSIS to support multiple systems or applications where data import or export is necessary, such as developing and supporting SQL Server interfaces for other TCC applications like OnBase and Slate.

Requirements

• Experience building, maintaining, troubleshooting, backing up, and repairing MS SQL Server database environments.
• Integration of Microsoft Azure services with SQL Server.
• Experience as an administrator performing system/database of Microsoft SQL Server services on a daily basis.
• Knowledge in monitoring and supporting Microsoft SQL server products/services for versions 2016 or higher.
• Knowledge in installing and configuring Microsoft SQL server products/services for versions 2016 or higher.
• Knowledge in automation tools and techniques using Microsoft SQL Server Integration Services.
• Experience designing and architecting multiple Microsoft SQL Server environments over multiple servers.
• Proficiency in programming languages such as TSQL, Windows Scripting, and PowerShell.
• Experience designing and developing reports using Microsoft SQL Server Reporting Services or other BI tools (such as Power BI or Tableau).

Responsibilities

• Provides technical and strategic direction on all TCC databases.
• Advises and consults with management, teams, and system developers.
• Provides advice and consultation to external customers.
• Maintains the database application environment and supports multiple customers that utilize the college’s mission-critical applications.
• Provides database administration support for all database software and utilities for TCC mission-critical applications.
• Performs MS SQL management functions.
• Plans and participates in scheduled disaster recovery exercises.
• Ensures that all databases have recovery plans, and all services meet TCC standards and requirements.
• Installs software and makes changes into production environments while mitigating or minimizing customer impacts.
• Develops and maintains reports for TCC reporting requirements in SSRS and other BI platforms.
• Designs, codes, tests, and documents all new or modified reports and their interface to other applications and programs.
• Develops ETL tasks in SSIS to support multiple systems or applications where data import or export is necessary for system requirements.
• Develops and supports SQL Server interfaces for other TCC applications, such as OnBase and Slate.

Benefits

• Comprehensive healthcare benefits package for you and your dependents including medical, dental, and vision insurance.
• Life and long-term disability insurance plans.
• Vacation, sick, and personal leave.
• Reduced tuition for the employee.
• Retirement benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed