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