Database designers and administrators design, develop, control, maintain and support the optimal performance and security of databases.
Job Description:
Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.
Duties and Tasks:
1) Test programs or databases, correct errors and make necessary modifications.
2) Revise company definition of data as defined in data dictionary.
3) Train users and answer questions.
4) Specify users and user access levels for each segment of database.
5)Review procedures in database management system manuals for making changes to database.
6) Select and enter codes to monitor database performance and to create production database.
7) Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
8) Modify existing databases and database management systems or direct programmers and analysts to make changes.
9) Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
10) Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
11) Establish and calculate optimum values for database parameters, using manuals and calculator.
12) Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
13) Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
14) Review project requests describing database user needs to estimate time and cost required to accomplish project.
15) Work as part of a project team to coordinate database development and determine project scope and limitations.
16) Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
17) Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
18) Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
Activities:
1) Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.
2) Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
3) Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
4) Training and Teaching Others — Identifying the educational needs of others, developing formal educational or training programs or classes, and teaching or instructing others.
5) Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them
6) Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.
7) Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
8) Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.
9) Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
10) Identifying Objects, Actions, and Events — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
11) Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
12) Developing and Building Teams — Encouraging and building mutual trust, respect, and cooperation among team members..
13)Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
14) Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
15) Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
16) Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.
17) Interpreting the Meaning of Information for Others — Translating or explaining what information means and how it can be used.
18) Provide Consultation and Advice to Others — Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
19) Monitor Processes, Materials, or Surroundings — Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems.
20) Coaching and Developing Others — Identifying the developmental needs of others and coaching, mentoring, or otherwise helping others to improve their knowledge or skills.
Abilities:
1) Oral Expression — The ability to communicate information and ideas in speaking so others will understand
2) Oral Comprehension — The ability to listen to and understand information and ideas presented through spoken words and sentences.
3) Written Comprehension — The ability to read and understand information and ideas presented in writing.
4) Written Expression — The ability to communicate information and ideas in writing so others will understand.
5) Speech Recognition — The ability to identify and understand the speech of another person.
6) Speech Clarity — The ability to speak clearly so others can understand you.
7) Problem Sensitivity — The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
8) Information Ordering — The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
9) Near Vision — The ability to see details at close range (within a few feet of the observer).
10) Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
11) Selective Attention — The ability to concentrate on a task over a period of time without being distracted.
11) Flexibility of Closure — The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.
13) Mathematical Reasoning — The ability to choose the right mathematical methods or formulas to solve a problem.
14) Category Flexibility — The ability to generate or use different sets of rules for combining or grouping things in different ways.
15) Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense.
15) Mathematical Reasoning — The ability to choose the right mathematical methods or formulas to solve a problem.
16) Fluency of Ideas — The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
Knowledge
1) Clerical — Knowledge of administrative and clerical procedures and systems such as word processing, managing files and records, stenography and transcription, designing forms, and other office procedures and terminology.
2) Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
3) Customer and Personal Service — Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
4) Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
5) English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.