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