City of Tucson

Develops, administers, and maintains department databases to ensure security, accuracy, and efficiency. Provides support for databases running on several platforms to enable user access to data. Meets with users to determine needs, configures databases with input from systems administrators, monitors and tunes databases for performance, and ensures data availability. Trains, guides, and mentors others in the execution of assigned tasks. Interacts with individuals at all levels within and outside of the organization to resolve technical and non-technical issues.

Understands and adheres to sound relational design practices using defined City standards; reviews logical and physical database designs for proposed changes to existing databases or new project implementations.

Ensures that the City's data and databases are available, usable, and reliable through monitoring, following best security practices, and data integrity facilities.

Establishes and enforces policies and procedures related to database authentication, data access control authorization, and auditing of security practices.

Implements database software by installing and testing several database software products and upgraded databases; plans, implements, and maintains database backup and recovery strategies to protect the City's data and databases.

Provides daily operations support to existing applications systems databases; provides technical project team support for application systems modifications and/or development; develops and maintains appropriate documentation.

Proactively establishes optimum values for existing and newly installed systems to optimize performance; ensures that best practices are followed so that good performance will result.

Troubleshoots and corrects problems.

Follows best practices to optimize system performance.

Evaluates new database methodologies, version upgrades, and/or new implementation methods for planned upgrades, migrations, and regular maintenance; advises management of opportunities, changes, or alternative action to meet user needs.

Administers and controls data resources by working with outside agencies to make on-line information sharing possible; monitors and maintains security of databases and project schedules for assignments; provides instructions, prototypes of programs, training and technical assistance on timely accomplishment of tasks; documents procedures with complete instructions for back-up personnel; and coordinates schedules with other departments' schedules for assistance.

This is a lead position affording guidance to other positions performing the same tasks. This lead position also reviews workloads, assigns work and coaches employees with specialized instructions and practices for job accomplishments. Lead personnel may contribute to other employees' performance evaluations, assist with the hiring process by interviewing and making recommendations and providing input to supervisory staff.

Minimum Education Level & Type: Bachelor's Degree

Minimum Experience Qualifications: At least 3 years in database development and administration

None

FLSA Status: Exempt

Occupational Group Code: 06

Occupational Group Description: Data Processing

EEO Job Category Code: B

EEO Job Category Description: Professionals

Organizational Level: Lead

NCCI: 8810

Bargaining Unit: Not Represented

The following information pertains to driving requirements for this classification with the City of Tucson. Under "Driving Level" None, Secondary or Primary, refers to the driving responsibility as it relates to the essential functions of the classification. License Type, is just that, the type of Arizona Driving License required for the classification. If the position requires a Commercial Drivers License (CDL), the endorsements will be listed under "Endorsements." Under Safety Sensitive a "Yes" means employees with this classification are subject to pre-employment and random drug testing. License Type A,B,C,D,or M may require the use of personal or City vehicles on City business. Individuals must be physically capable of operating the vehicles safely, possess a valid license and have an acceptable driving record. Use of a personal vehicle for City business will be prohibited if the employee is not authorized to drive a City vehicle or if the employee does not have personal insurance coverage. Exceptions to classification driving requirement's may exist based on position.

Driving Level: Incidental

License Type: Valid and Unrestricted D - Driver

CDL Endorsements: None

Safety Sensitive: No

This description is not intended to limit or in any way modify the right of management to assign, direct and control the work of employees under supervision. The listing of duties and responsibilities shall not be held to exclude other duties not mentioned that are of similar kind or level of difficulty. They are intended to describe the general nature and level of work being performed by individuals assigned to this position.