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