The Database Analyst is responsible to design, maintain, and control the corporate database(s). To analyze all informational requirements, develop database specifications, and enforce all database standards.
Responsibilities:
Designs logical and physical data bases or reviews description of changes to data base design to understand how changes to be made affect physical data base (how data is stored in terms of physical characteristics, such as location, amount of space, and access method); Analyzes current and future needs of the agency.
Establishes, maintains, and controls the agency data directory (including name, description, source of data, and keywords for categorizing and searching for data item descriptions).
Develops, documents, and enforces the standards, security procedures, and controls for access to ensure integrity of the database system.
Writes protocols for levels of access to view, print, sort, enter, revise, or delete material.
Designs procedures for testing and implementing new applications in the database environment.
Analyzes current and projected future database performance requirements; fine-tunes or recommends equipment changes when necessary.
Develops database training guidelines for data-entry personnel and end-users.
Consults with different departments to define needs and refine system to maximize multipurpose uses.
Interacts with technical support team and vendors to schedule upgrades, modifications, and required maintenance.
Maintains knowledge of database technology developments through training courses, seminars, and publications.
Coordinates physical changes to computer data bases; and codes, tests, and implements physical data base, applying knowledge of data base management system.
Establishes physical data base parameters.
Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions.
Specifies which users can access data bases and what data can be accessed by user. Tests and corrects errors, and refines changes to data base.
Selects and enters codes of utility program to monitor data base performance, such as distribution of records and amount of available memory.
Answers user questions.
Confers with coworkers to determine impact of data base changes on other systems.
Modifies data base programs to increase processing performance, referred to as performance tuning.
Adheres to the agency's policies and procedures.
Adheres to Agency code of ethics and complies with the Federal, State and Agency Mandated Regulations.
Complies with the agency standard for service delivery.
Additional Responsibilities:
Creating or updating websites and integrating portions of a website to a database for information collection
Perform help desk functions that involve all aspects of IT to include, but not limited to, user support, hardware and software support, network support, phones, fax machines, printers, copiers, etc.
Performs additional related duties as assigned by the Director of Business Intelligence and Information Technology.
Physical Demands
The employee is regularly required to use hands and fingers to handle, or feel; the employee must have fine manipulation ability of both hands.
The employee must constantly talk and hear.
The employee is frequently required to walk and sit.
The employee is occasionally required to stand and reach with hands and arms.
The employee must occasionally lift and/or move up to 75 pounds.
Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.
The employee must be able to handle high stressful situations on a day to day basis.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job:
The employee is occasionally exposed to wet and/or humid conditions and occasionally exposed to outside weather conditions including poor driving conditions.
The noise level in the work environment is usually minimal to moderate.