Will “Data Modeler” 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…

Tasks for “Data Modeler”

Design databases to support business applications, ensuring system scalability, security, performance and reliability.
Develop and document database architectures.
Plan and install upgrades of database management system software to enhance database performance.
Create and enforce database development standards.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
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.
Develop data models for applications, metadata tables, views or related database structures.
Identify, evaluate and recommend hardware or software technologies to achieve desired 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.
Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Test changes to database applications or systems.
Document and communicate database schemas, using accepted notations.
Demonstrate database technical functionality, such as performance, security and reliability.
Set up database clusters, backup, or recovery processes.
Provide technical support to junior staff or clients.
Develop load-balancing processes to eliminate down time for backup processes.

Related Technology & Tools

Personal computers
Copy machines
Laser facsimile machines
Load balancers

HiT Software Allora
Intel Data Migration Software
Apache Pig
Enterprise JavaBeans
IBM Rational Data Architect
Microsoft Visual Basic Scripting Edition VBScript
IBM DB2
Microsoft SQL Server Reporting Services
Multidimensional Expressions MDX
Citrix
Oracle JD Edwards EnterpriseOne
Flat File Checker
IBM Rational System Architect
IBM InfoSphere DataStage
Apache HTTP Server
Perl shell
SAP Sybase Adaptive Server Enterprise
IBM AIX
Microsoft Visual Studio
C shell
Symantec
Apatar
Talend Data Fabric
Advanced business application programming ABAP
Teradata Database
Veritas NetBackup
Spring Framework
Adobe Systems Adobe Acrobat
IBM Content Manager
SAS
Data modeling software
CA Erwin Data Modeler
Microsoft Active Server Pages ASP
Oracle Golden Gate
IBM InfoSphere Warehouse
Ruby
Splunk Enterprise
Unified modeling language UML
Microsoft Excel
Hewlett Packard HP-UX
UNIX
Job control language JCL
Adeptia ETL Suite
SAP Sybase PowerDesigner
Infobright Community Edition ICE
Microsoft Access
Microsoft ActiveX
Integrated development environment IDE software
Apache Sqoop
Relational database management software
Microsoft Exchange Server
Talend Big Data Integration
CA Technologies ERWin Data Modeler
Rapid-I RapidMiner
KornShell
R
PostgreSQL
Red Hat WildFly
Microsoft SharePoint
Oracle Data Guard
Sybase
Oracle Data Integrator
Data Recovery Software SQL Server Data Recovery
SMSi Twister Data Integrator
Microsoft PowerShell
Coglin Mill RODIN
Oracle JDBC
IBM Cognos Impromptu
SAP Crystal Reports
Common business oriented language COBOL
PHP: Hypertext Preprocessor
Interface Computers Data Loader
Oracle Application Server
Apache Hive
NoSQL
Oracle Enterprise Manager
Tableau
Oracle Solaris
Oracle Designer
Apache Avro
WisdomForce DatabaseSync System
Apple Macintosh OS
Dynamic hypertext markup language DHTML
IBM Domino
Customer information control system CICS
Oracle Java
Apache Cassandra
MySQL
Linux
Extensible markup language XML
Talend Open Studio
SAP
Oracle Hyperion
Scriptella
Apache Hbase
Nagios
Perforce Helix software
Oracle PL/SQL
IBM WebSphere
Oracle Recovery Manager
Red Hat Enterprise Linux
SPSS
Microsoft Windows
Microsoft SQL Server
Informatica PowerCenter
Apache Hadoop
Apache Oozie
Oracle WebLogic Server
Pentaho Kettle
Oracle Jdeveloper
Bash
MicroStrategy
Altova MapForce
Cisco IOS
Oracle Migration Workbench
Qlik Tech QlikView
Apache Solr
Transact-SQL
Oracle Fusion Applications
CloverETL
Python
Oracle Business Intelligence Enterprise Edition
Apache Spark
Oracle Real Application Cluster RAC
SAP Sybase Replication Server
ESRI ArcGIS software
Cloudera Impala
Jitterbit
SAP Business Objects
SAS Data Integration Studio
Practical extraction and reporting language Perl
MongoDB
Microsoft .NET Framework
Amazon Kinesis
Hewlett Packard LoadRunner
Puppet
Swift
Quest SQL Optimizer for Oracle
Apache Flume
Structured query language SQL
Microsoft Visual Basic
Epic Systems
Application server software
C#
C++
Microsoft Visio