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