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”

Identify and correct deviations from database development standards.
Test changes to database applications or systems.
Develop load-balancing processes to eliminate down time for backup processes.
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 database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
Develop and document database architectures.
Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
Document and communicate database schemas, using accepted notations.
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.
Demonstrate database technical functionality, such as performance, security and reliability.
Provide technical support to junior staff or clients.
Create and enforce database development standards.
Develop or maintain archived procedures, procedural codes, or queries for applications.
Design databases to support business applications, ensuring system scalability, security, performance and reliability.
Develop data models for applications, metadata tables, views or related database structures.
Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
Set up database clusters, backup, or recovery processes.

Related Technology & Tools

Laser facsimile machines
Copy machines
Personal computers
Load balancers

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