Resolution 08-019 Authorizing Database Administrator Position Classification CITY OF SPOKANE VALLEY
SPOKANE COUNTY,WASHTNGTON
RESOLUTION NO. 08-019
A RESOLUTION AUTHORIZING THE ESTABLISHMENT OF THE NEW POSITION OF
DATABASE ADMINISTRATOR FOR THE CITY OF SPOKANE VALLEY.
WHEREAS, the City Council from time to time must create new employee classifications and
adopt conditions of employment for those newly-created classifications to adjust its workforce in
response to workload demands; and
WHEREAS, the City Council through Ordinance #07-018 adopted the 2008 City budget which
included the City's Classification Matrix, including the Database Administrator;and
WHEREAS, since adoption of Spokane Valley Municipal Code provision 2.50.70, the City
Council has created various new employee classifications job descriptions; and
WHEREAS, the City Council adopted Spokane Valley Municipal Code provision 2.50.070
which, in part, provides that position classifications and job descriptions shall be developed for new
positions.
NOW THEREFORE, be it resolved by the City Council of the City of Spokane Valley, Spokane
County, Washington, as follows:
Section 1. Authorization for New Em I lovee Classification and Position Descri.tion for
"Database Administrator" Adopted. The City of Spokane Valley creates the new employee classification
of"Database Administrator," a full-time equivalent position, and adopts the position description for the
position of Database Administrator, attached hereto as Attachment I, as if fully set forth herein. This job
description includes a pay grade classification of 15 in the City's classification matrix.
Section 2. Effective Date. This Resolution shall be effective upon adoption.
Adopted this 23rd day of September,2008.
City of Spoka e Valley
VI-
Deputy Mayor Dick Denenny
ATT:S"
....---,./ _
City Clerk, Christine Bainbridge
Approved as to For i.
IL, ' /
Office of the City Attorney
Resolution 08-019 Database Administrator Page 1 of I
CITY OF SPOKANE VALLEY
POSITION DESCRIPTION
Class Title: Database Administrator Job Code Number: 418
Department: Finance Grade Number: 15
Division: NA FLSA Status: Exempt
Date: September 8, 2008 Location: City Hall
GENERAL PURPOSE
Performs a variety of database related services that primarily include designing, maintaining and
implementing database systems to meet the City's needs. Responsible for data analysis,
administration, database tuning, user support, performance measurement, scripting,report
writing, troubleshooting, and analysis of City database software systems; software identification,
procurement, and installation; and reviewing business technology needs of the City operations
for database administration. May be assigned other information Technology duties.
SUPERVISION RECEIVED:
Works under the general supervision of the Finance Director.
SUPERVISION EXERCISED
None.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Design, implement and maintain database systems to track City information in the areas included
but not limited to; public works projects and contracts, community development to include on-
line permitting, G1S, finance, administration and human resources.
Conducts need analysis with City departments to determine software requirements; communicate
with department personnel to facilitate the study, use, application and enhancement of database
application systems. Provides technical expertise and input.
Analyze and resolve problems associated with software applications. Detect, diagnose and report
related problems to applicable software vendors; secure, install, and test vendor supplied
software fixes.
Perform a variety of technical duties related to the design, development, acquisition,
implementation, production support, system administration, database administration, and
maintenance of complex computer and information related systems; provide vendors with design
specifications as needed.
Develop and maintain appropriate documentation, including necessary updates on City systems.
Database Administrator 1
Respond to departmental requests for database reporting support. Coordinate andlor provide
training to users, I,T. staff, and other department personnel in the use of business application
systems and equipment.
Comnmunicate with officials, business community representatives, City department personnel,
etc. on automation-related activities or projects.
Install commercial application software, and City produced software; develop associated
application menus and procedures for users.
Attend departmental and public meetings to discuss andlor address issues and policies. May
advise and recommend policies on the use of information technology.
Participate in and support team activities in a constructive, open and positive manner.
Cross-train and backup other Technology Services staff
Prepare accurate and timely reports and other written documents as directed.
Become familiar with follow, and actively support the mission, vision, values and behaviors
statements of. the City and department.
Perform other duties as assigned.
PERIPHERAL DUTIES
Provide backup support for ree]ated positions as needed.
Represent the City at various conferences and meetings_ Serves as a member of various
employee committees as assigned.
Perform related duties as assigned.
DESIRED MYNIMUM QUALIFICATIONS
Education and Experience:
A. Graduation from a four-year college or university with a degree in Information
Technology, Computer Science, or a closely related field; and
8. Three years of increasingly responsible experience in the analysis, design.
implementation and support of complex computer systems, at least one year of
which is in database administration; or
C. An equivalent combination of education and experience..
Database Administrator
Necessary Knowledge, Skills and Abilities:
A. Considerable knowledge of database systems including relational database
administration and data extraction.
B. Ability to support staff in the following applications: Eden Systems Financial
Software; PLUS permit tracking system, PRISM GIS system, Microsoft SQL
or ACCESS databases, Crystal Reports and HTML.
C. Ability to maintain assigned programs and systems; ability to troubleshoot
assigned programs; ability to meet project deadlines; ability to communicate
effectively orally and in writing; ability to establish and maintain effective
working relationships with, peers, vendors and supervisors; ability to exercise
sound judgment in evaluating situations and in making decisions; ability to
follow or give verbal and written instructions, as applicable.
D. A key value of the City is customer service. This position requires
considerable knowledge, ability and skill in the principles and practices of
excellent customer service as practiced in both the private and public sectors.
It requires the ability to effectively meet and deal with the public; the ability
to handle stressful situations; the ability to greet and respond to customers in a
friendly, pleasant and professional manner using appropriate inflection,
grammar and syntax; the ability to establish and maintain effective working
relationships with employees, supervisors, and the general public; the ability
to maintain a professional, courteous, and pleasant demeanor in difficult and
stressful situations; and the ability to diplomatically deal with difficult people.
A willingness to expend extra effort to help the public find answers or
information relative to their inquiry or complaint is expected.
SPECIAL REQUIREMENTS
Microsoft or related certifications desired but not required, including but not limited to Microsoft
Certified Professional (MCP) or Microsoft Certified Systems Engineer(MCSE).
TOOLS AND EQUIPMENT USED
Personal computer, printer, server, copy machine, fax machine, telephone, hand tools and various
diagnostic tools such as ETHERNET,NCP, and TSM, data scopes and breakout boxes.
PHYSICAL REQUIREMENTS
The physical requirements listed in this section include, but are not limited, to the motor/physical
abilities and skills required of this position in order to successfully undertake the essential duties
and responsibilities of the position. In accordance with the Americans with Disabilities Act
Database Administrator 3
(ADA), reasonable accommodations may be made to help individuals with disabilities to
undertake the essential duties and responsibilities of the position.
While undertaking the essential duties and responsibilities of the position, the employee must
repeatedly sit, speak, hear, listen and detect sounds, and use arms and hands to grip, hold, reach,
or manipulate the listed tools and equipment. The employee is periodically required to walk.
The employee must periodically lift and/or move up to 25 pounds. The employee must be able to
differentiate colors and see small objects at close range.
Employees in this position are expected to be generally available after normal business hours on
evenings and weekends to provide support for the various key business systems supported by the
IT division.
ADVERSE WORKING CON.DiTIONS
Adverse working conditions include, but are not limited to, extreme or intense environmental
circumstances (such as wetness, heat, cold, darkness, light, confined spaces, height, hazardous
materials, vibration, shock, explosion, etc.)to which the employee may be exposed while
undertaking the essential duties and responsibilities of this position. Reasonable accommodations
may be made in accordance with the Americans with Disabilities Act (ADA) so that employees
with disabilities may more successfully manage in said working conditions.
This position works in a general office environment. There are currently no adverse working
conditions associated with this position.
SELECTION GUIDELINES
Formal application, rating of education and experience; oral interview and reference check;job
related tests may be required.
The duties listed above are intended only as illustrations of the various types of work that may be
performed. The omission of specific statements of duties does not exclude them from the
position if the work is similar, related, or a logical assignment to the position.
The job description does not constitute an employment agreement between the employer and
employee and is subject to change by the employer as the needs of the employer and
requirements of the job change.
Approval: Approval:
Human Resources Manager City Manager
Effective Date: 9-23-2008 Revision History: New Position
Database Administrator 4