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