Job Descriptions & Pay
|Class Title:||DATABASE ADMINISTRATOR|
|Salary Schedule:||Approved Arizona Law Enforcement Merit System Council Salary Schedule|
|Summary Statement:||Performs work of considerable difficulty, analyzing, implementing and maintaining major databases; responsible for the design, implementation and maintenance of assigned projects in database and support system and standards. Responsible for designing and maintaining database and support systems including access methods, device allocations, organization, security, documentation, guidelines and standards; serves as the technical expert over major areas of complex database support activities; may supervise subordinate staff in planning, implementing and maintaining major database facilities. Performs related duties as assigned. This is a competitive classification.|
|Essential Functions:||(not intended to be all inclusive)
1. Analyzes application system specifications in order to produce logical and physical database structures of considerable difficulty.
2. Writes security specifications for data access controls for sensitive data.
3. Monitors, reviews and recommends methods of improving the performance of database software products.
4. Monitors, reviews, recommends and directs the modification of database structures to achieve optimal database performance.
5. Writes computer programs of considerable difficulty associated with database performance, recovery and statistics.
6. Advises application programmers and analysts on the proper use of database interface methodology.
7. Advises systems analysts on the design and use of database and file structures, and on proper use of the database commands.
8. Researches and corrects database integrity problems of considerable difficulty.
9. Designs and develops database support procedures of considerable difficulty.
10. Develops and recommends database standards.
11. Provides technical direction to programmers, analysts, and technical support personnel.
12. Organizes and schedules the database reorganizations.
13. Performs database recovery activities during emergency situations.
14. Provides seven day a week twenty-four hour a day on call support.
15. Installs and maintains new releases of the DB2 Universal DataBase (UDB) product set.
16. Installs and maintains new releases of the ORACLE product set.
17. Provides testing facilities for application programming.
18. Coordinates database problem solving activities between DPS and the vendor.
|Knowledge, Skills, & Abilities Required:||Knowledge of:
1. theory, principles, and practices of database systems specifications standards, applications programming, and database design and utilization techniques.
2. functions and capabilities of database systems and mainframe computer systems.
3. functions and capabilities of database management system performance monitoring methods.
4. client server components and methodology.
5. DB2 UDB product set.
6. UNIX operating system.
7. ORACLE database product.
1. planning and analyzing database requirements and capabilities and determine the most effective methods of utilization.
2. the use of programming, job control and data defining languages specific to the assignment.
1. establishing and maintaining effective working relationships with those contacted in the course of assignments.
2. effectively communicate, orally and in writing, at all levels.
3. resolve complex technical problems.
|Minimum Qualifications:||Requires five (5) years of computer programming experience. Three (3) years of experience must include use of the Departmentsâ€™ current database product set.
Progression to the next pay level/step requires an overall performance rating of at least â€œStandardâ€ in the last 12 months.
NOTE: College courses in computer science, management information systems or a related field from an accredited college or university may substitute for up to two (2) years of the required computer programming experience.
Must successfully complete the examination process.
FLSA status: Exempt
Current as of: 5/21/2013 8:17:42 PM