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