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