Under general direction, is responsible for the design, definition, installation, maintenance, security and integrity of moderate to large scale relational database systems.  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.

This position requires knowledge of all of the seven core competencies of the Supporting Services Professional Growth System (SSPGS) to include commitment to students, knowledge of job, professionalism, interpersonal, communication, organization, and problem solving. Thorough knowledge of and demonstrated proficiency with SQL Server and Oracle or similar relational database management systems, including programming, utilities, data dictionaries, schemas,  data communications networks, and system operations. Knowledge of programming languages such as SQL, PL/SQL, COBOL, and the korn shell. Knowledge of and proficiency with operating systems such as MS Windows and Unix.  Experience with distributed database concepts and techniques, 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.

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 all areas of relational database management systems, including database administration, design, tuning, troubleshooting, and programming. At least three years increasingly responsible experience in database administration with Oracle or similar database management systems in multi-platform environment. 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. 

Positions are required to operate computer workstations for sustained periods.

EXAMPLES OF DUTIES AND RESPONSIBILITIES:

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

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

Participates in new database hardware/software planning and evaluation.

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

Installs and upgrades database software and application development tools. 

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

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

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

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

Monitors and optimizes database performance. 

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

Maintains database system security.

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

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

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

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

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

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

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. 

Monitors 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. 

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

Assists in database administration staff selection. 

Supervises and serves as mentor to database administrator I.
Attends database design and system design walkthroughs to help identify potential problem areas and make recommendations for improving efficiency.  

Performs related duties as required.