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