Will “Data Architect” be Replaced By Robots? 🤔

Unknown Chance of Automation

Sadly, the research paper did not provide any information about this occupation. Maybe have a look at our directory?

Job 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.

Job Details

The SOC (Standard Occupational Classification) code is 15-1199.06

☝️ Information based on the reference occupation “Database Architects”.

Also Known As…

Tasks for “Data Architect”

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.
Test changes to database applications or systems.
Develop data models for applications, metadata tables, views or related database structures.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Demonstrate database technical functionality, such as performance, security and reliability.
Set up database clusters, backup, or recovery processes.
Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Identify and correct deviations from database development standards.
Plan and install upgrades of database management system software to enhance database performance.
Develop or maintain archived procedures, procedural codes, or queries for applications.
Develop load-balancing processes to eliminate down time for backup processes.
Document and communicate database schemas, using accepted notations.
Provide technical support to junior staff or clients.
Develop and document database architectures.
Create and enforce database development standards.

Related Technology & Tools

Load balancers
Personal computers
Laser facsimile machines
Copy machines

Quest SQL Optimizer for Oracle
IBM Rational Data Architect
Microsoft PowerShell
Python
Nagios
Qlik Tech QlikView
IBM InfoSphere Warehouse
Oracle JDBC
Altova MapForce
SAP Business Objects
UNIX
Oracle JD Edwards EnterpriseOne
Practical extraction and reporting language Perl
Apache Sqoop
Microsoft Active Server Pages ASP
C shell
SMSi Twister Data Integrator
Teradata Database
Tableau
Apache Pig
Oracle Hyperion
Infobright Community Edition ICE
Microsoft Visio
SPSS
Transact-SQL
Swift
Extensible markup language XML
Apache Flume
Job control language JCL
Apache Hive
MongoDB
IBM Content Manager
Microsoft SharePoint
SAP Sybase Replication Server
Microsoft Visual Basic Scripting Edition VBScript
SAS
Symantec
SAP
Microsoft Access
Scriptella
Dynamic hypertext markup language DHTML
MicroStrategy
Apache Spark
Ruby
Amazon Kinesis
Rapid-I RapidMiner
Perl shell
IBM AIX
Oracle Jdeveloper
Apache Hbase
Microsoft SQL Server
Microsoft Visual Basic
Microsoft ActiveX
Microsoft .NET Framework
Hewlett Packard LoadRunner
IBM DB2
IBM WebSphere
C#
SAP Sybase Adaptive Server Enterprise
HiT Software Allora
Talend Open Studio
Apache Solr
Veritas NetBackup
Integrated development environment IDE software
Interface Computers Data Loader
Splunk Enterprise
Common business oriented language COBOL
Citrix
Oracle Data Integrator
Oracle Business Intelligence Enterprise Edition
Microsoft Windows
Red Hat WildFly
Apache Avro
SAS Data Integration Studio
PHP: Hypertext Preprocessor
Apple Macintosh OS
Spring Framework
Relational database management software
PostgreSQL
Pentaho Kettle
IBM Cognos Impromptu
IBM InfoSphere DataStage
WisdomForce DatabaseSync System
Adeptia ETL Suite
Application server software
Microsoft Excel
CA Technologies ERWin Data Modeler
Data Recovery Software SQL Server Data Recovery
Oracle Data Guard
Microsoft Exchange Server
Oracle Fusion Applications
Apache HTTP Server
Advanced business application programming ABAP
Oracle Application Server
Puppet
Unified modeling language UML
Microsoft Visual Studio
Adobe Systems Adobe Acrobat
C++
Jitterbit
Coglin Mill RODIN
MySQL
Oracle Golden Gate
R
Multidimensional Expressions MDX
NoSQL
Oracle Enterprise Manager
Oracle Recovery Manager
Cisco IOS
Apache Oozie
Oracle Java
Oracle Migration Workbench
ESRI ArcGIS software
Sybase
Flat File Checker
Apache Hadoop
Epic Systems
Talend Data Fabric
KornShell
Oracle PL/SQL
SAP Crystal Reports
Customer information control system CICS
Perforce Helix software
Oracle Designer
Bash
CloverETL
Apache Cassandra
Apatar
Hewlett Packard HP-UX
IBM Domino
IBM Rational System Architect
Enterprise JavaBeans
Data modeling software
SAP Sybase PowerDesigner
Talend Big Data Integration
Oracle WebLogic Server
Cloudera Impala
Structured query language SQL
Informatica PowerCenter
Linux
Oracle Real Application Cluster RAC
Intel Data Migration Software
Oracle Solaris
Microsoft SQL Server Reporting Services
Red Hat Enterprise Linux
CA Erwin Data Modeler