Have a friend or colleague that might be interested in this job? Use our email a friend feature to notify them.

Return to Previous Page       Printer Friendly Version

 

People Making
A Difference!

Idaho
State Government


Idaho Judicial Branch


P.O. Box 83720
Boise, ID 83720-0101


WEBSITE:
www.isc.idaho.gov


EMAIL:
hr@idcourts.net

Non-Classified Opening

Database Administrator

Non-Classified Classification

Idaho Supreme Court

Open for Recruitment: January 4, 2017 - Open until further notice
Announcement # NONCLS097202
Salary Range: $57,268 - $71,585 annually (DOE) -Plus Competitive Benefits!

Location(s): Boise

SPECIAL NOTIFICATION:  This position is exempt from classified state service and the rules of the Division of Human Resources and the Idaho Personnel Commission.

General Position Summary:

Designs, installs, and maintains databases for the Idaho Judiciary. Ensures the security, quality, and integrity of database resources. This position works under the general supervision of the IT Manager.

Major Duties and Responsibilities: (The examples provided do not cover all the duties which the incumbent in this position may be required to perform.)

  • Provides database administration and management support for statewide judicial branch systems
  • Designs, develops, installs, and tests database systems in production as well as non-production systems
  • Upgrades, clones and manages existing and future database systems
  • Ensures compatibility and efficiency of database applications
  • Provides technical expertise on database management systems to clients, management, and IT personnel
  • Performs system, database and job monitoring, to include database health checks, and takes action to remedy any identified issues
  • Develops, improves and manages system and performance monitoring tools, to include recommending tools and resources to monitor Microsoft SQL Server activity 
  • Ensures performance considerations are designed into system design and configurations
  • Establishes and documents procedures and methods for database performance, and maintains a formal methodology for reporting performance
  • Provides key statistics and performance measures related to database systems
  • Troubleshoots and resolves database and system performance issues
  • Maintains and optimizes court database systems
  • Develops and implements security measures and policies for SQL Server to prevent unauthorized access
  • Ensures the security, availability and integrity of existing and new Microsoft SQL and Oracle database servers
  • Ensures data availability and system integrity for court database systems
  • Oversees and enforces standards and procedures for use, backup, and recovery of data
  • Backs up, recovers and restores data
  • Creates Microsoft SQL Server maintenance plans for disaster recovery planning and business continuity
  • Creates triggers, stored procedures, and query optimizations plans
  • Performs query and analysis of court database systems and creates reports
  • Queries and analyzes data for completeness and works with court staff to identify and correct incomplete data records
  • Applies data updates to ensure data accuracy
  • Works with vendors to analyze, design, and develop processes and procedures for migration to a new system database schema
  • Tests scripts and work with staff to identify and resolve potential migration issues 
  • Analyzes, designs, develops, and implements database models and database architecture to determine applicability for use in implementation of judicial database systems applications
  • Designs and develops processes to extract, transform, cleanse and move data and metadata into data warehouses, data marts, and operation data stores for in-house and outside agency use
  • Evaluates, tests and recommends database related hardware and software products
  • Develops and maintains an environment to provide data availability, dissemination, and consolidation
  • Researches and evaluates new technologies to improve database functionality
  • Provides 24/7 support for critical technology incidents 

Minimum Qualifications:

Education and Experience:

  • A bachelor’s degree in Computer Science, Information Technology, or other related degree
  • Five years of experience in database administration in a multi-user environment; previous experience with the court systems preferred 
  • 5+ years of experience as a Microsoft SQL Server database administrator
  • 2+ years of experience as an Oracle database administrator       

Knowledge, Skills and Abilities:

  • Knowledge of database fundamentals and administration best practices 
  • Knowledge of network and database performance monitoring techniques and data schemas
  • Knowledge of database backup and recovery procedures
  • Knowledge of database configuration and processes 
  • Knowledge of computer server hardware, web and application server and database and operating system technology
  • Knowledge of installing, managing and upgrading Oracle and Microsoft SQL databases
  • Knowledge of converting Oracle databases to Microsoft SQL databases
  • Skill in evaluating new software and determining applicability to the database environment
  • Skill in interpreting and translating end users requirements into logical and physical database designs
  • Ability to research and analyze problems logically and recommend appropriate courses of action
  • Ability to work independently
  • Ability establishes and maintain cooperative working relationships with co-workers, clients, justices, judges, and the other agencies
  • Ability to facilitate project initiatives
  • Ability to prepare technical manuals and other written instructions
  • Ability to learn new technologies and applications
  • Ability and willingness to work during non-business hours for maintenance and support efforts
  • Ability to work in a highly dynamic environment and able to function with minimal internal knowledge of environment
  • Ability to travel throughout the state as necessary   

The Judicial Branch reserves the right to consider an equivalent combination of education, training, and/or experience necessary to successfully perform the major responsibilities of the position. 

Application Instructions:

If interested in being considered for this position, please click here to complete the employment application located on our website and submit it, along with your cover letter and résumé, to hr@idcourts.net or to the Idaho State Judiciary, Human Resource Office, P. O. Box 83720, Boise, ID 83720-0101.  This announcement will remain open until the position has been filled.

Hiring is done without regard to race, color, religion, national origin, sex, age or disability. In addition, preference may be given to veterans who qualify under state and federal laws and regulations. If you need special accommodations to satisfy testing requirements, please contact the Division of Human Resources.