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