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…
- Database Architects
- Technical Operations Vice President
- System Engineer
- Information Technology Architect (IT Architect)
- Information Modeling Engineer Specialist
- Information Architect
- Database Consultant
- Database Architect
- Data Officer
- Data Architect
- Data Administrator
- SQL Server Developer
- SharePoint Architect
- Management Analyst
- Knowledge Architect
- Infrastructure Architect
- Information Engineer
- Database Modeler
- Database Engineer
- Database Designer
- Database Design Analyst
- Database Analyst
- Data Warehouse Architect
- Data Modeler
- Data Manager
- Data Base Design Analyst
- Data Analyst
Tasks for “Data Architect”
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Identify and correct deviations from database development standards.
- Create and enforce database development standards.
- Plan and install upgrades of database management system software to enhance database performance.
- Develop data models for applications, metadata tables, views or related database structures.
- Demonstrate database technical functionality, such as performance, security and reliability.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Design databases to support business applications, ensuring system scalability, security, performance and reliability.
- Provide technical support to junior staff or clients.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Develop load-balancing processes to eliminate down time for backup processes.
- 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 architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Test changes to database applications or systems.
- Set up database clusters, backup, or recovery processes.
- Develop and document database architectures.
- Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
- Document and communicate database schemas, using accepted notations.
Related Technology & Tools
- Laser facsimile machines
- Personal computers
- Load balancers
- Copy machines
- Oracle Hyperion
- Apache Pig
- Teradata Database
- SAS
- MicroStrategy
- Apache Hadoop
- Oracle Application Server
- CloverETL
- Oracle Java
- Linux
- Dynamic hypertext markup language DHTML
- IBM WebSphere
- Oracle Data Integrator
- IBM Content Manager
- Qlik Tech QlikView
- Microsoft Visio
- SAP Sybase Adaptive Server Enterprise
- Oracle Solaris
- Splunk Enterprise
- Oracle Business Intelligence Enterprise Edition
- IBM Rational System Architect
- Tableau
- Altova MapForce
- SPSS
- Veritas NetBackup
- C shell
- Oracle Fusion Applications
- Oracle WebLogic Server
- Apache Hive
- Oracle Designer
- Citrix
- Data modeling software
- R
- Talend Open Studio
- Microsoft Active Server Pages ASP
- Oracle JD Edwards EnterpriseOne
- Oracle Golden Gate
- Apatar
- Nagios
- Microsoft Visual Basic Scripting Edition VBScript
- Hewlett Packard HP-UX
- NoSQL
- Oracle JDBC
- Amazon Kinesis
- C++
- Apple Macintosh OS
- Microsoft Windows
- Swift
- SMSi Twister Data Integrator
- SAP Sybase PowerDesigner
- Infobright Community Edition ICE
- KornShell
- SAP Sybase Replication Server
- Apache Avro
- Cloudera Impala
- Microsoft Access
- Microsoft SQL Server Reporting Services
- IBM Rational Data Architect
- Sybase
- Customer information control system CICS
- IBM Domino
- Microsoft Visual Basic
- Rapid-I RapidMiner
- SAP Business Objects
- Common business oriented language COBOL
- Multidimensional Expressions MDX
- Apache Sqoop
- Ruby
- Oracle PL/SQL
- HiT Software Allora
- Bash
- Unified modeling language UML
- Structured query language SQL
- Adeptia ETL Suite
- IBM InfoSphere DataStage
- Microsoft Exchange Server
- Microsoft Excel
- IBM InfoSphere Warehouse
- Interface Computers Data Loader
- WisdomForce DatabaseSync System
- Practical extraction and reporting language Perl
- Oracle Enterprise Manager
- Pentaho Kettle
- Puppet
- Integrated development environment IDE software
- Perl shell
- Red Hat WildFly
- Oracle Jdeveloper
- Application server software
- Quest SQL Optimizer for Oracle
- Informatica PowerCenter
- Apache Oozie
- Apache HTTP Server
- IBM AIX
- MySQL
- Cisco IOS
- Perforce Helix software
- Spring Framework
- SAP
- PostgreSQL
- Oracle Data Guard
- IBM Cognos Impromptu
- Apache Solr
- Advanced business application programming ABAP
- ESRI ArcGIS software
- SAP Crystal Reports
- Transact-SQL
- Data Recovery Software SQL Server Data Recovery
- PHP: Hypertext Preprocessor
- Job control language JCL
- Relational database management software
- Apache Hbase
- Apache Cassandra
- IBM DB2
- Enterprise JavaBeans
- Oracle Real Application Cluster RAC
- Talend Data Fabric
- Apache Flume
- Epic Systems
- Adobe Systems Adobe Acrobat
- Oracle Recovery Manager
- Talend Big Data Integration
- Jitterbit
- Python
- C#
- Oracle Migration Workbench
- Red Hat Enterprise Linux
- UNIX
- Coglin Mill RODIN
- CA Erwin Data Modeler
- Microsoft SharePoint
- Apache Spark
- Microsoft PowerShell
- SAS Data Integration Studio
- Scriptella
- MongoDB
- Microsoft .NET Framework
- Microsoft Visual Studio
- CA Technologies ERWin Data Modeler
- Hewlett Packard LoadRunner
- Symantec
- Microsoft ActiveX
- Flat File Checker
- Intel Data Migration Software
- Microsoft SQL Server
- Extensible markup language XML