 |
|
Database Analyst I |
5660 |
|
|
23 |
| Under direction of the database
analyst II, assists with the design, definition, support,
security and integrity of databases. Researches, evaluates
and recommends database application development tools
and trains staff in their use. The work of the class involves
creating and maintaining database structures; participating
in the evaluation, installation and testing of database
software and hardware; providing technical training and
assistance to application development staff in the use
of software design and development tools; participating
in the definition and implementation of database security,
backup, and recovery procedures; creating and maintaining
schemas, DMCL's and subschemas. |
| Thorough knowledge of IDMS and Oracle
or similar database management systems, including programming,
data dictionaries, schemas, and subschemas. Knowledge
of programming languages such as SQL, PUSQL, COBOL, Culprit,
ADS/Online, and RPF. Proficiency with application development
tools such as PowerBuilder. Knowledge of and experience
with operating systems such as MS DOS, MS Windows, NetWare,
Apple System 7, and MVS/ESA. Familiarity with relational
database design and data modeling concepts and procedures.
Understanding of the relationships among the various components
of the database management system. Ability to analyze
and resolve complex problems relating to database system
performance and system and program abends. Ability to
provide effective training and technical assistance for
other staff members in the use of database software development
tools. Ability to perform work of a very detailed nature
requiring a high degree of accuracy. Ability to work well
under pressure and meet tight deadlines. Good organization
and time management skills; must be able to work effectively
as part of a team, and create and work from detailed work
plans. Good written and oral communications and human
relations skills. |
| Bachelor's degree from an accredited
college or university with considerable course work in
the field of data processing, or any nationally recognized
computer certification. Specialized training in relational
and network database management systems, including database
administration, tuning, troubleshooting, and programming.
Considerable increasingly responsible experience in database
programming with IDMS, Oracle or similar database management
systems. Other combinations of applicable education, training
and experience which provide the knowledge, abilities
and skills necessary to perform effectively in the position
may be considered. It is expected that this class will
possess less experience than the database analyst II,
and will work closely with the database analyst 11 to
gain necessary knowledge and experience to perform at
the senior level. |
| None |
|
(Special requirements such as lifting heavy objects and
frequent climbing.) None |
|
(Frequent overtime or night work required, etc.) Ability
to work some overtime, evenings and weekends, and when
urgent work requirements exist. |
|
No |
|
ssists with creating, monitoring and modifying databases.
Writes programs to perform database maintenance functions,
correct data integrity errors, load and unload data,
etc. Executes utilities and other programs to manipulate
data on databases. Researches, evaluates, and tests
software development tools; makes recommendations as
to which tools MCPS should purchase. Installs the tools
and trains developers in their use; provides assistance
and troubleshooting. Works with vendors to resolve problems.
Assists database analyst 11 in performing database administration
tasks, with emphasis on gaining necessary knowledge
and experience to accomplish these tasks on an independent
basis in order to perform at the senior level. Controls
and monitors user access to the database. Enrolls, monitors
and drops users; grants system and object privileges.
Maintains system security. Develops, tests, and implements
a strategy for backup and recovery of the databases.
First level of contact for developers and users for
questions and problems related to database issues and
software development tools. Provides training for development
staff and users in new releases, features or operations
of database software development tools.
Creates and modifies schemas, DMCLs and subschemas.
Develops required interfaces to allow purchased applications
software to operate efficiently and accurately on our
database system. Must be proactive to potential problems
to ensure the uninterrupted access to the database and
maximize performance and reliability. Participates in
new database hardware and software planning and evaluation.
Attends database program specification and code walkthroughs
to help identify potential problem areas and make recommendations
for improving efficiency. Performs related duties as
required.
|
7/95
|
This description may be changed at any time.
Note: A general guide to class description, which includes
definitions of standard terms used, is considered an integral
part of this description and is available
from the Office of Human Resources. |
|
