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