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

Job Description

The Information Services Support Division of the Alaska Court System (ACS) is accepting applications for a Data Administrator 1 (salary range 20).

Regular duties of this position will include:

Database Administration:

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.

Database Development:

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.

Project Administration:

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.

This position is flexibly-staffed.  Progression to the higher level will occur when the incumbent: 1) successfully completes a specified training plan; 2) meets all other specified terms of the flexible staffing agreement; 3) meets the minimum qualifications of the higher level; 4) is certified by the supervisor as capable to perform at the higher level; and 5) is approved by the Human Resources Department. When certified, the position may be reclassified to Data Administrator 2, salary range 22 ($4,266.00 bi-weekly).

The successful candidate should possess the following knowledge, skills, and abilities:

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.

Experience in Microsoft SQL server is preferred.

IMPORTANT:  Please attach a letter of interest in employment with the Alaska Court System.  Failure to submit a letter may disqualify you from consideration for an interview.

The Work Hours

Full-time court employees are currently scheduled to work 37.5 hours per week.  The work hours for this position are Monday – Friday, 8:00 a.m. to 4:30 p.m. with a one-hour lunch break.

Exceptional Benefits for Full-Time Employees

We offer a competitive benefits package that includes

12 paid holidays

,

medical, dental, and optional vision coverage

, and

employer-paid life insurance

. Employees are enrolled in the

Public Employees Retirement System (PERS)

and the

Alaska Supplemental Annuity Plan (SBS)

, with access to the

Alaska Deferred Compensation Plan

.

Personal leave

is accrued for vacation, illness, or personal needs.

Enjoy peace of mind and long-term security while serving your community.

See

http://doa.alaska.gov/drb/index.html

for additional information.

For more information on the Alaska Court System, please visit:

http://www.courts.alaska.gov

For information about what state courts do, please watch the following short video:

VIDEO: The who, what, when, where and how of state courts

The Alaska Court System is an EEO employer and proudly promotes diversity.

Minimum Qualifications

Two years of database administration experience using a recognized enterprise class database server in Cloud or On-Premise.

AND

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

Substitution:

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.

Database Administrator 2:  This is a flexibly-staffed job class.  The incumbent may be advanced to Range 22 upon meeting established criteria.

Additional Required Information

This applies to your application submission.

Documents to be Attached to the Application (REQUIRED):

A letter of interest, completed per the instructions below.

Post-secondary transcripts, if using education to meet minimum qualifications.

A list of three (3) professional references who have had supervisory authority over you, including your most recent supervisor, along with their daytime contact phone numbers

and

email addresses.

LETTER OF INTEREST

Please attach a professional letter of interest to your application before submitting it online or, if unable to attach to your application, email it to

[email protected]

.

Your letter of interest should:

1) Be professionally written and include proper format, grammar, spelling, and punctuation.

2) Explain how you meet the minimum qualifications of the position.

3) Express your interest in employment with the Alaska Court System.

The letter will be used to help determine which applicants will advance to the interview phase of the recruitment and selection process.

LEGAL EMPLOYMENT

The State’s online recruitment system, Workplace Alaska, requires applicants to certify that they have a legal right to accept employment in the United States. It is the responsibility of the employee to maintain the appropriate documentation to accept or continue legal employment.

The Alaska Court System does not sponsor visas.

WORK EXPERIENCE

If using work experience not already documented in your application, provide the employer’s name, your job title, dates of employment and whether full or part-time. Applications will be reviewed to determine if the responses are supported and Minimum Qualifications are clearly met. If they are not, the applicant will not advance to the interview and selection phase of the recruitment.

EDUCATION

If post-secondary education is required to meet the Minimum Qualifications, you must fill in the Education and Training section of the application. If you have not obtained a degree, please indicate the number of credit hours earned in the Degree Obtained field. Copies of transcripts are required to verify educational credentials used to meet or support the minimum qualifications for the position and are required with each application.

SPECIAL INSTRUCTIONS FOR FOREIGN EDUCATION

Education completed in foreign colleges or universities may be used to meet the minimum qualifications listed above. If utilizing this education, you must show that the education credentials have been submitted to a private organization that specializes in the interpretation of foreign educational credentials and that such education has