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