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