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