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