|
|
|
|
|
|
|
Careers / Database Architects |
|
|
|
|
|
|
|
|
Summary Description |
|
|
Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality. |
|
|
|
|
|
Sample Job Titles |
|
|
1. |
Data Administrator |
|
2. |
Data Analyst |
|
3. |
Data Architect |
|
4. |
Data Base Design Analyst |
|
5. |
Data Officer |
|
6. |
Data Warehouse Architect |
|
7. |
Database Analyst |
|
8. |
Database Architect |
|
9. |
Database Consultant |
|
10. |
Database Design Analyst |
|
11. |
Database Designer |
|
12. |
Database Engineer |
|
|
|
13. |
Database Modeler |
|
14. |
Information Architect |
|
15. |
Information Engineer |
|
16. |
Information Modeling Engineer Specialist |
|
17. |
Information Technology Architect (IT Architect) |
|
18. |
Infrastructure Architect |
|
19. |
Knowledge Architect |
|
20. |
Management Analyst |
|
21. |
SQL Server Developer |
|
22. |
System Engineer |
|
23. |
Technical Operations Vice President |
|
|
|
|
|
|
|
|
Job Tasks |
|
|
|
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
- Create databases to store electronic data.
|
|
|
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Develop procedures for data management.
|
|
|
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Collaborate with others to determine design specifications or details.
|
|
|
Develop data models for applications, metadata tables, views or related database structures.
- Design computer modeling or simulation programs.
- Develop models of information or communications systems.
|
|
|
Set up database clusters, backup, or recovery processes.
- Develop database parameters or specifications.
|
|
|
Create and enforce database development standards.
- Develop performance metrics or standards related to information technology.
- Develop procedures for data management.
|
|
|
Develop and document database architectures.
- Create databases to store electronic data.
- Document technical specifications or requirements.
|
|
|
Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
- Develop database parameters or specifications.
- Create databases to store electronic data.
|
|
|
Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- Monitor computer system performance to ensure proper operation.
|
|
|
Document and communicate database schemas, using accepted notations.
- Document design or development procedures.
- Communicate project information to others.
|
|
|
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Evaluate utility of software or hardware technologies.
- Provide recommendations to others about computer hardware.
|
|
|
Demonstrate database technical functionality, such as performance, security and reliability.
- Assess database performance.
|
|
|
Develop or maintain archived procedures, procedural codes, or queries for applications.
- Develop procedures for data management.
|
|
|
Test changes to database applications or systems.
- Test computer system operations to ensure proper functioning.
- Assess database performance.
|
|
|
Develop load-balancing processes to eliminate down time for backup processes.
- Create electronic data backup to prevent loss of information.
|
|
|
Provide technical support to junior staff or clients.
- Provide technical support for software maintenance or use.
|
|
|
Identify and correct deviations from database development standards.
- Resolve computer software problems.
|
|
|
Plan and install upgrades of database management system software to enhance database performance.
- Create databases to store electronic data.
- Install computer software.
|
|
|
|
|
|
|
|
Work Activities |
|
|
|
Interacting With Computers —
Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information. |
|
|
|
|
Getting Information —
Observing, receiving, and otherwise obtaining information from all relevant sources. |
|
|
|
|
Analyzing Data or Information —
Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts. |
|
|
|
|
Making Decisions and Solving Problems —
Analyzing information and evaluating results to choose the best solution and solve problems. |
|
|
|
|
Processing Information —
Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data. |
|
|
|
|
Updating and Using Relevant Knowledge —
Keeping up-to-date technically and applying new knowledge to your job. |
|
|
|
|
Communicating with Supervisors, Peers, or Subordinates —
Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person. |
|
|
|
|
Provide Consultation and Advice to Others —
Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics. |
|
|
|
|
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. |
|
|
|
|
Thinking Creatively —
Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions. |
|
|
|
|
Identifying Objects, Actions, and Events —
Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events. |
|
|
|
|
Documenting/Recording Information —
Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form. |
|
|
|
|
Interpreting the Meaning of Information for Others —
Translating or explaining what information means and how it can be used. |
|
|
|
|
Developing Objectives and Strategies —
Establishing long-range objectives and specifying the strategies and actions to achieve them. |
|
|
|
|
Organizing, Planning, and Prioritizing Work —
Developing specific goals and plans to prioritize, organize, and accomplish your work. |
|
|
|
|
Establishing and Maintaining Interpersonal Relationships —
Developing constructive and cooperative working relationships with others, and maintaining them over time. |
|
|
|
|
Communicating with Persons Outside Organization —
Communicating with people outside the organization, representing the organization to customers, the public, government, and other external sources. This information can be exchanged in person, in writing, or by telephone or e-mail. |
|
|
|
|
Coordinating the Work and Activities of Others —
Getting members of a group to work together to accomplish tasks. |
|
|
|
|
Monitor Processes, Materials, or Surroundings —
Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems. |
|
|
|
|
Scheduling Work and Activities —
Scheduling events, programs, and activities, as well as the work of others. |
|
|
|
|
Guiding, Directing, and Motivating Subordinates —
Providing guidance and direction to subordinates, including setting performance standards and monitoring performance. |
|
|
|
|
Coaching and Developing Others —
Identifying the developmental needs of others and coaching, mentoring, or otherwise helping others to improve their knowledge or skills. |
|
|
|
|
Estimating the Quantifiable Characteristics of Products, Events, or Information —
Estimating sizes, distances, and quantities; or determining time, costs, resources, or materials needed to perform a work activity. |
|
|
|
|
Resolving Conflicts and Negotiating with Others —
Handling complaints, settling disputes, and resolving grievances and conflicts, or otherwise negotiating with others. |
|
|
|
|
Developing and Building Teams —
Encouraging and building mutual trust, respect, and cooperation among team members. |
|
|
|
|
Training and Teaching Others —
Identifying the educational needs of others, developing formal educational or training programs or classes, and teaching or instructing others. |
|
|
|
|
Judging the Qualities of Things, Services, or People —
Assessing the value, importance, or quality of things or people. |
|
|
|
|
Selling or Influencing Others —
Convincing others to buy merchandise/goods or to otherwise change their minds or actions. |
|
|
|
|
Drafting, Laying Out, and Specifying Technical Devices, Parts, and Equipment —
Providing documentation, detailed instructions, drawings, or specifications to tell others about how devices, parts, equipment, or structures are to be fabricated, constructed, assembled, modified, maintained, or used. |
|
|
|
|
Monitoring and Controlling Resources —
Monitoring and controlling resources and overseeing the spending of money. |
|
|
|
|
Inspecting Equipment, Structures, or Material —
Inspecting equipment, structures, or materials to identify the cause of errors or other problems or defects. |
|
|
|
|
Performing Administrative Activities —
Performing day-to-day administrative tasks such as maintaining information files and processing paperwork. |
|
|
|
|
Staffing Organizational Units —
Recruiting, interviewing, selecting, hiring, and promoting employees in an organization. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Interesting Fact |
|
|
|
The word "salary" comes from salarium, or "salt money" and was used in ancient Rome to describe the wages paid to Roman legionnaires who were compensated in salt. |
|
|
|
Did you know... |
|
|
|
The MyPlan.com Undergraduate College Database provides detailed profiles on more than 1,700 different undergraduate colleges in the U.S. |
|
|
|
|
|
|
|