Database Architects
15-1243.00
Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.
Sample of reported job titles: Big Data Architect, Data Architect, Data Engineer, Data Officer, Database Analyst, Database Architect, Database Consultant, Database Developer, Database Programmer, Enterprise Architect, Enterprise Data Architect, Information Architect, Solutions Architect
Occupation-Specific Information
Tasks
- Develop and document database architectures.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Develop data models for applications, metadata tables, views or related database structures.
- 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 methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
- Create and enforce database development standards.
- Document and communicate database schemas, using accepted notations.
- Develop data model describing data elements and their use, following procedures and using pen, template or computer software.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Set up database clusters, backup, or recovery processes.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Develop load-balancing processes to eliminate down time for backup processes.
- Plan and install upgrades of database management system software to enhance database performance.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Test programs or databases, correct errors, and make necessary modifications.
- Identify and correct deviations from database development standards.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Write and code logical and physical database descriptions, and specify identifiers of database to management system or direct others in coding descriptions.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Provide technical support to junior staff or clients.
- Establish and calculate optimum values for database parameters, using manuals and calculators.
- Train users and answer questions.
Technology Skills
- Access software - Access management software; Citrix cloud computing software
- Administration software - Redgate SQL Server
- Analytical or scientific software - IBM SPSS Statistics π₯; Infobright Community Edition ICE; Minitab; Safe Software FME; SAS π₯; StataCorp Stata; Test data generator software; The MathWorks MATLAB π₯
- Application server software - Application server software; Docker π₯; GitHub π₯; Oracle Application Server; Oracle WebLogic Server; Red Hat OpenShift π₯; Red Hat WildFly; Spring Boot π₯
- Backup or archival software - Acronis Recovery Expert; BMC Software Recovery Manager RMAN; Data Recovery Software SQL Server Data Recovery; Database cloning software; EMC NetWorker; HP DataProtector; IBM ADSTAR; Oracle Data Guard; Oracle Recovery Manager; Storage management software; Systems and data disaster recovery software; Veritas NetBackup
-
Business intelligence and data analysis software -
IBM Cognos Impromptu; Micosoft SQL Server Analysis Services SSAS; Microsoft Power BI
; MicroStrategy; Oracle Business Intelligence Enterprise Edition; Qlik Tech QlikView; Tableau
- Cloud-based data access and sharing software - Google Drive; Microsoft SharePoint π₯
- Cloud-based management software - Amazon Web Services AWS CloudFormation π₯; IBM WebSphere; Jitterbit; Splunk Enterprise π₯
- Cloud-based protection or security software - SolarWinds
- Clustering software - Cluster server software; Oracle Real Application Cluster RAC; VMware
- Communications server software - IBM Domino
- Computer aided design CAD software - Autodesk Revit π₯
- Configuration management software - Chef π₯; Deployment software; Perforce Helix software; Puppet π₯; Red Hat Ansible Engine
- Content workflow software - Atlassian JIRA π₯
- Customer relationship management CRM software - Blackbaud The Raiser's Edge; Oracle Eloqua; Salesforce software π₯
-
Data base management system software -
ADO.NET; Amazon DynamoDB π₯; Amazon Kinesis; Apache Cassandra π₯; Apache Flume; Apache Hadoop π₯; Apache HBase; Apache Oozie; Apache Pig; Apache Solr; Apache Sqoop; BMC Software Change Manager; CA IDMS; Catalog navigation software; Concurrency control software; Couchbase Server; Data definition language DDL; Data manipulation language DML; Data transformation services DTS software; Database design software; Database management systems; Elasticsearch π₯; Embarcadero Technologies DBArtisan; Greenplum Database; IBM Interactive System Productivity Facility ISPF; Index tuning software; Informatica Big Data; MapR Converged Data Platform; MariaDB; MongoDB π₯; Multidimensional Expressions MDX; MySQL ; NoSQL ; Oracle Enterprise Manager; Oracle Enterprise Manager Cloud Control; Oracle Golden Gate; Oracle Migration Workbench; Oracle PL/SQL ; Quest Central; Quest SharePlex; Relational database management software; Relational database management system software; SAP Adaptive Server Enterprise; SAP Replication Server; SentryOne SQL Sentry; Talend Big Data Integration; Teradata Database π₯
- Data base reporting software - ASG Technologies ASG-Zeke; Microsoft SQL Server Reporting Services SSRS π₯; Oracle Reports; Oracle SQL Loader; Oracle SQL Plus; ReCrystallize Crystal Reports; SAP Crystal Reports
-
Data base user interface and query software -
Amazon Elastic Compute Cloud EC2 π₯; Amazon Redshift π₯; Amazon Web Services AWS software ; Apache Hive π₯; Blackboard software; Cloudera Impala; FileMaker Pro; IBM DB2 π₯; Microsoft Access ; Microsoft SQL Server ; Oracle Database ; Oracle JDBC; Structured query language SQL ; Teradata Active Enterprise Data Warehouse; Transact-SQL π₯
- Data mining software - Google Analytics π₯; IBM InfoSphere Warehouse; Rapid-I RapidMiner
- Desktop communications software - Skype
- Desktop publishing software - Microsoft Publisher
-
Development environment software -
Adeptia ETL Suite; Apache Ant; Apache Kafka π₯; Apache Maven π₯; C π₯; CloverETL; Common business oriented language COBOL; Eclipse IDE π₯; Go π₯; Integrated development environment IDE software; Microsoft .NET Framework π₯; Microsoft Azure software ; Microsoft PowerShell π₯; Microsoft Visual Basic π₯; Microsoft Visual Basic for Applications VBA π₯; Microsoft Visual Basic Scripting Edition VBScript; Microsoft Visual Studio π₯; Oracle Jdeveloper; Oracle SQL Developer π₯; Prolog; Quest SQL Optimizer for Oracle; Restructured extended executor REXX; Ruby π₯
- Document management software - Adobe Acrobat π₯; IBM Content Manager
- Electronic mail software - IBM Notes; Microsoft Exchange; Microsoft Outlook π₯
-
Enterprise application integration software -
Atlassian Bamboo π₯; BMC Software Control-M; Extensible markup language XML π₯; IBM InfoSphere DataStage; Microsoft SQL Server Integration Services SSIS ; Oracle Data Integrator; Oracle Fusion Middleware; SAS Data Integration Studio; SMSi Twister Data Integrator; Talend Open Studio
- Enterprise resource planning ERP software - Ab Initio; Ellucian Banner ERP; Informatica Corporation PowerCenter; Microsoft Dynamics π₯; Microsoft Dynamics GP; NetSuite ERP; Oracle Fusion Applications; Oracle Hyperion; Oracle JD Edwards EnterpriseOne; Oracle PeopleSoft π₯; Oracle PeopleSoft Financials; SAP Business Objects; SAP software π₯
- Enterprise system management software - IBM Power Systems software
- Expert system software - Ansible software π₯; Apache Mahout
- File versioning software - Apache Subversion SVN π₯; Git π₯
- Geographic information system - ESRI ArcGIS software π₯; Geographic information system GIS software
- Information retrieval or search software - Apache Avro; Data validation software; LexisNexis
- Manufacturing execution system MES software - CA Easytrieve Report Generator
- Medical software - Epic Systems π₯
-
Metadata management software -
Altova MapForce; Apatar; CA Technologies ERWin Data Modeler; Coglin Mill RODIN; Data dictionary software; Data mapping software; Data modeling software; Flat File Checker; HiT Software Allora; IBM Rational Data Architect; IBM Rational System Architect; Informatica PowerCenter; Informatica software ; Interface Computers Data Loader; Pentaho Kettle; Quest Erwin Data Modeler; SAP PowerDesigner; Scriptella; Talend Data Fabric; WisdomForce DatabaseSync System
- Multi-media educational software - Nearpod
- Network conferencing software - LogMeIn GoToWebinar
- Network monitoring software - Nagios; Wireshark; Zabbix
- Network security and virtual private network VPN equipment software - Virtual private networking VPN software
- Network security or virtual private network VPN management software - Database security software
-
Object or component oriented development software -
Advanced business application programming ABAP; Apache Groovy; Apache Spark π₯; C# π₯; C++ π₯; jQuery π₯; Jupyter Notebook; Microsoft ActiveX; Microsoft Visual Basic.NET; Microsoft Visual C# .NET; Oracle Java ; Perl π₯; Python ; R π₯; SAP PowerBuilder; Scala π₯; Swift π₯
-
Object oriented data base management software -
Hibernate ORM π₯; IBM Informix; Object database management system ODBMS; PostgreSQL
-
Office suite software -
Microsoft Office software
-
Operating system software -
Apple macOS π₯; Bash π₯; C shell; Cisco IOS; DOS shell script; Hewlett Packard HP-UX; IBM AIX; Job control language JCL; KornShell; Linux ; Microsoft Windows π₯; Microsoft Windows Server π₯; Operating system software; Oracle Solaris; Perl shell; Red Hat Enterprise Linux; Shell script π₯; Ubuntu; UNIX π₯; UNIX Shell π₯
- Portal server software - Apache HTTP Server
- Presentation software - Microsoft PowerPoint π₯
- Process mapping and design software - Microsoft Visio π₯; Visual Paradigm DB Visual ARCHITECT
- Program testing software - Computer Associates Log Analyzer; Database testing software; Hewlett Packard LoadRunner; JUnit π₯; Selenium π₯
- Project management software - Atlassian Confluence π₯; Microsoft Project π₯; Oracle Primavera Enterprise Project Portfolio Management π₯
- Requirements analysis and system architecture software - Database capacity planning software; Unified modeling language UML
-
Spreadsheet software -
Microsoft Excel
- Storage media loading software - Intel Data Migration Software
- Storage networking software - Amazon Simple Storage Service S3 π₯; Storage area network SAN software
- Transaction security and virus protection software - Encryption software; McAfee; NortonLifeLock cybersecurity software
- Transaction server software - Customer information control system CICS
- Video conferencing software - Cisco Webex π₯; Google Meet; LogMeIn GoToMeeting
- Web page creation and editing software - Adobe Dreamweaver; Google Sites
- Web platform development software - AJAX π₯; Apache Struts; Apache Tomcat π₯; Backbone.js; Cascading style sheets CSS π₯; Django π₯; Drupal π₯; Dynamic hypertext markup language DHTML; Enterprise JavaBeans; Ext JS; Extensible hypertext markup language XHTML; Google Angular π₯; Hypertext markup language HTML π₯; JavaScript π₯; JavaScript Object Notation JSON π₯; LAMP Stack; Microsoft Active Server Pages ASP π₯; Microsoft ASP.NET π₯; Microsoft ASP.NET Core MVC; Node.js π₯; Oracle Application Express APEX; Oracle Designer; Oracle JavaServer Pages JSP π₯; PHP π₯; React π₯; Ruby on Rails π₯; Spring Framework π₯
- Word processing software - 3M Post-it App; Google Docs π₯; Microsoft Word π₯
Occupational Requirements
Work Activities
- Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources.
- Monitoring Processes, Materials, or Surroundings - Monitoring and reviewing information from materials, events, or the environment, to detect or assess problems.
- Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Inspecting Equipment, Structures, or Materials - Inspecting equipment, structures, or materials to identify the cause of errors or other problems or defects.
- 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.
- Judging the Qualities of Objects, Services, or People - Assessing the value, importance, or quality of things or people.
- Processing Information - Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- 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.
- 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.
- Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
- Updating and Using Relevant Knowledge - Keeping up-to-date technically and applying new knowledge to your job.
- Developing Objectives and Strategies - Establishing long-range objectives and specifying the strategies and actions to achieve them.
- Scheduling Work and Activities - Scheduling events, programs, and activities, as well as the work of others.
- Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work.
- Performing General Physical Activities - Performing physical activities that require considerable use of your arms and legs and moving your whole body, such as climbing, lifting, balancing, walking, stooping, and handling materials.
- Handling and Moving Objects - Using hands and arms in handling, installing, positioning, and moving materials, and manipulating things.
- Controlling Machines and Processes - Using either control mechanisms or direct physical activity to operate machines or processes (not including computers or vehicles).
- Operating Vehicles, Mechanized Devices, or Equipment - Running, maneuvering, navigating, or driving vehicles or mechanized equipment, such as forklifts, passenger vehicles, aircraft, or watercraft.
- Working with Computers - Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- 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.
- Repairing and Maintaining Mechanical Equipment - Servicing, repairing, adjusting, and testing machines, devices, moving parts, and equipment that operate primarily on the basis of mechanical (not electronic) principles.
- Repairing and Maintaining Electronic Equipment - Servicing, repairing, calibrating, regulating, fine-tuning, or testing machines, devices, and equipment that operate primarily on the basis of electrical or electronic (not mechanical) principles.
- 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.
- Communicating with Supervisors, Peers, or Subordinates - Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Communicating with People Outside the 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.
- Establishing and Maintaining Interpersonal Relationships - Developing constructive and cooperative working relationships with others, and maintaining them over time.
- Assisting and Caring for Others - Providing personal assistance, medical attention, emotional support, or other personal care to others such as coworkers, customers, or patients.
- Selling or Influencing Others - Convincing others to buy merchandise/goods or to otherwise change their minds or actions.
- Resolving Conflicts and Negotiating with Others - Handling complaints, settling disputes, and resolving grievances and conflicts, or otherwise negotiating with others.
- Performing for or Working Directly with the Public - Performing for people or dealing directly with the public. This includes serving customers in restaurants and stores, and receiving clients or guests.
- Coordinating the Work and Activities of Others - Getting members of a group to work together to accomplish tasks.
- 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.
- 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.
- Providing Consultation and Advice to Others - Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
- 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.
- Monitoring and Controlling Resources - Monitoring and controlling resources and overseeing the spending of money.
Detailed Work Activities
- Create databases to store electronic data.
- Document technical specifications or requirements.
- Collaborate with others to determine design specifications or details.
- Develop procedures for data management.
- Design computer modeling or simulation programs.
- Develop models of information or communications systems.
- Develop database parameters or specifications.
- Develop guidelines for system implementation.
- Develop performance metrics or standards related to information technology.
- Document design or development procedures.
- Communicate project information to others.
- Coordinate project activities with other personnel or departments.
- Analyze market or customer related data.
- Analyze data to identify trends or relationships among variables.
- Assess database performance.
- Create electronic data backup to prevent loss of information.
- Install computer software.
- Evaluate utility of software or hardware technologies.
- Provide recommendations to others about computer hardware.
- Modify software programs to improve performance.
- Resolve computer software problems.
- Estimate time or monetary resources needed to complete projects.
- Write computer programming code.
- Provide technical support for software maintenance or use.
- Train others in computer interface or software use.