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