Database Administrator Ii

Join WCCCA - the second largest 911 Emergency Communications Center in the State of Oregon. Leverage your skills, talents and experience to support your community by supporting and growing our 9-1-1 Call Taking and Dispatching Computer Aided Dispatch (CAD) system.

This key position is responsible for managing the implementation of the agencies databases, and Computer Aided Dispatch (CAD) systems and CAD to CAD interfaces. This position has responsibility for installing, maintaining, and administrating the agency's CAD and GIS databases and related applications interfaces, maintaining, administrating, and supporting the agency's CAD system, messaging/paging, and fire station alerting systems.

A successful candidate will be responsible for maintaining a highly resilient 24 x 7 x 365 CAD system as well as provide technical support for Emergency Call Takers, Dispatchers and field-based Law, Fire and Emergency Medical personnel.

Key to this position is the ability to effectively interface with and meet the needs of the agency's user community (Law, Fire and Emergency Medical). This position responds to trouble calls, monitors alarms, collects data/information, analyzes and reports status and trends. Using this analysis and reports, the Database Administrator works with the senior technical staff, and management, as appropriate, to propose and implement improvements and or corrective actions.

The Database Administrator is key to the identification and resolution of the CAD system user community performance and reliability. An incumbent in this classification is periodically called upon to provide off-shift on-call technical support to respond to and resolve major malfunctions in the Agency's or Users data systems.

If you are ready to take your experience to the next level, we want to talk with you.

Note - The Agency reserves the right to fill this position at a Database Administrator II or Administrator I level, depending upon applicant's experience. Below is the Database Administrator I salary range.

Database Administrator I Salary Range:

Minimum - $30.00 per hour ($5200 monthly; $62,400 annually)
Maximum - $38.92 per hour ($6637 monthly; $79,640 annually)

Duties may include, but are not limited to the following:

1. Installation and testing changes/upgrades to the CAD application and other operating systems
2. Monitors and tests all CAD interface applications to identify operator/system errors and coordinates changes as needed.
3. Assists the dispatch floor with CAD equipment or software problems.
4. Maintains and updates CAD system database files, CAD tables and Records tables as needed.
5. Ensure Agency data retention polices comply with agency procedures and state/federal law.
6. Maintain Replication of CAD Databases to user agencies.
7. Writes special request reporting programs; designs applications to process CAD statistics; examines data for completeness and validity.
8. Performs system maintenance functions (i.e. system backups) and establishes procedures for CAD and agency Databases.
9. Provides data and information to WCCCA operations, users, and the public as needed, including incident reports and statistical records.
10. Maintain and update documentation of CAD and agency Database systems.
11. Develop knowledge of CAD to CAD interface to provide back up support to regional project team.
12. Provides training to other staff members as needed.
13. Ensure duties and tasks are conducted in accordance with the Agency Safety Program.
14. Perform other duties as assigned.

A minimum of four years' experience in a computer system environment with a minimum of two years' experience with database file coordination. Previous work experience with Public Safety Agencies and college level training in business administration and computer science preferred; any equivalent combination of experience and training that demonstrates the knowledge, skill and ability to perform the above-described duties.

Knowledge, Skills and Abilities

• Demonstrated knowledge of structured query languages, database design, and theories
• Demonstrated knowledge of database management and database replication.
• Demonstrated knowledge of database reporting tools as Microsoft SQL Server Reporting Services, Power BI, and Excel.
• General understanding of the services provided by a communications center to police, fire and emergency medical services (EMS); general understanding of computer application software packages.
• Ability to write database queries.
• Ability to write user interfaces to data mining programs so programs can be used by a variety of employees or users.
• Strong knowledge of network operations and the equipment necessary to have it work properly
• Ability to work within scheduling constraints.
• Ability to communicate effectively both orally and in writing.
• Ability to exercise good judgment, common sense and emotional intelligence in accomplishing responsibilities and in interactions with others
• Ability to apply a high level of initiative, discretion and judgment in accomplishing assigned tasks
• Ability to work under stressful and emotional conditions; ability to maintain confidentiality.
• Ability to establish and maintain effective relationships with those contacted in the course of work.

Physical Demands

Daily focus on a computer screen; daily use of a keyboard; daily operation of office equipment; occasional lifting, moving and carrying of objects up to 50 pounds; sitting for extended periods of time, crouching, bending, kneeling or reaching to perform duties; regular talking and listening to others in person and over the phone and/or radio; continual visual acuity so as to pay close attention to detail in performance of essential functions and in avoiding potential hazards; occasional dealing with distraught or difficult individuals. Although much of the work is conducted in an office environment, support for the 9-1-1 / Dispatch Center will require working under or inside of workstations and or in tight spaces. Occasional overtime and after hours on call work (this position is subject to after-hours, on-call, as part of a rotational pool of staff members). May be required to report after hours for emergencies.

Accommodations may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation.

Supervision Received/Exercised

The Database Administrator II works under the supervision of the IT Supervisor. This position does not normally exercise supervision of others.

Employment Type: Full Time