|
|
Database Administrators
|
|
|
|
CheckoutCareers.com
: : |
|
|
Database Administrators
|
|
| |
|
Coordinate changes to computer databases, test and implement the database applying knowledge of database management systems. May plan, coordinate, and implement security measures to safeguard computer databases.
| |
|
| |
|
|
|
|
Degrees
|
|
|
|
|
|
Abilities
|
|
|
Written Comprehension| | The ability to read and understand information and ideas presented in writing. |
|
|
Oral Expression| | The ability to communicate information and ideas in speaking so others will understand. |
|
|
Near Vision| | The ability to see details at close range (within a few feet of the observer). |
|
|
Oral Comprehension| | The ability to listen to and understand information and ideas presented through spoken words and sentences. |
|
|
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. |
|
|
Deductive Reasoning| | The ability to apply general rules to specific problems to produce answers that make sense. |
|
|
Category Flexibility| | The ability to generate or use different sets of rules for combining or grouping things in different ways. |
|
|
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). |
|
|
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). |
|
|
Originality| | The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem. |
|
|
Visualization| | The ability to imagine how something will look after it is moved around or when its parts are moved or rearranged. |
|
|
Written Expression| | The ability to communicate information and ideas in writing so others will understand. |
|
|
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. |
|
|
Inductive Reasoning| | The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events). |
|
|
Mathematical Reasoning| | The ability to choose the right mathematical methods or formulas to solve a problem. |
|
|
Selective Attention| | The ability to concentrate on a task over a period of time without being distracted. |
|
|
Speech Clarity| | The ability to speak clearly so others can understand you. |
|
|
Speech Recognition| | The ability to identify and understand the speech of another person. |
|
|
Far Vision| | The ability to see details at a distance. |
|
|
Finger Dexterity| | The ability to make precisely coordinated movements of the fingers of one or both hands to grasp, manipulate, or assemble very small objects. |
|
|
Memorization| | The ability to remember information such as words, numbers, pictures, and procedures. |
|
|
Perceptual Speed| | The ability to quickly and accurately compare similarities and differences among sets of letters, numbers, objects, pictures, or patterns. The things to be compared may be presented at the same time or one after the other. This ability also includes comparing a presented object with a remembered object. |
|
|
Visual Color Discrimination| | The ability to match or detect differences between colors, including shades of color and brightness. |
|
|
Number Facility| | The ability to add, subtract, multiply, or divide quickly and correctly. |
|
|
Speed of Closure| | The ability to quickly make sense of, combine, and organize information into meaningful patterns. |
|
|
Auditory Attention| | The ability to focus on a single source of sound in the presence of other distracting sounds. |
|
|
Time Sharing| | The ability to shift back and forth between two or more activities or sources of information (such as speech, sounds, touch, or other sources). |
|
|
Arm-Hand Steadiness| | The ability to keep your hand and arm steady while moving your arm or while holding your arm and hand in one position. |
|
|
Manual Dexterity| | The ability to quickly move your hand, your hand together with your arm, or your two hands to grasp, manipulate, or assemble objects. |
|
|
Wrist-Finger Speed| | The ability to make fast, simple, repeated movements of the fingers, hands, and wrists. |
|
|
Hearing Sensitivity| | The ability to detect or tell the differences between sounds that vary in pitch and loudness. |
|
|
Control Precision| | The ability to quickly and repeatedly adjust the controls of a machine or a vehicle to exact positions. |
|
|
Static Strength| | The ability to exert maximum muscle force to lift, push, pull, or carry objects. |
|
|
Depth Perception| | The ability to judge which of several objects is closer or farther away from you, or to judge the distance between you and an object. |
|
|
Multilimb Coordination| | The ability to coordinate two or more limbs (for example, two arms, two legs, or one leg and one arm) while sitting, standing, or lying down. It does not involve performing the activities while the whole body is in motion. |
|
|
Trunk Strength| | The ability to use your abdominal and lower back muscles to support part of the body repeatedly or continuously over time without 'giving out' or fatiguing. |
|
|
Extent Flexibility| | The ability to bend, stretch, twist, or reach with your body, arms, and/or legs. |
|
|
Glare Sensitivity| | The ability to see objects in the presence of glare or bright lighting. |
|
|
Gross Body Coordination| | The ability to coordinate the movement of your arms, legs, and torso together when the whole body is in motion. |
|
|
Speed of Limb Movement| | The ability to quickly move the arms and legs. |
|
|
|
|
|
|
Interests
|
|
|
Second Interest High-Point| | Secondary-Cutoff/Rank Descriptiveness |
|
|
Investigative| | Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally. |
|
|
Conventional| | Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow. |
|
|
Realistic| | Realistic occupations frequently involve work activities that include practical, hands-on problems and solutions. They often deal with plants, animals, and real-world materials like wood, tools, and machinery. Many of the occupations require working outside, and do not involve a lot of paperwork or working closely with others. |
|
|
Social| | Social occupations frequently involve working with, communicating with, and teaching people. These occupations often involve helping or providing service to others. |
|
|
Enterprising| | Enterprising occupations frequently involve starting up and carrying out projects. These occupations can involve leading people and making many decisions. Sometimes they require risk taking and often deal with business. |
|
|
Artistic| | Artistic occupations frequently involve working with forms, designs and patterns. They often require self-expression and the work can be done without following a clear set of rules. |
|
|
First Interest High-Point| | Primary-Rank Descriptiveness |
|
|
Third Interest High-Point| | Tertiary-Cutoff/Rank Descriptiveness |
|
|
|
|
|
|
Knowledge
|
|
|
Computers and Electronics| | Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming. |
|
|
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. |
|
|
Mathematics| | Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications. |
|
|
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. |
|
|
Administration and Management| | Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources. |
|
|
Education and Training| | Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects. |
|
|
English Language| | Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar. |
|
|
Economics and Accounting| | Knowledge of economic and accounting principles and practices, the financial markets, banking and the analysis and reporting of financial data. |
|
|
Personnel and Human Resources| | Knowledge of principles and procedures for personnel recruitment, selection, training, compensation and benefits, labor relations and negotiation, and personnel information systems. |
|
|
Engineering and Technology| | Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services. |
|
|
Telecommunications| | Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems. |
|
|
Communications and Media| | Knowledge of media production, communication, and dissemination techniques and methods. This includes alternative ways to inform and entertain via written, oral, and visual media. |
|
|
Design| | Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models. |
|
|
Law and Government| | Knowledge of laws, legal codes, court procedures, precedents, government regulations, executive orders, agency rules, and the democratic political process. |
|
|
Public Safety and Security| | Knowledge of relevant equipment, policies, procedures, and strategies to promote effective local, state, or national security operations for the protection of people, data, property, and institutions. |
|
|
Sales and Marketing| | Knowledge of principles and methods for showing, promoting, and selling products or services. This includes marketing strategy and tactics, product demonstration, sales techniques, and sales control systems. |
|
|
Psychology| | Knowledge of human behavior and performance; individual differences in ability, personality, and interests; learning and motivation; psychological research methods; and the assessment and treatment of behavioral and affective disorders. |
|
|
Production and Processing| | Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods. |
|
|
Foreign Language| | Knowledge of the structure and content of a foreign (non-English) language including the meaning and spelling of words, rules of composition and grammar, and pronunciation. |
|
|
Mechanical| | Knowledge of machines and tools, including their designs, uses, repair, and maintenance. |
|
|
Physics| | Knowledge and prediction of physical principles, laws, their interrelationships, and applications to understanding fluid, material, and atmospheric dynamics, and mechanical, electrical, atomic and sub- atomic structures and processes. |
|
|
Geography| | Knowledge of principles and methods for describing the features of land, sea, and air masses, including their physical characteristics, locations, interrelationships, and distribution of plant, animal, and human life. |
|
|
Transportation| | Knowledge of principles and methods for moving people or goods by air, rail, sea, or road, including the relative costs and benefits. |
|
|
Chemistry| | Knowledge of the chemical composition, structure, and properties of substances and of the chemical processes and transformations that they undergo. This includes uses of chemicals and their interactions, danger signs, production techniques, and disposal methods. |
|
|
History and Archeology| | Knowledge of historical events and their causes, indicators, and effects on civilizations and cultures. |
|
|
Sociology and Anthropology| | Knowledge of group behavior and dynamics, societal trends and influences, human migrations, ethnicity, cultures and their history and origins. |
|
|
Biology| | Knowledge of plant and animal organisms, their tissues, cells, functions, interdependencies, and interactions with each other and the environment. |
|
|
Building and Construction| | Knowledge of materials, methods, and the tools involved in the construction or repair of houses, buildings, or other structures such as highways and roads. |
|
|
Medicine and Dentistry| | Knowledge of the information and techniques needed to diagnose and treat human injuries, diseases, and deformities. This includes symptoms, treatment alternatives, drug properties and interactions, and preventive health-care measures. |
|
|
Philosophy and Theology| | Knowledge of different philosophical systems and religions. This includes their basic principles, values, ethics, ways of thinking, customs, practices, and their impact on human culture. |
|
|
|
|
|
|
Wages
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| District of Columbia | $53,050.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| North Carolina | $61,890.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| South Carolina | $54,050.00 |
|
|
|
|
|
|
|
|
|
|
|
|
| Virgin Islands | $38,920.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Related Careers
|
|
|
Computer & Information Systems Managers| | Plan, direct, or coordinate activities in such fields as electronic data processing, information systems, systems analysis, and computer programming. |
|
|
Computer Operators| | Monitor and control electronic computer and peripheral electronic data processing equipment to process business, scientific, engineering, and other data according to operating instructions. May enter commands at a computer terminal and set controls on computer and peripheral devices. Monitor and respond to operating and error messages. |
|
|
Computer Programmers| | Convert project specifications and statements of problems and procedures to detailed logical flow charts for coding into computer language. Develop and write computer programs to store, locate, and retrieve specific documents, data, and information. May program web sites. |
|
|
Computer Security Specialists| | Plan, coordinate, and implement security measures for information systems to regulate access to computer data files and prevent unauthorized modification, destruction, or disclosure of information. |
|
|
Computer Support Specialists| | Provide technical assistance to computer system users. Answer questions or resolve computer problems for clients in person, via telephone or from remote location. May provide assistance concerning the use of computer hardware and software, including printing, installation, word processing, electronic mail, and operating systems. |
|
|
Computer Systems Analysts| | Analyze science, engineering, business, and all other data processing problems for application to electronic data processing systems. Analyze user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations. May analyze or recommend commercially available software. May supervise computer programmers. |
|
|
Numerical Tool & Process Control Programmers| | Develop programs to control machining or processing of parts by automatic machine tools, equipment, or systems. |
|
|
|
|
|
|
Skills
|
|
|
Troubleshooting| | Determining causes of operating errors and deciding what to do about it. |
|
|
Persuasion| | Persuading others to change their minds or behavior. |
|
|
Instructing| | Teaching others how to do something. |
|
|
Active Listening| | Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times. |
|
|
Time Management| | Managing one's own time and the time of others. |
|
|
Reading Comprehension| | Understanding written sentences and paragraphs in work related documents. |
|
|
Operations Analysis| | Analyzing needs and product requirements to create a design. |
|
|
Monitoring| | Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action. |
|
|
Critical Thinking| | Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. |
|
|
Active Learning| | Understanding the implications of new information for both current and future problem-solving and decision-making. |
|
|
Complex Problem Solving| | Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. |
|
|
Systems Evaluation| | Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system. |
|
|
Social Perceptiveness| | Being aware of others' reactions and understanding why they react as they do. |
|
|
Coordination| | Adjusting actions in relation to others' actions. |
|
|
Judgment and Decision Making| | Considering the relative costs and benefits of potential actions to choose the most appropriate one. |
|
|
Systems Analysis| | Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes. |
|
|
Writing| | Communicating effectively in writing as appropriate for the needs of the audience. |
|
|
Management of Personnel Resources| | Motivating, developing, and directing people as they work, identifying the best people for the job. |
|
|
Speaking| | Talking to others to convey information effectively. |
|
|
Service Orientation| | Actively looking for ways to help people. |
|
|
Learning Strategies| | Selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new things. |
|
|
Quality Control Analysis| | Conducting tests and inspections of products, services, or processes to evaluate quality or performance. |
|
|
Negotiation| | Bringing others together and trying to reconcile differences. |
|
|
Technology Design| | Generating or adapting equipment and technology to serve user needs. |
|
|
Mathematics| | Using mathematics to solve problems. |
|
|
Operation and Control| | Controlling operations of equipment or systems. |
|
|
Equipment Selection| | Determining the kind of tools and equipment needed to do a job. |
|
|
Installation| | Installing equipment, machines, wiring, or programs to meet specifications. |
|
|
Operation Monitoring| | Watching gauges, dials, or other indicators to make sure a machine is working properly. |
|
|
Programming| | Writing computer programs for various purposes. |
|
|
Management of Financial Resources| | Determining how money will be spent to get the work done, and accounting for these expenditures. |
|
|
Equipment Maintenance| | Performing routine maintenance on equipment and determining when and what kind of maintenance is needed. |
|
|
Management of Material Resources| | Obtaining and seeing to the appropriate use of equipment, facilities, and materials needed to do certain work. |
|
|
Repairing| | Repairing machines or systems using the needed tools. |
|
|
Science| | Using scientific rules and methods to solve problems. |
|
|
|
|
|
|
Tasks
|
|
|
| Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information. |
|
| Modify existing databases and database management systems or direct programmers and analysts to make changes. |
|
| Test programs or databases, correct errors and make necessary modifications. |
|
| Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. |
|
| Select and enter codes to monitor database performance and to create production database. |
|
| Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. |
|
| Train users and answer questions. |
|
| Establish and calculate optimum values for database parameters, using manuals and calculator. |
|
| Specify users and user access levels for each segment of database. |
|
| Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management. |
|
| Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. |
|
| Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. |
|
| Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs. |
|
| Review project requests describing database user needs to estimate time and cost required to accomplish project. |
|
| Review procedures in database management system manuals for making changes to database. |
|
| Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records. |
|
| Work as part of a project team to coordinate database development and determine project scope and limitations. |
|
| Revise company definition of data as defined in data dictionary. |
|
|
|
|
|
Tools
|
|
|
| Desktop computers |
|
| Hard disk arrays |
|
| Redundant array of independent disks RAID systems |
|
| Hard disk drives |
|
| Hard disks |
|
| Mainframe computers |
|
| Notebook computers |
|
| Tape arrays |
|
| Tape libraries |
|
|
|
|
|
Technology
|
|
|
| Access software |
|
| Access management software |
|
| Analytical or scientific software |
|
| Test data generator software |
|
| Application server software |
|
| IBM WebSphere |
|
| Backup or archival software |
|
| Acronis Recovery Expert |
|
| Backup and archival software |
|
| BMC Catalog Manager |
|
| BMC Recovery Manager RMAN |
|
| Database cloning software |
|
| Hewlett Packard Omniback II |
|
| IBM ADSTAR |
|
| Legato NetWorker |
|
| Oracle Data Guard |
|
| Storage management software |
|
| Systems and data disaster recovery software |
|
| VERITAS NetBackup |
|
| Clustering software |
|
| Cluster server software |
|
| Oracle Real Application Cluster RAC |
|
| Computer based training software |
|
| Configuration management software |
|
| Deployment software |
|
| Data base management system software |
|
| BMC Change Manager |
|
| Catalog navigation software |
|
| Concurrency control software |
|
| Data definition language DDL |
|
| Data manipulation language DML |
|
| Data transformation services DTS software |
|
| Database design software |
|
| Database management software |
|
| Embarcadero Technologies DBArtisan |
|
| IBM DB2 |
|
| Index tuning software |
|
| Microsoft SQL Server |
|
| MySQL software |
|
| Oracle DBMS |
|
| Oracle Enterprise Manager |
|
| Oracle procedural language/structured query language PL/SQL |
|
| Quest Central |
|
| Relational database management software |
|
| Sybase Replication Server |
|
| Sybase SQL Server |
|
| Data base reporting software |
|
| Oracle Reports |
|
| Oracle SQL Loader |
|
| Oracle SQL Plus |
|
| ReCrystallize Crystal Reports |
|
| Data base user interface and query software |
|
| Database query language |
|
| Structured query language SQL |
|
| Development environment software |
|
| C |
|
| Microsoft Visual Basic |
|
| Microsoft Visual Basic Scripting Edition VBScript |
|
| Prolog |
|
| Restructured extended executor REXX |
|
| Enterprise application integration software |
|
| Enterprise application integration EAI software |
|
| Enterprise resource planning ERP software |
|
| SAP software |
|
| Information retrieval or search software |
|
| Data validation software |
|
| Metadata management software |
|
| AllFusion ERwin Data Modeler |
|
| Data dictionary software |
|
| Data mapping software |
|
| Data modeling software |
|
| IBM Rational Data Architect |
|
| Visual Paradigm DB Visual ARCHITECT |
|
| Network security or virtual private network VPN management software |
|
| Database security software |
|
| Object or component oriented development software |
|
| Java |
|
| Microsoft Visual Basic.NET |
|
| Microsoft Visual C# .NET |
|
| Practical extraction and reporting language Perl |
|
| Sybase PowerBuilder |
|
| Object oriented data base management software |
|
| IBM Informix |
|
| Object database management system ODBMS software |
|
| PostgreSQL software |
|
| Operating system software |
|
| DOS shell script |
|
| Shell script |
|
| Presentation software |
|
| Microsoft PowerPoint |
|
| Program testing software |
|
| Computer Associates Log Analyzer |
|
| Database testing software |
|
| Requirements analysis and system architecture software |
|
| Database capacity planning software |
|
| Spreadsheet software |
|
| Microsoft Excel |
|
| Storage networking software |
|
| Storage area network SAN software |
|
| Transaction security and virus protection software |
|
| Encryption software |
|
| Web platform development software |
|
| Hypertext markup language HTML |
|
| Oracle Designer |
|
| Word processing software |
|
| Microsoft Word |
|
|
|
|
|
Career Activities
|
|
|
| Interacting With Computers |
|
| adjust computer operation system |
|
| develop or maintain budgeting databases |
|
| develop or maintain databases |
|
| implement computer system changes |
|
| install computer programs |
|
| install hardware, software, or peripheral equipment |
|
| maintain client-server database |
|
| operate computer networks |
|
| program mainframe computer |
|
| revise or correct errors in computer programs, software, or systems |
|
| test computer programs or systems |
|
| use computer application flow charts |
|
| use computer programming language |
|
| use computers to enter, access or retrieve data |
|
| use geographical information system (GIS) software |
|
| use relational database software |
|
| use spreadsheet software |
|
| use word processing or desktop publishing software |
|
| write computer software, programs, or code |
|
| Thinking Creatively |
|
| design data security systems |
|
| develop mathematical simulation models |
|
| Processing Information |
|
| develop tables depicting data |
|
| Analyzing Data or Information |
|
| analyze programs using workflow chart or diagram |
|
| evaluate computer system user requests or requirements |
|
| Updating and Using Relevant Knowledge |
|
| follow data security procedures |
|
| follow data storage procedures |
|
| use computer networking technology |
|
| use interpersonal communication techniques |
|
| use knowledge of mainframe computers |
|
| use mathematical or statistical methods to identify or analyze problems |
|
| use object-oriented computer programming techniques |
|
| use project management techniques |
|
| use structural analysis techniques to analyze computer systems |
|
| Identifying Objects, Actions, and Events |
|
| understand computer equipment operating manuals |
|
| Organizing, Planning, and Prioritizing Work |
|
| plan computer security measures |
|
| Establishing and Maintaining Interpersonal Relationships |
|
| establish and maintain relationships with team members |
|
| work as a team member |
|
| Communicating with Supervisors, Peers, or Subordinates |
|
| confer with personnel to discuss security violations or programming |
|
| Training and Teaching Others |
|
| | | | |
