Database Coordinator - Memphis, United States - City of Memphis

Description

ESSENTIAL JOB FUNCTIONS: Works under the direction of assigned Administrator or Designee to create, develop, implement and maintain a comprehensive data management program to include a variety of databases such as, citizen service request, inventory management, maintenance request and repairs, projects, regulatory compliance records, permit records, barricade records, asset and equipment inventory. Coordinates fuel reports, employee attendance reports, training records, lift station faults and error reports. Conducts research for best practices in data management and technical solutions to improve productivity. Coordinates and performs various phases of database application systems development utilizing mapping software. Provides support by coordinating, designing, modifying, and documenting database programs and procedures. Creates queries and procedures custom reports from databases that are requested by management. Conducts and coordinates applications planning to recommend the appropriate information technology in order to provide complete maintenance tracking systems and to help analyze and solve operational problems. Analyzes and corrects database program malfunctions. Coordinates, assembles, analyzes, and presents related technical reports as requested from department heads from the data management programs implemented. Ensures efficiency and standardization within the departments and division. Evaluates and provides input in selection and development of current data management technologies. Provides technical oversight and personnel training for specified service center with program and technical assistance as needed. Formulates specifications for database programs and provide guidance for implementing spreadsheet and database software programs to management staff. Attends various job-related meetings and conferences as requested. Travels to various worksites to provide training and technical assistance to staff and addresses information technology needs. Provides training and technical assistance to division personnel as needed. Coordinates and prepares progress reports as required to accurately reflect operational efficiency and effectiveness, interacts with public, vendors, Information Technology Department (ITD), management and other staff members on information technology issues and concerns.


OTHER FUNCTIONS: Performs additional functions (essential or otherwise) which may be assigned.


TYPICAL PHYSICAL DEMANDS: Must be able to communicate clearly both verbally and in writing. Requires the ability to operate general office equipment such as a personal computer and telephone.


TYPICAL WORKING CONDITIONS: Work is performed primarily in an office environment except during on-site visits for inventory inspections and meetings. May be exposed to all weather conditions, including exposure to fumes, odors, dust, and noise.


MINIMUM QUALIFICATIONS: Bachelor's Degree in Business Administration, Computer Science, or a related field with substantial course work in database management and five (5) years' experience in application systems analysis or database management; or any combination of experience or training which enables one to perform the essential job functions. Working experience with Microsoft Office Excel strongly preferred.