TEL:86.10.351.4036002
Email:service@sxfoa.gov.cn
Database Administrator 4(Tennessee)
Source:http://www.tn.gov/ 2011-08-10 11:50:36

Job Title: DATABASE ADMINISTRATOR 4 
Closing Date/Time: Wed. 08/10/11 7:59 PM Central Time 
Salary: $4,999.00 - $8,000.00 Monthly
$59,988.00 - $96,000.00 Annually
 
Job Type: Full-Time
Location: Davidson County, Tennessee 
   

 
Summary/Distinguishing Features  Benefits  Supplemental Questions
 
LOCATION OF (1) POSITION TO BE FILLED:  DEPARTMENT OF HEALTH, DAVIDSON COUNTY

SUMMARY: Under general supervision, is responsible for developing and implementing methods, techniques, and standards for the effective management of data resources; and performs related work as required.

DISTINGUISHING FEATURES: This is the lead working level class in the Database Administrator sub-series. An employee in this class functions as a project leader and is responsible for monitoring, evaluating, and recommending changes affecting database performance, and designing or implementing new or revised methods, techniques, and standards for data and database management. This class differs from Database Administrator 3 in that an incumbent of the latter is responsible for implementing methods, techniques, and standards for data and database management and does not function as a lead worker.
 
 Examples of Duties and Responsibilities: 
1. Leads a staff of database administrators in the design and review of database systems; determines data resource needs; reviews data structures and physical database objects designed by staff to verify that Office of Information Resources standards, procedures, and guidelines have been followed; evaluates data model deliverables for conformity to Office of Information Resources standards, procedures, and guidelines and user requirements; reviews logical databases to determine design changes needed; talks with agency administrators, end users and others to coordinate the implementation processes for new or revised database system designs with the overall State data architecture.

2. Provides 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; writes procedures to control migration of database components; grants appropriate user privilege levels; instructs other programmers and analysts to make changes to programs which result in better database performance.

3. Acts as project leader in monitoring performance of application systems; 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 system parameters); evaluates information gathered from users and other staff to establish minimum standards for services and determine impact of database changes on other systems; identifies service needs related to software and hardware improvements; makes recommendations to management concerning problems or issues in the database environment to ensure optimal performance and productivity of database systems.

4. Performs 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; identifies system characteristics that provide information for ongoing database documentation; coordinates the database maintenance and implementation activities with programming staff, vendors, agency users, and overall State data architecture.

5. Leads other database administrators in the development and enforcement of standards, procedures, and guidelines and policies for data processing methods, techniques, and procedures to establish the operational framework in which database management systems are consistently and effectively utilized; reviews system requirements, or current needs, current State standards, procedures, and guidelines and Office of Information Resources policies to define techniques for monitoring and evaluating database performance; compares user activities and deliverables to standards, procedures, and guidelines to determine adherence; instructs users to correctly follow standards, procedures, and guidelines and correct any violations; identifies changes that need to be made in repository facility to meet current needs.

6. Identifies 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); instructs users in the use of database software to enhance database system usage, facilitate problem resolution, and maximize customer service; makes recommendations to management and purchasing units on viable vendor proposals based on the evaluation process.
 
 Minimum Qualifications: 
Education and Experience: 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., IMS/DB, DB2, Oracle) including at least three years of specialized experience that involved data modeling, database design, or performance monitoring and tuning of database management systems.

Substitution of Experience for Education: Professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, DB2, Oracle) may substitute for the required bachelor's degree on a year-for-year basis to a maximum of four years.

Substitution of Graduate Education for the Required Experience: Any graduate coursework in management information systems, business data processing, computer and information systems, or computer science may substitute for the required experience on a year-for-year basis to a maximum of one year (thirty-six graduate quarter hours or a master's degree in the above listed fields is equivalent to one year of experience), there being no substitution for the required three years of specialized experience.

OR

Education and Experience: Graduation from an accredited college or university with an associate's degree in business data processing, management information system, computer and information systems, computer science, or other directly related field and five years of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, DB2, Oracle) including at least three years of specialized experience that involved data modeling, database design, or performance monitoring and tuning of database management systems.

Substitution of Specific Experience for the Specialized Associate's Degree: Experience in data modeling, database design, or performance monitoring and tuning of database management systems may substitute for the specialized associate's degree on a year-for-year basis to a maximum of two years.

OR

Two years of experience as a Database Administrator 3 with the State of Tennessee.
 
 Necessary Special Qualifications/Examination Method: 
NECESSARY SPECIAL QUALIFICATIONS: None.

EXAMINATION METHOD: Education and experience rating, 100%.
 
 
 

Editor:Li lin
Shanxi People's Government Foreign Affairs Office (2011) All rights reserved
Address:No.388 Taiyuan Street Yingze | Post Code:030001 | TEL:86-351-4040426 transfer 3009 |  Email: service@sxfoa.gov.cn