Database Administration
Job Code |
Job
Title |
Pay
Grade |
1610P2 |
Database Administrator I |
29 |
1611P2 |
Database Administrator II |
31 |
1612P2 |
Database Administrator III |
33 |
1613P2 |
Database Administration Supervisor |
35 |
OCCUPATIONAL CONCEPT
Coordinate changes to computer databases, test and implement the database
applying knowledge of database management systems. May plan, coordinate, and
implement security measures to safeguard computer databases.
TASKS
-
Develop standards and guidelines to guide the use and acquisition of software
and to protect vulnerable information.
-
Modify existing databases and database management systems or direct
programmers and analysts to make changes.
-
Test programs or databases, correct errors and make necessary modifications.
-
Plan, coordinate and implement security measures to safeguard information in
computer files against accidental or unauthorized damage, modification or
disclosure.
-
Approve, schedule, plan, and supervise the installation and testing of new
products and improvements to computer systems, such as the installation of new
databases.
-
Train users and answer questions.
-
Establish and calculate optimum values for database parameters, using manuals
and calculator.
-
Specify users and user access levels for each segment of database.
-
Develop data model describing data elements and how they are used, following
procedures and using pen, template or computer software.
-
Develop methods for integrating different products so they work properly
together, such as customizing commercial databases to fit specific needs.
-
Review procedures for making changes in database management systems manuals.
-
Review project requests describing database user needs to estimate time and
cost required to accomplish project.
-
Select and enter codes to monitor database performance and to create
production databases.
LEVELS OF WORK
Database Administrator I: This is routine technical work assisting in design,
implementation and maintenance of databases. Assists in the maintenance of
database dictionaries as well as designing, coding, testing and debugging of
database programs. Work is of a standardized nature that may involve a variety
of duties. Analytical thought becomes more important due to increased data and
changing situations.
Minimum Requirements: Successful completion of 12 hours in computer science
coursework or certification and six months experience designing/analyzing,
coding, testing, debugging, database programs or system software programming and
analysis. Education may be substituted for experience as determined relevant by
the agency.
Database Administrator II: This is full performance technical work in the
design, implementation and maintenance of databases. Maintains and documents
less complex database programs and assists with complex databases. Designs,
codes, tests, debugs, and maintains databases. Incumbent initiative may be
required to obtain guidance for new or unexpected situations. Several databases,
technologies or products may be involved. Employees at this level work under
general supervision, receiving some instructions with respect to the details.
Work is standardized and performed within established procedures, methods and
policies. Involves no supervisory or leadership responsibility.
Minimum Requirements: Successful completion of 24 hours in computer science
coursework or certification and one year experience designing/analyzing, coding,
testing, debugging database programs or system software programming and analysis
or two years experience designing/analyzing, coding, testing, and debugging
database programs or system software programming and analysis. Education may be
substituted for experience as determined relevant by the agency.
Database Administrator III: This is advanced technical work providing design,
implementation and maintenance of complex databases. Conducts feasibility
studies related to database development, designing, implementing and modifying
databases relying on knowledge and experience with control languages, access
methods, access time, device allocation, validation checks, organization and
statistical methods; maintains database dictionaries; and integrates systems
through database design. Functions as a senior consultant or top technical
consultant in specialized areas of databases management by providing guidance,
technical expertise and/or research services to others. Assignments are received
in terms of expected results. Work is periodically checked for progress and
conformance to established policies and requirements. May oversee other staff on
a project basis.
Minimum Requirements: Successful completion of 24 hours in computer science
coursework or certification and three years experience designing/analyzing,
coding, testing, debugging database programs or system software programming and
analysis or four years experience designing/analyzing, coding, testing,
debugging database programs or system software programming and analysis.
Education may be substituted for experience as determined relevant by the
agency.
Database Administration Supervisor: This is supervisory work in database design,
implementation and maintenance. Work involves reviewing and evaluating the work
of subordinates, implementing policies regarding budget, staffing levels, and
quality standards. Oversees database administration including configuration,
security, resource monitoring and reporting, troubleshooting and the development
of specialized programs. Performs as first line supervisor responsible for the
performance of subordinate employees and provides status reports on the
activities of the assigned unit.
Minimum Requirements: Successful completion of 24 hours in computer science
coursework or certification and four years experience designing/analyzing,
coding, testing, debugging database programs or system software programming and
analysis, or five years of experience in database implementation and maintenance
or system software programming and analysis. Education may be substituted for
experience as determined relevant by the agency.
Necessary Special Requirements:
Some positions in this class series may require a security clearance at the time
of appointment.
NC: 08/05
REV: 06/08
REV: 06/09
|