The Administrative Office of the Courts is seeking a highly qualified person for the position of Database Administrator. This position is responsible for implementing methods, techniques, and standards for the effective management of data resources. The successful candidate in this position will review data models and database designs; evaluate and recommend changes affecting dataset performance and implement new or revised methods, techniques, and standards for database management.
- Design data structures following standards, procedures, and guidelines: Reviews logical databases to determine database design changes needed; designs physical database objects (e.g., cluster indexes, alternate indexes, and physical database schema); constructs physical databases on appropriate system platforms; calculates database parameters; implements new or revised systems to ensure accuracy, efficiency, and adherence to technical standards.
- Provide technical assistance to other personnel involved in computer applications development: Answers questions from application development teams and describes techniques related to database management (e.g., structured query language, coding performance, security authorization, problem resolution); clarifies system and user requirements for vendors; and grants appropriate user privilege levels.
- Monitor application systems performance and identifies performance enhancements to application programs and databases: Identifies causes of poor response and turnaround times in database systems; recommends application data access changes (e.g., adding indexes, moving data sets, changing systems parameters); identifies service needs related to software and hardware improvements; runs system utility programs on on-line monitors to collect statistical data; and recommends changes to database systems to ensure optimal performance and productivity.
- Perform daily maintenance, tracking and documentation of production database systems: Creates and schedules database specific jobs (e.g., image copy utility jobs, reorganization utility jobs, statistics collection utility jobs, backup utility jobs, database recovery jobs); uses database documentation and knowledge of the system to determine necessary actions to recover from problems or failures; coordinates the database maintenance and implementation activities with programming staff, vendors, agency users, and overall State data architecture.
- Identify database software which can be used to solve existing problems or improve existing systems: Researches and tests new products; evaluates and selects database software products which will enhance the performance and integration of data management tasks; writes computer programs which provide user-friendly interfaces and procedures to automate maintenance and reporting tasks associated with database facilities; reviews output and software documentation, monitors software packages, and talks to vendors and users to identify causes of errors in software packages (e.g., installation errors, exit code errors); and instructs users in the use of database software to enhance database system usage, facilitate problem resolution, and maximize customer service.
Minimum Qualifications: Graduation from an accredited college or university with a bachelor's degree and five years of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., Oracle, MS SQL Server), including at least two years of specialized experience that involved data modeling, database design, or performance monitoring and tuning of database management systems. Experience using TOAD for SQL Server or SQL Server Management Studio required. Experience using Crystal Reports is a plus.
Professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., Oracle, MS SQL Server) may substitute for the required bachelor's degree on a year-for-year basis to a maximum of four years. Experience using TOAD for SQL Server or SQL Server Management Studio is a requirement.
For more information call: Human Resources at (615) 741-2687.