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