] Office of Human Resources - Montgomery County Public Schools

OFFICE OF HUMAN RESOURCES AND DEVELOPMENT → CLASSIFICATION → DATABASE ADMINISTRATOR II

Sorted by job title: A - C | D - H | I - Q | R - Z

Database Administrator II

MONTGOMERY COUNTY PUBLIC SCHOOLS CLASS DESCRIPTION
OFFICIAL TITLE: Database Administrator II CODE: 5670 SQ/OQ: Optimal Qualified
WORKING TITLE: Database Administrator II GRADE: 25 MONTHS: 12
SUMMARY DESCRIPTION OF CLASSIFICATION: Under general direction, is responsible for the design, definition, installation, maintenance, security and integrity of moderate to large scale computer relational database systems which are the same as, or very similar to the MCPS system. The work of the class involves designing, creating, and maintaining new database structures and integrating them with existing databases; monitoring and tuning the operation of relational database management systems; evaluating, installing and testing database software and hardware; providing technical training and assistance to application development staff and users; participating in the definition and implementation of database security, backup, and recovery procedures; developing and enforcing database standards and procedures.
MINIMUM QUALIFICATION STANDARDS
KNOWLEDGE, SKILLS, AND ABILITIES: Thorough knowledge of and demonstrated proficiency with SQL Server IDMS and Oracle or similar relational database management systems, including programming, utilities, data dictionaries, schemas, subschemas, data communications networks, and system operations. Knowledge of programming languages such as SQL, PL/SQL, COBOL, Culprit, ADS/Online, and the korn shellRPF. Knowledge of and proficiency with operating systems such as MS DOS, MS Windows and Unix., NetWare, Apple System 7, and MVS/ESA. Experience with distributed database concepts and techniques, symmetric replication and distributed systems management in a multi-platform environment. Familiarity with data warehouse operations and data repository concepts. Thorough understanding of and demonstrated proficiency with relational database design and data modeling concepts and procedures. Thorough understanding of the relationships and interactions among the various components of the database management system. Knowledge of current technologies used in local and wide area networks. Ability to analyze and resolve complex problems relating to database system performance, system and program abends, and data integrity and accessibility. Ability to provide guidance, effective training, and technical assistance for other staff members in database concepts, features and operations. 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. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).
EDUCATION, TRAINING, AND EXPERIENCE: Bachelors degree required. College course work in the field of data processing, or any nationally recognized computer certification. Specialized training in all areas of relational and network database management systems, including database administration, design, tuning, troubleshooting, and programming. Three years increasingly responsible experience in database administration with IDMS, Oracle or similar database management systems in multi-platform environment. Experience with database design and administration utilizing client-server technology. Experience working with network and networking protocols in a WAN environment. 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.
CERTIFICATE AND LICENSE REQUIREMENTS: Oracle DBA Masters Certificate.
PHYSICAL DEMANDS: (Special requirements such as lifting heavy objects and frequent climbing.) Positions are required to operate computer terminals workstations for sustained periods.
SPECIAL REQUIREMENTS: (Frequent overtime or night work required, etc.) Ability to work frequent overtime, evenings and weekends, and when urgent work requirements exist.
OVERTIME ELIGIBLE: No

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

1. Creates databases and schemas to meet requirements of applications development.

2. Designs and creates databases.

3. Recommends and makes modifications to the database logical and physical structures to improve efficiency or correct problems.

4. Participates in new database hardware/software planning and evaluation.

5. Keeps up to date on database technology; researches and evaluates new database technologies and products for possible use by MCPS.

6. Installs and upgrades database software and application development tools.

7. Works with the Unix and Windows administrators team to allocate and manage system and database storage, and plans future storage requirements for the database system.

8. Executes utilities and other programs to manipulate data on databases to accommodate structural changes, resolve data integrity errors, or expand space.

9. Controls and monitors user access to the database in compliance with established security procedures.

10. Enrolls, monitors and drops users; grants system and object privileges as required.

11. Monitors and optimizes database performance.

12. Works with WAN engineering and client-server applications development groups on issues related to deployment of large scale Oracle or SQL/Server database and client-server applications.

13. Maintains database system security.

14. Develops, tests, and implements a strategy for backup and recovery of the databases.

15. Determines the best course of action to be taken if it is necessary to restore any data.

16. Maintains communication with outside vendors to keep current on products and resolve problems.

17. Develops and enforces guidelines and standards for databases and database applications.

18. Acts as a database authority or consultant to whom application developers and users can go for help and advice.

19. Develops required interfaces to allow purchased applications software to operate efficiently and accurately on our MCPS database systems.

20. Based on requirements analysis, detail design documents, and meetings with technical staff, develops detailed work plans for implementing new, or modifying existing computer databases; executes and utilizes preliminary analysis reports; assembles/writes necessary job steps; schedules necessary computer down time; executes and verifies database changes.

21. Must be proactive to monitor database systems proactively to resolve potential problems to ensure the uninterrupted access to the database and maximize performance and reliability. This requires vigilant monitoring of database usage, system performance, space requirements, and inconsistencies with new releases of the database and related software.

22. Provides training for development staff and users in new releases, features or operations of database software, and recommends training for database administration staff.

23. Assists in database administration staff selection.

24. Supervises and serves as mentor to database analyst administrator I.

25. Attends database design and system design walkthroughs to help identify potential problem areas and make recommendations for improving efficiency.

26. Performs related duties as required.

Class Established: 7/95
Date(s) Revised: 2/2008
Last Reviewed:

This description may be changed at any time.