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