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