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