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