Data Administrator 1 (41-6090) Anchorage Information Services Support Division

State of Alaska•Anchorage, AK

11d•Onsite

About The Position

The Information Services Support Division of the Alaska Court System (ACS) is accepting applications for a Data Administrator 1. This position involves designing, administering, monitoring, maintaining, and supporting enterprise court databases to ensure system availability, reliability, security, and performance. It also includes participating in the design, development, implementation, and maintenance of enterprise database solutions and serving as the technical lead for database projects. This is a flexibly-staffed position, with potential progression to Data Administrator 2 upon meeting specific criteria.

Requirements

Two years of database administration experience using a recognized enterprise class database server in Cloud or On-Premise.
Two years of work experience in database maintenance and development writing T-SQL or scripts for Microsoft SQL or enterprise class Relational Database Management System (RDMS).
Database Administrator experience in Microsoft SQL Server or enterprise class Relational Database Management System (RDMS).
Working knowledge of RDMS architecture.
Advanced experience in SQL programming, Microsoft T-SQL preferred.
RDMS scripting experience for automation and proficient in SSIS or any Extract Transform Load (ETL) tools.
Experience in database performance optimization and tuning.
Working knowledge of Microsoft SQL transactional replications or High Availability (HA) architecture.
Working experience of system and database backup and recovery.
Methodical troubleshooting skills for database solutions.
Experience in RDMS management and monitoring tools.
A bachelor's degree in computer science or a closely related field may be substituted for up to two years of the required four years of experience.

Nice To Haves

Experience in Microsoft SQL server is preferred.

Responsibilities

Designs, administers, monitors, maintains, and supports enterprise court databases to ensure system availability, reliability, security, and performance.
Installs, configures, and maintains database management systems; manages database security, user access, and data integrity; and performs routine maintenance, upgrades, and troubleshooting.
Monitors and optimizes SQL Server environments, including transactional replication, to support enterprise reporting and data warehousing.
Plans and implements database patches and upgrades, evaluates infrastructure and capacity needs, and recommends solutions to support current operations and future organizational growth.
Participates in the design, development, implementation, and maintenance of enterprise database solutions to support court operations.
Designs and optimizes database objects, Transact-SQL (T-SQL) code, and SQL Server Integration Services (SSIS) ETL processes to ensure data integrity, performance, and scalability.
Collaborates with stakeholders to analyze business requirements and develop effective database solutions; performs testing, deployment, and ongoing support; and prepares technical documentation to support system maintenance and knowledge transfer.
Serves as the technical lead for database projects and as a senior member of the database administration team, providing leadership in the support, administration, and operation of enterprise database environments.
Collaborates with technical staff, business stakeholders, and court personnel to plan and implement database solutions; provides technical guidance, mentoring, and troubleshooting support; promotes database administration standards and best practices; and participates in project committees and cross-functional initiatives to ensure secure, reliable, and effective database services.