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