The Database Administrator is responsible for designing, implementing, and coordinating the operation of multifaceted data systems. This position is governed by state and federal laws and agency/institution policy.
The formal education equivalent of a bachelors degree in information technology, computer science, computer systems engineering, or a related area; plus three years of experience in database development, implementation, and analysis.
Additional requirements determined by the agency for recruiting purposes require review and approval by the Office of Personnel Management.
OTHER JOB RELATED EDUCATION AND/OR EXPERIENCE MAY BE SUBSTITUTED FOR ALL OR PART OF THESE BASIC REQUIREMENTS, EXCEPT FOR CERTIFICATION OR LICENSURE REQUIREMENTS, UPON APPROVAL OF THE QUALIFICATIONS REVIEW COMMITTEE.
Designs database systems and coordinates the testing of programs to ensure project output meets user requirements and data processing standards.
Consults with users and programmers to identify needs and existing system capability and determines requirements for database design formats and application specifications.
Implements data structure changes from user requests and evaluates system performance and space availability.
Evaluates new hardware and software by providing cost control and updated cost analysis.
Writes and installs utility programs and maintains on-line programs, batch programs, and job control languages.
Implements and monitors database access and configurations. Resolves database performance and capacity issues. Performs database recover and back-up. Performs capacity planning.
Provides technical assistance to programming, applications, and production personnel concerning the utilization of current and expanded database systems.
Performs other duties as assigned.
Knowledge of computer related applications and analytical methods for evaluating data processing programs.
Knowledge of complex computer database systems and data processing software.
Knowledge of SQL Server, IBM DB2, IBM UDB, Informix, Oracle, and MySQL.
Knowledge of advanced programming methods.
Ability to communicate with analysis, programming, and design teams concerning databases and specifications.
Ability to determine the source of problems and then recommend corrective actions.
Ability to determine the effectiveness of existing database systems.
Ability to design, implement, and maintain complex databases.
Ability to diagnose system failures.
Detailed knowledge of SQL Server, IBM UDB
Working knowledge of IBM DB2, Oracle, Mysql
Employer Job Listing Link