The functions listed below are those that represent the majority of the time spent working in this class. Management may assign additional functions related to the type of work of the job as necessary.
- Assist as the liaison between the Regional Communications Operations Team Operator and consultants for data analytics.
- Work with management team to create a prioritized list of ORCAT reporting needs
- May supervise professional and technical personnel on assigned work teams
- Maintain backups and backup schedules across all E911 systems and databases.
- Serve as a Data Analyst for data mining analysis and reporting on the call processing environment
- Assist in planning design setup testing and implementation of databases required for the Next Generation 911 environment
- Assist with updating all SOP documents associated with E911 databases
- Design and develop scheduled reports for exception call processing.
- Design develop and implement business intelligence tools and performance dashboards
- Design develop test and implement interfaces to obtain data from disparate and legacy systems
- Support the existing Replicated Databases and all interfaces
- Assist with database upgrades on key application databases utilized internally
- Development of reports in SQL Server Reporting Services (SSRS)
- Assist in developing reports of Key Performance Indicators
- Write SQL queries when needed
- Become proficient and support Power BI tools and Voice Recording System (VRS) search tools.
- Serve as backup for all project activities associated with the GIS Assessment and Remediation initiatives.
- Serve as the backup liaison to agencies carriers customer premise equipment vendor(s) and internal County staff for the County Geospatial Routing database that will be used for Next Generation 911.
- Assist in establishing and maintaining the Geospatial Database for Broward County to ensure and maintain 98% accuracy across the Automatic Location Information Database MSAG Database and the County equivalent GIS Databases
- Serve as backup for exception reporting and coordinating all remediation activities associated with the GIS Central Repository data by working with the individual agencies for timely reporting and updates.
- Responsible for designing modeling developing and supporting SQL Relational Database Management Systems (RDBMS).
- Write SQL queries when needed for troubleshooting data analysis and interfaces
Additional Responsibilities:
- Maintains change control records to record system activity in preproduction and production environments.
- Promotes and supports replicated database changes and upgrades through Change Management;
- Assist with capacity planning and fine tuning of databases for optimal performance
- Database Lifecycle Planning
- Assist with Strategic Planning and Administration of databases.
- Maintain up-to-date system documentation in SharePoint
- Support of VIPER ATT Voice Network VRS Systems On Call Alarm monitoring Testing and Project Support
- This position is part of the emergency activation support team that provides assistance and support to ORCAT at the Emergency Operations Center (EOC). Work Schedule may be changed depending on business need during Emergency Operations
- Performs related work as assigned.
Physical Demands
Physical demands refer to the requirements for physical exertion and coordination of limb and body movement.
Performs sedentary work that involves walking or standing some of the time and involves exerting up to 10 pounds of force on a regular and recurring basis or sustained keyboard operations.
Unavoidable Hazards (Work Environment)Unavoidable hazards refer to the job conditions that may lead to injury or health hazards even though precautions have been taken
Competencies
Required Experience:
IC