The Database Analyst is responsible for designing, implementing, and maintaining database systems and monitoring and resolving internal database problems, using hierarchical or relational database management techniques. This position is governed by state and federal laws and agency policy.
The formal education equivalent of a bachelor's degree in information technology, computer science, or a related field; plus two years of experience in database development and analysis. Additional requirements determined by the agency for recruiting purposes require review and approval by the Office of Personnel Management. OTHER JOB RELATED EDUCATION AND/OR EXPERIENCE MAY BE SUBSTITUTED FOR ALL OR PART OF THESE BASIC REQUIREMENTS, EXCEPT FOR CERTIFICATION OR LICENSURE REQUIREMENTS, UPON APPROVAL OF THE QUALIFICATIONS REVIEW COMMITTEE.
Develops, maintains, and monitors data processing needs, identifies user problems, and proposes solutions. Designs, develops, implements, and maintains database tables, queries, and reports which meet customer requirements. Performs analysis and diagnostics to isolate the source of network, hardware, and/or software malfunctions. Schedules, coordinates, and performs maintenance, repair, and upgrade of computer systems with users and other organizational personnel. Participates in group meetings to identify business requirements and processes. Analyzes business requirements and comprehends business definitions of data. Analyzes user's current information flow requirements and determines feasibility of design approach for diverse and large scale application systems. Performs other duties as assigned.
Knowledge of various computer systems. Knowledge of design of relational database systems. Knowledge of technology and new user applications. Knowledge of data structures and logic. Ability to assist staff with various problem definitions and solutions. Ability to design effective database schema and normalization. Ability to communicate orally and in writing.
Occasional or frequent twenty-four (24) hour on-call duty may be required. Infrequent, short duration travel may be required. Some overnight stays may be required.
Experience using interface messaging software to include Rhapsody or Mirth; Microsoft Office, Microsoft Project, Microsoft SQL 2014 or newer.
Experience with Health Level 7 (HL7 2.5.1, HL7 2.3.1 or newer), Clinical Document Architecture (CDA), Extensible Markup Language (XML) files, Simple Object Access protocol (SOAP) testing and/or Structured Query Language (SQL).
Employer Job Listing Link