From IICM

Job Title: DATABASE DESIGN ANALYST
Summary

Designs logical and physical databases and coordinates database development as part of project team by performing the following duties.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Reviews project request describing database user needs.

• Estimates time and cost required to accomplish project.

• Determines if project requires creating series of new programs or modifying existing programs that access data stored in databases.

• Work with project team workers to determine scope and limitations of project.

• Reviews procedures in database management system manuals for making changes to database such as defining, creating, revising, and controlling database.

• Revises company definition of data as defined in data dictionary (information about data, including name, description, source of data item, and key words for categorizing and searching for data item descriptions).

• Determines and enters changes to data dictionary descriptions, including type, structure, and intended use of data within system.

• Develops data model describing data elements and how they are used.

• Creates description to enable Programmer Analyst to understand how programs should access data.

• Writes description of how user accesses data, referred to as logical database.

• Writes physical database description such as location, space requirements, and access method, to protect company data resources against unauthorized access and accidental destruction.

• Creates databases and loads tables into the databases.

Competencies

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

Bachelor's degree (B. A.) from four-year college or university; or one to two years related experience and/or training; or equivalent combination of education and experience.

Language Skills

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.

Mathematical Skills

Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry.

Reasoning Ability

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Computer Skills

To perform this job successfully, an individual should have knowledge of Postgresql, MY-SQL, and MS-SQL databases as well as phpMYSQadmin nd phpPGadmin database administration software.

Work Environment

This is a virtual position -- the volunteer can work from anywhere he or she chooses.