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