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