|SENIOR DATABASE ADMINISTRATOR|
|SEIU Professional Exempt|
|Performs the duties of the Database Administrator, including highly technical and administrative work in the installation, development, and maintenance if the City's MS SQL/Oracle Database environment. This position provides consulting to the Applications Development Staff to correctly develop application database design models. The position is responsible for developing and enforcing citywide data and database design standards, operational procedures and software interfaces. Incumbent exercises considerable judgment in the resolution of technical problems and in all administrative and professional situations. Work is performed under limited supervision and is evaluated while in progress and upon completion through direct observation, discussion, review of established procedures and achievement of desired results.|
|Install and maintain MS SQL/Oracle software; tune MS SQL/Oracle databases for optimal database use.
Analyze database models developed by Application Development staff; provide education and consulting service support for effective relational database design and consistency with data standards.
Develop procedures for data accuracy on computers with MS SQL/Oracle databases.
Review application procedures for data completeness on all computers with MS SQL/Oracle databases.
Ensure data security on all computers with MS SQL/Oracle databases.
Develop methodologies for efficiently storing MS SQL/Oracle data; ensure availability of the data on all computers; provide efficient backup and recovery of data on all computers with MS SQL/Oracle databases.
Perform other related duties as required.
|Ability to install and maintain software, and develop database standards and backup/recovery procedures.
Ability to work within a group environment and serve as its leader.
Ability to establish and maintain effective working relationships with other Information System Bureaus, Orange County and the Property Appraiser.
|Bachelor's degree in Computer Science, Management Information Systems, or related field required with four (4) or more years related experience with a minimum of two years experience in database team leadership and project coordination. Including the following: training and mentoring assistant/backup database personnel; coordinating activities developer teams in using database software; arrange, supervise and perform vendor software and tools upgrades. Specific experience with MS SQL/Oracle CASE products and database modeling concepts is required with training and/or experience with Dec Ultrix preferred.
REVISED: 7/2/02 - VCJ