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