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